Chapter 13 apply what you know worksheet how to How to calculate the two items because it's in red and do not know if it's right and how do I come to calculate those please. rev par change and goppar change
Show Formulas Trace Precedents Define Name fox Error Checking Trace Dependents Use in Formula Calculati Watch Name AutoSum Recently Financial Logical Text Date & Lookup & Math 8& More insert unction Evaluate Formula Window Options Time Reference Trig Functions Manager Create from Selection Remove Arrows Used Formula Auditing Defined Names Function Libeary 17 (D16-816)/D16 F E Chapter 13 Apply What You Know-Student Worksheet 13.1 Karla's 200-Room Hotel: Revenue Analysis Last Year Pricing 200 Room Property 5% ADR 10 % ADR Increase Increase 200 365 77.50% Available Rooms Room Nights in 1 Year chaal Forecasted Occupancy % 200 365 80.00%) 58,400.00 S 56,575.00 200 365 70.00% $ 51,100.00 164.99 ooms sold Make sure you multiply by mmber of Days in the Year 149.99 S DR $ 157.49 S $ 8,759,416 $ 8,909,968 S 8,430,938 122.05 S ev vPAR PAR change ontrollable operating costs@ 5.00 per room ss operating profit OPPAR PPAR change 119.99 S N/A 115.49 3.9% $ 2,628,000 $ 2,545,875 S 2,299,500 1.7% 6,131,416 S 6,364,093 S 6,131,438 87.18 S 3.7% $ 83.99 S N/A 83.99 0.0% With Group Forecast Rooms Available ADR ms available 250 $180.00 250 $168.00-(Number of rooms at one A as sold 200 Rooms sold Room revenue 250 n revenue $36,000 $42,000 pancy % (Rooms sold/ Rooms ble) Occupancy % (Rooms sold/ Rooms available) 80% 100% s sold 200 13.1 Karla's 200-Room Hotel: Revenue Analysis Last Year Pricing 200 10 % ADR Increase 200 5% ADR Increase 200 365 77.50% $ 58,400.00 $ 56,575.00 S 51,100.00-- Ma 157.49 $ $ 8,759,416 $ 8,909,968| $ 8,430,938 122.05 $ 1.7% $ 2,628,000 $ 2,545,875 $ 2,299,500 200 Room Property Available Rooms 365 365 Room Nights in 1 Year 70.00% 80.00% Actual/Forecasted Occupancy % Rooms sold 164.99 149.99 $ $ ADR Rev 119.99 $ N/A 115.49 -3.9% $ RevPAR RevPAR change Controllable operating costs @ $45.00 Gross operating profit per room S6,131,416 $ 6,364,093 6,131,438 87.18 $ 3.7% GOPPAR $ 83.99 $ 83.99 GOPPAR change N/A 0.0% 13.3 With Grom Rooms available ADR 250 Rocmc Show Formulas Trace Precedents Define Name fox Error Checking Trace Dependents Use in Formula Calculati Watch Name AutoSum Recently Financial Logical Text Date & Lookup & Math 8& More insert unction Evaluate Formula Window Options Time Reference Trig Functions Manager Create from Selection Remove Arrows Used Formula Auditing Defined Names Function Libeary 17 (D16-816)/D16 F E Chapter 13 Apply What You Know-Student Worksheet 13.1 Karla's 200-Room Hotel: Revenue Analysis Last Year Pricing 200 Room Property 5% ADR 10 % ADR Increase Increase 200 365 77.50% Available Rooms Room Nights in 1 Year chaal Forecasted Occupancy % 200 365 80.00%) 58,400.00 S 56,575.00 200 365 70.00% $ 51,100.00 164.99 ooms sold Make sure you multiply by mmber of Days in the Year 149.99 S DR $ 157.49 S $ 8,759,416 $ 8,909,968 S 8,430,938 122.05 S ev vPAR PAR change ontrollable operating costs@ 5.00 per room ss operating profit OPPAR PPAR change 119.99 S N/A 115.49 3.9% $ 2,628,000 $ 2,545,875 S 2,299,500 1.7% 6,131,416 S 6,364,093 S 6,131,438 87.18 S 3.7% $ 83.99 S N/A 83.99 0.0% With Group Forecast Rooms Available ADR ms available 250 $180.00 250 $168.00-(Number of rooms at one A as sold 200 Rooms sold Room revenue 250 n revenue $36,000 $42,000 pancy % (Rooms sold/ Rooms ble) Occupancy % (Rooms sold/ Rooms available) 80% 100% s sold 200 13.1 Karla's 200-Room Hotel: Revenue Analysis Last Year Pricing 200 10 % ADR Increase 200 5% ADR Increase 200 365 77.50% $ 58,400.00 $ 56,575.00 S 51,100.00-- Ma 157.49 $ $ 8,759,416 $ 8,909,968| $ 8,430,938 122.05 $ 1.7% $ 2,628,000 $ 2,545,875 $ 2,299,500 200 Room Property Available Rooms 365 365 Room Nights in 1 Year 70.00% 80.00% Actual/Forecasted Occupancy % Rooms sold 164.99 149.99 $ $ ADR Rev 119.99 $ N/A 115.49 -3.9% $ RevPAR RevPAR change Controllable operating costs @ $45.00 Gross operating profit per room S6,131,416 $ 6,364,093 6,131,438 87.18 $ 3.7% GOPPAR $ 83.99 $ 83.99 GOPPAR change N/A 0.0% 13.3 With Grom Rooms available ADR 250 Rocmc
