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 team and that host 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:
Year Occupancy Rate
Compute an exponential smoothing forecast with a =.20, an adjusted exponential smoothing forecast with a = .20 and B =.20 and a linear forecast. Compare the three forecast, using MAD and average error (E) and indicate which seem to be most accurate.
This solution is comprised of detailed step-by-step calculation of the given problem in EXCEL and provides students with a clear perspective of the underlying concepts.