Aerospace & Defense Manufacturing calculator
Aerospace Supplier Shortage Exposure Calculator
Check a supplier delivery plan against a specific part need. Enter required units, usable allocated stock, confirmed on-time receipts and acquisition cost.
What this calculator does
- Measure uncovered part demand and its acquisition value using allocated stock and confirmed receipts before a common need date.
Formula used
- Covered units = min(required units, usable stock + on-time receipts)
- Uncovered units = max(0, required units − usable stock − on-time receipts)
- Demand coverage = covered units ÷ required units × 100
- Uncovered acquisition value = uncovered units × cost per unit
Inputs explained
- Units Required by Need Date: Approved demand for one interchangeable part by its need date.
- Usable Stock for This Demand: Accepted stock allocated exclusively to this demand.
- Confirmed Receipts Before Need Date: Accepted usable receipts confirmed before the same need date.
- Acquisition Cost per Unit: Recorded acquisition cost for the uncovered part.
How to use the result
- Best suited to delivery recovery Review, critical part coverage.
- This is not a supplier risk score or probability of disruption. Late, unapproved or uncertain receipts must be excluded. Legacy impact scenarios now vary measured required quantity.
Current U.S. benchmarks
- Steel mill PPI stands at 381.162 (BLS, Aug 2026), up 23.4% from a year earlier. New factory orders are up 8.5% year over year (Census).
- The U.S. has 11,691 transportation equipment establishments employing about 1,682,910 workers (Census County Business Patterns, 2023).
Common questions
- Should I include a supplier promise with an uncertain date? Exclude it until its usable receipt before the need date is confirmed. You can run a separate scenario for uncertain receipts.
- Can stock reserved for another program be counted? No. Only include stock allocated to this demand, otherwise both programs would claim the same coverage.
- Does uncovered acquisition value estimate a line stoppage loss? No. It values the missing units at your acquisition cost. Lost output, expedite charges and delay costs require separate estimates.
- Where did the old supplier severity ratings go? Measured part demand and supply replace the ordinal ratings. The retained low and high scenario links now compare required quantities; no score conversion is implied.
Last reviewed 2026-10-06.