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.
Network
Four regional distribution centers
- Dallas DCNorth America · USA180,000units cap.
- Rotterdam DCEurope · Netherlands150,000units cap.
- Chennai DCAsia Pacific · India200,000units cap.
- Jakarta DCAsia Pacific · Indonesia90,000units cap.
Suppliers
Category specialists, measured on actual PO history
| Supplier | Category | Lead time | σ | OTIF |
|---|---|---|---|---|
| Trackline Manufacturing | Undercarriage | 33.4 d | 10 d | 65.1% |
| Meridian Hydraulics Ltd. | Hydraulic Components | 20.4 d | 3.7 d | 58.3% |
| Circuit & Cab Electronics | Electrical & Cabin | 26 d | 5.4 d | 66% |
| Ironclad GET Works | Ground Engaging Tools | 13.7 d | 1.7 d | 68.3% |
| Vantage Engine Systems | Engine & Powertrain | 17.3 d | 2.4 d | 73.7% |
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.
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.
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.
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
| SKU | Product | Category | ABC | Avg weekly | 12-wk forecast avg |
|---|---|---|---|---|---|
| SKU-005 | Seal Kit | Hydraulic Components | A | 248.6 | 269.1 |
| SKU-009 | Air Filter | Engine & Powertrain | A | 360.4 | 368.2 |
| SKU-018 | Wiring Harness | Electrical & Cabin | A | 413.3 | 459.4 |
| SKU-011 | Track Chain | Undercarriage | B | 166.2 | 170.5 |
| SKU-001 | Hydraulic Pump | Hydraulic Components | C | 18.7 | 21.1 |