Five popular beliefs about sales forecasts

  • Sales forecasts are always false
  • Don’t forecast when sales are low
  • Use technology to manage complex, multiple data sets
  • Only one sales forecast is necessary
  • Remember, using sales forecasts is complicated

Sales forecasting is essential for supply chain stock optimization and inventory flows management. Although a simple concept, sales forecasting is misunderstood by many. To fully comprehend the attributes of sales forecasting, it is vital to understand the nature of a forecast, how it is used, created and interpreted. Intuition alone is inadequate when referencing mathematical models, impact factors or probability. Here, we examine five popular beliefs about sales forecasts in the supply chain. We clarify the fundamental concepts with examples to help readers use the sales forecasts wisely and with unbeatable results.

1. SALES FORECASTS ARE ALWAYS FALSE

Before identifying a forecast is false, it’s essential to know what it is and what it really means. Unlike intuition, a sales forecast is not a “bet”, or a number of sales that will take place at a given time for a given product at a given location. In the broadest sense, a forecast assesses the weight associated with each possible value for the quantity to be sold. This weighting is called a probability. In Figure 1, we provide two forecast examples (a and b) and do not recognize only one single possible sale value, but several weighted values.

Unlike the probability-based view describing future possibilities, far often do we find the sales forecast expressed or understood as a single whole number, associated with some remaining uncertainty. Realistically, this number represents the average quantity sold (or “expected” quantity). It should be noted that there are more possible values outside of this single averaged value. In Figure 1 (b), we see that the average value is 1.40, but the forecast indicates that it is more likely to sell the quantity of 0, 1 or 2. The probability of selling three or more is relatively low. In all cases, the quantity sold will be different from the expected value (1.40 as in Figure 1). A naive reading would concur that the forecast is “false.”

For supply use, the forecast of sales as expressed by probabilities is the necessary figure since it directly links the forecast, target service rate and quantity to be supplied. In Figure 1, let us imagine that we want to determine what is the quantity of stock that guarantees a service rate of at least 98% (to have a maximum 2% stock-out rate) . In Figure 1 (a), the probability of selling the quantity of 0 or 1 or 2 is equal to the sum of probabilities of selling 0, 1 or 2 (here, 98.5%). This emphasizes the importance of having at least two pieces in stock to satisfy the desired service level. In example (b), four pieces would be kept in stock by using the same reasoning.

A first glance of the two sales forecasts would conclude that one piece (example a) and two pieces (example b) be respectively stocked. It must be noted that these figures fall short in guaranteeing the desired rate of service.

Figure 1: Two sales forecast profiles for an article in a point of sale on a given day. The left profile (a) predicts an average of 0.21 sales, with a probability of nearly 90% selling 0, while the right profile (b) predicts an average of 1.40 sales with a 35% probability of selling 1. This profile is more “uncertain” than the one on the left.

A common point of view in relation to this scenario is: “It is useless to make sales forecasts, they are too false to be useful”. Physics addresses this view by two fundamental truths:

Truth #1: It takes time to transport stock from point A to point B. When the stock arrives at point B for being used, several days or months have passed.

Truth #2:  The stock needed at point B is subject to demand variations and logistic constraints.
If no forecasts are made, how can we define the stock required for point B in the future? We can identify “security stock”, but recognize it as a vehicle to mitigate demand uncertainty. This brings the question ‘how do you do it when you have to exactly calibrate the security stock?’ Anticipating sales is a vital teller of when security stock should be calibrated. All in all, sales forecasts are always created in explicit, implicit manners, with or without sophisticated tools. It is important to always establish a vision of future sales, while keeping uncertainty in mind.

Today, there are high-performance sales forecasting methods that significantly reduce inventories from 5% to 50% across the supply chain.  Security stocks are reduced to the absolute minimum without creating stock out due to a strong estimation of the uncertainty. They also work when sales are very low, as we will see in the next point.

We now understand why forecasts are not as “false” as a first glance reading might suggest, and that the various demands for optimal Supply Chain management must be based on quality forecasts.

2. DON’T FORECAST WHEN SALES ARE LOW

Sales forecasting for rare-selling items does not work with traditional statistical methods such as moving averages or even more sophisticated approaches (ARIMA models, Winter-Holt, etc.).

Figure 2: Rare sales are characterized by long periods without any sales (green dots), with a sale from time to time (orange dot).

Figure 2 shows an example of rare sales. Observing an item in a store over time doesn’t provide enough information to make usable forecasts. On the other hand, in Figure 3, if we observe this same article in several points of sale, we see the phenomena relative to the store or the period. This enables us to estimate the probabilities of daily sales per store.

Figure 3: Rare sales of the same item over time in several stores. We see that some stores have more sales than others (by row), however specific days also bring more sales over all stores combined (by column).

It’s possible to refine the sales knowledge of any given article by also analyzing the sales of “similar” items at the same point of sale (Figure 4). The correlations between these sales can be identified and provide a statistically significant consolidated sample.

Figure 4: The crossing with similar articles makes it possible to better determine a generalizable behavior.

 Additional information such as current and future promotions, weather, the intrinsic characteristics of the articles should also be taken into consideration in forecast creation. The probabilities of sale are generated daily for each store and item. This results in making it possible to calculate the inventory needed to guarantee the desired rate of service at any given time.

With reference to the supply of rare-selling items, another concern is: ‘Why make a forecast for a rare sale item, which is sold bi-monthly? At the end we will provide a stock of one piece.’

If this reasoning is valid for any given article in any given store, it is erroneous when considering long periods of time and multiple sale points. Being a “slow mover” is not a permanent state because during a promotion or any event generating traffic, a slow moving article can experience an immediate increase in demand (and sales), requiring additional stock. The risk of missing sales can pose significant impact, especially in the luxury sector. Sales forecasts enable these variations to be controlled and the inventory of one piece per store to be changed to two or three pieces per store when they are needed.

Moreover, a thorough analysis of channels and shops will convey that the sales potential differs between the Oxford Street  flagship and a small shopping center. Even for a rare-selling product, there will be stores that require two or three pieces when the other stores need one. How can we specifically identify these stores without predicting their sales?

For rare-selling products, forecasting remains an imperative optimization tool that can be implemented with an appropriate statistical approach.

3. TOO MANY FACTORS IN A SALES FORECAST

The creation of sales forecasts requires taking into account factors such as daily sales, promotions, detailed article references, multi-level product hierarchy, detailed sales receipts, stores characteristics, weather and social networks

At this day in age, we now have complete archives and Big Data and Machine Learning technologies. The integration and utilization of these factors are now within reach.

The most advanced technologies are based on Machine Learning, which enable to creation of programs that automatically recognize the relationship between aforementioned factors and sales. They are able to select and automatically insert these factors into an extensive sales forecast.
For example, the use of weather data is used to improve forecasts in a relatively transparent and simple manner.

Machine Learning chains are also capable of sequential learning. They carry out forecasts according to several models and learn how to select the best ones over time by comparing the forecasts made with actual daily, resulting in an increase in performance.

Significant advances in Big Data technology and progress in the science of Artificial Intelligence (of which Machine Learning is a component) enable sales forecasting systems to take all these factors into account in an efficient and easy way.

4. ONLY ONE SALE FORECAST IS NEEDED

To carry out a distribution activity, several kinds of forecasts are necessary in order to:

  • Define the stocks of sale points and warehouse order preparations, the sales forecast is calculated with a granularity in the article, per day and per outlet over a period of a few days to weeks;
  • Plan orders to suppliers for warehouse procurement, the sales forecast is calculated with item granularity, weekly for a few weeks to months;
  • Define the sales objectives of the sales teams of sales points, over a season or a year, to the week and the day;
  • Evaluate the return on investment of a marketing campaign; Etc.

There are often several independent systems to carry out these forecasts for varying needs in each company. Isn’t is possible to take away different predictions from a single “fundamental” forecast? Contrary to what intuition inspires us, this fundamental prediction does not exist. Let’s see why.

In order to have forecasts on multiple levels, an aggregation of the forecasts at the highest level needs to be conducted and then boil the findings down to their finer components. Both approaches are inadequate. For example, bursting a warehouse forecast for each store by weighting figures would lead to excessive averaging and predictions with a large bias. This would also eliminate the notion of sales probability. In terms of aggregation, this would lead to predictions with high statistical error (mathematical ”variance”).: when the prediction values are added, the errors of the models used at the lowest level are also added.

To avoid such a sensitive process, the most reliable results, the best “bias / variance tradeoff”, are obtained by elaborating the forecast models directly to the desired granularity.

Companies have several entities and services involving distinct predictive approaches. The different forecasts should not be disjointed from one another. The capacity of bringing coherence between all levels is essential. For example, if several stores organize a specific promotion, they should see an impact in their forecasts, as well as in warehouse outflow.

For this type of problem, a Machine Learning approach involves a statistical modelling step between the store level and the warehouse level. The model obtained in this way will establish a flexible link between the data closest to the issue to be solved (outputs warehouses) and the realistic need anticipated by the stores, with precision on all levels.

5. USING SALES FORECASTS IS COMPLICATED

The best sales forecasts are misunderstood and misused, therefore not bringing forth their expected value. For this reason, we must define the business gesture upstream to not confront the user with concepts left unmastered.

For example, the in-store inventory manager will only see order proposals, with a detailed explanation of all its steps (cadence, frequency, packaging, current inventory and overall period sales forecast). Analysis and forecasting management will be entrusted to a specialized team of inventory planners and forecasters, oftentimes operating from headquarters.

A powerful procurement tool is designed taking into account the expertise of its various users. It directly calculates a probable forecast to the desired granularity, considering many real world constraints (budget, financing, delays, merchandising, stock shortage, service rate, preparation and reception capacity). To support the business need, the tool speaks the language of the end user. Depending on the targeted business, the forecast can be transformed into a calculation of inventory to be supplied, budget forecasts, recommendations for supply width and simulation of commercial operations.

The next-generation supply chain forecasting tools are efficient, ergonomic and highly automated. A thorough training in mathematics to use the forecast is unnecessary because it is an intermediate datum which drives the desired result: an efficient and controlled supply chain.