For one of our customers we have build on top of their ERP system a stock projection overview (see graph).
Standard MRP generated data of gross requirements and supply is first extended to provide a detailed trace until the source of these demands and supply (forecast/sales/...).
For this we developed our own multi-level-pegging routine, capable of handling co and by products know in the process industry.
The result is a Hyper Analyzer dataset on which the future stock situation can be evaluated on any time line (day/week/month...) and by any grouping (vendor/buyer-planner/...) . This way the customer can proactively take measures which will lower inventory cost and will turn the business in a lean direction.