Great Sales Forecasting Equals Out of StockSales Forecasting is a measure of the market response; it is not a measure of market demand. The problem with sales forecasting is that simple; the most accurate sales forecast is only a measure of market response to what you had available. This is not accurate when considering future market demand. Issues with constrained supply, service levels, price and promotion are not analyzed correctly in Sales Forecasting. This is why sales forecasting is responsible for out of stocks and overstocks in many companies.

The ‘Dim Erotic Sin’ of Sales Forecasting Software

There are many software solutions in the marketplace today with the words ‘Demand’ and ‘Forecasting’ in the title or description. This marketing misdirection is a ploy to point companies to older software products with the old bait and switch routine. Sales Forecasting takes the total data from sales to create a forecast. The reality of this misdirection is sales do not equal demand or put another way: past sales do not equal future demand. The word ‘demand’ in a software title, a marketing message and a good software sales person can misdirect even the smartest of executives. The problem with a sales forecasting methodology for inventory replenishment is that it is based on past market responses – a misdirection.

The belief that sales and demand forecasting are the same or that sales forecasting is the right tool for inventory replenishment is a total misdirect. While many claim they understand the differences and are not fooled by marketing and sales pitches, I ask the question-did you even catch my misdirection?

Differences Between Demand Forecasting and Sales Forecasting for Replenishment

The differences between demand forecasting and sales forecasting are significant when used for inventory replenishment. Two Big Issues with Sales Forecasting for Inventory Replenishment are lack of Lost Sales in the forecast process and lack of effective filtering of Promotional Sales before forecasting.

Demand Forecasting

Because Out of Stock delivers zero sales, a sales forecasting software solution will lower the forecast. This results in lower inventory being sent for replenishment which will result in additional lost sales. This type of behavior will become a self-repeating funnel of lower sales, lower forecast, and out of stocks. If I sell 100 units a week in a four week month, the forecast should be 400 units a month. If Out of stock for one week results in 300 total monthly sales units; the sales forecasting software will lower the forecast below 400. The result of the new lower forecast will be less inventory sent for replenishment.

In a different four week month, the same product with a 100 unit a week forecast is run on promotion in week 2 and sells 200 units that week, a 100% lift. The month end total sales for the product will be 500 units (weekly sales: 100+200+100+100). A sales forecasting solution will raise the forecast based on the total sales of 500 being higher than the 400 unit forecast. Some sales forecasting solutions will totally ignore a sales week where promotions occurred. The system assumes the remaining weeks are normal and calculates the forecast based on 3 weeks – is that accurate? The reality is your regular demand is 100 units a week and skipping data is just asking for problems to occur.

It Only Gets Worse in Later Promotions

When you want to run the same promotion in six months, how do you replicate it? Since the promotion is mixed into regular demand, or worse is totally ignored, you have no basis to use for forecasting your future promotion. The results are out of stocks during your promotion. Does this sound familiar?

The Problem with Sales Forecasting is You are Not Feeding Demand into the Forecast Engine, you are not using Demand!

Demand Forecasting is the Act of Forecasting Market Demand

Too obvious for you? By now, some of you are asking the right question: What type of forecasting methodology are we using today? Ask yourself this question, does the software have a place where you can see sales broken out by demand type? Does the system have forecasting rules that include the demand types in the forecast logic? Your next question is what are the demand types?

FREE Lost Sales Kit

Demand types include:

  1. Regular Sales
  2. Lost Sales
  3. Promotion Sales
  4. Event Sales
  5. Close-out Sales

A Demand Forecasting solution must provide a forecast based on each segmented demand type listed. Lower end systems will only use three types. Higher end Demand Forecasting software use all 5 demand types, breaking out each demand type into units and also provide consolidated forecast total units.

The ‘Demand’ Forecasting Software Sales Misdirection

People are developing marketing phrases that have nothing to do with demand forecasting. The misdirection comes in different forms. One company lists their forecast algorithms with the claim they are demand forecasting because they use certain forecast algorithms. Sales Forecasting software and Demand Forecasting software can use the same algorithms. The forecast algorithms are NOT the difference between sales and demand forecasting. Some companies claim they are forecasting demand and list demand types that do not exist in universities, textbooks or reality. You can easily see how each of these is describing a market response.

These are NOT types of Demand, they ARE Market Response

  1. Fast Selling
  2. Slow Selling
  3. Regular Selling
  4. Intermittent Selling

The Key things to Know about Demand Forecasting

The segmenting of sales into demand types is the key difference of Demand Forecasting. The separation of demand greatly improves forecast accuracy and results in lower inventory costs and in more accurate inventory replenishment. Modern systems use more than 10 algorithms and deliver higher forecast accuracy. By contrast the best and most popular replenishment systems in the market 7 or more years ago used only 4 or fewer algorithms and three demand types. Why does this matter to you – because you will get higher forecast accuracy, better replenishment, lower costs, improved promotional lift, and higher total sales. By the way – Don’t be fooled by the ‘Dim Erotic Sin’ of Sales Forecasting, remember ‘Dim Erotic Sin’ is just an anagram for Misdirection.

Want Help Getting Your Review Started?

If you need help getting started contact Data Profits for a free consultation. You can also request a demo and see how things can start to improve in your supply chain with our 30 day install. ‘Are you ready to tighten the Links in Your Chain? ™’
[QuickLinks]

Learn More


Copyright © Data Profits, Inc. 2013 All Rights Reserved.