Chapter 13 Apply What You Know-Student Worksheet 13.1 Karla's 200-Room Hotel: Revenue Analysis 200 Room Property Last Year Pricing Available Rooms Room Nights in 1 Year Actual/ Forecasted Occupancy % Rooms sold $ ADR $ Rev $ RevPAR RevPAR change Controllable operating costs @ $45.00 per room Gross operating profit GOPPAR GOPPAR change 5% ADR Increase 200 365 80.00% 58,400.00 $ 149.99 8,759,416 N/A N/A 10 % ADR Increase 200 365 77.50% 56,575.00 $ 200 365 70.00% 51,100.00 13.3 Original Forecast Rooms available ADR Rooms sold Room revenue 250 $180.00 200 $36,000 Occupancy % (Rooms sold / Rooms available) 80% Rooms sold Distributable CPOR 200 $68 Distributable operating expense $13,600 Undistributable cost per available room Rooms available Undistributable operating expense $28 250 $7,000 Room revenue Distributable operating Undistributable cost perexpense available room Gross operating profit (GOP) $36,000 $13,600 $7,000 $15,400 GOP % <--Cell B24 <--Cell B31 <--Cell B35 <-GOP/Rooms 42.78% Revenue 13.4 Dentists Rooms requested ADR Rooms sold Room revenue Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Less CPOR Less Distributable Undistributable Operating Expense Gross operating profit (GOP): Rooms 150 $199.00 150 $29,850 150 $75 $11,250 $30 150 $4,500 $29,850 <--Cell B49 $11,250 <--Cell B54 $4,500 <--Cell B58 $14,100 TOTAL GOP GOP per Sold Room $94 ent Worksheet <--- Make sure you multiply by number of Days in the Year With Group Forecast Rooms Available ADR Rooms sold Room revenue Occupancy % (Rooms sold / Rooms available) Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Distributable operating Undistributable cost perexpense available room Gross operating profit (GOP) GOP % Doctors Rooms available ADR Rooms Room revenue Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Less CPOR Less Distributable Undistributable Operating Expense Gross operating profit (GOP): Rooms + GOP: F&B + GOP: Meeting space TOTAL GOP GOP per Sold Room Chapter 13 Apply What You Know-Student Worksheet 13.1 Karla's 200-Room Hotel: Revenue Analysis 200 Room Property Last Year Pricing Available Rooms Room Nights in 1 Year Actual/ Forecasted Occupancy % Rooms sold ADR Rev RevPAR RevPAR change Controllable operating costs @ $45.00 per room Gross operating profit GOPPAR GOPPAR change $ $ $ $ $ $ 200 365 80.00% 58400 149.99 8,759,416 119.99 N/A 2,628,000 5% ADR Increase 10 % ADR Increase 200 365 77.50% 56575 $ 157.49 $ 8,909,968 $ 122.05 1.7% $ 2,545,875 200 365 70.00% 51100 $ 164.99 $ 8,430,938 $ 115.49 -3.9% $ 2,299,500 6,131,416 $ 6,364,093 $ 6,131,438 83.99 $ 87.18 $ 83.99 N/A 3.7% 0.0% 13.3 Original Forecast Rooms available ADR Rooms sold Room revenue 250 $180.00 200 $36,000 Occupancy % (Rooms sold / Rooms available) 80% Rooms sold Distributable CPOR 200 $68 Distributable operating expense $13,600 Undistributable cost per available room Rooms available Undistributable operating expense $28 250 $7,000 Room revenue Distributable operating Undistributable cost perexpense available room Gross operating profit (GOP) GOP % $36,000 $13,600 $7,000 $15,400 42.78% 13.4 Dentists Rooms requested ADR Rooms sold Room revenue Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Less CPOR Less Distributable Undistributable Operating Expense Gross operating profit (GOP): Rooms 150 $199.00 150 $29,850 150 $75 $11,250 $30 150 $4,500 $29,850 $11,250 $4,500 $14,100 TOTAL GOP GOP per Sold Room $94 ent Worksheet With Group Forecast Rooms Available ADR Rooms sold Room revenue Occupancy % (Rooms sold / Rooms available) Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Distributable operating Undistributable cost perexpense available room Gross operating profit (GOP) GOP % Doctors Rooms available ADR Rooms Room revenue Rooms sold Distributable CPOR Distributable operating expense Undistributable cost per available room Rooms available Undistributable operating expense Room revenue Less CPOR Less Distributable Undistributable Operating Expense Gross operating profit (GOP): Rooms + GOP: F&B + GOP: Meeting space TOTAL GOP GOP per Sold Room