S&OP, Demand Planning & Forecasting calculator
Backorder Exposure Cost Calculator
Backorder Exposure Cost quantifies the real money at risk when order lines can't be filled on time — the margin you'll likely forfeit to cancellations plus the cash you'll burn expediting and appeasing customers to save the rest. Supply chain planners, customer service leaders, and S&OP teams use it to translate a stockout event from an abstract service-level miss into a dollar figure that finance and operations both understand. Unlike a flat 'lost sales' estimate, it weights lost margin by the probability an order actually walks (the cancellation rate) and adds the fixed recovery spend you incur regardless. That makes it useful for deciding how hard to fight a given backorder — and how much safety stock is worth carrying to prevent it.
What this calculator does
- Estimates the financial exposure of open backorders that may cancel before they can be fulfilled.
- A fulfillment planner uses it to prioritize which backorder clusters to expedite based on margin at risk.
- It computes total dollar exposure from backorders as weighted lost margin plus a fixed recovery adder, and divides that by backordered lines for a per-line figure.
Formula used
- Total exposure = backordered lines x lost margin per line x cancellation rate % + recovery spend
- Exposure per line = total exposure / backordered lines
Inputs explained
- Backordered order lines:
- Lost margin per backordered line:
- Expected order cancellation rate:
- Customer recovery & expedite spend:
How to use the result
- 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.
- The cancellation rate is an estimate — if actual customer behavior differs, the variable portion of exposure moves proportionally.
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 Backorder Exposure Cost? Multiply backordered lines by lost margin per line by the cancellation rate, then add fixed recovery and expedite spend. With 320 lines × $48 × 30% + $3,000, that is $4,608 variable + $3,000 fixed = $7,608 total exposure.
- What is exposure cost per backordered line? Divide total exposure by the number of backordered lines. In the example, $7,608 ÷ 320 = $23.78 per line — a handy figure for deciding whether an expedite that costs more than that per line is worth it.
- Why multiply by the cancellation rate? Not every backordered line is lost — many customers wait. The 30% cancellation rate means you only expect to forfeit margin on about a third of the lines, so the variable exposure is $4,608 rather than the full $15,360 of margin at risk.
- What's the difference between exposure cost and lost sales? Lost sales assumes the order is gone; exposure cost weights the loss by cancellation probability and adds the recovery spend you incur trying to keep the order. It's a more realistic, decision-ready number.
- What is a good Backorder Exposure Cost? Lower is always better, but the metric is most useful relative to the cost of prevention. If carrying enough safety stock to avoid this backorder costs less than the $7,608 exposure, the inventory pays for itself.
Last reviewed 2026-05-12.