A-level Business revision · Theme 3: Decision-making techniques and influences

Quantitative sales forecasting

The idea

Time-series analysis uses past data to forecast. Moving averages smooth out fluctuations to show the trend. Extrapolation extends the trend line into the future. Correlation measures the link between two variables, such as advertising and sales; it does not prove cause.

  1. Calculate moving averages to find the trend.
  2. Extrapolate the trend, with caution.
  3. Use correlation to judge relationships.

Watch out Correlation does not prove that one variable causes the other.

See it worked

Worked example

Sales for four quarters are 120, 140, 130, 150. Find the first three-quarter moving average.

  1. Add the first three: 390.
  2. 390/3=130390/3 = 130.

Answer 130

Your turn

Question 1Calculator allowed2 marks

Sales over three months were 210, 240 and 270. What is the three-month moving average?

Question 21 mark

A scatter graph shows sales rising as advertising spending rises. This is:

Choose one
Question 32 marks

Give one limitation of extrapolation.

Write your answer, then see a model answer
  1. Name the assumption.
  2. Explain why it may fail.

Answer It assumes past trends continue, so it fails when the market changes, for example because of a new competitor or recession.

A-level Business Pro, Pearson Edexcel 9BS0

A-level Business Pro

£119 once

Price rises to £199 on 1 January. Save £80 by joining before then.

At least 12 months of access

By paying you agree to our Terms and get access straight away, which ends your 14-day cancellation right.

No VAT is charged.

Independent practice for Pearson Edexcel A-level Business (9BS0), not endorsed by Pearson.

Privacy · Terms