Inventory Scenarios
What-if analysis: safety stock, service level, lead time sensitivity
Scenario Parameters
Base Safety Stock Multiplier
Range: 1.0×–3.0×
Demand Variability (CV)
Target: ≤ 0.20
Service Level Target
Current: 97.1%
Lead Time (days)
Category average
Review Period
Fixed cycle
Scenario Results — Best Fit
Recommended Safety Stock7,200 cases
Projected Service Level98.4%
Projected DOS15.2 days
Additional Carrying Cost+₹1.7L/mo
Stockout Risk Reduction−65%
Safety Stock vs Service Level vs Cost
Lead Time Sensitivity Analysis
SKU-Level Scenario Comparison
| SKU | Current SS | Scenario SS | Current DOS | Target DOS | Δ Carry Cost | Service Level | Risk |
|---|---|---|---|---|---|---|---|
| AquaPure 500ml | 6,000 | 7,200 | 21.3d | 15d | +₹0.4L | 98.4% | healthy |
| FruitBurst Orange | 3,000 | 4,200 | 10.0d | 15d | +₹0.5L | 97.8% | warning |
| CoolSip Lemon | 2,500 | 3,800 | 11.0d | 15d | +₹0.4L | 97.5% | warning |
| SportZone Energy | 2,000 | 3,000 | 12.5d | 15d | +₹0.3L | 97.2% | warning |
| MintFresh Water | 1,800 | 2,600 | 14.8d | 15d | +₹0.2L | 98.1% | healthy |