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
A Townsville outdoor and camping store recorded its quarterly sales ($'000). Data are illustrative.
| Year | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| 2021 | 113 | 105 | 123 | 164 |
| 2022 | 124 | 113 | 129 | 182 |
| 2023 | 130 | 125 | 141 | 190 |
| 2024 | 142 | 130 | 151 | 206 |
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.
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.
Step 2: Seasonal indices (average percentage method)
Each value as a percentage of its yearly mean, e.g. Q4 2021: . With a spreadsheet, the mean percentages give
Q1 0.898, Q2 0.834, Q3 0.960, Q4 1.309 (sum 4.001, allowing for rounding).
The indices are needed twice — to deseasonalise the data and to re-seasonalise the forecast.
Step 3: Deseasonalise
Divide each value by its quarter's index, e.g. Q4 2024: . The deseasonalised values rise steadily from about 126 to 157.
Step 4: Fit the trend line
Least-squares line of deseasonalised sales against ( is Q1 2021): with . Deseasonalised sales are increasing by about $2410 per quarter.
Step 5: Forecast Q4 2025
Q4 2025 is . Trend value: . Forecast: , about $221 800.
Step 6: Decide, and comment on reliability
The forecast is above $220 000, so on this analysis she should hire the extra staff member. But it is only about $1800 (less than 1%) above the threshold, and it is an extrapolation four quarters beyond the data. The trend is strong () and the Christmas peak is very consistent, so the forecast is reasonable — but it is close enough that she should check Q1–Q3 2025 sales before committing.
Answer
Forecast Q4 2025 sales are about $221 800 (trend , Q4 index 1.309), just above the $220 000 threshold, so the analysis supports hiring — with the caution that the margin is small and the forecast is a four-quarter extrapolation.
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Quarterly sales ($'000), is Q1 2021.
Method
Plot and describe the series.
Find seasonal indices by the average percentage method.
Deseasonalise and fit a trend line against .
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 (Q1 2025) instead of for Q4 2025.
Giving a yes/no answer with no comment on how close the forecast is to the threshold.