Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A 1 April 2 3 Hotel 4 Hotel A 5 Hotel B Hotel C Hotel D 8 Hotel E 9 Hotel F 10 Hotel G
A 1 April 2 3 Hotel 4 Hotel A 5 Hotel B Hotel C Hotel D 8 Hotel E 9 Hotel F 10 Hotel G Hotel H 6 7 11 12 13 Comp Set 14 15 Indexes 16 Hotel A 17 Hotel B 18 Hotel C 19 Hotel D 20 Hotel E 21 Hotel F 22 Hotel G 23 Hotel H 24 B Rooms 350 375 410 460 500 400 350 300 C Revenue Manager: Property C OCC D ADR 65.24% $100.42 75.90% $91.38 85.81% $91.46 53.19% $116.19 76.67% $67.47 56.67% $121.80 90.00% $88.49 86.67% $89.73 Occupancy Index ADR Index AVL E 10,500 11,250 12,300 13,800 15,000 12,000 10,500 9,000 F G SOLD REVENUES RevPAR 6,850 $687,850.25 8,539 $780,255.18 10,555 $965,325.50 7,340 $852,848.20 11,500 $775,955.40 6,800 $828,235.68 9,450 $836,255.25 7,800 $699,888.20 H $65.51 $69.36 $78.48 $61.80 $51.73 $69.02 $79.64 $77.77 RevPAR/Yield Index
A B 1 April 2 D E F G H Revenue Manager: Property C 3 Hotel Rooms OCC ADR AVL SOLD REVENUES RevPAR 4 Hotel A 350 65.24% $100.42 10,500 6,850 $687,850.25 $65.51 5 Hotel B 375 75.90% $91.38 11,250 8,539 $780,255.18 $69.36 6 Hotel C 410 85.81% $91.46. 12,300 10,555 $965,325.50 $78.48 7 Hotel D 460 53.19% $116.19 13,800 7,340 $852,848.20 $61.80 8 Hotel E 500 76.67% $67.47 15,000 11,500 $775,955.40 $51.73 9 Hotel F 400 56.67% $121.80 12,000 6,800 $828,235.68 $69.02 10 Hotel G 350 90.00% $88.49 10,500 9,450 $836,255.25 $79.64 11 Hotel H 300 86.67% $89.73 9,000 7,800 $699,888.20 $77.77 12 13 Comp Set 14 15 Indexes 16 Hotel A 17 Hotel B 18 Hotel C 19 Hotel D 20 Hotel E 21 Hotel F 22 Hotel G 23 Hotel H 24 Occupancy Index ADR Index RevPAR/Yield Index
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started