Question
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
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 | 44 | |
March | 43 | |
April | 41 | |
May | 49 |
3-Period Moving Average | enter forecast for June using 3-Period Moving Average | |
---|---|---|
5-Period Moving Average | enter forecast for June using 5-Period Moving Average |
(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 | enter 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 | enter forecast for July using 3-Period Moving Average | |
---|---|---|
5-Period Moving Average | enter forecast for July using 5-Period Moving Average | |
Nave method | enter forecast for July using 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) | enter the mean absolute deviation | |
---|---|---|
MAD (5-period) | enter the mean absolute deviation | |
MAD (nave) | enter the mean absolute deviation |
(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) | enter the mean squared error | |
---|---|---|
MSE (5-period) | enter the mean squared error | |
MSE (nave) | enter the mean squared error |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started