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)

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