TT
TerraTrac Equipment Parts
Demand Forecasting & Supply Planning
Part 2

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.

Critical positions
16
cover < one lead time
Below reorder point
26 / 28
action required this cycle
Healthy / overstocked
1 / 1
1 healthy · 1 overstocked position
Recommended buy (filtered)
$8.16M
at standard unit cost
Filter

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.

SKUDCOn handOn orderFcst / wkSafety stockReorder pointDoSFlagRecommendTiming
Air Filter
SKU-009 · A · Vantage Engine Systems
Chennai DC
Asia Pacific
64811281364168dCritical
560 u
MOQ 20 · pack 10
Order now
arrives ~17d
Seal Kit
SKU-005 · A · Meridian Hydraulics Ltd.
Dallas DC
North America
5713592.711240415dCritical
505 u
MOQ 20 · pack 5
Order now
arrives ~20d
Seal Kit
SKU-005 · A · Meridian Hydraulics Ltd.
Rotterdam DC
Europe
35056.8932864dCritical
445 u
MOQ 20 · pack 5
Order now
arrives ~20d
Track Chain
SKU-011 · B · Trackline Manufacturing
Chennai DC
Asia Pacific
304358.81554929dCritical
755 u
MOQ 25 · pack 5
Order now
arrives ~33d
Track Chain
SKU-011 · B · Trackline Manufacturing
Dallas DC
North America
109585212540022dCritical
510 u
MOQ 25 · pack 5
Order now
arrives ~33d
Air Filter
SKU-009 · A · Vantage Engine Systems
Jakarta DC
Asia Pacific
53057.4571916dCritical
280 u
MOQ 20 · pack 10
Order now
arrives ~17d
Track Chain
SKU-011 · B · Trackline Manufacturing
Rotterdam DC
Europe
26031.3892876dCritical
460 u
MOQ 25 · pack 5
Order now
arrives ~33d
Track Chain
SKU-011 · B · Trackline Manufacturing
Jakarta DC
Asia Pacific
79028.47624819dCritical
345 u
MOQ 25 · pack 5
Order now
arrives ~33d
Wiring Harness
SKU-018 · A · Circuit & Cab Electronics
Dallas DC
North America
14447124.114451711dCritical
700 u
MOQ 5 · pack 10
Order now
arrives ~26d
Hydraulic Cylinder
SKU-002 · B · Meridian Hydraulics Ltd.
Chennai DC
Asia Pacific
74043.35921612dCritical
300 u
MOQ 50 · pack 10
Order now
arrives ~20d
Wiring Harness
SKU-018 · A · Circuit & Cab Electronics
Rotterdam DC
Europe
1020108.71184117dCritical
610 u
MOQ 5 · pack 10
Order now
arrives ~26d
Wiring Harness
SKU-018 · A · Circuit & Cab Electronics
Jakarta DC
Asia Pacific
111072.38630411dCritical
420 u
MOQ 5 · pack 10
Order now
arrives ~26d
Hydraulic Pump
SKU-001 · C · Meridian Hydraulics Ltd.
Chennai DC
Asia Pacific
907.110359dCritical
60 u
MOQ 50 · pack 10
Order now
arrives ~20d
Cutting Edge
SKU-022 · B · Ironclad GET Works
Dallas DC
North America
12102113537dCritical
75 u
MOQ 50 · pack 5
Order now
arrives ~14d
Hydraulic Pump
SKU-001 · C · Meridian Hydraulics Ltd.
Rotterdam DC
Europe
314.67226dCritical
50 u
MOQ 50 · pack 10
Order now
arrives ~20d
Cutting Edge
SKU-022 · B · Ironclad GET Works
Jakarta DC
Asia Pacific
6012.57273dCritical
50 u
MOQ 50 · pack 5
Order now
arrives ~14d
Seal Kit
SKU-005 · A · Meridian Hydraulics Ltd.
Chennai DC
Asia Pacific
2566682.816651027dStockout risk
535 u
MOQ 20 · pack 5
Order this cycle
arrives ~20d
Air Filter
SKU-009 · A · Vantage Engine Systems
Dallas DC
North America
1131211048331716dStockout risk
320 u
MOQ 20 · pack 10
Order this cycle
arrives ~17d
Air Filter
SKU-009 · A · Vantage Engine Systems
Rotterdam DC
Europe
1621578.98726116dStockout risk
260 u
MOQ 20 · pack 10
Order this cycle
arrives ~17d
Seal Kit
SKU-005 · A · Meridian Hydraulics Ltd.
Jakarta DC
Asia Pacific
863636.95920223dStockout risk
225 u
MOQ 20 · pack 5
Order this cycle
arrives ~20d
Wiring Harness
SKU-018 · A · Circuit & Cab Electronics
Chennai DC
Asia Pacific
284107154.318063318dStockout risk
700 u
MOQ 5 · pack 10
Order this cycle
arrives ~26d
Hydraulic Cylinder
SKU-002 · B · Meridian Hydraulics Ltd.
Dallas DC
North America
133037.45619425dStockout risk
200 u
MOQ 50 · pack 10
Order this cycle
arrives ~20d
Hydraulic Cylinder
SKU-002 · B · Meridian Hydraulics Ltd.
Rotterdam DC
Europe
83025.43412623dStockout risk
140 u
MOQ 50 · pack 10
Order this cycle
arrives ~20d
Hydraulic Cylinder
SKU-002 · B · Meridian Hydraulics Ltd.
Jakarta DC
Asia Pacific
752221.63110631dStockout risk
90 u
MOQ 50 · pack 10
Order this cycle
arrives ~20d
Hydraulic Pump
SKU-001 · C · Meridian Hydraulics Ltd.
Dallas DC
North America
134672720dStockout risk
50 u
MOQ 50 · pack 10
Order this cycle
arrives ~20d
Hydraulic Pump
SKU-001 · C · Meridian Hydraulics Ltd.
Jakarta DC
Asia Pacific
1023.451625dStockout risk
50 u
MOQ 50 · pack 10
Order this cycle
arrives ~20d
Cutting Edge
SKU-022 · B · Ironclad GET Works
Chennai DC
Asia Pacific
362222.3125318dHealthy—
No action
arrives ~14d
Cutting Edge
SKU-022 · B · Ironclad GET Works
Rotterdam DC
Europe
391414.8113725dOverstocked—
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.