Spare Parts & Slow Movers: Intermittent Demand, ADI & CV², Croston Forecasts, Service-Level Stock, Criticality and Dead Stock
Plan stock for parts that sell rarely and unpredictably: classify demand patterns, forecast with Croston's method, measure errors without MAPE traps, set stock for a service level, rank critical parts and clean out dead stock, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course plans the stock of slow-moving spare parts for a fictional maintenance store in a spreadsheet. You split demand histories full of zeros into demand frequency and size, calculate the average demand interval and CV² to classify parts as smooth, erratic, intermittent or lumpy, see why moving averages lag, continue a Croston forecast with its SBA bias correction, compare forecasts with MAE, bias and scaled MAE instead of MAPE, set min and max stock from a fictional lead-time probability table with XLOOKUP and CEILING, build a criticality × value matrix with COUNTIFS and review dead stock with YEAR, MONTH and SUMIFS.
Lessons
- Demand With Zeros: Demand Months, Average Interval and Demand Size Pro
- Smooth, Erratic, Intermittent or Lumpy: Classifying Parts by ADI and CV² Pro
- Why Moving Averages Fail on Lumpy Demand Pro
- Croston's Method: Smoothing Size and Interval Separately Pro
- Measuring Forecast Error Without the MAPE Trap Pro
- Service-Level Stock From a Probability Table: Min and Max Levels Pro
- Criticality × Value: A Stocking Policy for Every Cell of the Matrix Pro
- Dead Stock & the Spare Parts Dashboard Pro