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:
Service Level Driven Planning (SLDP) is an approach to inventory planning based on exposing the tradeoffs between SKU availability and inventory cost that are at the root of all wise inventory decisions. When organizations understand these tradeoffs, they can make better decisions and have greater variability into the risk of stockouts. SLDP unfolds in four steps: Benchmark, Collaborate, Plan, and Track.
Inventory optimization has become an even higher priority in recent months for many of our customers. Some are finding their products in vastly greater demand; more have the opposite problem. In either case, events like the Covid19 pandemic are forcing a reexamination of standard operating conditions, such as choices of reorder points and order quantities.
In this Video Dr. Thomas Willemain, co–Founder and SVP Research, defines and compares the three most used inventory control policies. These policies are divided into two groups, periodic review and continuous review. There is also a fourth policy called MRP logic or forecast based inventory planning which is the subject of a separate video blog that you can see here. These videos explain each policy, how they are used in practice and the pros and cons of each approach.