$654$

pons Two different forecasting tectiniques $($Fi wnd F$2)$ were used to forecast demand for cases of bottled water, Actual demand and the lwo sets of forechsts tore ins follows.

Glick therellor the Excel Oatalile

a$.$ Compute Mab for each set of forecasts. Glven your results, which lorecost appenes to be more accurate? Note: Round your answers to $1$ decimal place.

$\backslash$table$[[$MODFI$],[$MADF$2]]$

$$

b$.$ Compute the MSE for esch set of forecasts. Given your results, which forecast appears to be more accurate? Note: Round your answers to $2$ decimal places.

$\backslash$table$[[$MSEF$1],[$MSEF$2]]$

$q,$

C$.$ In practice, either MAD or MSE would be employed to compute forecist errors. What factors might lead a managen to choose ond rather thon the other? $q,$

d$.$ Compute MAPE for each data set. Which forecast appoars to bo moro oceurate? Note Round your intermedlate calculations and final answers to $2$ decimal places.

$\backslash$table$[[$MNPEF$],[$MNEEF$]]$