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