Page 175 - Microsoft Word - 00 BA3 IW Prelims STUDENT.docx

Forecasting

Example continued

Takings 8 Qtr
Quarter ($’000) 4 Qtr total Average
Year = Y total (centred) = T
1 13 –

–
2 22 – –
20X1 116
3 58 235 29.4
119

4 23 244 30.5
125
1 16 253 31.6
128

2 28 258 32.2
20X2 130
3 61 261 32.6
131
4 25 263 32.9

132
1 17 264 33.0
132
2 29 265 33.1

20X3 133
3 61 267 33.4
134
4 26 269 33.6
135

1 18 274 34.2
139
2 30 281 35.1
20X4 142

3 65 – –
–
4 29 –

169