Sparely
DU

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.

Forecast next 12 months
650,795 units
36,100 units from planned maintenance jobs
Parts with irregular demand
99%
Intermittent, lumpy, erratic, single-issue or never used
Forecast bias (backtest)
10% vs 115%
Sparely model vs static average, May–Sep 2026 hold-out
Demand detection AUC
0.778
Ranks which parts will be needed (1.0 = perfect, 0.5 = random)

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

PatternMeaningPartsForecast 12m
No demandNever issued in 17 months5,62543,720
Single issueIssued in only one month1,170168,133
IntermittentSporadic timing, stable size43354,919
LumpySporadic timing, variable size12154,807
ErraticRegular timing, very variable size88266,195
SmoothRegular demand, regular size4463,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

MethodWAPEBiasAUC
Static average (current practice)134%+115%0.769
Croston SBA (classical intermittent)96%+58%0.763
CALIBER hybrid model100%+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))

ModelAUCAvg precisionBrierHit rate, top 10%
Rule: issued in last 180 days0.7890.551–42%
Statistical demand model (compound Poisson)0.8260.5880.05646%
ML early warning (gradient boosting)0.8950.6720.03648%

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 probabilityPartsMean predictedActually needed
[0, 0.05]12,3991.6%1.9%
(0.05, 0.1]9057.3%10.1%
(0.1, 0.2]69114.3%15.1%
(0.2, 0.3]21424.1%31.3%
(0.3, 0.5]21238.4%38.7%
(0.5, 0.7]8159.8%53.1%
(0.7, 1.0]46092.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

DueEquipmentJobParts it uses
01 Oct 2026PX_PP-517A
CHARGE GAS PUMP · crit. B
Lube oil changeOIL
01 Oct 2026PY_PP-1584B
COOLING WATER PUMP · crit. B
Pump overhaulBEARING, COUPLING, GASKET, IMPELLER, O-RING, RING, SEAL, SLEEVE, STUDBOLT
01 Oct 2026PX_TCV-918
TEMPERATURE CONTROL VALVE · crit. C
Final Element Overhaul; CVDIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET
01 Oct 2026PX_PP-402A-M
MOTOR FOR PP-402A · crit. B
Re-greasing Bearing MotorGREASE
01 Oct 2026PX_TCV-1974
HE-1967C TEMP CONTROL · crit. B
Final Element Overhaul; CVDIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET
01 Oct 2026PX_LCV-751B
PP-520 LEVEL CONTROL · crit. C
Final Element Overhaul; Control ValveDIAPHRAGM, GASKET, O-RING, PACKING SET, SEAT RING, SPRING, STUDBOLT, TRIM SET
01 Oct 2026PX_PP-1720D
METHANOL PUMP · crit. C
Lube oil changeOIL
01 Oct 2026PX_PP-1583A
CAUSTIC PUMP · crit. B
Pump overhaulBEARING, COUPLING, GASKET, IMPELLER, O-RING, RING, SEAL, SLEEVE, STUDBOLT
01 Oct 2026PX_PP-679C
QUENCH WATER PUMP · crit. A
Lube oil changeOIL
01 Oct 2026PY_PP-1063
METHANE PUMP · crit. A
Lube oil changeOIL
01 Oct 2026PX_PP-423A
INHIBITOR PUMP · crit. A
Lube oil changeOIL
01 Oct 2026PX_FCV-658
PP-1800A OUTLET FLOW · crit. C
Final Element Overhaul; CVDIAPHRAGM, 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.

DatePartIssuedNormal up to
30 Sept 20264100000129
BEARING,BALL,1ROW,DEEP GROOVE,6316
4 EA3
30 Sept 20264100029734
ELBOW,45DEG,1/2IN,SCH40,SS316,BW
15 EA14.4
30 Sept 20264100073350
CASTABLE,REFRACTORY,DENSE,1500DEG C
6,000 KG978
30 Sept 20264100073394
CASTABLE,REFRACTORY,INSUL,1600DEG C
1,000 KG334
30 Sept 20264100098110
SCREW,TAPPING,M6X20MM,CS ZN
500 EA359
30 Sept 20264100098171
SCREW,TAPPING,M5X25MM,SS304
5,000 EA515
30 Sept 20264100107132
OIL,LUBRICANT,ISO VG 32,MINERAL,1L
200 L25.8
30 Sept 20264200004694
LAMP,LED,18W,24VDC,FLOOD
4 EA3
29 Sept 20264100073350
CASTABLE,REFRACTORY,DENSE,1500DEG C
1,000 KG978
29 Sept 20264200000138
TERMINAL,LUG,PIN,8X6MM,CRIMP
1,500 EA669
27 Sept 20264100091498
GREASE,POLYUREA,NLGI 2,1KG
5,000 KG180
27 Sept 20264100103434
TAPE,PTFE,19MMX10M
22 RL13.4

126 abnormal issues in the last 90 days; the 12 most recent are shown.