Solve the below problem:
Q: 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.25.) Month Actual Values January 34 February 42 March 39 April 43 May 45 3-Period Moving Average 5-Period Moving Average
(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
(c) If the actual labor figure for June turns out to be 47, what would be the forecast for July using each of these models? (Round answers to 2 decimal places, e.g. 15.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.25.) MAD (3-period) MAD (5-period) MAD (naïve)
(e) Compare the accuracy of these models using the mean squared error (MSE). (Round answers to 2 decimal places, e.g. 15.25.) MSE (3-period) MSE (5-period) MSE (naïve)