The Smart Forecaster
Pursuing best practices in demand planning,
forecasting and inventory optimization
Most demand forecasts are partial or incomplete: They provide only one single number: the most likely value of future demand. This is called a point forecast. Usually, the point forecast estimates the average value of future demand.
Much more useful is a forecast of full probability distribution of demand at any future time. This is more commonly referred to as probability forecasting and is much more useful.
The Average is Not the Answer
The one advantage of a point forecast is its simplicity. If your ERP system is also simple, the point forecast fills in the one number needed by the ERP system to do workforce scheduling or raw material purchases.
The disadvantage of a point forecast is that it is too simple. It ignores additional information in an item’s demand history that can give you a more complete picture of how demand might unfold: a probability forecast.
Going Beyond the Average: Probability Forecasting
While the point forecast provides limited information, e.g., “The most likely demand next month is 15 units”, the probability forecast adds crucial information, e.g., “There is a 20% chance that demand will exceed 28 units and a 10% chance that it will be less than 5 units”.
This information lets you do risk assessment and contingency planning. Contingency planning is necessary because the point forecast usually has only a small chance of actually being correct. A probability forecast may also say “The chance of demand being 15 units is only 10%, even though it is the single most likely value.” In other words, there is a 90% chance that the point forecast is wrong. This kind of error is not a mistake in the forecasting calculations: it is the reality of dealing with demand volatility. It might better be called an “uncertainty” than an “error”.
An operations manager can use the extra information in a probability forecast in both informal and formal ways. Informally, even if an ERP system requires a single-number forecast as input, a wise manager will want to have some clue about the risks associated with that point forecast, i.e., its margin of error. So a forecast of 15 ± 1 unit is a lot safer than a forecast of 15 ± 10. The ± part is a compression of a probabilistic forecast. Figure 1 below shows an item’s demand history (red line), point forecasts for the next 12 months (green line) and their margins of error (cyan lines). The lowest forecast of about 3,300 units occurs in June, but the actual demand might be as much as 800 units higher or lower.
Bonus: Application to Inventory Management
Inventory management requires that you balance item availability against the inventory cost. It turns out that knowing the full probability distribution of demand over a replenishment lead time is essential for setting reorder points (also called mins) on a rational, scientific basis. Figure 2 shows a probability forecast of total demand during the 33 week replenishment lead time for a certain spare part. While the average lead time demand is 3 units, the most likely demand is zero, and a reorder point of 14 is needed to insure that the chance of stocking out is only 1%. Once again, the average is not the answer.
Knowing more is always better than knowing less and the probability forecast provides that extra bit of crucial information. Software has been able to supply a point forecast for over 40 years, but modern software can do better and provide the whole picture.
Figure 1: The red line shows the demand history of a finished good. The green line shows the point forecasts for the next 12 months. The blue lines indicate the margins of error in the 12 point forecasts.
Figure 2: A probabilistic forecast of demand for a spare part over a 33 week replenishment lead time. The most likely demand is zero, the average demand is 3, but a reorder point of 14 units is required to have only a 1% chance of stock out.
Do your statistical forecasts suffer from the wiggle effect?
What is the wiggle effect? It’s when your statistical forecast incorrectly predicts the ups and downs observed in your demand history when there really isn’t a pattern. It’s important to make sure your forecasts don’t wiggle unless there is a real pattern. Here is a transcript from a recent customer where this issue was discussed:
How to Handle Statistical Forecasts of Zero
A statistical forecast of zero can cause lots of confusion for forecasters, especially when the historical demand is non-zero. Sure, it’s obvious that demand is trending downward, but should it trend to zero?
Smart Software’s article has won 1st place in the 2022 Supply Chain Brief MVP Awards Forecasting category!
Smart Software is pleased to announce that our article “Managing Inventory amid Regime Change” has won 1st place in the Forecasting category of the 2022 Supply Chain Brief MVP Awards.