S&OP, Demand Planning & Forecasting worked example

Backorder Exposure Cost at 35% expected order cancellation rate: a worked example

This scenario runs the backorder exposure cost calculation on the strong side: 35% expected order cancellation rate, with every other input held at its documented default. A fulfillment planner uses it to prioritize which backorder clusters to expedite based on margin at risk.

The inputs for this scenario

  • Backordered order lines: 320 order lines (unchanged)
  • Lost margin per backordered line: 48 $/line (unchanged)
  • Expected order cancellation rate: 35 % (raised for this scenario; the documented default is 30)
  • Customer recovery & expedite spend: 3,000 $ (unchanged)

Working through the calculation

  • Applying the documented formula (Total exposure = backordered lines x lost margin per line x cancellation rate % + recovery spend) to the inputs above produces each figure below.
  • At this operating point the engine returns 8,376 $ for total backorder exposure cost, the number this scenario is built around.
  • At this operating point the engine returns 26.18 $ / piece for backorder exposure cost per unit.
  • At this operating point the engine returns 5,376 $ for variable backorder exposure cost.
  • At this operating point the engine returns 3,000 $ for fixed backorder exposure cost adder.

How this compares with the baseline

  • Against the tool's baseline example, where expected order cancellation rate sits at 30% and the headline result is 7,608 $, this scenario comes in 10.09% above the baseline at 8,376 $.
  • Use it during a stockout, an allocation event, or an S&OP shortfall review to size the financial risk and prioritize which orders to expedite. Treat this as a target state: the delta against the baseline quantifies what the improvement is worth before you commit to chasing it.

Results at a glance

  • Total backorder exposure cost: 8,376 $ (headline result)
  • Backorder exposure cost per unit: 26.18 $ / piece
  • Variable backorder exposure cost: 5,376 $
  • Fixed backorder exposure cost adder: 3,000 $

Run it with your numbers

  • Every input above is editable in the live Backorder Exposure Cost calculator, which recalculates instantly and can be shared with the inputs intact.

Last reviewed 2026-05-12.