Advanced Planning, Scheduling & APS calculator
Late Order Exposure Calculator
Late Order Exposure converts a slipping schedule into a single dollar figure that planning, customer service, and operations can all act on. It multiplies the count of late or at-risk orders by the average financial exposure each one carries, scales that by the share genuinely attributable to scheduling (rather than design, supply, or customer holds), and adds the cost of customer recovery actions like expediting or goodwill credits. APS planners and production control leads use it to defend overtime, premium freight, or a re-sequencing decision in the daily dispatch meeting. It matters because OTD penalties, chargebacks, and lost re-orders rarely show up on one report until the month closes.
What this calculator does
- Estimate financial exposure from late production orders using late-order count, penalty or margin exposure, responsibility share, and customer recovery cost.
- a supply chain manager needs to quantify the impact of orders projected to miss due dates
- It computes the total dollar exposure from late orders as schedule-attributable exposure (orders x exposure per order x attributable share) plus a fixed customer recovery cost.
Formula used
- Schedule-attributable late exposure = late orders × exposure per late order × schedule-attributable exposure
- Late order exposure = schedule-attributable late exposure + customer recovery cost
Inputs explained
- Late or at-risk orders:
- Exposure per late order:
- Schedule-attributable exposure:
- Customer recovery cost:
How to use the result
- Use it when your schedule shows a cluster of orders trending past due and you need to size the financial case for expediting, overtime, or re-sequencing before the ship date.
- Exposure per order is an average; a single strategic account or a liquidated-damages clause can dwarf the blended figure, so validate the per-order number against your worst contracts.
Current U.S. benchmarks
- Manufacturing hourly earnings average $30.27 (BLS, Jun 2026), up 4.4% from a year earlier. Median machinist pay is $28.24/hr (OEWS 2025), with state medians on each state page. Manufacturers have 529k open positions nationally (BLS JOLTS).
- U.S. manufacturing runs at 75.6% of capacity (Federal Reserve, May 2026). New factory orders are up 2.3% year over year (Census).
Common questions
- How do you calculate late order exposure? Multiply the number of late or at-risk orders by the average exposure per order, then multiply by the percentage attributable to scheduling, and add the customer recovery cost. With 12 orders at $850 each, 70% schedule-attributable plus $1,500 recovery, exposure is 12 x 850 x 0.70 = $7,140, plus $1,500 = $8,640.
- What counts as exposure per late order? It is the blended financial hit per late order: late-delivery penalties or liquidated damages, premium freight to recover, the margin on at-risk re-orders, and any chargeback. Pull it from your last few months of actual late-order costs rather than guessing.
- Why apply a schedule-attributable percentage? Not every late order is the planner's fault. Customer engineering holds, late material, and credit holds shift the cause elsewhere. The 70% in the example says seven of every ten exposure dollars trace to sequencing or capacity decisions you can actually influence.
- What is a good late order exposure number? There is no universal benchmark; the goal is a downward trend and an exposure smaller than the cost of the fix. If recovering the $8,640 example only requires $2,000 of overtime, acting is clearly justified; if it needs $12,000 of premium freight, you renegotiate dates instead.
- Late order exposure vs OTD percentage, what is the difference? On-time delivery percentage tells you how often you miss; late order exposure tells you what those misses cost. A 96% OTD shop can still carry large exposure if the 4% that slip are high-value contracts with penalty clauses.
Last reviewed 2026-05-12.