What it measures
% of production and sales plans executed as agreed in S&OP
This KPI measures deviation from a plan after execution is complete; the consequences (service failures, incorrect inventory build) are already locked in by the time the score is calculated, typically 3-5 weeks after the decision.
Business impact
- Triggers a 'chaos tax' of unplanned changeovers, last-minute raw material air-freight, and customer service overtime to manage the fallout from broken production promises.
- Directly creates the wrong inventory position: capital is tied up in over-produced standard items while high-demand promotional SKUs are stocked out, leading to simultaneous write-offs and lost sales.
Formula
(Actual volume / S&OP planned volume) x 100Grain
One row per SKU per location per forecast version per period
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Demand_Forecast. It guards against missing dates and values with NOT ISBLANK checks.
Fact_Demand_Forecast— 9 mandatory columns — period key, actual qty, ...Dim_Customer— key + nameDim_Forecast_Version— key + nameDim_Material— material_key + material_descriptionDim_Period— key + nameDim_Plant— key + nameDim_Product— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
| Target | 0.95 — performance considered compliant at or above this line |
| Warning | 0.88 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build S&OP Adherence in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.