Demand Forecasting
Hybrid demand intelligence: planned demand from the maintenance plan + failure-driven demand from each part's own history, pooled with the failure rate of every piece of equipment it is installed on.
Total spare-part demand: history and 12-month forecast
Units per month, all parts. History excludes turnaround issues (handled as event demand).
Demand patterns (Syntetos–Boylan classification)
Monthly demand, 17 months, turnaround excluded
| Pattern | Meaning | Parts | Forecast 12m |
|---|---|---|---|
| No demand | Never issued in 17 months | 5,625 | 43,720 |
| Single issue | Issued in only one month | 1,170 | 168,133 |
| Intermittent | Sporadic timing, stable size | 433 | 54,919 |
| Lumpy | Sporadic timing, variable size | 121 | 54,807 |
| Erratic | Regular timing, very variable size | 88 | 266,195 |
| Smooth | Regular demand, regular size | 44 | 63,021 |
Only 44 parts have smooth demand, so a single moving-average or Min–Max rule cannot work. Each part gets the method its evidence supports:
- • 5,630 parts — Installed-base failure prior (no history)
- • 1,526 parts — Credibility blend: own history + installed-base prior
- • 325 parts — Recency-weighted compound Poisson (own history)
Backtest: train May 2025 – Apr 2026, test May – Sep 2026
Units per part over the 5-month hold-out, turnaround excluded
| Method | WAPE | Bias | AUC |
|---|---|---|---|
| Static average (current practice) | 134% | +115% | 0.769 |
| Croston SBA (classical intermittent) | 96% | +58% | 0.763 |
| CALIBER hybrid model | 100% | +10% | 0.778 |
WAPE = total absolute error ÷ actual demand. Bias = over-forecast (+) or under-forecast (−); a static average over-forecasts by ~115% because it repeats turnaround and abnormal issues, which over-stocks the warehouse. AUC measures how well the model ranks which parts will be demanded — 267 parts with no training history were demanded in the test window, and only the installed-base prior can anticipate them.
ML early warning: will this part be needed in the next 90 days?
Gradient boosting on 59,848 part-month snapshots; tested out-of-time on 14,962 (origins 2026-06-01 to 2026-07-01 (+90d labels))
| Model | AUC | Avg precision | Brier | Hit rate, top 10% |
|---|---|---|---|---|
| Rule: issued in last 180 days | 0.789 | 0.551 | – | 42% |
| Statistical demand model (compound Poisson) | 0.826 | 0.588 | 0.056 | 46% |
| ML early warning (gradient boosting) | 0.895 | 0.672 | 0.036 | 48% |
Each row is a part at a monthly origin date; features use only data before the origin, the label is any non-turnaround issue in the next 90 days. Base rate 7.1%: of the 10% of parts the model ranks highest, 48% were actually needed (6.7× better than picking at random). The model complements the quantity forecast: it decides which parts to watch, the compound-Poisson model decides how many.
Calibration on the hold-out
| Predicted probability | Parts | Mean predicted | Actually needed |
|---|---|---|---|
| [0, 0.05] | 12,399 | 1.6% | 1.9% |
| (0.05, 0.1] | 905 | 7.3% | 10.1% |
| (0.1, 0.2] | 691 | 14.3% | 15.1% |
| (0.2, 0.3] | 214 | 24.1% | 31.3% |
| (0.3, 0.5] | 212 | 38.4% | 38.7% |
| (0.5, 0.7] | 81 | 59.8% | 53.1% |
| (0.7, 1.0] | 460 | 92.8% | 93.9% |
What drives the prediction
Permutation importance on the hold-out (drop in AUC when the feature is shuffled)
- Number of FuncLocs it is installed on0.042
- log10 unit price0.029
- Purchase requisitions in the last 180 days0.026
- Mean lead time (days)0.009
- Share of parts in its category issued in the last 180 days0.008
- Issue days since history start0.008
- Open PO quantity at the origin0.007
- FuncLocs with criticality A/B0.005
Installed base (how many FuncLocs a part sits on), price class, recent purchasing and lead time carry most of the signal — the same drivers the statistical model uses, learned from data instead of fixed.
Known future demand from the maintenance plan
Part-consuming jobs due per month (overhaul, filter replacement, lubrication)
A job consumes the parts in its FuncLoc's BoM that this kind of job replaces, at Installed Qty × a usage factor of 0.72 calibrated from preventive-order history. Inspection, calibration and test jobs consume none.
Next part-consuming maintenance jobs
| Due | Equipment | Job | Parts it uses |
|---|---|---|---|
| 01 Oct 2026 | PX_PP-517A CHARGE GAS PUMP · crit. B | Lube oil change | OIL |
| 01 Oct 2026 | PY_PP-1584B COOLING WATER PUMP · crit. B | Pump overhaul | BEARING, COUPLING, GASKET, IMPELLER, O-RING, RING, SEAL, SLEEVE, STUDBOLT |
| 01 Oct 2026 | PX_TCV-918 TEMPERATURE CONTROL VALVE · crit. C | Final Element Overhaul; CV | DIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET |
| 01 Oct 2026 | PX_PP-402A-M MOTOR FOR PP-402A · crit. B | Re-greasing Bearing Motor | GREASE |
| 01 Oct 2026 | PX_TCV-1974 HE-1967C TEMP CONTROL · crit. B | Final Element Overhaul; CV | DIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET |
| 01 Oct 2026 | PX_LCV-751B PP-520 LEVEL CONTROL · crit. C | Final Element Overhaul; Control Valve | DIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET |
| 01 Oct 2026 | PX_PP-1720D METHANOL PUMP · crit. C | Lube oil change | OIL |
| 01 Oct 2026 | PX_PP-1583A CAUSTIC PUMP · crit. B | Pump overhaul | BEARING, COUPLING, GASKET, IMPELLER, O-RING, RING, SEAL, SLEEVE, STUDBOLT |
| 01 Oct 2026 | PX_PP-679C QUENCH WATER PUMP · crit. A | Lube oil change | OIL |
| 01 Oct 2026 | PY_PP-1063 METHANE PUMP · crit. A | Lube oil change | OIL |
| 01 Oct 2026 | PX_PP-423A INHIBITOR PUMP · crit. A | Lube oil change | OIL |
| 01 Oct 2026 | PX_FCV-658 PP-1800A OUTLET FLOW · crit. C | Final Element Overhaul; CV | DIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET |
Abnormal consumption — last 90 days
Issues far above the part's normal size (robust z-score > 3.5). They are capped in the forecast so one unusual issue does not inflate stock levels; check for misuse, wrong bookings or a new failure mode.
| Date | Part | Issued | Normal up to |
|---|---|---|---|
| 30 Sept 2026 | 4100000129 BEARING,BALL,1ROW,DEEP GROOVE,6316 | 4 EA | 3 |
| 30 Sept 2026 | 4100029734 ELBOW,45DEG,1/2IN,SCH40,SS316,BW | 15 EA | 14.4 |
| 30 Sept 2026 | 4100073350 CASTABLE,REFRACTORY,DENSE,1500DEG C | 6,000 KG | 978 |
| 30 Sept 2026 | 4100073394 CASTABLE,REFRACTORY,INSUL,1600DEG C | 1,000 KG | 334 |
| 30 Sept 2026 | 4100098110 SCREW,TAPPING,M6X20MM,CS ZN | 500 EA | 359 |
| 30 Sept 2026 | 4100098171 SCREW,TAPPING,M5X25MM,SS304 | 5,000 EA | 515 |
| 30 Sept 2026 | 4100107132 OIL,LUBRICANT,ISO VG 32,MINERAL,1L | 200 L | 25.8 |
| 30 Sept 2026 | 4200004694 LAMP,LED,18W,24VDC,FLOOD | 4 EA | 3 |
| 29 Sept 2026 | 4100073350 CASTABLE,REFRACTORY,DENSE,1500DEG C | 1,000 KG | 978 |
| 29 Sept 2026 | 4200000138 TERMINAL,LUG,PIN,8X6MM,CRIMP | 1,500 EA | 669 |
| 27 Sept 2026 | 4100091498 GREASE,POLYUREA,NLGI 2,1KG | 5,000 KG | 180 |
| 27 Sept 2026 | 4100103434 TAPE,PTFE,19MMX10M | 22 RL | 13.4 |
126 abnormal issues in the last 90 days; the 12 most recent are shown.