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 Occupancy Rate (%) 1 2 3 4 5 6 8 83 78 75 81 86 85 89 90 86

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 30P
icon
Related questions
Question
Need help with the forecast for year 10. Linear trend line
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
Occupancy Rate (%)
1
2
3
4
5
6
7
8
9
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 Occupancy Rate (%) 1 2 3 4 5 6 7 8 9 83 78 75 81 86 85 89 90 86
In the Bayside Fountain Hotel problem, compute a linear trend line forecast.
According to the result from Excel and/or POM-QM, the forecast for the year 10
would be (type number only, two decimals)
90.32
Transcribed Image Text:In the Bayside Fountain Hotel problem, compute a linear trend line forecast. According to the result from Excel and/or POM-QM, the forecast for the year 10 would be (type number only, two decimals) 90.32
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing