Forecast sales with qualitative evidence and moving averages
Explain why firms forecast sales, calculate four-period centred moving averages and use qualitative forecasts with care.
Cambridge International AS & A Level Business 9609, 2026–2028 syllabus and 2029 syllabus, section 8.1.3. Treat forecasts and market estimates as uncertain evidence, and relate recommendations to the stated product and customers. Written practice is self-checked. Specialist review has not been completed for this lesson; these exercises do not award an official mark or establish exam readiness.
Before you begin
- Use the stated product, target market and period consistently; distinguish a forecast or model from a guaranteed result.
Work on paper. Try each question before revealing help, and explain why your method works.
Quick readiness check
Why use a moving average in sales analysis?
What you will learn
- Explain business uses of sales forecasts
- Calculate and centre a four-period moving average
- Assess qualitative forecasting and forecast limitations
Forecasts coordinate business decisions
Sales forecasts can guide production, staffing, inventory, cash planning, budgets and capacity decisions. Forecasts help coordinate resources but remain estimates that should be revised when evidence changes.
Qualitative forecasts draw on informed judgement, customer research, sales-team knowledge or expert views. They can help with new products or limited historical data but may reflect bias, incentives or inconsistent assumptions. Record the evidence and uncertainty behind the estimate.
A four-period moving average smooths short-term variation
For four consecutive periods, calculate the mean of the four sales values. Because four is an even number, the average lies between the second and third periods. Calculate the next overlapping four-period average and average the two adjacent moving averages to centre the result on the intervening period.
Moving averages smooth seasonal or irregular fluctuations but lag behind a turning point and do not explain causes. Use consistent periods and data definitions; do not present a historical trend as a guaranteed forecast. Combine it with market knowledge and revise it as conditions change.
Pause and explain
A four-period moving average uses an even number of periods. What extra step centres it?
Worked example
Quarterly sales are 80, 100, 120, 140 and 160 units. Calculate the four-quarter moving averages and the centred value for quarter 3.
Show the worked solution
- First average for Q1–Q4: (80+100+120+140)÷4 = 110.
- Next average for Q2–Q5: (100+120+140+160)÷4 = 130.
- Centre between them on Q3: (110+130)÷2 = 120.
Answer The two four-quarter moving averages are 110 and 130 units. Their centred moving average for quarter 3 is (110+130)÷2 = 120 units.
Try a topic test
Choose Easy, Normal or Difficult. Save your answers and open worked review after finishing.
Test this topic →From guided practice to a new situation
Write your answer and reasoning first. Use a hint only if you are stuck. The model solution is for self-checking; your written work is not automatically marked.
Monthly sales for months 1–5 are 20, 24, 28, 32 and 36. Calculate both four-month moving averages and the centred value for month 3.
Give me a hint
Average months 1–4, then months 2–5, and centre the two results.
Compare my reasoning
- First average = (20+24+28+32)÷4 = 26.
- Second average = (24+28+32+36)÷4 = 30.
- Centred value for month 3 = (26+30)÷2 = 28.
The first moving average is 26 units and the second is 30 units. The centred moving average for month 3 is 28 units.
Look for these in your work
- Both four-period windows are used
- Averages are correct
- Centre is assigned to month 3
A new product has no sales history, but a sales team forecasts demand from customer interviews. Explain one strength, one risk and a way to improve the forecast.
Give me a hint
Qualitative evidence may be useful without history, but check sample and incentives.
Compare my reasoning
- Interviews can reveal needs before launch.
- Stated interest may differ from actual purchase and the sample may be biased.
- Triangulate with a pilot, pre-orders or comparable products and show ranges.
Interviews can reveal needs when there is no sales history, but stated interest may not convert into purchases and the sample may be unrepresentative. The team could compare views with a small pilot, pre-orders or analogous products and provide a range with assumptions rather than one precise figure.
Look for these in your work
- Usefulness is stated
- Bias or uncertainty is recognised
- An evidence-based improvement is proposed
A manager plans next quarter's staffing from a moving average even though a major competitor has just closed. Explain why the forecast should be reviewed.
Give me a hint
Identify the event as new evidence outside the historical series.
Compare my reasoning
- Historical data do not include the competitor closure.
- Demand may shift, but the size and timing are uncertain.
- Update the forecast using market evidence and revise staffing in stages.
The moving average reflects earlier conditions and does not include the competitor closure. Some customers may switch, but the volume and timing are uncertain. The manager should gather current enquiries and market data, update the forecast and consider staged staffing or capacity rather than treating the historical trend as certain.
Look for these in your work
- New information is distinguished from past data
- Effect is conditional
- Plan is adjusted with staged decisions
Common mistakes
- Assigning an even-period moving average to the wrong quarter
- Treating a smoothed trend as a certain future result
- Using qualitative judgement without recording its assumptions
What can you explain now?
Why use a moving average in sales analysis?
Compare with the explanation
To smooth short-term fluctuation and reveal a trend
Smoothing can make a broad pattern easier to see, though it can lag.
After trying it yourself, choose your next review. This is your self-assessment.
Your review choice appears on Today. Sign in to sync it across devices.
Make it stick
How do moving averages and qualitative evidence support forecasts, and why should managers keep assumptions and new information visible?
If you needed the solution, close it and solve the problem again from a blank page. A correct answer is stronger when you can explain the reason for each step.