$2$

$3($i$)$ Enter appropriate formulae in the shaded cells to calculate MA$(3)$ forecasts for weeks $5$ to $9.$

$4($ii$)$ Use the forecasts from weeks $4$ to $8$ to calculate the MAPE.Moving average forecast

Exponential smoothing forecast

Smoothing constant: $,0\mathrm{.}8$