Marketing >
Sales Forecasting
COVERS ALL MAJOR EXAM BOARDS
Teaching Business
Sales Forecasting
A clear guide to sales forecasting, including time series analysis, trends, seasonal variation and four-quarter moving averages.
10
Created by an experienced Head of Business and examiner
_edited.png){kind=small}
AQA | Edexcel | Cambridge | Eduqas | WJEC | OCR | GCSE
KEY POINTS
Sales forecasting estimates future sales using past data, market research and business judgement.
Forecasts help businesses plan production, stock levels, staffing, cash flow and marketing activity.
Time series analysis uses past sales data arranged over time to identify patterns.
A trend shows the general long-term movement in sales, such as rising, falling or stable demand.
Seasonal variation occurs when sales regularly rise or fall at particular times of the year.
A four-quarter moving average smooths out seasonal changes in quarterly data to reveal the underlying trend.
Businesses can use sales forecasts to reduce uncertainty, but forecasts are never guaranteed.
Forecast accuracy may be affected by changing customer tastes, competitors, economic conditions, weather or unexpected events.
Strong exam answers should explain both the value and limitations of using sales forecasts for decision-making.
KEY DEFINITION
Sales Forecasting
Sales forecasting is the process of estimating future sales using past sales data, market research and analysis of market trends.
Main Explanation
Sales forecasting is the process of estimating future sales. Businesses use forecasts to help plan decisions such as production, stock levels, staffing, cash flow, marketing budgets and business expansion. A forecast does not guarantee what will happen, but it can reduce uncertainty and help managers make more informed decisions.
One common approach is to use past sales data. If a business has records of sales over several months, quarters or years, it can look for patterns. This is known as time series analysis because the data is arranged over time. For example, a business may compare quarterly sales to see whether demand is rising, falling or affected by seasonal factors.
A trend is the general direction of sales over time. Sales may show an upward trend, a downward trend or remain fairly stable. Identifying the trend helps a business judge whether demand is generally increasing or decreasing. This can support decisions about capacity, stock, investment and marketing objectives.
Seasonal variation occurs when sales regularly rise or fall at particular times of the year. For example, sales of ice cream may rise in summer, while sales of coats may rise in winter. Seasonal patterns matter because a business may need more stock, staff or promotion at certain times of the year.
A four-quarter moving average is often used when sales data is collected quarterly. It smooths out seasonal changes by calculating the average sales across four consecutive quarters. This helps reveal the underlying trend by reducing the impact of one unusually high or low quarter.
Because four-quarter moving averages use an even number of time periods, businesses often calculate a centred moving average. This is found by averaging two consecutive four-quarter moving averages. The centred moving average can then be compared with actual sales to estimate seasonal variation.
Sales forecasts can be valuable because they improve planning. If a business expects sales to rise, it may increase production, order more stock, recruit staff or increase marketing activity. If sales are expected to fall, the business may reduce stock purchases, control costs or adjust prices and promotion.
However, sales forecasting has limitations. Forecasts are based on past data and assumptions, so they may be inaccurate if market conditions change. Competitor actions, economic downturns, new technology, supply problems, weather or changing customer tastes can all affect actual sales. A forecast is therefore a guide, not a guarantee.
Overall, sales forecasting is useful because it helps businesses prepare for future demand. Strong exam answers should explain how the forecast helps decision-making, but also consider whether the data is reliable and whether external factors may make the forecast inaccurate.
✎ EXAMINER TIP
Students often calculate a moving average correctly but do not explain why it is useful. Strong answers explain that moving averages smooth out seasonal variation and help managers see the underlying sales trend.
KEY FORMULAS(s)
Profit and Profitability Formulas
These key formulas help you calculate different profit measures and profitability ratios used in business.
Gross Profit
Gross profit = Revenue − Cost of sales
The profit made after deducting direct costs.
!
Remember: profit shows how much money has been made, while profitability shows how efficiently revenue is being turned into profit.
DATA TABLE
Income Statement for North Coast Coffee Ltd
This statement shows how revenue is converted into gross profit, operating profit and net profit.
Revenue
£250,000
Output
Fixed Costs
Variable Costs
Total Costs
Revenue
Profit / Loss
0 candles £1,200 £0 £1,200 £0 -£1,200
Net profit is the final profit remaining after all costs and expenses have been deducted from revenue.
Four-Quarter Moving Averages
This chart shows how four-quarter moving averages smooth out seasonal fluctuations in quarterly sales data. It helps students see the difference between actual sales and the underlying trend.
WORKED EXAMPLE
Worked Example: North Coast Coffee
How many coffees must be sold to break even?
Fixed Costs
£1,800
equity + long-term debt
Break-even output = Fixed costs ÷ Contribution per unit
Contribution per unit = Selling price − Variable cost
£3.50 − £1.10 = £2.40
1
Step 1: Calculate contribution
£3.50 − £1.10 = £2.40
Contribution per unit is the amount each coffee contributes towards fixed costs.
BREAK-EVEN OUTPUT:
750 coffees per month
EXAM TIP
Always explain what the number means for the business. Do not just calculate the break-even point.
Sales Forecasting and Time Series Analysis
This diagram shows how businesses use past sales data, time series analysis, trends, seasonal variation and moving averages to produce a sales forecast.
APPLICATION
Coastal Scoops
Coastal Scoops sells ice cream, frozen yoghurt and cold drinks from three seaside kiosks. Sales are much higher during spring and summer, but fall during autumn and winter. This means the business cannot simply assume that a quiet winter quarter means the business is failing or that a busy summer quarter means sales will keep rising.
Sales forecasting could help Coastal Scoops plan more effectively. If previous sales data shows a clear seasonal pattern, managers can estimate when demand is likely to rise and when it may fall. This would help the business plan stock levels, temporary staffing, opening hours and marketing activity.
Time series analysis would be useful because the business can compare sales over several quarters. A four-quarter moving average could smooth out the seasonal peaks and troughs, making it easier to see whether the underlying trend is rising or falling.
If the forecast suggests that summer sales are likely to be higher than last year, Coastal Scoops may order more ingredients, recruit extra staff and increase promotion before the busy period begins. If the forecast suggests weaker demand, the business may reduce stock orders to avoid waste.
However, the forecast may not be accurate. Bad weather, local events, new competitors or changes in visitor numbers could all affect actual sales. This means Coastal Scoops should use forecasts as a planning tool, but still monitor real sales data and adjust decisions during the year.
This independent educational case study is not affiliated with, endorsed by or sponsored by Greggs plc. Any financial figures used alongside this example should be treated as simplified or hypothetical estimates created for teaching purposes.
_edited.png)
ANALYSIS
EXAM FOCUS
Analysis questions require you to examine a business concept or issue in detail, breaking it down into its component parts. You should explain how and why something happens and consider its impact on the business.
How to Approach Analysis Questions
1
Identify the key issue or concept
2
Break it down
3
Explain how and why
4
Reach a reasoned conclusion
Read the question carefully and highlight the focus of the analysis.
Consider the different factors, causes or impacts related to the issue.
Provide clear explanations using business terms and links points to context.
Evaluate the overall implications for the business.
Example Analysis Question
North Coast Coffee is considering using break-even analysis before opening a second café.
Advantages
• Sales forecasts may be inaccurate.
• Assumes costs and revenue remain constant.
• External factors may reduce reliability.
• Ignores qualitative business factors.
Disadvantages
• Sales forecasts may be inaccurate.
• Assumes costs and revenue remain constant.
• External factors may reduce reliability.
• Ignores qualitative business factors.
Key Exam Tip
If you find it difficult to expand your answer and show the type of depth that an examiner is looking for in a top response, consider using the 'so what' approach.
Tesco carry out market research - so what? - this allows them to better understand customer needs - so what? as a result Tesco can provide goods more likely to sell - so what? - this will increase Tesco profit and ensure higher levels of customer satisfaction - so what? this means that customers are likely to become more loyal to Tesco.
Avoid These Exam Traps
Students often lose marks on calculation and analysis questions by making these mistakes. Watch out for them in your exam!
1
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Tip:
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
2
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Tip:
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
3
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Tip:
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
Be precise. Read the question carefully. Show your working.
Small mistakes can cost big marks.
EXAM PRACTICE
Practice Question
Apply your knowledge of profit and profitability to answer this exam-style question.
1
MINI CASE STUDY
North Coast Coffee Ltd is a premium coffee business which sells freshly roasted coffee beans through its online store and a small chain of independent cafés. The business has experienced strong sales growth due to increasing demand for high-quality speciality coffee products.
The business generates annual revenue of £250,000. Its cost of sales, including coffee beans, packaging and direct production costs, totals £100,000. North Coast Coffee Ltd also faces operating expenses of £80,000, including marketing, employee wages, rent and administration costs. In addition, the business pays £20,000 in interest and taxation each year.
The owner, Mia Thompson, is reviewing the company’s profitability because rising wage costs and increased competition in the premium coffee market have started to place pressure on operating profit margins. She is considering increasing prices slightly in order to protect profitability while still maintaining customer demand.
.jpg)
2
EXAM QUESTION
Analyse the possible reasons for BrightBite’s falling profit margins and evaluate strategies it could use to improve profitability.
3
HOW TO ANSWER
P
Point
E
Explain
A
Apply
C
Consequence
H
However...
4
MODEL ANSWER
P
Point
Increasing prices could improve the profitability of North Coast Coffee Ltd because each sale would generate a larger amount of revenue and potentially increase profit margins.
5
EXAMINER TIP
For full marks, make sure you analyse causes rather than just listing them, and evaluate realistic strategies with clear judgement. THINK: Which strategy would have the biggest impact and why?
CALCULATOR
THIS TOPIC · POWERPOINT RESOURCE
Sales Forecasting
CHOOSE YOUR EXAM BOARD:
Product Title
Instant download — school site licence included
-
Fully editable PowerPoint lesson
-
Relevant activities and practice questions
-
School site licence — share with your department
Helvetica Light is an easy-to-read font, with tall and narrow letters, that works well on almost every site.
£3.00
RELATED TOPICS
Continue Learning
Build your understanding by exploring other topics that connect closely with this one.
Profit and Profitability
Learn how to calculate profit and analyse profitability to measure the financial performance of a business.