| Chapter 6 Apply What You Know-Student Worksheet |
| 6.1 |
| History | Thursday | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 |
| | Occ % | 69.5 | 73.5 | 66.5 | 72 | 72.5 | 69 | 77 |
| | ADR | $151.50 | $145.95 | $161.50 | $178.50 | $179.95 | $129.95 | $159.95 |
| Rooms Available | | 200 | 200 | 200 | 200 | 200 | 200 | 200 | Total | Occ. % | ADR | RevPAR |
| Weeks 1 - 4 | Rooms Sold |
| | Revenue |
| | Rev Par |
| Weeks 2 - 5 | Rooms Sold |
| | Revenue |
| | Rev Par |
| Weeks 3 - 6 | Rooms Sold |
| | Revenue |
| | Rev Par |
| Weeks 4 - 7 | Rooms Sold |
| | Revenue |
| | Rev Par |
| 6.2 |
| Occupancy Report: The Doubletree Hotel | | | | | For Dates May 1–14 |
| Run Date: Today |
| Date | Day | Rooms Available | Reserved | Blocked | Total Held | Current Occ. % |
| 5/1 | Mon | 500 | 210 | 60 | | % |
| 5/2 | Tues | 500 | 175 | | 420 |
| 5/3 | Wed | 500 | 200 | | | 50.00% |
| 5/4 | Thur | 500 | 90 | 110 |
| 5/5 | Fri | 500 | 220 | | 300 |
| 5/6 | Sat | 500 | 100 | | | 75.00% |
| 5/7 | Sun | 500 | 275 | 25 |
| 5/8 | Mon | 500 | 100 | | 350 |
| 5/9 | Tues | 500 | | 250 | | 90.00% |
| 5/10 | Wed | 500 | 60 | 210 |
| 5/11 | Thur | 500 | | 175 | 420 |
| 5/12 | Fri | 450 | 210 | 60 |
| 5/13 | Sat | 450 | 175 | | 420 |
| 5/14 | Sun | 450 | 200 | | | 50% |
| Total |
| Availability Report: The Doubletree Hotel | | | | | For Dates May 1–14 |
| Run Date: Today |
| Date | Day | Rooms Available | Reserved | Blocked | Total Held | Available for Sale |
| 5/1 | Mon | 500 | 210 | 60 |
| 5/2 | Tues | 500 | 175 | | 420 |
| 5/3 | Wed | 500 | 200 | | | 250 |
| 5/4 | Thur | 500 | 90 | 110 |
| 5/5 | Fri | 500 | 220 | | 300 |
| 5/6 | Sat | 500 | 100 | | | 125 |
| 5/7 | Sun | 500 | 275 | 25 |
| 5/8 | Mon | 500 | 100 | | 350 |
| 5/9 | Tues | 500 | | 250 | | 50 |
| 5/10 | Wed | 500 | 60 | 210 |
| 5/11 | Thur | 500 | | 175 | 420 |
| 5/12 | Fri | 450 | 210 | 60 |
| 5/13 | Sat | 450 | 175 | | 420 |
| 5/14 | Sun | 450 | 200 | | | 225 |
| Total |
| 6.3 |
| Hawthorne Suites Hotel |
| Group Rooms Pace Report | | FOR: Jan -Dec Next Year |
| Month | Sold in September (This Year) | Total Committed Group Rooms (Jan-Dec Next Year) |
| Jan | | 1250 |
| Feb | 150 | 1950 |
| Mar | | 5620 |
| Apr | 360 | 1210 |
| May | 100 | 1075 |
| June | 240 | 1090 |
| July | | 2200 |
| Aug | 300 | 3700 |
| Sept | | 1900 |
| Oct | 100 | 2900 |
| Nov | 200 | 5700 |
| Dec | | 620 |
| TOTAL | 1450 | 29,215 |
| Last Update: 9/30/This Year | | Prepared BY: Wendy Parker |
| 6.4 |
| Rooms Forecast Report for: | Tuesday (This week) |
| Date: June 3rd. | Day: Tuesday |
| Total rooms available | 200 |
| Out-of-order (OOO) rooms | 0 |
| Net Availability | 200 |
| Stayovers | 85 |
| Reservations (Arrivals) | 60 |
| Rooms Sold or Reserved |
| Adjustments: |
| Overstays | 15 |
| Early departures | 10 |
| No-shows | 5 |
| Total Forecast Sold or Reserved After Adjustments |
amassagardi001
ch_6_hw.xlsx
