Question
If it is too blurry to see, here is the text rewritten here.. Joel estimates that the net ADR yield on the 200 rooms he
If it is too blurry to see, here is the text rewritten here..
Joel estimates that the net ADR yield on the 200 rooms he has already sold will average 88 percent. He also knows that at this hotel it costs $55.00 to prepare, sell, and clean (prepare for resale) each room sold. To help him make the very best revenue optimization decision possible, complete the worksheet and then answer the questions that follow. (No questions follow here for this assingment, just the worksheet)
EDIT: Here's more information
1.
RevPAR Estimate Worksheet: City Center Plaza | |||
Prepared By Joel L. | |||
Distribution Channel | Group Sales | CRS Sale | 3rd Party Merchant |
Previous booked revenue: 200 rooms @ $229.99 | $45,998.00 | $45,998.00 | $45,998.00 |
Estimated channel revenue contribution | $14,800.00 | $15,524.32 | $16,000.00 |
Total rooms revenue estimate | $60,798.00 | $61,522.33 | $61,998.00 |
Total rooms sold | $280.00 | $290.00 | $300.00 |
ADR | $217.14 | $212.15 | $206.66 |
Occ. % | $93.34 | $96.66 | $100.00 |
RevPAR | $202.66 | $205.07 | $206.66 |
2.
Net ADR Yield Estimate Worksheet: City Center Plaza | Prepared by Joel L. | ||
Distribution Channel | Group Rooms | CRS Sales | 3rd Party Merchant |
Rooms sold (A) | 80 | 90 | 100 |
(Standard) rate (B) | 185 | 172.49 | 160 |
Gross revenue C= A*B | 14800 | 15524.1 | 16000 |
Franchise fee (8%) D=C*8% | 1184 | 1241.93 | 1280 |
Franchise marketing Fee (3%)E=C*8% | 444 | 465.72 | 480 |
Franchisors CRS fee (1% + $2.00 per room) F 14800*1%+80*2=308 15524.1*1%+90*2=335.24 16000*1%+100*2=360 | 308 | 335.24 | 360 |
IDS fee ($10.00 per room)G | 1000 | ||
Net total revenue (C-d-E-F-g) | 12864 | 13481.21 | 12880 |
Net ADR yield | 160.8 | 149.79 | 128.8 |
(12864/80) | (13481.21/90) | (12880/100) |
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