Holiday Lodge The Holiday Lodge is a large hotel and casino in the Adirondacks. The relatively new hotel is two years old, and the manager is trying to develop a plan to staff the maintenance department. The hotel’s manager wants to use the two years of data below to forecast one month ahead of maintenance calls. The data is provided in the spreadsheet named HOLIDAY LODGE DATA.XLS Month Calls 1 46 2 39 3 28 4 21 5 14 6 16 7 14 8 13 9 9 10 13 11 18 12 15 13 12 14 6 15 19 16 9 17 12 18 14 19 16 20 12 21 13 22 9 23 14 24 15 Develop a forecast for month 25 using a 4 month moving average, exponential smoothing (a = 0.2) and regression. Which forecast is preferred? Why?
Holiday Lodge
The Holiday Lodge is a large hotel and casino in the Adirondacks. The relatively new hotel is two years old, and the manager is trying to develop a plan to staff the maintenance department. The hotel’s manager wants to use the two years of data below to
|
Month |
Calls |
|
1 |
46 |
|
2 |
39 |
|
3 |
28 |
|
4 |
21 |
|
5 |
14 |
|
6 |
16 |
|
7 |
14 |
|
8 |
13 |
|
9 |
9 |
|
10 |
13 |
|
11 |
18 |
|
12 |
15 |
|
13 |
12 |
|
14 |
6 |
|
15 |
19 |
|
16 |
9 |
|
17 |
12 |
|
18 |
14 |
|
19 |
16 |
|
20 |
12 |
|
21 |
13 |
|
22 |
9 |
|
23 |
14 |
|
24 |
15 |
Develop a forecast for month 25 using a 4 month moving average, exponential smoothing (a = 0.2) and regression. Which forecast is preferred? Why?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
How do you calculate sum of squares and sum of products?
by Bartleby Expert
