Safety stock sized on the interval
A foodservice distributor of frozen bakery ships about 10,800 cases a week, at a stock cost of about €38 a case. It ordered to last year’s week plus 6%, and kept three weeks of safety stock because nobody trusted the plus 6%.
On 182 weeks auto-ARIMA chose a seasonal model on a 52-week cycle, and the residuals passed: Ljung-Box p of 0.38. The band ran ±7% next week to ±15% by week twelve. Replayed 26 times over the previous year, the model missed by 6.4% twelve weeks ahead, and the band held the actual week 293 times in 312. Sized on the band, safety stock fell to 1.9 weeks: about €450k of working capital.
Read the full caseThe backtest that earned the forecast a vote
error twelve weeks ahead, 26 rolling originsMean absolute error. The 95% interval held the actual week in 94% of the forecasts, which is what lets you stock to it.