Back to Coverage GridProjected shortfall
Freeze-Dried Mango
Tropico Andes · Peru · 10 wk LT · $11.20/lb
On Hand
2,100 lbs
Safety Stock
350 lbs
Min Coverage (8 wk)
5.5 wks
Inventory Value
$23,520.00
Weekly Plan
| Week | Start OH | Demand | Receipts | End OH | Coverage | Status |
|---|---|---|---|---|---|---|
| W47 | 2,100 | 280 | — | 1,820 | 12.4 | Safe |
| W48 | 1,820 | 294 | — | 1,526 | 11.4 | Safe |
| W49 | 1,526 | 294 | — | 1,232 | 10.4 | Tight — order now |
| W50 | 1,232 | 308 | — | 924 | 9.5 | Tight — order now |
| W51 | 924 | 294 | — | 630 | 8.5 | Tight — order now |
| W52 | 630 | 280 | — | 350 | 7.5 | Tight — order now |
| W1 | 350 | 266 | — | 84 | 6.5 | Tight — order now |
| W2 | 84 | 280 | 1,500 | 1,304 | 5.5 | Tight — order now |
| W3 | 1,304 | 294 | — | 1,010 | 4.5 | Critical — inside lead time |
| W4 | 1,010 | 308 | — | 702 | 3.5 | Critical — inside lead time |
| W5 | 702 | 294 | — | 408 | 2.5 | Critical — inside lead time |
| W6 | 408 | 280 | — | 128 | 1.5 | Critical — inside lead time |
| W7 | 128 | 266 | — | -138 | -0.5 | Projected shortfall |
Open POs
- PO-442201,500 lbsETA W2
Supplier reliability: 96% (last 12 mo)