Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Management

Authors: Stephen Lofthouse

2nd Edition

047149237X, 9780471492375

More Books

Students also viewed these Finance questions

Question

=+Does performance degradation have an impact on company revenues?

Answered: 1 week ago