S&OP, Demand Planning & Forecasting worked example

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

Here is what the math looks like when conditions slip. We hold every other input steady and drop expected order cancellation rate to 22%, then walk the calculation through step by step. Estimates the financial exposure of open backorders that may cancel before they can be fulfilled.

The inputs for this scenario

  • Backordered order lines: 320 order lines (held at the documented default)
  • Lost margin per backordered line: 48 $/line (held at the documented default)
  • Expected order cancellation rate: 22 % (the input this scenario stresses; the baseline uses 30)
  • Customer recovery & expedite spend: 3,000 $ (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Total exposure = backordered lines x lost margin per line x cancellation rate % + recovery spend.
  • Total backorder exposure cost works out to 6,379 $ at these inputs, and this is the headline figure for the scenario.
  • Backorder exposure cost per unit works out to 19.93 $ / piece at these inputs.
  • Variable backorder exposure cost works out to 3,379 $ at these inputs.
  • Fixed backorder exposure cost adder works out to 3,000 $ at these inputs.

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 16.15% below the baseline at 6,379 $.
  • The practical read: the gap between this scenario and the baseline is entirely attributable to expected order cancellation rate, so recovering it is worth quantifying in dollars before considering equipment or staffing changes. The cancellation rate is an estimate — if actual customer behavior differs, the variable portion of exposure moves proportionally.

Results at a glance

  • Total backorder exposure cost: 6,379 $ (headline result)
  • Backorder exposure cost per unit: 19.93 $ / piece
  • Variable backorder exposure cost: 3,379 $
  • Fixed backorder exposure cost adder: 3,000 $

Run it with your numbers

  • To rerun this with your own numbers, open the live Backorder Exposure Cost calculator, set expected order cancellation rate to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.