Chapter 7 Apply What You Know-Student Worksheet 7.1 Room Type Superior Parlor Suite Parlor Suite Jr. Parlor Suite Deluxe Standard Total Nights Total Revenue ADR Total Revenue Difference Kingston Harbor Inn Upsell Results: Week 1 Rack Rate Nights Reserved Actual Night Actual Reserved Revenue Usage Revenue $299.99 $249.99 $219.99 $159.99 $109.99 75 100 125 250 450 1000 $22,499.25 $24,999.00 $27,498.75 $39,997.50 $49,495.50 75 110 140 275 400 1000 $164,490.00 $164.49 $22,499.25 $27,498.90 $30,798.60 $43,997.25 $43,996.00 $168,790.00 $168.79 $4,300.00 Total Revenue % Difference Total Revenue Difference * 52 Weeks $223,600.00 Based on Sherri's first week data: A) What would the Inn's ADR have been if all arriving guests had been assigned to their orriginally reserved rooms? B) What was the ADR actually achieved by the Inn as a result of the upsell program? C) What would the Inn's revenue have been if all arriving guests had been assigned to the originally reserved rooms? D) What was the revenue actually achieved by the Inn as the result of the upsell program? E) What was the amount of the increased revenue that resulted from Sherri's upsell program? F) What was the percent increase in the revenue achieved by the Inn as a result of the program? G) Assume this first week represents the typical week for the uypsell program. What would the hotel's 52-week revenue increase be as the result of implementing it? 7.2 Total Rooms available at the Hampton Inn 1 Day 3 Days 175 525 $164.49 $168.79 $164,490.00 $168,790.00 $4,300.00 $223,600.00 Thursday Under Latisha's Plan Friday Saturday Under M TOTAL Thursday Firefighterss rooms @ $99.00/night 90 90 90 270 90 All Other Rooms @ $149.99/night Total Reserved Total Rooms Available 55 35 45 135 55 145 30 125 50 135 40 405 120 145 30 Additional Firefighters rooms sold 20 20 20 60 0 10 175 $10,890.00 $9,749.35 $20,639.35 100.00% $117.94 $117.94 30 175 $10,890.00 $9,749.35 $20,639.35 100.00% $117.94 $117.94 20 175 $10,890.00 $9,749.35 $20,639.35 100.00% $117.94 $117.94 60 525 $32,670.00 $29,248.05 $61,918.05 100.00% $117.94 $117.94 20 165 $8,910.00 $11,249.25 $20,159.25 94.29% $122.18 $115.20 Transient rooms sold Total Rooms Sold Group revenue Transient revenue Total revenue Occupancy % ADR RevPAR Correct Cells to Assignm Answers Fill-in ent % 90 92 98% Under Mark's Plan Friday Saturday TOTAL 90 90 270 35 45 135 125 50 135 40 405 120 0 0 0 40 165 $8,910.00 $11,249.25 $20,159.25 94.29% $122.18 $115.20 30 165 $8,910.00 $11,249.25 $20,159.25 94.29% $122.18 $115.20 90 495 $26,730.00 $33,747.75 $60,477.75 94.29% $122.18 $115.20