Lesson 7: Forecasting and solving time series problems

Should the store hire for Christmas? A full time series analysis

SkillsSolving time series problemsSeasonal indicesForecasting

Worked example

  • Complex unfamiliar
  • Technology active

A Townsville outdoor and camping store recorded its quarterly sales ($'000). Data are illustrative.

YearQ1Q2Q3Q4
2021113105123164
2022124113129182
2023130125141190
2024142130151206

The owner hires an extra full-time staff member for any quarter with forecast sales above $220 000. Should she hire one for Q4 2025? Carry out a time series analysis to decide.

1 of 6 steps
  1. Step 1: Describe the plot

    There is an increasing trend, with yearly means of 126.25, 137, 146.5 and 157.25 thousand dollars. There is strong seasonality: a peak every Q4 (Christmas) and the lowest sales every Q2. The irregular fluctuations are small.

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Quarterly sales ($'000), t=1t = 1 is Q1 2021.

Method

  1. Plot and describe the series.

  2. Find seasonal indices by the average percentage method.

  3. Deseasonalise and fit a trend line against tt.

  4. Forecast (trend value × index), then answer the question with a reliability comment.

Watch out for

  • Comparing the trend value (169.41) with $220 000 — it must be re-seasonalised first.

  • Using t=17t = 17 (Q1 2025) instead of t=20t = 20 for Q4 2025.

  • Giving a yes/no answer with no comment on how close the forecast is to the threshold.

Save your progress with a free account