ERP & MRP Planning calculator
Material Shortage Risk Calculator
Material Shortage Risk is a weighted score that ranks how dangerous a potential component or raw-material shortage is to your production plan, combining how badly a stockout would hurt the line, how likely it is to happen, and how hard it is to see coming. Supply planners, buyers, and MRP controllers use it to triage thousands of part numbers so attention goes to the items that can actually stop the line. It borrows the logic of FMEA's severity-occurrence-detection structure but tunes the weights toward production impact, which usually matters most on a shop floor. The result lets a planning team move from gut-feel expediting to a defensible priority list for safety stock, dual sourcing, and buffer reviews.
What this calculator does
- Score material shortage risk from production impact, shortage likelihood, and shortage visibility.
- a materials manager needs to prioritize shortage actions
- It computes a single weighted risk score from production impact, shortage likelihood, and detection difficulty using fixed weights of 0.40, 0.35, and 0.25.
Formula used
- Material shortage risk score = production impact × 0.40 + shortage likelihood × 0.35 + visibility risk × 0.25
Inputs explained
- Production impact if material is short:
- Likelihood of a shortage occurring:
- Difficulty of detecting the shortage early:
How to use the result
- Use it when prioritizing which materials need safety-stock increases, expediting, or supplier risk mitigation across a large bill of materials.
- The scores are subjective judgments on a common scale; if raters apply the 1-10 scale inconsistently across parts, the rankings will be skewed and incomparable.
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 material shortage risk? Multiply each factor by its weight and add them: production impact × 0.40 + likelihood × 0.35 + detection difficulty × 0.25. With scores of 9, 7, and 6 that gives 3.6 + 2.45 + 1.5 = 7.55.
- What is a high material shortage risk score? On a 1-10 input scale the score also lands roughly 1-10. The example's 7.55 is high-priority; scores above 7 generally warrant safety stock, dual sourcing, or active expediting, while under 4 can be monitored.
- Why does production impact carry the most weight? At 0.40 it dominates because a shortage that stops the line costs far more than one easily absorbed by buffer. The example shows impact contributing 3.6 of the 7.55 total, the single largest piece.
- How is this different from a standard FMEA RPN? A classic RPN multiplies severity, occurrence, and detection into a 1-1000 number. This model uses a weighted sum instead, which keeps the score on the same 1-10 scale and prevents one extreme factor from dwarfing the others.
- What should I do with a high shortage risk score? Raise safety stock or reorder points, qualify a second supplier, tighten visibility with supplier scorecards or ASN tracking, and place the part on an exception list reviewed every MRP cycle.
Last reviewed 2026-05-12.