Excel worksheet for marketing
amassagardi001
excel_ch_7_8_and_9.xlsxChapter 7
| Chapter 7 Apply What You Know-Student Worksheet | |||||
| 7.1 | |||||
| Kingston Harbor Inn Upsell Results: Week 1 | |||||
| Room Type | Rack Rate | Nights Reserved | Reserved Revenue | Actual Night Usage | Actual Revenue |
| Superior Parlor Suite | $299.99 | 75 | 75 | ||
| Parlor Suite | $249.99 | 100 | 110 | ||
| Jr. Parlor Suite | $219.99 | 125 | 140 | ||
| Deluxe | $159.99 | 250 | 275 | ||
| Standard | $109.99 | 450 | 400 | ||
| Total Nights | 1000 | 1000 | |||
| Total Revenue | |||||
| ADR | |||||
| 7.2 | |||||
| Under Latisha’s Plan | Under Mark’s Plan | ||||
| Rooms sold | |||||
| Group revenue | |||||
| Transient revenue | |||||
| Total revenue | |||||
| Occupancy % | |||||
| ADR | |||||
| RevPAR | |||||
| 7.4 | |||||
| Last Month | This Month | Change | Inc/Dec. | ||
| Rooms | |||||
| Rooms Avail | |||||
| Occupancy % | |||||
| Rooms Sold | |||||
| ADR | |||||
| Monthly Rev. |
Chapter 8
| Chapter 8 Apply What You Know-Student Worksheet | |||
| 8.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 | |||
| Estimated channel revenue contribution | |||
| Total rooms revenue estimate | |||
| Total rooms sold | |||
| ADR | |||
| Occ. % | |||
| RevPAR | |||
| 8.2 | |||
| Net ADR Yield Estimate Worksheet: City Center Plaza | Prepared by Joel L. | ||
| Distribution Channel | Group Rooms | CRS Sales | 3rd Party Merchant |
| Rooms sold | 80 | 90 | 100 |
| (Standard) rate | $185.00 | $172.49 | $160.00 |
| Gross revenue | |||
| Franchise fee (8%) | |||
| Franchise marketing Fee (3%) | |||
| Franchisor’s CRS fee (1% + $2.00 per room)) | |||
| IDS fee ($10.00 per room) | |||
| Net total revenue | |||
| Net ADR yield | |||
| 8.3 | |||
| GOPPAR Estimate Worksheet: City Center Plaza | Prepared by Joel L. | ||
| Channel | Group Rooms | CRS | 3rd Party Merchant |
| Previous booked rooms net revenue @ 88% net ADR yield | |||
| Channel contributed net revenue* | |||
| Total net revenue | |||
| Total rooms sold | 280 | 290 | 300 |
| Rooms cost @ $55.00 | |||
| After rooms costs Revenue | |||
| GOPPAR (300 rooms available) |
Chapter 9
| Chapter 9 Apply What You Know-Student Worksheet | ||||
| 9.1 | ||||
| Hawthorne Suites May Performance | ||||
| Statistics | Last May | This May | ||
| Occupancy % | 75% | 85% | ||
| Rooms sold | ||||
| ADR | $129.99 | $116.99 | ||
| Rooms revenue | ||||
| RevPAR | ||||
| Controllable operating costs | ||||
| Gross operating profit | ||||
| GOPPAR | ||||
| 9.2 | ||||
| City Center Novotel Performance: | ||||
| Occupancy % | Novotel | Comp Set | Index | |
| This month | 57.2 | 58.1 | ||
| Last 3 months | 55.1 | 57.7 | ||
| Last 12 months | 51.3 | 55.6 | ||
| ADR | ||||
| This month | $266.57 | $270.15 | ||
| Last 3 months | $244.91 | $269.69 | ||
| Last 12 months | $231.45 | $268.95 | ||
| RevPAR | ||||
| This month | ||||
| Last 3 months | ||||
| Last 12 months | ||||
| 9.3 | ||||
| Property | Number of Rooms | Supply | ||
| Sheraton | ||||
| Radisson | ||||
| Holiday Inn Crown Plaza | ||||
| Hyatt Place | ||||
| Clarion | ||||
| JAMIE LYNN | ||||
| Total | ||||
| 9.4 | ||||
| Source of Business Calculation | ||||
| Group | With Lawrence Walks | Without Lawrence Walks | ||
| Sold | ||||
| ADR | $ - 0 | $ 129.00 | ||
| Total revenue estimate | $ - 0 | $ - 0 | ||
| Daily per room ancillary revenue | $ 8.00 | $ 8.00 | ||
| Total ancillary revenue | $ - 0 | $ - 0 | ||
| RevPOR | $ - 0 | $ - 0 | ||
| Total revenue | ||||
| Revenue Variance | Amount | % | ||
| $ | 14.6 | |||
| 9.5 | ||||
| Channel | ADR | Total Fees: 5% franchisor fee PLUS an additional; | Net ADR | Net ADR Yield |
| Third-party websites | $166.54 | 27% | ||
| Franchisor website | $229.99 | 7% | ||
| Proprietary website | $239.99 | 5% | ||
| Travel agent | $209.59 | 11% |
