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

Forecasting

Question 4

Moving averages

A time series analysis of past sales units shows the following actual figures:

Jan 107, Feb 176, Mar 197, Apr 182, May 251, Jun 272, Jul 257, Aug 326, Sep
347, Oct 332, Nov 401.

Calculate the 3 point moving averages for the data given
Y = T + S
Actual/prediction 3 point average
Month (Y) 3 point total (T)
Jan 107
Feb 176 480 160
Mar 197 555 185
Apr 182 630 210
May 251 705 235
Jun 272 780 260
Jul 257 855 285
Aug 326 930 310
Sep 347 1005 335
Oct 332 1080 360
Nov 401
Dec

171