. In the Bayside Fountain Hotel problem, compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 10 would be  b. In the Bayside Fountain Hotel problem, for the exponentially

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Chapter5: Business And Economic Forecasting
Section: Chapter Questions
Problem 2.1CE
icon
Related questions
Question

a. In the Bayside Fountain Hotel problem, compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 10 would be 

b. In the Bayside Fountain Hotel problem, for the exponentially smoothed forecast with an α value of .20, compute the mean absolute deviation (MAD) via Excel and/or POM-QM.

c. In the Bayside Fountain Hotel problem, compute an adjusted exponentially smoothed forecast with α = .20
and β = .20. According to the result from Excel and/or POM-QM, the forecast for the year 4 would be 

d. 

The Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000-
seat arena that is home to the city's professional basketball and ice hockey teams and that
hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel
has experienced the following occupancy rates for the past 9 years, since the coliseum
opened. Compute an exponentially smoothed forecast with an a value of .20. According to
the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number
only, two decimals)
Year
1
2
3
4
5
6
7
8
9
Occupancy Rate (%)
83
78
75
81
86
85
89
90
86
Transcribed Image Text:The Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000- seat arena that is home to the city's professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an a value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) Year 1 2 3 4 5 6 7 8 9 Occupancy Rate (%) 83 78 75 81 86 85 89 90 86
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Sales
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning