Question

I'm wondering how to figure out the two squares that are in red how old did it come to be that figure if it's right but it still read sometimes they don't change to white the square but if it's wrong with the correct answer be on chapter 13 apply what you know

d13 How did it get to that percent under the 10% ADR increase because I had seen somewhere where it was 3.9% however it still stays read when I apply it to the XL worksheet and also on the 17 on the excel sheet words is go park change it has the less your pricing and a 5% ADR increases 3.7% and 10% and 80 or increase 0.0% but I don't know if that's right or wrong it's the red and it hasn't changed I just don't understand what to do on that one

Chapter 13 Apply What You Know-Student Work 3.1 365 Karla's 200-Room Hotel: Revenue Analysis 200 Room Property Last Year 5% ADR 10 % ADR Pricing Increase Increase Available Rooms 200 200200 Room Nights in 1 Year 365 365 Actual Forecasted Occupancy % 80.00% 77.50% 70.00% • Rooms sold $ 58,400.00 $ 56,575.00 $ 51,100.00 O ADR 149.99 $ 157.49 $ 164.99 71 Rev $ 8,759,416 $ 8,909,968 $ 8,430,938 12 RevPAR 119.99 $ 122.05 $ 115.49 13 RevPAR change NAI 1.7% 9% Controllable operating costs @ $ 2,628,000 $ 2,545,875 S 2,299,500 14 $45.00 per room 15 Gross operating profit $ 6,131,416 S 6,364,093 $ 6,131,438 16 GOPPAR 17 GOPPAR change 83.99 $ 87.18 $ 83.99 N/A 18 3.7% 0.0% 19 13.3 21 Rooms available 22 ADR With Rooms 250 $180.00 200 $36,000 23 Rooms sold 24 Room revere 25 Occupancy % (Rooms sold / Rooms 26 available) ADR Rooms Room rc 8096 Occupan available) 20 Rooms sold 29 Distributable CPOR 30 31 Distributable operating expense 200 $68 Rooms so. Distributab Undistributable cost per available $13.600 Distributabl Chapter 13 $28 Undistribute

Answer 1

The table can be filled as below:

Sr No	200 Room Property	Last Year Pricing	5% ADR Increase	10% ADR Increase
1	Available Rooms	200	200	200
2	Room Nights in 1 year	365	365	365
3	Actual/ Forecasted Occupancy %	80%	77.50%	70%
4	Rooms sold (1 * 2 * 3)	58400	56575	51100
5	ADR	149.99	157.49	164.99
6	Rev (4 * 5)	8759416	8909997	8430989
7	RevPAR (6 / [1 * 2])	119.99	122.05	115.49
8	RevPAR change	N/A	1.7%	-3.9%
9	Controllable operating costs @ $45 per room (4 * 45)	2628000	2545875	2299500
10	Gross Operating Profit (6 - 9)	6131416	6364122	6131489
11	GOPPAR (10 / [1 * 2])	83.99	87.18	83.99
12	GOPPAR Change	N/A	3.7%	0.0%

Please note: The amount put by you in cell D11 (Rev for 10% Increase in ADR) is incorrect.

The calculations for RevPAR Change and GOPPAR Change is as follows:

RevPAR Change = (RevPAR after ADR increase - Last Year Pricing Rev PAR) / RevPAR after ADR increase * 100

RevPAR Change for 5% increase = [(122.05 - 119.99) / 122.05] * 100 = 1.7%

RevPAR Change for 10% increase = [(115.49 - 119.99) / 115.49] * 100 = -3.9%

GOPPAR Change = (GOPPAR after ADR increase - Last Year Pricing GOPPAR) / GOPPAR after ADR increase * 100

GOPPAR Change for 5% increase = [(87.18 - 83.99) / 87.18] * 100 = 3.7%

GOPPAR Change for 10% increase = [(83.99 - 83.99) / 83.99] * 100 = 0%