IM ALT Abbade Abbade AaBb CcDdi Ante de A " Namna No Spacing Heading 1 Heading 2 Discovery Learning Exerdse (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 price: $1150, $1200, $1100, $1350, $750, $500, $1800, $600, $1450, 51400 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, I 1. Combined ADA 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 hour. The averate check was Focus w MacBook Air 21 Aalboc de Albcode AaBb CcDdi AaroCode: A Normal No Spacing Heading 1 Heading 2 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.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 trule. Cabin sold Price Cabins sold Available 800 Revenue Interior 85% $750 Promenade 400 100% 5800 Oceanview 400 95% $900 800 65% Balcony Suite $1000 I 100 55% $1250 Total: Focus W MacBook Air