Current Attempt in Progress

Hospitality Hotels forecasts monthly labor needs.

$($a$)$ Given the following monthly labor figures, make a forecast for June using a three$-$period moving average and a five$-$period moving

average. $($Round answers to $2$ decimal places, e$.$g$.15\mathrm{.}25.)$

$3-$Period Moving Average

$5-$Period Moving Average

$($b$)$ What would be the forecast for June using the naive method? $($Round answers to $2$ decimal places, e$.$g$.15\mathrm{.}25.)$

Forecast for June

$($c$)$ If the actual labor figure for June turns out to be $44,$ what would be the forecast for July using each of these models? $($Round answers

to $2$ decimal places, e$.$g$.15\mathrm{.}25.)$

$3-$Period Moving Average

$5-$Period Moving Average

Na$$ve method

$($d$)$ Compare the accuracy of these models using the mean absolute deviation $($MAD$).($Round answers to $2$ decimal places, e$.$g$.15\mathrm{.}25.)$

$($e$)$ Compare the accuracy of these models using the mean squared error $($MSE$).($Round answers to $2$ decimal places, e$.$g$.15\mathrm{.}25.)$

MSE $(3-$period$)$

MSE $(5-$period$)$

MSE $($na$$ve$)$