Explore BrainMass

Explore BrainMass

    Forecast Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    1 83
    2 78
    3 75
    4 81
    5 86
    6 85
    7 89
    8 90
    9 86

    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.

    © BrainMass Inc. brainmass.com October 1, 2020, 11:36 pm ad1c9bdddf

    Solution Summary

    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.