Question: can anyone help me solve this problem? i only need help with parts d and e. Hospitality Hotels forecasts monthly labor needs. (a) Given the
can anyone help me solve this problem? i only need help with parts d and e.
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, eg. 15.25.) Month Actual Values January 38 February 46 March 42 April 40 May 44 3-Period Moving Average 42 5-Period Moving Average 42 (b) What would be the forecast for June using the naive method? (Round answers to 2 decimal places, eg. 15.25.) Forecast for June 44 C (b) What would be the forecast for June using the naive method? (Round answers to 2 decimal places, eg. 15.25.) Forecast for June 44 (c) 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, e.g. 15.25.) 3-Period Moving Average 43 5-Period Moving Average 43.40 45 Naive method (d) Compare the accuracy of these models using the mean absolute deviation (MAD). (Round answers to 2 decimal places, es. 15.25.) 2.11 MAD (3-period) 4 MAD (5-period) MANI E - Q DEL (d) Compare the accuracy of these models using the mean absolute deviation (MAD). (Round answers to 2 decin MAD (3-period) 2.11 MAD (5-period) 4 MAD (nave) (e) Compare the accuracy of these models using the mean squared error (MSE). (Round answers to 2 decimal place MSE (3-period) MSE (5-period) MSE (naive)


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
