Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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)

Why? 3. Jocl estimates that the net ADR yield on the 200 rooms he has already sold epate, sell average 88 percent. He also knows that at his hotel it costs $55.00 to pr clean ( wim and e very best rew optimization decision possible, complete the worksheet and then answer the questict that follow GOPPAR Estimate Worksheet: City Center Plaza Prepared by Joel L Third-Party Merchant Channel Group Rooms CRS Previous booked rooms net revenue @ 88% net ADR yield Channel contributed net revenue Total net revenue Total rooms sold 280 290 Rooms cost $55.00 After rooms costs revenue GOPPAR (300 rooms available) From Question 2: Chapter 8 Why? 3. Jocl estimates that the net ADR yield on the 200 rooms he has already sold epate, sell average 88 percent. He also knows that at his hotel it costs $55.00 to pr clean ( wim and e very best rew optimization decision possible, complete the worksheet and then answer the questict that follow GOPPAR Estimate Worksheet: City Center Plaza Prepared by Joel L Third-Party Merchant Channel Group Rooms CRS Previous booked rooms net revenue @ 88% net ADR yield Channel contributed net revenue Total net revenue Total rooms sold 280 290 Rooms cost $55.00 After rooms costs revenue GOPPAR (300 rooms available) From Question 2: Chapter 8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bond Markets Analysis And Strategies

Authors: Frank J.Fabozzi

7th Edition

0136078974, 978-0136078975

More Books

Students also viewed these Finance questions

Question

=+3. Who can provide information for evaluation?

Answered: 1 week ago