S&OP KPIs: What to Track in Each Cycle

S&OP KPIs tell the executive team whether the planning process is producing a plan that can be executed, whether the company is executing it and whether the plan is turning into service, margin and cash. Without them, S&OP becomes a monthly meeting about opinions. With too many, it becomes a data dump. The right set is short, defined once, calculated the same way every month and linked to decisions. This guide lists twelve KPIs grouped by the step of the cycle they inform, gives formulas, owners and frequency, shows worked examples with checked arithmetic and offers advice on presenting them. It is part of demand planning and inventory optimization, follows S&OP for small and mid-sized companies and S&OP software, and leads to integrated business planning and financial reconciliation in S&OP. Many of the measures also appear in demand planning KPIs and operations KPIs. Financial outcomes feed cash flow management.

Demand step

1. Forecast accuracy (weighted error). Sum of absolute errors divided by sum of actual demand, at the item or family level and the purchase lag. Owner: demand planner. Monthly. See WMAPE.

1. Forecast bias. Total forecast minus total actual, divided by total actual. Owner: demand planner. Monthly. A bias beyond a few percent for several months needs action. See forecast bias.

1. Forecast value added. The accuracy gain or loss of each step against a naive benchmark. Owner: S&OP leader. Quarterly. See forecast value added.

Supply step

1. Plan attainment (supply). Actual output or shipments divided by planned, for the period. Owner: operations. Monthly.

Example: planned shipments of 10,000 units and actual shipments of 9,300 give 9,300 / 10,000 = 93.0 percent attainment, a shortfall of 700 units. Analyze by cause: capacity, materials, quality or demand lower than planned.

1. Schedule adherence. Production or purchase orders completed on time as planned, divided by total orders. Owner: supply planning. Weekly or monthly.

Example: of 120 orders scheduled, 108 were completed on time, so adherence is 108 / 120 = 90.0 percent.

1. Capacity utilization. Actual output divided by available capacity. Owner: operations. Monthly.

Example: output of 8,400 units against capacity of 10,500 gives 8,400 / 10,500 = 80.0 percent. Very high utilization leaves no room for variability, while very low utilization means unabsorbed cost.

1. Supplier on-time-in-full. Receipts that arrived on time and complete divided by receipts due. Owner: procurement. Monthly.

Inventory and service

1. Service level or fill rate. Units shipped complete and on time divided by units ordered. Owner: operations or customer service. Weekly or monthly. See in-stock rate.

1. Inventory against plan. Actual inventory value divided by planned, or the difference. Owner: supply chain and finance. Monthly.

Example: planned inventory of $5.0 million and actual of $5.6 million. The variance is 5.6 - 5.0 = $0.6 million, or 0.6 / 5.0 = +12 percent. If the cause is demand lower than forecast, it points to bias. If it is early receipts, it points to supply execution. At an 18 percent carrying cost, the extra $0.6 million costs about $108,000 a year (0.6 × 0.18 = 0.108).

1. Days of supply or inventory turnover. See days of supply and inventory turnover. Owner: supply chain. Monthly.

Financial

1. Revenue and margin against plan. Actual revenue and gross margin compared with the S&OP plan and the budget, with the variance split into volume, price and mix. Owner: finance. Monthly. See financial reconciliation in S&OP.

Process health

1. Cycle and decision health. On-time delivery of inputs, whether the meeting took place on schedule, the number of decisions made, and the share of actions closed on time. Owner: S&OP leader. Monthly.

Example: of 22 actions due, 18 were closed on time, so the closure rate is 18 / 22 = 81.8 percent. A falling closure rate is an early sign that decisions are not being followed through.

A one-page scorecard

The targets shown are placeholders to be set from your own history. Include a short note on the one or two items that need attention, not a commentary on every number.

How to use the KPIs in the meeting

Spend the first ten minutes on the previous cycle's results. Focus on exceptions: KPIs outside their range, with cause and proposed action. Use the numbers to frame decisions: for example, if bias has been positive for four months, the demand plan needs adjusting, and the decision is whether to reduce the plan or review the inputs. Do not review KPIs that never change. Use a simple status color but always show the number.

Setting targets

Base targets on history and capability, not aspiration. Set them by segment where it matters (accuracy by item class, service by customer tier). Review annually. Set limits that trigger action, such as bias beyond plus or minus 5 percent for three months. Be wary of targets that conflict: pushing service up and inventory down at once requires better forecasting or shorter lead times, not just a target.

Definitions and data

Write a one-page dictionary: each KPI, formula, data source, owner, frequency and level. Lock definitions once agreed. If a definition changes, restate the history. Automate the calculation where possible, so that the planner's time goes to analysis.

Common mistakes

1. Too many KPIs.
2. Definitions that drift.
3. Reporting without owners.
4. Measuring at a level that hides problems.
5. Targets that conflict.
6. Never reviewing whether the KPIs still matter.

Leading and lagging indicators

Some KPIs describe what has happened (lagging), such as revenue against plan or service level. Others warn about what will happen (leading), such as forecast bias, supplier on-time performance, inventory coverage against lead time and order backlog. A balanced scorecard needs both. If the only measures reviewed are lagging, the meeting is always explaining the past. A leading measure like three consecutive months of positive bias gives the team time to act before inventory builds. For each lagging measure, ask what leading measure would have warned you.

From KPI to action

A KPI is only useful if it has a trigger and a response. Agree in advance what happens when a measure moves outside its range.

Treat these as a starting point. The ranges and responses should come from your own process.

Reading two KPIs together

KPIs often explain each other. Suppose plan attainment is 93 percent and the fill rate is 94 percent. If demand was above plan, the shortfall in shipments is a supply problem, and service suffers. If demand was below plan, the shortfall in shipments is not a supply problem, and the fill rate would not be expected to fall. Compare attainment with actual demand to separate the two. Similarly, an inventory variance of plus 12 percent alongside a bias of plus 10 percent points to the forecast, while the same variance with neutral bias points to early receipts or production running ahead of the plan. Reading pairs of measures turns a dashboard into a diagnosis.

Data sources and automation

Draw KPIs from the systems that already hold the data: orders and shipments from the ERP, inventory from the warehouse system, production from the manufacturing system, financials from the ledger. Automate the extract with a scheduled query or a BI dataset, and keep the calculation logic in one place. A scorecard that takes the planner two days to build is a scorecard that will not be built on time. See executive dashboard examples for finance and operations for scorecards that refresh without manual steps.

FAQs

What are the most important S&OP KPIs?

Forecast accuracy and bias, plan attainment, schedule adherence, service level, inventory against plan, revenue and margin against plan, and decision and action closure.

How often should S&OP KPIs be reviewed?

Most monthly in the S&OP cycle, with service and schedule measures weekly and process measures such as forecast value added quarterly.

Who owns S&OP KPIs?

Each KPI should have a named owner in the function that can influence it, with the S&OP leader responsible for the scorecard.

What is plan attainment?

Actual output or shipments divided by the planned amount for the period, showing how well the company executes its plan.

How many KPIs are enough?

Eight to twelve is usually enough. More dilutes attention.