SAM SALES FIGURE

MONTH	UNIT SALES FIGURE
JAN	14
FEB	16
MARCH	23
APRIL	25
MAY	24

a) Make a forecast for June using a three-period moving average and a four-period moving average. (Clearly show all formulas and calculations and round to one decimal place).

b) Using the data presented above, what will be the forecast for July (using both the three-period moving average and four-period moving average) if the actual unit sales figure for June turns out to be 20? (Clearly show all formulas and calculations and round to one decimal place).

c) Using the data presented above, what will be the forecasts for June and July using the exponential smoothing method? Compile two different forecasts for both months (four forecasts in all) using alpha values of 0.1 and 0.6 and with a forecast value for May of 23; actual sales for June would be 20. (Clearly show all formulas and calculations and round to one decimal place).