How to Reduce Uncertainty and Anticipate Change in your Supply Chain? Forecasting is key.

By

February 8, 2023
3 min read
How to Reduce Uncertainty and Anticipate Change in your Supply Chain? Forecasting is key.

Forecast quality is inevitably dependent on the quality of the underlying data. One-off events, such as a dramatic increase in sales or an unusual drop in demand, can dramatically change the forecast for the worse. Therefore, one must pay attention to the historic sales to produce accurate forecasts.

The AGR forecasting module is designed to catch all possible trends, including slow and fast movers, seasonal trends, or items increasing or decreasing in sale. This means that users do not need advanced statistical knowledge as the system handles the forecasting part automatically. As sales data arrives, the forecasting module automatically calculates sales forecasts based upon one of the following forecasting models to satisfy all mainstream business forecasting requirements. The best fitting forecasting method gets chosen automatically for an item depending on the nature of the product and the amount of historic data available. The following is a description of these forecasting models and the differences between them.

Expert Selection

Expert selection allows the Forecasting Module to select an appropriate univariate forecasting technique automatically. Expert selection operates as follows. If the data set is very short, Forecasting Module defaults to simple moving average. Otherwise Forecasting Module examines the data for the applicability of the intermittent or discrete forecast models. Although the forecasts produced from such models are just straight horizontal lines, they often provide forecasts superior to those from exponential smoothing for low- volume, messy data. If neither of these models are applicable to the data, the choice is now narrowed down to different forms of exponential smoothing and Box-Jenkins models. Forecasting Module next runs a series of tests on the data and applies a rule-based logic that may lead to a model selection based on data characteristics. If the rule-based logic does not lead to a definitive answer, Forecasting Module performs an out- of-sample test to choose between an exponential smoothing model and a Box-Jenkins model.

Simple Methods

Simple Method includes moving average models and is for very short or extremely volatile data. This is a common inventory management method – used by wholesalers and distributors for demand forecasting – to average the sales over the previous few months. This method can work well for items in consistent demand, but it does not work so well for others. Because different items can have a very different demand pattern, it is extremely important to choose the most relevant forecasting method for each item.

If the data set is very short or has fewer than 10 points the Forecasting Module defaults to simple moving average.

Exponential Smoothing

Exponential smoothing works as its name suggests. It extracts the level, trend and seasonal indexes by constructing smoothed estimates of these features, weighting recent data more heavily. It adapts to changing structure but minimizes the effects of outliers and noise. Twelve different Holt-Winters Exponential Smoothing Models are provided to accommodate a wide range of data characteristics. Exponential smoothing models capture and forecast the level of the data along with different types of trends and seasonal patterns. The models are adaptive, and the forecasts give greater emphasis to the recent history verses the more distant past. The robustness of exponential smoothing makes it ideal when there are no leading indicators, and when the data is too short or volatile for Box-Jenkins.

The ‘wait-and-see’ attitude to changes around them is the intuitive way people employ exponential smoothing in their daily living.

Keep in mind that although exponential smoothing can take the following factors into consideration when projecting a forecast; the trend, level, seasonal effects, event effects, random events and noise. They do not and cannot include the effects of future random events or noise, so the forecast is much smoother than the actual future will turn out to be.

Discrete Distribution

These models apply to data consisting of small whole numbers, including some zeroes. The forecasts are non-trended and non-seasonal. Discrete distributions are for use on data that might consist entirely of zeroes and small integers. Infrequently used spare parts is an example of items that often fall into this class.

Although the forecasts produced are just straight horizontal lines, they often provide forecasts superior to those from exponential smoothing for low-volume, messy data. 

Croston’s Intermittent Demand Model (Low Volume Model)

The Croston’s model is designed for data with numerous zeroes, like orders for a slow-moving part that is usually ordered to replenish stock. The non-zero data points are normally or log-normally distributed. The forecasts are non-trended and non-seasonal.

The time series consists of much sales data, especially for lower volume items with irregular demand. For many periods there is no demand at all. This might be the case for items that are usually ordered in batches to replenish downstream inventories. This method works by combining a smoothed estimate of the average demand for periods that have demand with a smoothed estimate of the average demand interval.

The forecasts produced will show straight horizontal lines.

Curve Fitting

Curve fitting identifies the general form of the curve that the data is following and is used to model the global trend of the historic sales data. Curve fitting is quite useful for short time series data, where the suggested minimum length is 10 data points. The curve fitting supports four types of curves: a straight line, quadratic, exponential, and growth (S-curve). Keep in mind that the curve does not accommodate seasonal patterns.

Box-Jenkins

Box-Jenkins works well for stable data sets and can capture and forecast both trend and seasonality. The data must consist of a minimum of 40 data points. The method is, quite simply, the richest family of statistical models that can be practically applied in the real world. Ideally, a forecaster would switch between Box-Jenkins and exponential smoothing models, depending on the properties of the data, which is precisely what the Forecasting Module automatic selection is designed to do. Box-Jenkins and Exponential Smoothing differ in that they are based on autocorrelations (stable data sets) rather than a structural view of level, trend and seasonality. Box-Jenkins models tend to perform better than exponential smoothing models for longer, more stable data sets and not as well for noisier, more volatile data.

How is your company forecasting your products? Feel free to contact us to see if our forecasting software can help your organization. 

Related Posts
November 11, 2024
6 min read
Discover how AGR’s inventory management solution bridges the gaps left by traditional ERPs, bringing advanced forecasting, automated ordering, and real-time insights to your supply chain—all up and running in as little as a week.

By

October 22, 2024
6 min read
If you’re looking for ways to reduce inventory on hand, avoid stockouts, optimize orders, and streamline manual processes, a stock management solution should be a top priority in your 2025 budget

By