Question: Hospitality Hotels forecasts monthly labor needs. la) 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 38 February March 40 45 April May 45 43.33 3-Perlod Moving Average 5-Period Moving AverageSee the answerSee the answerSee the answer done loading

Show transcribed image textAnswer = 3-period moving average = 43.33 5-period moving average = 42.4 (b) Naive method = 45 (c) 3-period moving average = 45 5-period moving average = 43.80 Naive method = 45 Explanation Calculate Naive method Month Actual value(A) Naive(N) (A-N)…View the full answerTranscribed image text: Hospitality Hotels forecasts monthly labor needs. la) 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 38 February March 40 45 April May 45 43.33 3-Perlod Moving Average 5-Period Moving Average 47.40 b) What would be the forecast for June using the naïve method? (Round answers to 2 decimal places, eg. 15.25.) Forecast for June 45.00 Ic) If the actual labor figure for June turns out to be 45, what would be the forecast for July using each of these models? (Round answers to 2 decimal places, eg. 15.25.) 3-Period Moving Average 45.00 5-Period Moving Average 43.80 45 Naive method Idi Compare the accuracy of these models using the mean absolute deviation (MAD). (Round answers to 2 decimal places, eg. 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, eg. 15.25.) MSE (3-period) MSE (5-period) MSE (narve) eTextbook and Media Save for Later Last saved 1 day ago. Attempts: 0 of 3 used Submit Answer 44

*Related*