The Bayside Fountain Hotel is adjacent to County Coliseum, a24,000?seat arena that is home to the city’s professionalbasketball and ice hockey teams and that hosts a variety ofconcerts, trade shows, and conventions throughout the year. Thehotel has experienced the following occupancy rates for the past 9years, since the coliseum opened:
1..............83
2..............78
3..............75
4..............81
5..............86
6..............85
7..............89
8...............90
9...............86
a.Use Excel and POM?QM to compute an exponential smoothingforecast with ? = .20, an adjusted exponential smoothing forecastwith ? = .20 and ? = .20. Print yourresults. b.Use POM?QM to compute a linear trend line forecast. Print yourresults. Use the linear function obtained from POM?QM to manuallycompute forecast for year 11 through13. c.Use MAD to compare three forecasts and indicate which seems to bemost accurate.
