Procurement & Supply Chain

Spare parts inventory optimisation: service level vs. working capital

Spare parts demand is lumpy, slow and long-tailed, so textbook safety stock often fails. How to segment parts, set service levels per segment and clear out slow-moving and obsolete stock.

Not ready to talk yet? Take the 3-minute Procurement Data Check

IllustrativeExcess stockSweet spot95% service levelInventory valueService level

TL;DR

  • Don’t set one service level for all parts. Segment by value, demand pattern and criticality.
  • Most spare parts have intermittent demand. Normal-distribution safety stock overstocks some and understocks others.
  • Slow-moving and obsolete stock needs a rule, an owner and a monthly review, or it keeps growing.
  • The trade-off curve shows what each extra point of fill rate costs in stock. Decide on it explicitly.
For:Supply chain planningSpare parts logisticsControllingHead of Service

How should you segment spare parts?

DimensionClassesWhy
Value (ABC)A = top 80% of consumption valueWhere the working capital sits
Demand pattern (XYZ)X regular, Y fluctuating, Z sporadicWhich forecasting and stocking method fits
CriticalityMachine down / degraded / no impactHow much a stock-out hurts
LifecycleRamp-up, mature, run-out, end of lifeBuild stock or reduce it

Most spare parts are Z parts

In a typical spare parts range, a large share of items sells only a few times a year. Classic safety stock formulas assume regular demand and don’t fit. Use methods built for intermittent demand, or a simple min/max with a criticality rule.

Which service level for which segment?

SegmentTarget fill rateStocking rule
A · X · critical98–99%Forecast-based safety stock
A · Z · critical95%Min/max of 1–2 pieces, reorder on use
C · Z · critical95%Insurance stock, central warehouse only
C · Z · non-critical80–85% or to orderNo stock, quote the lead time
End-of-life partsPer last-time-buy planRun out, no replenishment

What does the trade-off look like?

INVENTORY NEEDED BY FILL-RATE TARGET ($M)85% fill rate$4.1M90% fill rate$5M95% fill rate$6.6M98% fill rate$8.9M99% fill rate$10.8MIllustrative. The last points of fill rate cost the most stock.
Fill rate      = order lines delivered from stock ÷ all order lines
Days of cover  = stock value ÷ average daily consumption value
Slow mover     = no issue in the last 12 months, stock > 0
Obsolete       = no issue in 36 months, no where-used in active BOMs,
                 and no installed machines that still need it

How do you clear slow-moving and obsolete stock?

SLOW AND OBSOLETE STOCK CLEAN-UPIdentifySlow and obsoleteby ruleCheck installedbaseStill needed formachines in thefield?DecideKeep, reduce,return, scrapWrite downTogether withcontrollingPreventLot sizes,end-of-life process
  • Return parts to suppliers where agreements allow.
  • Offer parts to customers whose machines use them, as kits or maintenance offers.
  • Reduce lot sizes for slow movers. Large lots are the main source of excess.
  • Run an end-of-life process with every product discontinuation: last-time buy for long-life parts, run-out for the rest.

Checklist

  • 24–36 months of issues per part
  • Criticality per part, agreed with service
  • Installed base per machine type
  • Stock and value per warehouse
  • Agreed fill-rate targets per segment

FAQ

What is a good fill rate for spare parts?

It depends on the segment. Critical, high-volume parts often target 95–99%, while non-critical, sporadic parts can run lower or on order. One rate for all parts wastes working capital.

What is intermittent demand?

Demand that occurs irregularly, with many periods of zero demand. It is typical for spare parts and needs different forecasting methods than regular demand.

How do we define obsolete spare parts?

Parts with no issues for a long period, often 24 to 36 months, no where-used in active BOMs and no installed machines that still need them.

Should slow-moving spare parts be scrapped?

Not automatically. Check the installed base first. A part with no recent demand may still be the only part that fits machines in the field.

What is an ABC/XYZ analysis?

A segmentation of parts by consumption value (ABC) and demand regularity (XYZ). It helps set different stocking and forecasting rules per segment.

How much working capital sits in your spare parts?

Send us stock, consumption and BOM data under NDA. We’ll return a segmented stock view with slow movers, obsolete stock and target levels.

Similar Posts