This is Part 1 of a two-part series on inventory forecasting. This blog provides some basic information about viable inventory forecasting techniques. Forecasting is a key step in inventory planning but not the only one. There are other key variables and processes that come into play in good supply chain replenishment planning including inventory rationalization and optimization..
Forecasting customer demand is an important and necessary part of the chain of calculations needed to optimize inventory stocking levels. There are a wide variety of techniques that can be used, making forecasting a confusing and sometimes difficult process. If your goal is to not only forecast demand but also stock inventory at optimal levels, then forecasting must be combined with inventory planning and replenishment optimization algorithms to reach the goals of higher service levels with less inventory.
Forecasting is an important part of inventory replenishment planning
Modern inventory planning systems perform a statistical analysis of historical item usage patterns to predict future usage. Some also employ demand-sensing techniques using real-time data in addition to some historic demand. After calculating a new forecast, the systems determine optimal stocking levels. On a day-to-day basis, they compare actual inventory status with optimal stocking levels to decide what to order and when. Thus, forecasts are a fundamental piece of inventory planning. The more accurate and usable the forecasts, the better job the planning can do in making sure service levels are high enough with a minimum of inventory.
The starting point for forecasting is clean and reliable demand history data
Item demand history is usually taken from actual sales or item order or shipping data. However, some businesses are able to capture customer demand requests that may or may not be satisfied from stock.
For inventory planning, forecasting usually deals with a time series of monthly or weekly data. Many times there are high demand spikes that need to be reviewed. What caused the spikes? Some examples might be:
- A data entry error leading to an erroneous data point in the organization’s transaction system. This happens more frequently than one would imagine.
- A special promotion for the item leading to a heavy demand in the off-season month.
- A large new customer signed on and stocked its locations, an event likely to be repeated when other new customers sign on.
Abnormal history data like this can be identified by methods such as Statistical Process Control (Control Charts). Some systems automatically eliminate or dampen these “outliers” which is helpful but can also be problematic if the cause is not known by the planner. Others change their value to be in the expected range. A third approach is to identify the situation automatically and have a user/planner change the outlier history value to one that most reasonably acts as a guide for forecasting.
Forecasting techniques vary by type of demand
The forecasting process must indicate what level of demand is expected, by month, and the demand variance (how much the demand might spike.) The expected demand indicates the inventory needed for the re-supply period. The variance leads to a calculation of the safety or buffer stock needed to cover demand surges.
Statistical analysis of historical demand generates forecasts with three components: level, trend, and seasonality.
Some products are staples with a fairly steady demand month after month. A moving window average of the last x months of demand can give a good picture of the level of demand, which may have some gradual changes.
Trend Up or Down
Other products have a rising or falling “trend.” The moving window average tends to lag behind reality, so a regression analysis finding a best fit straight line through the data points can give a better forecast.
The straight line fit may be misleading, however, if the history values bounce around a lot. The regression fit will show a downward trend, but the history curve bounces so much you don’t know if this trend is real. In such a case, you need to be careful how quickly you reduce the inventory levels. A statistical calculation called the R2 test tells how much confidence we should have in the regression fit.
Many items have large demand at certain times of year and little or no demand at other times. For example, parts for lawn mower repairs have a large demand spring and early summer, and little demand over the winter. Air conditioners and parts will have a slightly later season. Trend analysis for these items will often show an upward or downward trend when the real underlying behavior is a change of season.
Seasonal demand is best modeled by observing the demand for each calendar month over several years of history. These monthly averages can be smoothed if seasonal changes are gradual. Some forecasters model the seasonal changes with a Fourier Series (general approach to model any periodic function), but this is usually overkill. Box-Jenkins analysis (also referred to as Autoregressive/Integrated/Moving Average, or ARIMA) is a powerful way to analyze periodic time series data. It is also overkill in general, as the period is almost always 12 months for inventory planning situations. In some applications other periods, such as end-of-quarter hockey sticks, may make the ARIMA approach more useful.
Find out More!