When it comes to planning out the future of your business, the most reliable source for prediction is a look at your sales past. Quantitative sales forecasting is one of the most objective ways that you can predict where your business will be in the near future and beyond.
Although no method is a magical crystal ball that will be 100% accurate, sales forecasting allows you to get a general idea of where your business is headed. It does not take complicated in-depth statistical analysis to get an overall look into your sales department and see the direction that it is heading. Rather, using simple sales forecasting methods can let you know how your sales team is doing and what may need to be adjusted.
But what is the best forecasting method for sales? To give you an idea, in this article, we’ll break down what quantitative sales forecasting is, why you need it, and the top methods you can apply today. As well as some examples of a sales forecasting template you can use to get started.
What Is Sales Forecasting?
The valuable data from sales forecasting arms companies with the ability to make informed business decisions, helping drive all facets of the company from sales efforts to operations and everything in between. Sales forecasting provides a solid foundation for almost all other planning and budgeting activities in a business.
Sales forecasting is typically split into two categories: quantitative and qualitative. Although they both have the same goal of predicting future sales and gaining deeper insight, they use two very different methods. Here is a quick look at each one:
What Is Quantitative Sales Forecasting?
Quantitative sales forecasting is a type of sales forecasting that is strictly objective and focuses on hard numerical sales data collected over the past months, and even years. This data is used to calculate future sales, revenue, and expenses. Quantitative methods are more focused on the numbers to give the most accurate prediction over any other variable.
Quantitative forecasting allows companies to easily pinpoint trends that have been occurring previously and may continue to occur. These trends are then used to derive formulas that will help you forecast future sales. With quantitative methods, the sales forecasts that are created have clear data to support them.
Thus, these types of forecasting methods are highly dependent on a clean and accurate data set of previous sales numbers, analysis of historic performance, and complete visibility into your sales pipeline.
What Is Qualitative Sales Forecasting?
Qualitative sales forecasting is a type of sales forecasting that is entirely subjective and brings human emotion into the equation. With qualitative sales forecasting, business leaders use intuition, experience, and feedback from customers to make predictions about where sales are headed. An advantage with these types of methods is that they can factor in external events that would affect sales, like fluctuations in consumer spending/earnings, changes in government policies, new industry innovations, etc.
Qualitative methods are a highly emotional and sometimes unreliable form of sales forecasting. This is why they are typically used by new businesses that do not have previous data to analyze, by businesses in industries that see significant fluctuations, and/or in combination with quantitative forecasting methods.
In this article, we will be focusing on the quantitative side of forecasting because, when you have previous sales data to utilize, it can be the most reliable means of predicting your future sales. Although it will not be able to predict certain market fluctuations and will not predict numbers down to the dollar, it is often the more accurate way to put together forecasts.
Why Use Quantitative Sales Forecasting?
There are several reasons you might want to take a serious look into implementing quantitative sales forecasting methods, including:
Quantitative forecasting gives you a completely objective perspective based on the strength of past sales data.
Sometimes, it can be hard, especially for small businesses, to get an objective look at how their sales are doing and where it is going. For example, when seeing lackluster sales, it might be too easy for a business to try to stick with ignorance. Or, sometimes, in more subjective forecasting methods, enthusiastic employees may inflate their sales predictions, or those that are nervous about not showing positive numbers may falsify their forecasted sales.
On the other hand, with the level of objectivity in hard numerical data from quantitative sales forecasting, you’ll have the ammunition you need for more accurate forecasting. Thus allowing you to get a real look at the company’s history and what is going and enabling you to make an informed plan for the future.
Ability to See Trends
Pinpointing trends is crucial for sales success and company growth. Is there a newly productive territory where sales are continuing to increase in? Are sales of a product plateauing as the market becomes saturated? Is your company continuing to see an increase in overall sales revenue year over year? Quantitative sales forecasting allows you to see all of this.
If there is a pattern of a steady increase, decrease, or cycle in numbers, quantitative forecasting methods can factor this into the formulas. Then your forecasted numbers will fit in with the historical pattern.
Attraction of Key Stakeholders
When you have hard data that clearly shows historical growth, you have a powerful means for attracting and engaging external stakeholders. Being able to give the most specific predictions will allow you to more easily secure loans, bring on partners, and find investors.
Compared to qualitative methods, quantitative sales forecasting methods are usually cheaper to implement. This is because the main resource needed for the forecast is your past sales data. There is little additional expense involved beyond the cost of data gathering, which is usually done in your sales CRM.
On the other hand, qualitative methods can often require the use of expert opinion, surveys, and other similar sources, which require consultants and/or paid advisors to put together.
Top Methods of Quantitative Sales Forecasting
Thankfully, sales forecasting methods do not need to be complicated. With basic math skills, you can use your past information to come up with predictions for your future sales and revenue. Here are some of the top quantitative forecasting methods as well as some sales forecast examples:
Naive Approach (aka Naive Forecast)
The most cost-effective forecasting model that can serve as a comparison point and start to determine future growth
The naive approach is the quantitative forecasting method that will most often serve as a starting point, helping to begin to determine the future growth and sales goals.
Simply put, using the naive forecast would mean you forecast that the next period’s numbers will be the same as the previous period or that next period’s numbers will be what was sold in the previous year during the same period. For example, if the next period is the month of September, you would forecast that the month’s sales will be the same as last September’s.
Just as unsophisticated as the name implies, there are no formulas used with this method and it does not factor in any adjustment. It also does not attempt to establish causal factors. The naive forecast will give you a baseline to compare with forecasts generated by more sophisticated techniques.
Straight-Line Method (aka Historical Growth Rate)
The easiest forecasting method to calculate future sales while factoring in growth
This is the simplest of all the methods to calculate future sales and factor any growth into the equation. Straight-line forecasting is sometimes referred to as the historical growth rate and can give you a rough look at where sales will be based on past growth rate.
The simple formula looks something like this:
|Previous period’s sales revenue x (1 + % rate of sales growth) = next period’s revenue|
Say, for example, you were trying to predict next month’s sales based on the fact that sales are growing by 30% each month and revenue last month was $100,000.
So in this case, the formula would be:
|$100,000 x (1 + 30%) = $130,000|
There are many options available online for a basic sales forecast template to use with this method (and many of the other methods we go over below). A good example is this template from Smartsheet, available in both Excel version and Google Sheets version.
The most complete sales forecasting method when there is not much annual fluctuation
Another commonly used method, linear regression allows you to get an average based on the charted progress of your sales. This will give you a great average to use to evaluate the direction things are heading.
Take a look at this sales forecast example which depicts the linear regression method in a graph format:
In the graph above, the average is depicted by the straight dotted line. This can also be achieved pretty quickly through a sales forecast Excel spreadsheet of your data using the TREND function (directions are here).
Although some months’ sales may be higher and others lower, tracking each month will give you a good average that can be determined. This average will make seeing your company trends and predicting where you will be much easier.
It can be difficult to simply look at numbers and equations in line item form to get a good prediction. Graphing it out visually in a linear regression chart will help you to see more clearly the trends in your business.
The best sales forecasting method for time-relevant sales goals
The run rate method is another simple equation that is an average of past sales data and can have a big impact on your sales predictions. It is represented by:
|Total revenue / sum of past sales periods|
Really. It’s that simple.
It is best used when you are tracking sales for a set period. For example, if you have a sales goal to meet by the end of the year, it can help you to see whether you are staying on target.
Let’s say that you are in May and you’ve sold $50,000 worth of product, but you want to see what you will make by the end of the year if trends continue.
Since averages are broken down monthly, you can calculate that you are making $10,000 a month and have 7 months left in the year:
|7 X $10,000 = $70,000|
When you add that total to what you have already made:
|$50,000 + $70,000 = $120,000|
So, you can somewhat predict $120,000 in total sales revenue for the year based on this run rate.
The run rate method can also be used if you are needing to breakdown your forecast further and predict the sales revenue by individual products. Here is another sales forecast template from Smartsheet that you can use to get started in that scenario, available in Excel format.
In many cases, when you are trying to forecast sales revenue for the remainder of a set period, the run rate method works best, thus making goal tracking and ensuring you hit the goals easier to do.
Simple Moving Average
A more accurate method for forecasting short term trends which can also account for steady increases in revenue
This quantitative method is very similar to the run rate method but deals with a dynamic period and therefore creates a dynamic average. When using this method to forecast, the period you will be pulling data from moves forward depending on the timeframe you are dealing with. The sales data from several consecutive past periods will be combined to provide a reasonable sales forecast for the next period.
The formula that you will be using is:
|The sum of previous periods sales / total number of time periods included = next period’s forecasted sales|
For example, let’s say you want to determine forecasted sales for the next 6 months. You have the sales data from the past 30 months to use in putting together your forecast. So this gives you exactly five 6-month periods to work with.
We’ll use the chart below for this forecasting example:
|6 Month Period||Revenue||Total Revenue||Shifting Average|
The first place to start is to determine the simple moving average for the first 18 months of your data (the first three 6-month periods). These would be labeled in the chart as 6-month periods 1 through 3.
So, you would add the revenue from the first three 6-month periods to put on line 3 under total revenue. Then divide this number by three, since you are using three 6-month periods, to give you the first simple moving average (or shifting average) number. This figure is then put in line 3 under the “Shifting Average” column.
Now, to get the next simple moving average you would just move forward one 6-month period. So, you repeat the process for periods 2 through 4. This simple moving average would then be put in line 4 under the “Shifting Average” column.
Then, you would repeat the process one more time for periods 3 through 5. This simple moving average would then be put in line 5 under the “Shifting Average” column.
So when determining your forecasted sales revenue for the next period (the 6th period in the chart), you simply use the shifting average figure from period 5. So, in this example, the forecasted revenue for the next 6 months would be $155,018.33.
The simple moving average can be used for many different periods depending on your needs, whether you are wanting to forecast sales for the next month to forecasting sales for the next year or anything in between.
If you are wanting to structure your forecast by the month and use this forecasting method, this sales projection template from Smartsheet can help you quickly get started. You can use either the Excel version or the Google Sheets version.
With this simple moving average method, you can factor in and account for steady increases in revenue to help make your forecast for the next period even more accurate.
Use Quantitative Sales Forecasting to Grow Your Business
Taking a look into your future is essential for sales. If you want to grow your company and grow your sales team and keep them accountable, utilizing quantitative forecasting will prove invaluable. These methods made up of simple data and math will help you to get a basic look into where you are headed and if you will meet your goals.
Backed by solid numbers and insight, you can also better direct the future of your sales and make informed decisions to help your company remain profitable. Give these methods a try today!