Month Sales
January 100
Feburay 94
March 106
April 80
May 68
June 94
1. Develop forecasts for months April to July using a moving average model with AP=3 and then calculated the overall Mean Absolute Deviation (MAD) and Tracking Signal (TS) for months April to June.
2. With an alpha value of 0.3 and a starting forecast in month January equal to actual in month January, develop forecasts for months February t oJuly using exponential smoothing and then calculate the overall MAD and TS for months February to June.
3. Develop a linear regression equation to forecast the sales of the units and then calculate the number of units for month July.