S&OP, Demand Planning & Forecasting worked example

Forecast Value Add at 25% forecast accuracy lift captured by planning: a worked example

This worked example runs the forecast value add numbers for a tougher week than the baseline: 25% forecast accuracy lift captured by planning instead of the typical 35%. Quantifies the dollar value a forecast adds over a naive baseline across the SKU-periods your demand planners review.

The inputs for this scenario

  • Forecasted SKU-months reviewed in the cycle: 1,200 SKU-months (held at the documented default)
  • Gross margin exposed to error per SKU-month: 85 $/SKU-month (held at the documented default)
  • Forecast accuracy lift captured by planning: 25 % (the input this scenario stresses; the baseline uses 35)
  • Planning tool and analyst overhead cost: 4,000 $ (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Total FVA = SKU-periods x margin at risk x accuracy lift % + planning overhead.
  • Total forecast value add cost works out to 29,500 $ at these inputs, and this is the headline figure for the scenario.
  • Forecast value add cost per unit works out to 24.58 $ / piece at these inputs.
  • Variable forecast value add cost works out to 25,500 $ at these inputs.
  • Fixed forecast value add adder works out to 4,000 $ at these inputs.

How this compares with the baseline

  • Against the tool's baseline example, where forecast accuracy lift captured by planning sits at 35% and the headline result is 39,700 $, this scenario comes in 25.69% below the baseline at 29,500 $.
  • Use it to justify planning tool spend, size the payoff of accuracy improvements, or benchmark manual overrides against a naive forecast. A result at this level usually justifies acting on the stressed input before touching anything else, because every other figure in the table is downstream of it.

Results at a glance

  • Total forecast value add cost: 29,500 $ (headline result)
  • Forecast value add cost per unit: 24.58 $ / piece
  • Variable forecast value add cost: 25,500 $
  • Fixed forecast value add adder: 4,000 $

Run it with your numbers

  • To rerun this with your own numbers, open the live Forecast Value Add calculator, set forecast accuracy lift captured by planning to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.