A sales forecast is one of the key business management tools. It allows you to plan revenue, track goal achievement, and identify risks in advance. Without forecasting, decisions are made intuitively, leading to chaos and losses. A well-constructed sales forecast helps executives make informed decisions, allocate budgets effectively, and confidently scale their business even in unstable market conditions.
In the full article, you’ll find a detailed algorithm for creating accurate sales forecasts and specific tools to transform uncertainty into a manageable system 👇
In today’s business environment, where markets change at lightning speed and competition only grows, quality forecasting becomes a key survival factor. Companies that can accurately predict their sales gain a huge advantage: they plan resources more efficiently, optimize inventory and financial flows, and most importantly – stay ahead of competitors.
In this article, we’ll explore in detail what is a sales forecast, why it’s critically important for any business, and how to make a sales forecast that actually works. Ready to turn uncertainty into a strategic advantage? Let’s go!
A sales forecast is a scientifically-based estimate of a company’s future sales volume over a specific period. Essentially, it’s your attempt to look into the future and understand how many products or services you’ll be able to sell, based on historical data analysis, market trends, and various external factors.
A sales forecast isn’t just a number you want to achieve. It’s a realistic prediction based on facts and analytical methods. It answers the question “what will likely happen?” rather than “what do we want to happen?”
For example, a coffee shop chain owner might forecast that sales will grow by 7% in the upcoming month based on data about launching a new seasonal drink line, analysis of sales from the same period last year, and information about a planned business center opening near one of the locations.
It’s important to understand that sales forecasts are living tools that require regular updates. In business, you can never say: “I made a forecast for the year, now I can relax.” Effective sales forecasting is a continuous process requiring constant analysis and adjustment based on new data and market changes.
Sales forecasting is a necessary management element for companies of any size. It’s not just a trendy business term or a tool for large corporations. Let’s examine why sales forecasting should become your regular practice.
Without a clear understanding of future sales, it’s impossible to make informed business development decisions. A sales forecast allows you to:
Practical example: The “Novus” supermarket chain, thanks to accurate forecasting, was able to optimize its promotions and achieve forecast accuracy of 96.2%, which minimized excess inventory after promotions and reduced missed sales to 3.8%.
An accurate forecast helps manage company resources more efficiently:
Practical example: Ukrainian company Intertop successfully diversified its assortment from a traditional focus on footwear to clothing, accessories, and sporting goods thanks to careful analysis of consumer preferences and demand forecasting in new categories.
Incidentally, for B2B and more complex product areas, it’s important not only to forecast but also to improve sales methods and strategies, so your development plan matches the market.
A sales forecast is the foundation of financial planning:
In today’s volatile world, forecasting becomes a crucial risk management tool:
One of the most common business mistakes is confusing sales forecasting and planning. Although these concepts are interrelated, they have fundamentally different natures and purposes. Understanding these differences is critically important for building an effective sales management system.
| Criterion | Sales Forecasting | Sales Planning |
|---|---|---|
| Essence | Objective assessment of probable sales volume based on data analysis and trends | Subjective establishment of sales targets that the company aims to achieve |
| Basis | Historical data, statistical methods, market trends, external factors | Company strategic goals, available resources, management ambitions |
| Question | “What will likely happen?” | “What do we want to happen?” |
| Function | Analytical, descriptive | Motivational, directive |
| Time horizon | Usually short-term (weeks, months) | Can be long-term (quarters, years) |
| Flexibility | High (regularly updated) | Medium (usually fixed for a certain period) |
| Responsibility | Analysts, marketers | Management, sales department |
It’s important to understand that forecasts and plans shouldn’t exist in isolation from each other. The most effective approach is when the forecast serves as the basis for sales planning, and the plan in turn is a motivating benchmark, slightly exceeding the forecast but remaining in the zone of realistic achievements.
For example, if your forecast shows that the company will likely sell 1000 product units next month, a reasonable sales plan might be set at 1100-1150 units. Such a plan will be ambitious enough to motivate the team, but not so detached from reality as to cause frustration and demotivation.
Additionally, it’s important to consider the mutual influence of forecasts and plans. The plan may include additional marketing activities or incentive programs for salespeople that can affect actual sales and, consequently, should be taken into account in future forecasts.
In this regard, conducting a sales department analysis and audit becomes relevant to identify weaknesses in the team and processes before setting new plans.
There are many sales forecast methods, each with its strengths and weaknesses. Choosing the right sales forecast methodology depends on your business specifics, available data, and required forecast accuracy. Let’s look at the main sales forecast techniques, dividing them into subjective and objective.
Subjective methods are based on opinions, judgments, and expert assessments rather than statistical data analysis. They are especially useful when historical data is insufficient or when market conditions are rapidly changing.
This method involves collecting information directly from customers about their future purchase intentions.
Advantages:
Disadvantages:
Application: Especially effective for B2B sales with a small number of large clients or when launching new products.
This method is based on collecting forecasts from sales department employees who directly interact with customers.
Advantages:
Disadvantages:
Application: Works well for companies with a strong sales team and individualized customer approach.
Middle and top managers make forecasts based on their experience and market understanding.
Advantages:
Disadvantages:
Application: Valuable as an additional method for adjusting forecasts, especially when making strategic decisions.
Engaging external experts or industry analysts to form forecasts.
Advantages:
Disadvantages:
Application: Useful when entering new markets or during significant industry changes.
Are you striving to create a sales forecast that really works, but drowning in numbers and variables? This is a typical problem faced by 80% of business owners. At Sales Rocket, we transform uncertainty into predictable results, having built more than 187 systematic sales departments across 14+ industries. Our approach is based not only on accurate data analytics but also on implementing a comprehensive system that makes your sales transparent and manageable. We conduct detailed audits, identify “bottlenecks” in your sales funnel, set up transparent reporting, KPIs and dashboards, which allows not just forecasting, but guaranteeing achievement of planned results. Sales Rocket clients receive an average +35% increase in turnover, and the record indicator was +$1.6 million over 4 months of work.
Objective methods are based on statistical data analysis and mathematical models. They usually require a sufficient volume of historical data.
Launching a product or marketing campaign in a limited market to forecast results in a broader market.
Advantages:
Disadvantages:
Application: Ideal for launching new products or entering new markets.
This method is based on analyzing historical sales data to identify patterns and trends.
Advantages:
Disadvantages:
Application: Effective for stable markets with clear seasonal patterns.
Breaking down the time series into components (trend, seasonality, cyclicality, and random fluctuations) for more accurate forecasting.
Advantages:
Disadvantages:
Application: Suitable for companies with complex sales structures and pronounced seasonality.
In addition to the main methods, there are additional approaches that can significantly improve the accuracy of your forecasts. They become especially useful when used in combination with other methods.
The causal method is based on identifying factors that affect sales volume and building mathematical models describing these relationships.
When to apply:
Tool: Regression analysis, which allows determining how various factors (price, advertising expenses, seasonality, economic indicators, etc.) affect sales volume.
Result: A mathematical model that quantitatively describes the influence of various factors on sales and allows forecasting future results when these factors change.
For example, analysis might show that every 10% increase in the advertising budget leads to a 3% sales growth, while a 5% price increase reduces sales by 2%. With such a model, you can forecast how different marketing strategies will affect your sales.
As part of a comprehensive analysis, you can also evaluate the effectiveness of sales department managers and their contribution to forecast fulfillment and plan execution.
This method involves developing several forecast variants based on different market situation development scenarios.
When to apply:
Tool: Developing at least three scenarios (optimistic, realistic, pessimistic) with an indication of the probability of each one’s realization.
Result: A set of forecasts corresponding to different scenarios, allowing the company to prepare for different future options and develop appropriate action plans.
In practice, the best results are often achieved by using a combination of different forecasting methods.
When to apply:
Tool: Combining results from different forecasting methods with specific weight coefficients reflecting the reliability of each method.
Result: A more balanced and accurate forecast, taking into account both objective data and subjective expert assessments.
Using comprehensive approaches contributes not only to correct forecasting but also allows focusing on key sales department indicators for deep performance analytics.
Accurate sales forecast calculation requires understanding the mathematical formulas and approaches underlying various sales forecasting models. Let’s consider the basic sales forecast formula and examine their application through practical examples.
The simplest formula for forecasting is based on historical data considering expected growth or decline:
Sales forecast = Previous period sales × (1 + Expected growth rate/100)
Example: If last month’s sales were 1 million hryvnias, and you expect 5% growth, the forecast for the next month will be:
Sales forecast = 1,000,000 × (1 + 5/100) = 1,050,000 hryvnias
If your business is subject to seasonal fluctuations, you can use a sales forecast formula with a seasonal coefficient:
Sales forecast = Base forecast × Seasonal coefficient
where the seasonal coefficient is calculated as the ratio of sales in a specific month to average monthly sales over several years.
Sales forecast examples: If your base forecast for December is 1.2 million hryvnias, and historically December sales are 30% higher than the monthly average (seasonal coefficient 1.3), then:
Sales forecast = 1,200,000 × 1.3 = 1,560,000 hryvnias
For more complex forecasting that takes trends into account, you can use linear regression:
Y = a + bX
where:
Coefficients a and b are calculated based on historical data using the least squares method.
Example: Historical data analysis showed that the base sales level (a) is 900,000 hryvnias, and monthly growth (b) is 50,000 hryvnias. Then the forecast for the 10th month will be:
Y = 900,000 + 50,000 × 10 = 1,400,000 hryvnias
To account for several factors affecting sales, multiple regression is used:
Y = a + b₁X₁ + b₂X₂ + … + bₙXₙ
where:
Example: Analysis showed that sales are influenced by three factors: advertising budget (X₁), price (X₂), and seasonality (X₃). The model has the form:
Y = 500,000 + 2 × X₁ – 5,000 × X₂ + 100,000 × X₃
If next month’s planned advertising budget is 100,000 hryvnias, product price is 1,000 hryvnias, and seasonal factor is 1.2, then the sales forecast will be:
Y = 500,000 + 2 × 100,000 – 5,000 × 1,000 + 100,000 × 1.2 = 500,000 + 200,000 – 5,000,000 + 120,000 = -4,180,000
A negative result indicates an error in the model or incorrect parameter selection. In reality, it’s necessary to carefully check sales forecasting models against historical data before using them.
This method smooths fluctuations in data by averaging values over several periods:
Sales forecast = (Sales₁ + Sales₂ + … + Salesₙ) / n
where n is the number of periods for averaging.
Example: If sales for the last 3 months were 1,100,000, 950,000, and 1,050,000 hryvnias, then the forecast for the next month using a 3-month moving average will be:
Sales forecast = (1,100,000 + 950,000 + 1,050,000) / 3 = 1,033,333 hryvnias
To forecast monthly sales, you can also use the monthly sales forecast formula that considers the specific growth patterns observed during particular months of the year:
Plan fulfillment forecast (%) = (Current fulfillment / Elapsed portion of period) × 100%
In this example:
Plan fulfillment forecast = (40% / 50%) × 100% = 80%
This means that at current rates, the plan will be 80% fulfilled by the end of the month.
When building models, be sure to analyze how increasing the average check affects total sales volumes and plan fulfillment.
Microsoft Excel is one of the most accessible and powerful tools for sales forecasting. Even without specialized education in statistics, you can create fairly accurate forecasts using Excel’s built-in functions.
This function allows predicting a future value based on existing values using linear regression.
Syntax:
=FORECAST(x, known_y_values, known_x_values)
where:
Step-by-step instructions:
This more advanced function uses an exponential smoothing algorithm (ETS) to forecast future time series values.
Syntax:
=FORECAST.ETS(target, values, timeline, [seasonality], [data_completion], [aggregation])
Step-by-step instructions:
Excel offers an automated “Forecast Sheet” tool that significantly simplifies the forecasting process.
Step-by-step instructions:
1. Select your data range, including headers (e.g., A1:B13)
2. Go to the “Data” tab
3. In the “Forecast” group, click “Forecast Sheet”
4. A dialog box will open with a forecast preview
5. Adjust parameters if necessary:
6. Click “Create”
Excel will create a new sheet with a chart displaying historical data, forecast, and confidence intervals.
Sales forecast in Excel is particularly convenient for small and medium businesses as it doesn’t require specialized software and allows quickly visualizing results. The sales forecast template in Excel can be customized to include both simple calculations (e.g., using trend) and more complex models considering seasonality and external factors.
For more complex forecasting considering multiple factors, you can use the “Regression” tool in the “Data Analysis” add-in.
Step-by-step instructions:
1. If the “Data Analysis” add-in is not activated:
2. Prepare the data: dependent variable (sales) and independent variables (factors)
3. Go to the “Data” tab and select “Data Analysis”
4. Select “Regression” and click OK
5. Fill in the dialog box:
6. Click OK
The regression analysis results include coefficients for each factor, which can be used to build a forecasting model.
Sales forecasting is not just a set of Excel formulas or statistical data analysis. It’s the foundation of your business strategy, requiring a comprehensive approach and professional expertise. Sales Rocket offers not just forecasting consultations, but a full-fledged sales management system where accurate forecasting becomes a natural result of properly built processes. Our methodology includes auditing the current state of the sales department, implementing CRM with configured analytics, developing a KPI system and regular reporting, team training, and continuous support for changes. The result? Instead of a “black box” with unpredictable sales, you get a transparent system where every funnel element is measurable and manageable. Our clients – from local companies to brands like Mitsubishi, Yamaha, and Naftogaz – confirm: Sales Rocket’s systematic approach increases not only forecast accuracy but also real business turnover.
Today, many companies are moving to forecast automation through digital tools. Implementing sales with CRM allows getting even more accurate figures based on complex analytics of customer data, deals, and interactions. This is especially relevant for medium and large organizations where information volumes grow rapidly.
How to make a sales volume forecast in Excel? Start by analyzing historical data, identify seasonal patterns and trends, then use appropriate functions (FORECAST, TREND, or GROWTH) to extrapolate data into the future. Supplement the statistical forecast with expert assessments and consideration of marketing activities. When working on sales forecast marketing integration, ensure your forecasts account for upcoming campaigns and their expected impact on sales performance.
Sales forecasting is not a luxury but a necessity for any business striving for sustainable growth and profitability. In our article, we examined various aspects of this process: from understanding fundamental differences between forecasting and planning to practical steps for creating forecasts in Excel.
The key conclusion is that there is no universal forecasting method suitable for all situations. The most effective approach is to combine different sales forecast methods, considering your business specifics, available data, and market conditions. Statistical methods, such as regression analysis and exponential smoothing, show the highest accuracy (up to 80-90%), especially when supplemented with expert assessments.
It’s important to remember that forecasting is a continuous process, not a one-time event. In rapidly changing market conditions, it’s critically important to regularly update forecasts, considering new data and changes in the external environment. Flexibility and adaptability become key success factors.
How to make a sales forecast? Start by analyzing historical data, select appropriate forecasting methods depending on your business characteristics, consider external factors’ influence, and regularly check your forecasts’ accuracy, making necessary adjustments.
Implementing a forecasting culture in your company can become a serious competitive advantage. Companies that can accurately predict future sales make more informed decisions, manage resources more efficiently, and respond faster to market changes.
Sales forecast calculation requires both analytical skills and deep business understanding. With the methods and tools described in this article, you can significantly improve your forecasts’ accuracy and, consequently, overall business efficiency.
Start improving your sales forecasting skills today – and your business will thank you tomorrow!
A sales forecast is a justified estimate of the sales volume a company can achieve over a specific period, based on analysis of historical data, market trends, and other factors.
There are several ways to make a forecast in Excel: use the FORECAST or FORECAST.ETS functions, create a forecast sheet through the “Data” > “Forecast” tab, or conduct regression analysis using the “Data Analysis” add-in.
A sales forecast is needed by almost all company departments: management for strategic planning, the finance department for budgeting, the purchasing department for inventory management, the production department for capacity planning, HR for personnel planning, and marketing for evaluating campaign effectiveness.
A sales forecast is an objective assessment of what will likely happen, based on data analysis. A sales plan is a target indicator the company aims to achieve. A forecast answers the question “what will happen?”, while a plan answers “what do we want to happen?”.
A proper sales forecast requires:
A sales forecast can be explained as a scientifically based prediction of a company’s future sales, based on analysis of past results and factors affecting sales. It’s a tool that helps businesses prepare for the future and make informed decisions.
A forecast is needed for effective resource planning, inventory optimization, cash flow planning, budgeting, setting realistic goals for the sales department, and making strategic decisions about business development.
The main Excel functions for data forecasting include FORECAST, FORECAST.ETS, TREND, GROWTH, and the “Forecast Sheet” tool on the “Data” tab.
To build a progression in Excel, you can use the TREND function (for linear progression) or GROWTH (for exponential progression). You can also use a trend line on a chart, which can be extrapolated into the future with various progression types (linear, exponential, logarithmic, etc.).
To calculate a monthly sales forecast, you can use several approaches: analyze data for the same period last year with adjustments for current growth/decline, apply a moving average for the last few months, or use more complex models that account for seasonality and trends in Excel, you can apply a monthly sales forecast formula using the FORECAST or TREND functions.
Time to read: 6 min.
21 August 2025