$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$

$$

$3.$ Please $1)$ adjust the REVPAR from $1999$ to $2008$ for inflation using the CPI provided.

Year

RevPAR

CPI

Adjusted RevPAR

$1999$

$$50\mathrm{.}90$

$166\mathrm{.}6$

$2000$

$$54\mathrm{.}02$

$172\mathrm{.}2$

$2001$

$$50\mathrm{.}26$

$177\mathrm{.}1$

$2002$

$$48\mathrm{.}91$

$179\mathrm{.}9$

$2003$

$$49\mathrm{.}15$

$184$

$2004$

$$53\mathrm{.}03$

$188\mathrm{.}9$

$2005$

$$57\mathrm{.}56$

$195\mathrm{.}3$

$2006$

$$62\mathrm{.}03$

$201\mathrm{.}6$

$2007$

$$65\mathrm{.}63$

$207\mathrm{.}3$

$2008$

$$64\mathrm{.}37$

$215\mathrm{.}3$

$2)$ Also calculate $9-$year overall growth percentage.

$3)$ Then calculate annual average growth percentage.