Many field sales managers are guilty of charging head-on into an Excel grid; plotting their historical sales data and drawing some nice, fancy, linear lines stretching far into the future.
Unfortunately the sales forecasting process requires a little more careful consideration than that. Before building a model there are some key questions to ask and steps to follow:
What type of market am I working with?
Is there precedence to what I’m doing?
Is the data I’ve extrapolated accurate?
Have I tested different models?
Which model best fits my sales process?
Insufficient answers to questions like these may lead to picking an inappropriate sales forecasting process for your sales management process model and leave your predictions well off the mark.
Sales Forecasting Process from Preparation to Execution
First thing’s first – before we do anything it’s important to understand the market you are operating within. This will affect the type of sales forecasting process you choose.
I like to break this section down into 2 distinct segments I came across in Paul Arinaga’s Sales Forecasting for Busy People: market definition and market characteristics.
#1 Definition of your market segment
Here you need to define the specific areas or niche of the market that your product or service serves. Let’s say for example, you work in the automotive sector. Ask yourself if you target a specific segment of that sector? Is your product geared more towards the assembly of vehicles or after their distribution to the dealer? Are you serving a niche sector of the market? i.e. do you target high-end cars or more those available for general distribution.
Choosing to label your market as simply “automotive” leaves you at risk of undervaluing your actual market share. If you specialize in auto parts, define your market as such. That way when drawing up your sales forecast it’s being done within context of that niche, not in an obviously much larger market like “auto-parts”.
Now that you’ve defined the playing field you’ll be competing on, it’s the role of the area sales manager to look at some of its particular characteristics.
This could include:
Market growth – are you operating in an established market with a steady increase in forecast growth, or is a relatively new, openly volatile market full of unpredictability.
Seasonality – are there certain times of the year you are likely to sell more than others? Ice cream or sun lotion distributors are more likely to be busier in summer months than in the winter one would assume. This should be factored in when choosing your sales forecasting process.
Price sensitivity – how do you compare to your competitors? Are you undercutting the market? Or are you substantially higher than the market average? This too will affect both the volume and/or value of your product.
Upcoming changes – sticking with the automotive industry, the introduction of self-driving vehicles will bring with it a whole set of new laws and legislation. So too will the switch to electric powered cars. How will these changes affect your sales output? Will you need to make costly adjustments to your product to align with new regulations? Are your auto-parts likely to be used by electric car manufacturers. Knowing of these changes in advance allows you to adjust your sales forecasting process accordingly.
Historical Sales Data
Something else you’ll want to figure out early on in your preparation is whether or not you have any hard sales data to work with. If your product is completely new and ready to launch into the market then this obviously isn’t going to be possible. However, if this isn’t your first rodeo there should be something for you to work with.
Now it’s important to remember that data extrapolation only works in steady, stable markets that experience little fluctuation. If there’s a lot of disruptive, unpredictable change then an alternative method of forecasting, such as exponential smoothing should be explored.
#2 Choosing the Right Model
Now that you’ve got your basic preparation out of the way it’s time to choose the sales forecasting process that best fits your business.
The two types of sales forecasting process are generally split into two groups: quantitative sales forecasting and qualitative sales forecasting
Quantitative Sales Forecasting
The so called quantitative methods of sales forecasting are those used with the availability of historical sales data that can be extrapolated to predict future revenue. These methods rely more on sound, mathematical equation than opinionated judgement from expert peers.
3 of the most popular techniques include:
Trend analysis: The idea here is that through the study of past sales data you can pick up on certain trends that with reason, could be used to predict similar fluctuations in the future. This could either be from seasonality, random factor analysis and economic demand.
Exponential Smoothing: Probably considered the most accurate and widely used for an accurate sales forecasting process it makes an exponentially considered average of past sales to try and predict future revenue.
Simple Moving Average: This technique requires the sales manager to extrapolate sales data from a “dynamic” set period of time; a rolling window of maybe 2,3 or maybe even 6 months.
So if you have sales data available research the pros and cons for each of these techniques to find one that best suits your business model.
Qualitative Sales Forecasting
The qualitative methods of forecasting are the complete opposite of their quantitative cousins; these techniques are subjective, relying more on the opinion of market experts or surveys than any complicated mathematical equations.
That does not make them any less useful mind. They are going to be the best method of forecasting if you are absent of any historical sales data of which you could use.
Some of the more popular techniques include:
Delphi Method: This requires employing the help of an expert panel. Assemble an unbiased team of market leaders to throw in their 2 cents and conduct a forecast for a set period of time. The key here is to get them to do it first alone, and then as a group. What you’ll often find is that the average of an expert’s opinion is never far off from the reality.
Market Survey: Ask cooperative partners and customers to give you their sales expectations. This gives you a rough idea of what you can expert in terms of market growth in your industry.
Ask your sales team: Works best if you deal in large ticket items for a small number of customers. They are in regular touch with your customers and can therefore give you the names of accounts, how much they purchase, how frequently do they purchase and their budget size.
Again, before choosing make sure to do some thorough research into which of the techniques you think will be most applicable to your sales process. You can always conduct tests to determine accuracy but it helps if you already have a shortlist from which to work from.
#3 Collection and Validation of Sales Data
The next step in the sales forecasting process is to make sure the data you’re about to use to conduct your forecast is as clean and accurate as possible. Without it, even the most sophisticated sales forecasting process will struggle to give you any insight.
Think of the idiom garbage-in, garbage-out. Feed a system crap data and it’s going to give you even crapper insight.
A lot of blame is heaped on the field sales guys for this as at the end of the day it’s them entering the data.
But we shouldn’t be so quick to judge.
Often the tools they are given just aren’t suitable for the job. You have to remember these guys spend most of their day travelling, meeting with clients before dashing off again for another appointment. They don’t have time to sit down, fire up a laptop, rifle through a groggy CRM and leave a comment. They need something more intuitive.
Mobile CRM apps are designed specifically to increase data accuracy by making life as easy as possible for the field rep. If they can enter data quickly, in real-time via an easy-to-use application the info is going to be fresh, live and extremely accurate.
This is what you want before conducting a sales forecast.
Also, if you are using historical, extrapolated data with the idea of choosing one of the suggested quantitative forecasting techniques then there are a couple of things to watch out for. The first is to highlight any anomalies by plotting your data into a standard excel graph as follows:
sales forecasting process graph
As you can see between months 5-7 there appears to be an abnormal amount of units sold during this period of time when comparing it to the rest of the data. Now this could be down to a number of reasons: seasonality, perhaps there was an acquisition or company merger or human error.
If you determine that this was in fact just “rogue” data and a one-off occurrence it’s normally recommended that you remove it completely before continuing with your forecast.
This same logic applies when deciding to use a qualitative method of sales forecasting. Your data, whether gathered from internal reports, markets surveys or expert panels will need to be checked for credibility. If there are other data sets available for alternative market reports, cross check for any obvious anomalies.
#4 Putting Theory To the Test
The next step of the sales forecasting process is to build out your model and test it. This could be either through an Excel grid or specialized software program, depending on the model you chose to go with.
To do this I recommend you try what is called a Within Sample technique
Basically this means using a set of available data, so your survey, market research or own sales data to forecast a set period of time and then compare it to the known outcomes or results.
If the out-sample forecast error (the difference between the known results and those forecast by your model) is better than the in-sample MANE (mean absolute naive error) then there’s a good chance you’re on to a workable model for you sales process. The more data you have the, better, as you will be able to more accurately compare your output sample deviation over a longer period of time.
If you’re unsure on how to calculate the MANE, it can be down as follows: