$1.$ Compute the variance analysis for a metropolitan hotel$$s rooms revenue and indicate the reasons for the gain or loss in revenue compared to budget. The hotel$$s budgeted rooms revenue is $$13,175,251$ based on total occupied rooms of $88,788$ and an average room rate of $$148\mathrm{.}39.$ The property$$s actual rooms revenue totaled $$12,787,792$ with occupied rooms totaling $93,945$ with an average room rate of $$136\mathrm{.}12.$

$2.$ Please create a trend index based on the following information:

Year

ADR

ADR Trend Index

$1999$

$$80\mathrm{.}94$

$2000$

$$85\mathrm{.}30$

$2001$

$$84\mathrm{.}07$

$2002$

$$82\mathrm{.}82$

$2003$

$$82\mathrm{.}96$

$2004$

$$86\mathrm{.}41$

$2005$

$$91\mathrm{.}16$

$2006$

$$98\mathrm{.}00$

$2007$

$$104\mathrm{.}08$

$2008$

$$106\mathrm{.}55$