Compute an exponential smoothing forecast


Problem:

The Oceanside hotel is adjacent to city 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 nice years since the coliseum opened:

Year
1    75%
2    70
3    72
4    77
5    83
6    81
7    86
8    91
9    87

Compute an exponential smoothing forecast with a=0.20, an adjusted exponential smoothing forecast with a=0.20 and b=0.20 and a linear trend line forecast. Compare the three forecasts using MAD and average error (E) and indicate which forecast seems to be most accurate.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Compute an exponential smoothing forecast
Reference No:- TGS02074177

Now Priced at $20 (50% Discount)

Recommended (95%)

Rated (4.7/5)