Please answer with detailed calculations , good formatting and explanations else a downvote will be given. Submit the solution only if the answer is 100% correct else skip for other tutor. otherwise wrong answer will be reported for unprofessionalism. 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 nine years since the coliseum opened:

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

Compute an exponential smoothing forecast with = .20, an adjusted exponential smoothing forecast with = .20 and = .20, and a linear trend line forecast.

Find the linear trend line and compare the exponential smoothing, adjusted exponential smoothing, and linear trend models using MAD and average error and indicate which is most accurate. (Show formulas in excel sheet)