[See Solution] For 2006 and 2007, let’s assume that quarterly hotel revenues (in millions of dollars) in Statesboro were: Q1 Q2 Q3 Q4 2006 8 9 12 7 2007
Question: For 2006 and 2007, let’s assume that quarterly hotel revenues (in millions of dollars) in Statesboro were:
Q1 Q2 Q3 Q4
2006 8 9 12 7
2007 10 11.5 14 9
Use an appropriate method to estimate the trend and seasonality in this data and forecast the quarterly revenues accordingly for 2008. Submit your supporting Excel work via WebCT.
Deliverable: Word Document 