Discovery Learning Exercise $($DLE$)$ #$9$: Calculating Revenue

Scenario $1$:

You are an owner of a super$-$exclusive luxury hotel. Your property has $20$ rooms. All your rooms are unique in their design and amenities; therefore, you charge different prices for the rooms. Last night you sold $11$ of your rooms for the following prices: $$1150,$ $$1200,$ $$1100,$ $$1350,$ $$750,$ $$500,$ $$1800,$ $$600,$ $$1450,$ $$1400$ and $$1500.$ Using this information, please, calculate the hotel performance measures. Show your calculations.

$1.$ Revenue from room sales

$2.$ Occupancy percentage for the last night

$3.$ Average Daily Room Rate $($ADR$)$

$4.$ Revenue per Available Room $($RevPAR$)$

Scenario $2$:

Now assume that you are changing carpet in three of your rooms and they are not available for sale. What indicators will change? Please calculate new data for the following and show your calculations.

$1.$ Revenue from room sales

$2.$ Occupancy percentage for the last night

$3.$ Average Daily Rate $($ADR$)$

$4.$ Revenue per Available Room $($RevPAR$)$

Scenario $3$: You work as a revenue manager of a Residence Inn branded hotel in Orlando, FL$.$ The hotel has $250$ rooms. On Monday you sold $225$ rooms with the Average Daily Rate $($ADR$)$ of $$175$ and on Tuesday you sold $200$ rooms with the ADR of $$160.$ What is your combined ADR for Monday and Tuesday? Show your calculations.

$1.$ Combined ADR for Monday and Tuesday: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Scenario $4$:

You work at a Mexican restaurant. The restaurant has $100$ seats available and offers lunch from $11$:$30$ am until $200$ pm$.$ Yesterday, you had $200$ customers during the lunch hours. The average check was $$18\mathrm{.}50.$ Please calculate the following and show your calculations.

$2.$ Total revenue for yesterday$$s lunch

$3.$ Revenue per Available Seat Hour $($REVPASH$)($chapter $11)$

Scenario $5$:

The Navigator of the Seas cruise ship has $2500$ cabins. Below are the cabin types and prices for a $7$ Night Western Caribbean Cruise. Please calculate the number of cabins sold and the total revenue by cabin type and in total from the cabin sales for this cruise.

Cabin Available $\%$ sold Price Cabins sold Revenue

Interior $80085\%$ $$750$

Promenade $400100\%$ $$800$

Oceanview $40095\%$ $$900$

Balcony $80065\%$ $$1000$

Suite $10055\%$ $$1250$

Total: