The Smart Forecaster
Pursuing best practices in demand planning, forecasting and inventory optimization
Service level is a key performance indicator for companies that put a premium on satisfying customer demand. Service level is defined as the probability of surviving a replenishment lead time without stocking out.
Inventory management best practice begins with setting service level targets, then calculates reorder points (also called Mins) to achieve those targets. These calculations should account for variability in both demand and replenishment lead time. There are many software systems available for doing these calculations. If everything works out, the achieved service level ends up very close to the target service level. Unfortunately, there is often a painful gap between the two.
One reason for the gap is unrealistic models of demand. In many cases, software for calculating reorder points uses textbook formulas based on mathematical assumptions that make analysis simple at the expense of realism. Many “Inventory 101” textbooks use formulas that assume demand has a Normal distribution (a.k.a. the “bell-shaped curve”) for finished goods and the Poisson distribution for spare parts. Fortunately, there are now inventory optimization and forecasting systems that process the actual demand histories of the inventory items using probabilistic forecasting. These solutions calculate an accurate estimate of the distribution – not some idealized version. To learn more check out this past blog on probabilistic forecasting:
But there is a second source of error in textbooks that operates invisibly in many inventory software package: “undershoot”.
Calculations of reorder points almost always assume that stockouts arise when the total demand during a replenishment interval exceeds the reorder point. For example, assume that demand averages 1 unit per day. If lead time is 5 days, then on average lead time demand is 5 units. Setting the reorder point at 5 units would yield a laughable service level somewhere in the vicinity of 50%. Adding safety stock to the calculation might result in a reorder point of, say, 11 units, which might correspond to a service level of 95%. Another way to say this is, starting at a reorder point of 11 units, there should be a 95% chance of surviving the 5 day lead time without experiencing cumulative demand of more than 11 units. Theoretically!
What’s missing from this analysis is the undershoot phenomenon. Undershoot means that the lead time begins not at the reorder point but below it. Undershoot happens every time the demand that breached the reorder point took the stock down below (not down to) the reorder point. The figure below shows replenishment cycles with and without undershoot. Undershoot picks your pocket before you even begin to roll the dice. It deludes the inventory professional into thinking his or her reorder points are sufficient to achieve their targets, whereas actual performance will not make the grade.
There is only one situation in which undershoot is not a worry: when demand is always either zero or one unit. In that case, undershoot is impossible. But in all other cases, undershoot is sure to happen to some extent, and it can seriously undercut the service level actually achieved by a given choice of reorder point. Our analyses show that the conditions most vulnerable to undershoot involve highly intermittent and skewed demand with very short lead times – the very conditions being made most common by market trends.
What can be done to protect yourself from the effect of undershoot on reorder point calculations? Use inventory optimization and forecasting software that isn’t tied to the old textbook assumptions and instead automatically accounts for undershoot when calculating the service level produced by any choice of reorder point.
To see Smart Software’s Inventory Optimization solution in action, register to see a recorded demo below:
The three types of supply chain analytics are “descriptive”, “predictive”, and “prescriptive.” Each plays a different role in helping you manage your inventory. Modern supply chain software lets you exploit all three helping you to reduce inventory costs, improve on time delivery and service levels, while running a more efficient supply chain.
We just need to feed our demand histories into our new statistical methods, and we can start planning more effectively. Not quite: it’s about the technology and the process. You are investing in a new business process to develop forecasts for driving business strategy and inventory planning decisions.
No, not that kind of regime change: Nothing here about cruise missiles and stealth bombers. And no, we’re not talking about the other kind of regime change that hits closer to home: Shuffling the C-Suite at your company. In this blog, we discuss the relevance of regime change on time series data used for demand planning and forecasting.