C$6$

$=C5**30$

$\backslash$table$[[$A$,$B$,$C$,$D$,],[1,$TYS $4,,,],[2,,,,],[3,$Rooms Sales Comparison,,,$],[4,,$Last Month,Next Month,$\%$ Change$],[5,$Total Rooms Available,$300,300,],[6,$Monthly Total Rooms Available,$9000,9000,],[7,$Occupancy $\%,58\mathrm{.}5\%,,],[8,$Total Rooms Sold,$5265,,],[9,$ADR,$159\mathrm{.}00,$$$,139\mathrm{.}00],[10,$Monthly Rooms Revenue,$$,837,135,],[,,,,]]$

A$.$ Assume that this month and last month each contained $30$ days. How many total rooms would have to be sold at an ADR of $$139\mathrm{.}00$ this month to equal the rooms revenue achieved last month?

B$.$ What would be the percentage change in ADR experienced by the Hayman House next month versus last month?

C$.$ What would be the percentage change in occupancy required to equalize the rooms revenue achieved last month?

D$.$ Why does a $10$ percent decrease in ADR require more than a $10$ percent increase in occupancy percentage to equalize room revenue?

E$.$ What additional factors would you suggest Bill and Rebecca mention to this owner as they discuss the advisability of his proposed pricing strategy?