Supply Chain Demand Variability Safety Stock Simulator
Calculate safety stock levels using demand and lead time variability for supply chain optimization.
Worked Examples
Example 1: Consumer Electronics Component
Problem: Electronic component: avg demand 5,000/month, std dev 1,500. Lead time 21 days ± 5 days. Target 97% service level. Unit cost $15. Calculate safety stock.
Solution: Parameters:\n- Daily demand: 5,000/30 = 167 units\n- Daily std dev: 1,500/30 = 50 units\n- Lead time: 21 days, σLT = 5 days\n- Z for 97%: 1.88\n\nCombined Variability:\n- Demand variance: 50² × 21 = 52,500\n- Lead time variance: 167² × 5² = 696,889\n- Combined σ = √(52,500 + 696,889) = 866 units\n\nSafety Stock:\n- SS = 1.88 × 866 = 1,628 units\n\nReorder Point:\n- Demand during LT: 167 × 21 = 3,507\n- ROP = 3,507 + 1,628 = 5,135 units\n\nCosts:\n- Safety stock value: 1,628 × $15 = $24,420\n- Annual holding (25%): $6,105\n\nNote: Lead time variability contributes more than demand variability!
Result: Safety Stock: 1,628 | ROP: 5,135 | $6,105/year holding cost
Example 2: Service Level Optimization
Problem: Retailer comparing service levels for $50 product. Demand: 200/week, σ = 60. Lead time: 7 days (no variability). Stockout costs $100/incident. Find optimal service level.
Solution: Safety Stock by Service Level:\n- 90%: Z=1.28 → SS = 1.28 × 60 × √1 = 77\n- 95%: Z=1.65 → SS = 99\n- 97%: Z=1.88 → SS = 113\n- 99%: Z=2.33 → SS = 140\n\nAnnual Holding Costs (25%):\n- 90%: 77 × $50 × 0.25 = $963\n- 95%: $1,238\n- 97%: $1,413\n- 99%: $1,750\n\nExpected Stockout Costs:\n- 90%: 10% × 52 weeks = 5.2 stockouts × $100 = $520\n- 95%: 2.6 stockouts = $260\n- 97%: 1.6 stockouts = $160\n- 99%: 0.5 stockouts = $50\n\nTotal Cost Analysis:\n- 90%: $963 + $520 = $1,483\n- 95%: $1,238 + $260 = $1,498\n- 97%: $1,413 + $160 = $1,573\n- 99%: $1,750 + $50 = $1,800\n\nOptimal: 90-95% service level minimizes total cost
Result: Optimal: 90-95% | Total cost ~$1,500 | Higher SL not justified by stockout savings
Example 3: Multi-Supplier Strategy
Problem: Critical part: demand 300/day, σ = 75. Current: single supplier, 30-day lead time ± 10 days. Alternative: dual-source with 15-day lead time ± 2 days (20% cost premium). Compare safety stock.
Solution: Single Supplier Analysis:\n- Demand variance: 75² × 30 = 168,750\n- Lead time variance: 300² × 10² = 9,000,000\n- Combined σ = √9,168,750 = 3,028\n- SS (95%): 1.65 × 3,028 = 4,996 units\n\nDual-Source Analysis:\n- Demand variance: 75² × 15 = 84,375\n- Lead time variance: 300² × 2² = 360,000\n- Combined σ = √444,375 = 667\n- SS (95%): 1.65 × 667 = 1,101 units\n\nComparison:\n- SS reduction: 4,996 - 1,101 = 3,895 units\n- At $20/unit: $77,900 inventory reduction\n- Annual holding savings: $19,475\n\nCost Premium Analysis:\n- 300 × 365 × $20 × 20% = $438,000/year premium\n- Inventory savings: $19,475/year\n\nConclusion: Dual-sourcing not justified by inventory alone.\nBut consider: supply risk reduction, flexibility, negotiating leverage.
Result: Single: 4,996 SS | Dual: 1,101 SS | Dual saves $19K but costs $438K premium
Frequently Asked Questions
What is safety stock?
Safety stock is extra inventory held to buffer against demand and supply variability. It protects against stockouts when actual demand exceeds forecast or when suppliers deliver late. The amount depends on desired service level, demand variability, and lead time variability. Higher safety stock = fewer stockouts but higher carrying costs.
How do I calculate safety stock?
Basic formula: Safety Stock = Z × σ × √LT, where Z is service level factor, σ is demand standard deviation, and LT is lead time. For variable lead times: SS = Z × √(LT×σD² + D²×σLT²), combining demand and lead time variability. This accounts for both sources of uncertainty.
What is the relationship between service level and safety stock?
Non-linear relationship. Going from 90% to 95% requires ~30% more safety stock. From 95% to 99% requires ~40% more. From 99% to 99.9% nearly doubles it. The cost of that last bit of service level is exponentially higher. This is why not everything should be 99%.
How does lead time affect safety stock?
Longer lead times require more safety stock because more can go wrong during the wait. Safety stock scales with square root of lead time—doubling lead time increases safety stock by ~40%, not 100%. Lead time variability often matters more than length; work on consistency first.
Should I use the same safety stock approach for all items?
No. ABC analysis segments items by value/importance. A items (high value): careful calculation, high service levels. B items (moderate): standard formulas. C items (low value): simple rules or periodic review. One-size-fits-all approaches either under-stock critical items or over-stock trivial ones.
How often should I recalculate safety stock?
Depends on demand stability. Stable demand: quarterly or annually. Seasonal or trending: monthly or per season. Highly volatile: continuously with rolling averages. Major events (new products, market changes): immediate recalculation. Stale parameters cause stockouts or excess inventory.