skip to Main Content

5 Most Common Mistakes Made in Sales Forecasting

Best Practices
07/31/2018

Selling anything, from widgets to wide-load trucks, isn’t an exact science. There are fluctuations in demand, in supply of raw materials, in shipping and more. That said, getting as close to reality as possible in sales forecasting is how you can control and increase your profit margins. After all, the forecast is what can help you be proactive in working with issues in revenue numbers, rather than reacting to a problem in the supply chain.

There are plenty of ways to improve your sales forecasting techniques, but this post will highlight the most common, and therefore costly, mistakes that manufacturers tend to make in sales forecasting.

Mistake #1—Giving way to the ‘best guess’

Hunches, guesses and crystal balls are the least effective ways of forecasting future sales and yet so many companies continue to rely on these methods. While it’s true that all sales forecasts and demand plans are, to some extent, based on unknown factors, it is possible to limit those unknowns so as to get as realistic a set of data as possible. Forecasts that are based on current data, known influencing factors and historical patterns will always be closer to reality than those that aren’t.

Mistake #2—Ignoring historical patterns

Newer businesses might not yet have historical data to draw on but any business that has been a going concern for some years should have reams of it. Unless the company has restructured recently, altered its product lines significantly or gone in an entirely different direction, there should be historical data that reflects discernable demand and sales patterns. These patterns are the best predictors of the future, because while they don’t necessarily take into account current changes and/or possible impacts to the supply chain, they give you a baseline against which you can build accurate numbers.

Mistake #3—Using spreadsheets that reside in silos

Spreadsheets were a fabulous invention but when it comes to looking at data these days, they are manual, clunky and only represent the data at one point in time, and from the point of view of a specific business silo. Imagine sitting in a forecasting meeting and looking at six different sets of data. There is no chance that the resulting forecast will be remotely accurate.

“Static monthly forecasts can’t account for these fluctuations. Manual sales forecasts or siloed inventory planning lags behind what is actually occurring. Forecasting without accounting for projected capacity can lead to not enough or too much inventory.” (Source)

Instead, a good sales forecasting tool will enable you to engage in “what if” scenarios using real-time data, transparent across the entire supply chain and factoring in different informational needs. In this scenario, the key performance indicators (KPIs) that are used to look at future sales possibilities will be limited to a maximum number and be the same across the chain, so everyone is looking at the same data, resulting in the same forecast.

Mistake #4—Not going with the flow

Looking at sales forecasts as static objects is part of why they don’t help in planning everything from available resources and supply to operations to sales and ultimately delivery. It’s why they often don’t help with the bottom line. Instead, you need to go with the flow. A major change in your supply chain warrants a review of the numbers and appropriate adjustments to ensure you are properly supplied or that you have the inventory you need, such as for a big sale that was not anticipated but is coming!

In this way, a sales forecast can become a living document that more accurately reflects your business reality.

Mistake #5—Assuming that the forecast is gold

There is no better way to set up your entire time, from end to end in the supply chain, for failure than holding up the sales forecast as some kind of divine prophecy. It might be inflated because the figures from past years were higher due to a change in the marketplace. It might be underwhelming for the same reason. You need to see the sales forecast as a guideline for action but also a target that is not stuck in cement but moveable.

With these common mistakes in mind, review your sales forecasting processes to ensure that you are not making them. Combining these with forecasting and data plan best practices is essential for your bottom line.

Related Articles

Supply Chain Planning to the Rescue – Cash Flow Management During COVID-19

During the best of times, managing cash flow can be challenging. But during long-term disruptions such as COVID-19, cash flow management can become an existential exercise. As companies look to assess the damage from the pandemic, in order to define [...]

Demand Forecast Accuracy – A Better Way to Fight the Bullwhip Effect

Supply chain disruptions are nothing new. As 2020 continues to demonstrate, some disruptions can have a greater, catastrophic impact. But even small fluctuations can cause what is known as the “Bullwhip Effect”. This phenomenon occurs when demand signals are amplified [...]

5 Tips to Hacking Distribution Requirement Planning in the Food and Beverage Industry

The Food Waste Reduction Roadmap Report of 2019 show that a third of food, which includes beverages, is wasted around the world. Further analysis of the ongoing waste across the food and beverage production chain in the United Kingdom highlights [...]

Top 5 Production Capacity Planning Challenges You Should Know

Modern manufacturing is a complex endeavor for any company.  Equipment capability, labor and productivity must be balanced against demand, sales forecasts, supply chain issues and many other factors to produce the right volume at the right time. Too much and [...]

Best Practices for Resource Capacity Planning for Small and Medium Businesses

Manufacturing can be challenging in the best of conditions.  But for small and medium-sized businesses (SMBs) striving to remain competitive with large companies, their smaller size and reach mean that planning is even more crucial.   Small and medium-sized businesses often [...]

Strategies for Optimizing Customer Service Levels

  While every business works diligently to improve efficiency and operational excellence, at the end of the day it’s the customer who determines a company’s success.  And companies are looking for new ways to optimize customer service levels to improve [...]

Going Green in Supply Chain

Can supply chain professionals help their business become more sustainable? Absolutely! You will be helping the environment, but going green can also help your business with brand building and efficiency. It can even be as simple as moving to the [...]

Computational thinking in today’s industry

Industry Week defines computational thinking as, “A structured approach to problem-solving, which ultimately allows you to come up with a solution that can be effectively carried out by computers, people, or—typically—a combination of both.” This is a great tool when [...]

A Focus on the Eighth Lean Waste in Manufacturing

There were originally seven wastes of lean manufacturing, but an eighth was added in the 1990s that should not be ignored! Dave Turbide said, “Variously called unused human creativity, under-utilized talent, incorrect use of abilities, unused human intellect, or simply [...]

The Life of a Demand Planner

What do the first 100 days look like for the average demand planner? What trends does a demand planner hope to establish when embarking on this new journey? Much like POTUS, you can’t go it alone -- you need your [...]
Subscribe to our Blog
Back To Top