S&OP, Demand Planning & Forecasting calculator

Demand Plan Attainment Calculator

Demand Plan Attainment measures how often actual demand landed within tolerance of the agreed demand plan across a set of planning periods. It is a core S&OP scorecard metric that demand planners, supply chain leaders and finance use to judge whether the consensus plan is trustworthy enough to drive purchasing and capacity decisions. A high attainment rate means the plan is a reliable basis for commitments; a low one signals the plan is fiction and downstream buffers are absorbing the miss. Teams review it every planning cycle to hold the forecasting process accountable. It reframes forecast accuracy as a pass/fail hit rate that executives immediately understand.

What this calculator does

  • Estimate demand plan attainment for sandop, demand planning and forecasting using production-ready inputs so teams can track KPI performance and decide whether corrective action is needed.
  • Use it when demand plan attainment in s and op, demand planning and forecasting needs a clean rate and gap-to-target you can put on a tier board.
  • It computes the percentage of planning periods that hit the demand plan within tolerance and the gap in points to your target rate.

Formula used

  • Demand plan attainment rate = demand plan attainment count ÷ total demand plan attainment population × 100
  • Demand plan attainment gap to target = demand plan attainment rate - target demand plan attainment rate

Inputs explained

  • Periods where demand plan was met within tolerance:
  • Total planning periods evaluated:
  • Target attainment rate for the demand plan:

How to use the result

  • Use it in monthly or weekly S&OP reviews to grade demand-plan reliability and track it against a service target.
  • A hit/miss rate ignores the size of each miss, so a plan that barely misses many periods can score the same as one that misses badly on a few.

Current U.S. benchmarks

  • The producer price index for steel mill products stands at 348.53 (BLS, May 2026), up 6.7% from a year earlier. Quotes priced off last quarter's material cost miss this move.
  • The U.S. has 3,569 primary metal manufacturing establishments employing about 354,911 workers (Census County Business Patterns, 2023).

Common questions

  • How do you calculate demand plan attainment? Divide the number of periods that met the plan within tolerance by the total periods evaluated, then multiply by 100. With 8 periods met out of 250, attainment is 3.2%.
  • What is a good demand plan attainment rate? Mature S&OP processes target 80% or higher within a sensible tolerance band. The 3.2% in the example, against a 95% target, leaves a 91.8-point gap — indicating the plan or the tolerance definition is badly broken.
  • What is the gap to target and why does it matter? The gap is attainment rate minus your target, expressed in points. Here 3.2% minus 95% is a 91.8-point shortfall, which quantifies exactly how far the process sits from acceptable and frames the size of the improvement effort.
  • Demand plan attainment vs forecast accuracy — what's the difference? Forecast accuracy measures the magnitude of error (e.g. MAPE); attainment is a binary hit rate within a tolerance. Attainment is easier to communicate to leadership, but accuracy tells you how big the misses were.
  • How do you improve demand plan attainment? Tighten the consensus process, remove bias from the baseline forecast, and set a realistic tolerance band. Chasing attainment by widening tolerance is a trap — it flatters the number without improving the plan.

Last reviewed 2026-05-12.