Supply Planning
Reorder point = forecast demand over the supplier lead time + safety stock. Safety stock uses a 95% cycle service level (z = 1.645) and combines demand variability and lead-time variability: SS = z x sqrt(LT x σ_demand² + (μ_demand x σ_LT)²). Lead times and their standard deviations come from the actual 220-PO delivery history, not the supplier master.
Inventory position and replenishment plan
Days of supply is based on the 12-week forecast, not trailing demand. Order quantities are rounded up to pack size and floored at MOQ.
| SKU | DC | On hand | On order | Fcst / wk | Safety stock | Reorder point | DoS | Flag | Recommend | Timing |
|---|---|---|---|---|---|---|---|---|---|---|
Air Filter SKU-009 · A · Vantage Engine Systems | Chennai DC Asia Pacific | 64 | 81 | 128 | 136 | 416 | 8d | Critical | 560 u MOQ 20 · pack 10 | Order now arrives ~17d |
Seal Kit SKU-005 · A · Meridian Hydraulics Ltd. | Dallas DC North America | 57 | 135 | 92.7 | 112 | 404 | 15d | Critical | 505 u MOQ 20 · pack 5 | Order now arrives ~20d |
Seal Kit SKU-005 · A · Meridian Hydraulics Ltd. | Rotterdam DC Europe | 35 | 0 | 56.8 | 93 | 286 | 4d | Critical | 445 u MOQ 20 · pack 5 | Order now arrives ~20d |
Track Chain SKU-011 · B · Trackline Manufacturing | Chennai DC Asia Pacific | 30 | 43 | 58.8 | 155 | 492 | 9d | Critical | 755 u MOQ 25 · pack 5 | Order now arrives ~33d |
Track Chain SKU-011 · B · Trackline Manufacturing | Dallas DC North America | 109 | 58 | 52 | 125 | 400 | 22d | Critical | 510 u MOQ 25 · pack 5 | Order now arrives ~33d |
Air Filter SKU-009 · A · Vantage Engine Systems | Jakarta DC Asia Pacific | 53 | 0 | 57.4 | 57 | 191 | 6d | Critical | 280 u MOQ 20 · pack 10 | Order now arrives ~17d |
Track Chain SKU-011 · B · Trackline Manufacturing | Rotterdam DC Europe | 26 | 0 | 31.3 | 89 | 287 | 6d | Critical | 460 u MOQ 25 · pack 5 | Order now arrives ~33d |
Track Chain SKU-011 · B · Trackline Manufacturing | Jakarta DC Asia Pacific | 79 | 0 | 28.4 | 76 | 248 | 19d | Critical | 345 u MOQ 25 · pack 5 | Order now arrives ~33d |
Wiring Harness SKU-018 · A · Circuit & Cab Electronics | Dallas DC North America | 144 | 47 | 124.1 | 144 | 517 | 11d | Critical | 700 u MOQ 5 · pack 10 | Order now arrives ~26d |
Hydraulic Cylinder SKU-002 · B · Meridian Hydraulics Ltd. | Chennai DC Asia Pacific | 74 | 0 | 43.3 | 59 | 216 | 12d | Critical | 300 u MOQ 50 · pack 10 | Order now arrives ~20d |
Wiring Harness SKU-018 · A · Circuit & Cab Electronics | Rotterdam DC Europe | 102 | 0 | 108.7 | 118 | 411 | 7d | Critical | 610 u MOQ 5 · pack 10 | Order now arrives ~26d |
Wiring Harness SKU-018 · A · Circuit & Cab Electronics | Jakarta DC Asia Pacific | 111 | 0 | 72.3 | 86 | 304 | 11d | Critical | 420 u MOQ 5 · pack 10 | Order now arrives ~26d |
Hydraulic Pump SKU-001 · C · Meridian Hydraulics Ltd. | Chennai DC Asia Pacific | 9 | 0 | 7.1 | 10 | 35 | 9d | Critical | 60 u MOQ 50 · pack 10 | Order now arrives ~20d |
Cutting Edge SKU-022 · B · Ironclad GET Works | Dallas DC North America | 12 | 10 | 21 | 13 | 53 | 7d | Critical | 75 u MOQ 50 · pack 5 | Order now arrives ~14d |
Hydraulic Pump SKU-001 · C · Meridian Hydraulics Ltd. | Rotterdam DC Europe | 3 | 1 | 4.6 | 7 | 22 | 6d | Critical | 50 u MOQ 50 · pack 10 | Order now arrives ~20d |
Cutting Edge SKU-022 · B · Ironclad GET Works | Jakarta DC Asia Pacific | 6 | 0 | 12.5 | 7 | 27 | 3d | Critical | 50 u MOQ 50 · pack 5 | Order now arrives ~14d |
Seal Kit SKU-005 · A · Meridian Hydraulics Ltd. | Chennai DC Asia Pacific | 256 | 66 | 82.8 | 166 | 510 | 27d | Stockout risk | 535 u MOQ 20 · pack 5 | Order this cycle arrives ~20d |
Air Filter SKU-009 · A · Vantage Engine Systems | Dallas DC North America | 113 | 121 | 104 | 83 | 317 | 16d | Stockout risk | 320 u MOQ 20 · pack 10 | Order this cycle arrives ~17d |
Air Filter SKU-009 · A · Vantage Engine Systems | Rotterdam DC Europe | 162 | 15 | 78.9 | 87 | 261 | 16d | Stockout risk | 260 u MOQ 20 · pack 10 | Order this cycle arrives ~17d |
Seal Kit SKU-005 · A · Meridian Hydraulics Ltd. | Jakarta DC Asia Pacific | 86 | 36 | 36.9 | 59 | 202 | 23d | Stockout risk | 225 u MOQ 20 · pack 5 | Order this cycle arrives ~20d |
Wiring Harness SKU-018 · A · Circuit & Cab Electronics | Chennai DC Asia Pacific | 284 | 107 | 154.3 | 180 | 633 | 18d | Stockout risk | 700 u MOQ 5 · pack 10 | Order this cycle arrives ~26d |
Hydraulic Cylinder SKU-002 · B · Meridian Hydraulics Ltd. | Dallas DC North America | 133 | 0 | 37.4 | 56 | 194 | 25d | Stockout risk | 200 u MOQ 50 · pack 10 | Order this cycle arrives ~20d |
Hydraulic Cylinder SKU-002 · B · Meridian Hydraulics Ltd. | Rotterdam DC Europe | 83 | 0 | 25.4 | 34 | 126 | 23d | Stockout risk | 140 u MOQ 50 · pack 10 | Order this cycle arrives ~20d |
Hydraulic Cylinder SKU-002 · B · Meridian Hydraulics Ltd. | Jakarta DC Asia Pacific | 75 | 22 | 21.6 | 31 | 106 | 31d | Stockout risk | 90 u MOQ 50 · pack 10 | Order this cycle arrives ~20d |
Hydraulic Pump SKU-001 · C · Meridian Hydraulics Ltd. | Dallas DC North America | 13 | 4 | 6 | 7 | 27 | 20d | Stockout risk | 50 u MOQ 50 · pack 10 | Order this cycle arrives ~20d |
Hydraulic Pump SKU-001 · C · Meridian Hydraulics Ltd. | Jakarta DC Asia Pacific | 10 | 2 | 3.4 | 5 | 16 | 25d | Stockout risk | 50 u MOQ 50 · pack 10 | Order this cycle arrives ~20d |
Cutting Edge SKU-022 · B · Ironclad GET Works | Chennai DC Asia Pacific | 36 | 22 | 22.3 | 12 | 53 | 18d | Healthy | — | No action arrives ~14d |
Cutting Edge SKU-022 · B · Ironclad GET Works | Rotterdam DC Europe | 39 | 14 | 14.8 | 11 | 37 | 25d | Overstocked | — | Hold / no buy arrives ~14d |
Assumptions
- Cycle service level 95% (z = 1.645) for A and B items; C items reviewed at the same level for comparability.
- Lead time and σ taken from actual PO order-to-receipt history per supplier.
- Weekly review cycle; order-up-to level = reorder point + 4 weeks of forecast demand.
- Demand allocated to DCs using each DC's share of the last 52 weeks of adjusted demand.
What the grid is saying
The network is structurally under-covered. Across the five reviewed SKUs, cover runs 4-26 days against replenishment lead times of 17-33 days. 16 of 28 positions cannot survive a single lead time even with on-order stock counted, so the exposure is not a forecasting artefact — it is a policy gap.
Undercarriage is the largest single commitment. Track Shoe alone accounts for the biggest recommended buy, because Trackline's 33-day lead time and 10-day variability inflate both the lead-time demand term and the safety stock term of the reorder point.
No position is genuinely overstocked. Where the dataset looks "heavy" — Chennai on Seal Kit and Track Shoe — the cover is still only 3-4 weeks. Excess-inventory write-down is not the issue this cycle; expediting capacity and cash for the catch-up buy is.