Chapter 6 Apply What You Know-Student Worksheet H N isto ig r ht ic Pe al T rf h or u r m sd an a ce y 6.1 Thursday Occ % ADR Week 1 Week 2 Week 3 Week 4 69.50% 73.50% 66.50% 72.00% $151.50 $145.95 $161.50 $178.50 Rooms Sold Revenue Sold Occ% 139 147 133 144 $21,058.50 $21,454.65 $21,479.50 $25,704.00 ADR RevPAR Weeks 1-4 70.375% $112.15 Weeks 2-5 71.1% $101.32 Weeks 3-6 70.0% $113.73 Weeks 4-7 72.6% $117.72 6.2 Occupancy Report: The Doubletree Hotel For Dates May 1-14 Run Date: Today Date Day Rooms Available Reserved Blocked Total Held 5/1 Mon 500 210 60 270 5/2 Tues 500 175 245 420 5/3 Wed 500 200 50 250 5/4 Thur 500 90 110 200 5/5 Fri 500 220 80 300 5/6 Sat 500 100 275 375 5/7 Sun 500 275 25 300 5/8 Mon 500 100 250 350 5/9 Tues 500 200 250 450 5/10 Wed 500 60 210 270 5/11 Thur 500 245 175 420 5/12 Fri 450 210 60 270 5/13 Sat 450 175 245 420 5/14 Sun 450 200 25 225 2460 2060 4520 Total Availability Report: The Doubletree Hotel For Dates May 1-14 Run Date: Today Date Total Day Rooms Available Reserved Blocked Total Held 5/1 Mon 500 210 60 270 5/2 Tues 500 175 245 420 5/3 Wed 500 200 50 250 5/4 Thur 500 90 110 200 5/5 Fri 500 220 80 300 5/6 Sat 500 100 275 375 5/7 Sun 500 275 25 300 5/8 Mon 500 100 250 350 5/9 Tues 500 200 250 450 5/10 Wed 500 60 210 270 5/11 Thur 500 245 175 420 5/12 Fri 450 210 60 270 5/13 Sat 450 175 245 420 5/14 Sun 450 200 25 225 2460 2060 4520 Worksheet Week 5 Week 6 Week 7 72.50% 69.00% 77.00% $179.95 $129.95 $159.95 145 138 154 $26,092.75 $17,933.10 $24,632.30 Correct Cells to Assignm Answers Fill-in ent % 82 90 91% or Dates May 1-14 Current Occ. % 54.00% 84.00% 50.00% 40.00% 60.00% 75.00% 60.00% 70.00% 90.00% 54.00% 84.00% 60.00% 93.33% 50.00% 65.99% or Dates May 1-14 Available for Sale 230 80 250 300 200 125 200 150 50 230 80 180 30 225 65.99%