TT
TerraTrac Equipment Parts
Demand Forecasting & Supply Planning
Case study

TerraTrac Equipment Parts — Demand Forecasting & Supply Planning

TerraTrac distributes spare parts for heavy construction equipment across five categories, operating four regional distribution centers and sourcing from five category-specialist suppliers. This dashboard reviews two years of weekly sell-through, the current inventory position, and 220 historical purchase orders to produce a 12-week forecast and a replenishment plan.

Forecast accuracy (WMAPE)
23.1%
vs 24% naive baseline
Positions below reorder point
26 / 28
16 cannot cover one lead time
Recommended buy this cycle
$8.16M
MOQ and pack size respected
Worst supplier lead time
33.4 d
Trackline Mfg · σ 10.0 d · P95 51 d

Network

Four regional distribution centers

  • Dallas DC
    North America · USA
    180,000
    units cap.
  • Rotterdam DC
    Europe · Netherlands
    150,000
    units cap.
  • Chennai DC
    Asia Pacific · India
    200,000
    units cap.
  • Jakarta DC
    Asia Pacific · Indonesia
    90,000
    units cap.

Suppliers

Category specialists, measured on actual PO history

SupplierCategoryLead timeσOTIF
Trackline ManufacturingUndercarriage33.4 d10 d65.1%
Meridian Hydraulics Ltd.Hydraulic Components20.4 d3.7 d58.3%
Circuit & Cab ElectronicsElectrical & Cabin26 d5.4 d66%
Ironclad GET WorksGround Engaging Tools13.7 d1.7 d68.3%
Vantage Engine SystemsEngine & Powertrain17.3 d2.4 d73.7%
Forecast

Seasonal + promo regression is the better planning basis

A trend + Fourier-seasonality + promotion regression averages 23.1% WMAPE per SKU x DC on a blind 8-week holdout, versus 24% for a 52-week moving average, and it removes the systematic under-forecast the moving average carries into promotion weeks. Every reviewed SKU shows a clear annual cycle and a measurable promotion lift.

Data quality

Undercarriage demand in weeks 41-46 is censored, not soft

The weeks 41-46 supply disruption at Chennai and Jakarta suppressed observed sell-through for all five Undercarriage SKUs by an average of 163%. Uncorrected, it drags the forecast down and understates safety stock for the least reliable supplier in the network.

Inventory

26 of 28 SKU x DC positions sit below reorder point

Network-wide cover is 1-3 weeks against supplier lead times of 2-5 weeks. 16 positions cannot even cover a single replenishment lead time; $8.16M of buys are recommended this cycle.

Supply

Trackline Manufacturing is the structural constraint

33.4-day actual average lead time with a 10-day standard deviation and a 51-day P95 — roughly double every other supplier. It drives the largest safety-stock requirement in the portfolio and warrants a secondary source.

SKUs in scope

Five SKUs spanning three ABC classes and four categories

SKUProductCategoryABCAvg weekly12-wk forecast avg
SKU-005Seal KitHydraulic ComponentsA248.6269.1
SKU-009Air FilterEngine & PowertrainA360.4368.2
SKU-018Wiring HarnessElectrical & CabinA413.3459.4
SKU-011Track ChainUndercarriageB166.2170.5
SKU-001Hydraulic PumpHydraulic ComponentsC18.721.1