- 20 Marks
QT – May 2019 – L1 – Q1a – Forecasting
Calculate centered trend values using moving average, determine seasonal variations, adjust variations, and forecast future clients using a multiplicative model.
Question
The number of clients who consulted Tsoo Consult within a period of three years were recorded as follows:
Year | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |
---|---|---|---|---|
1 | 75 | 70 | 75 | 80 |
2 | 95 | 85 | 80 | 65 |
3 | 100 | 105 | 115 | 90 |
Required:
a) Assuming a 4 quarterly cycle, calculate the centred trend values for the data by moving average method. (4 marks)
b) Using (a) above and the multiplicative model, calculate the average seasonal variations. (5 marks)
c) Using (b) above, calculate the adjusted average seasonal variations for the data. (5 marks)
d) Using the trend and the adjusted average seasonal variation, forecast the number of clients for Year 4 based on the multiplicative model. (6 marks)
Find Related Questions by Tags, levels, etc.
- Tags: Forecasting, Moving Averages, Multiplicative Model, Seasonal Variation, Time series
- Level: Level 1
- Topic: Forecasting
- Series: MAY 2019
Report an error