Question: Need help on the remainder blank please Need help on the remainder blank please Hospitality Hotels forecasts monthly labor needs. (a) Given the following monthly

Need help on the remainder blank please Need help on the remainder blank please Need helpNeed help on the remainder blank please Need helpNeed help on the remainder blank please

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 33 February 47 March 43 April 39 May 46 3-Period Moving Average 42.67 5-Period Moving Average 41.60 (b) What would be the forecast for June using the nave method? (Round answers to 2 decimal places, e.g. 15.25.) Forecast for June 46.00 (c) If the actual labor figure for June turns out to be 43, 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 43.6 Nave 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) 1.4 MAD (nave) (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) 1.96 MSE (nave)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!