S&OP and demand planning
A demand and supply planning view that measures forecast accuracy by family and horizon, so the S&OP cycle argues from one set of numbers.
- Forecast accuracy
- 78.4%
- 1 - value-weighted MAPE
- Average coverage
- 34 days
- stock over forecast demand
- Supplier OTIF
- 91.2%
- on time and in quantity
- Inventory capital
- $84.6M
- all families
Illustrative figures · fictitious client · under NDA
The challenge
An S&OP process ran on disconnected spreadsheets, so forecast accuracy was unknown and every function came to the meeting with a different number.
What we built
We built a governed planning model and Power BI dashboards that track demand, supply, and forecast accuracy by product family and horizon, giving the S&OP cycle one shared view.
- A governed planning model over demand and supply data.
- Forecast accuracy by family and planning horizon.
- A shared S&OP dashboard for every function.
Outcomes
- One set of numbers for the S&OP cycle.
- Forecast accuracy measured instead of assumed.
- Demand and supply lined up by horizon.
The dashboard we delivered
Forecast accuracy
1 - MAPE for the cycle, against the 80% target
Inventory capital by family
Click to open by supplier
Items in the slice
One row per item planned in the cycle
Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.
Want a dashboard like this on your data?
Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.
Start a project