Q$3$ Forecasting

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

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

$6$ Moving average forecast

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$\backslash$table$[[$Week$,\backslash$table$[[$Demand$],[(00s)$