Transcribed Image Text
Hospitality Hotels forecasts monthly labor needs.(a) Given the following monthly labor figures, make a forecast forJune using a three-period moving average and a five-period movingaverage. (Round answers to 2 decimal places, e.g.15.25.)MonthActual ValuesJanuary35February45March44April44May463 - Period Moving Average = 44.675 - Period Moving Average = 42.8(b) What would be the forecast for June using the naïve method?(Round answers to 2 decimal places, e.g.15.25.)Forecast for June = 46(c) If the actual labor figure for June turns out to be 45, whatwould be the forecast for July using each of these models?(Round answers to 2 decimal places, e.g.15.25.)3 - Period Moving Average = 455 - Period Moving Average = 44.8Naive method = 45(d) Compare the accuracy of these models using the mean absolutedeviation (MAD). (Round answers to 2 decimalplaces, e.g. 15.25.)MAD (3-period) = ?MAD (5-period) = ?MAD (naive) = ?(e) Compare the accuracy of these models using the mean squarederror (MSE). (Round answers to 2 decimalplaces, e.g. 15.25.)MSE (3-period) = ?MSE (5-period) = ?MSE (naive) = ?