Hotel Dionysus Unit 267 | |||||||||
Comparative Income Statement | |||||||||
For the Years Ending December 31 | |||||||||
Year 1 | % | Year 2 | % | Year 3 | % | Year 4 | % | ||
Revenue | |||||||||
Transient | $ 5,052,454 | 44.0% | $ 4,847,383 | 42.1% | $ 5,234,698 | 45.3% | $ 5,256,472 | 50.2% | |
Group | 6,423,343 | 56.0% | 6,679,599 | 57.9% | 6,320,083 | 54.7% | 5,204,731 | 49.8% | |
Total Room Revenue | $ 11,475,797 | 100.0% | $ 11,526,982 | 100.0% | $ 11,554,781 | 100.0% | $ 10,461,202 | 100.0% | |
Room Nights/ADR | |||||||||
Transient | 32,305 | $ 156.40 | 30,072 | $ 161.20 | 31,557 | $ 165.88 | 34,002 | $ 154.59 | |
Group | 48,457 | $ 132.56 | 49,064 | $ 136.14 | 45,411 | $ 139.18 | 39,915 | $ 130.39 | |
Total Room Nights/ADR | 80,762 | $ 142.09 | 80,762 | $ 145.66 | 80,762 | $ 150.13 | 80,762 | $ 141.53 | |
Payroll and Payroll Benefit Expense | |||||||||
Front Office | $ 429,159 | 3.7% | $ 437,743 | 3.8% | $ 446,498 | 3.9% | $ 415,632 | 4.0% | |
Housekeeping | $ 617,503 | 5.4% | $ 629,853 | 5.5% | $ 642,450 | 5.6% | $ 655,299 | 6.3% | |
Guest Services | $ 331,631 | 2.9% | $ 338,264 | 2.9% | $ 345,029 | 3.0% | $ 351,930 | 3.4% | |
Payroll Taxes and Employee Benefits | $ 652,622 | 5.7% | $ 712,068 | 6.2% | $ 769,328 | 6.7% | $ 868,087 | 8.3% | |
Payroll Taxes and Employee Benefits | $ 2,030,915 | 17.7% | $ 2,117,927 | 18.4% | $ 2,203,305 | 19.1% | $ 2,290,948 | 21.9% | |
Direct Expenses | CPOR | CPOR | CPOR | CPOR | |||||
Amenity Expense | $ 149,409 | $ 1.85 | $ 150,793 | $ 1.91 | $ 151,062 | $ 1.96 | $ 149,427 | $ 2.02 | |
Cleaning Supplies | $ 52,495 | $ 0.65 | $ 52,981 | $ 0.67 | $ 50,029 | $ 0.65 | $ 57,656 | $ 0.78 | |
Decorations | $ 60,000 | $ 0.74 | $ 62,500 | $ 0.79 | $ 59,000 | $ 0.77 | $ 45,000 | $ 0.61 | |
Glassware Expense | $ 29,074 | $ 0.36 | $ 28,489 | $ 0.36 | $ 27,708 | $ 0.36 | $ 26,610 | $ 0.36 | |
Guest Transportation | $ 185,000 | $ 2.29 | $ 205,000 | $ 2.59 | $ 215,000 | $ 2.79 | $ 245,000 | $ 3.31 | |
Linen Expense | $ 169,600 | $ 2.10 | $ 174,098 | $ 2.20 | $ 167,789 | $ 2.18 | $ 190,707 | $ 2.58 | |
Miscellaneous Expense | $ 36,343 | $ 0.45 | $ 35,611 | $ 0.45 | $ 34,635 | $ 0.45 | $ 33,263 | $ 0.45 | |
Paper Supplies | $ 68,647 | $ 0.85 | $ 64,891 | $ 0.82 | $ 70,810 | $ 0.92 | $ 65,786 | $ 0.89 | |
Terry Expense | $ 130,834 | $ 1.62 | $ 135,322 | $ 1.71 | $ 140,081 | $ 1.82 | $ 149,313 | $ 2.02 | |
Uniform Expense | $ 40,381 | $ 0.50 | $ 41,151 | $ 0.52 | $ 39,253 | $ 0.51 | $ 48,046 | $ 0.65 | |
Total Direct Expenses | $ 921,783 | $ 11.41 | 950,836 | $ 12.02 | 955,368 | $ 12.41 | 1,010,808 | $ 13.67 | |
Departmental Profit | $ 8,523,099 | 74.3% | $ 8,458,219 | 73.4% | $ 8,396,109 | 72.7% | $ 7,159,446 | 68.4% | |
Hotel Dionysus Unit 267 | |||||
Inventory Analysis | |||||
For the Years Ending December 31 | |||||
Year 1 | Year 2 | Year 3 | Year 4 | ||
Rooms Available | 285 | 285 | 285 | 285 | |
Room Nights Occupied | 80,762 | 79,136 | 76,968 | 73,917 | |
Guest Amenities | |||||
Soap | $ 5,048 | $ 5,149 | $ 5,663 | $ 5,149 | |
Shampoo | $ 10,095 | $ 10,297 | $ 11,327 | $ 10,297 | |
Conditioner | $ 11,105 | $ 11,327 | $ 12,460 | $ 12,460 | |
Total Guest Amenities Inventory | $ 26,248 | $ 26,773 | $ 29,450 | $ 27,905 | |
Linen | |||||
Top Sheets | $ 8,550 | $ 8,721 | $ 9,593 | $ 10,073 | |
Bottom Sheets | $ 10,260 | $ 10,465 | $ 11,512 | $ 12,087 | |
Duvet Covers | $ 12,312 | $ 12,558 | $ 16,326 | $ 17,142 | |
Pillow Cases | $ 8,123 | $ 8,285 | $ 8,451 | $ 8,873 | |
Total Linen Inventory | $ 39,245 | $ 40,029 | $ 45,881 | $ 48,175 | |
Terry | |||||
Wash Cloths | $ 7,909 | $ 8,067 | $ 8,874 | $ 9,317 | |
Hand Towels | $ 10,677 | $ 10,890 | $ 11,979 | $ 12,578 | |
Bath Towels | $ 11,744 | $ 11,979 | $ 15,573 | $ 16,352 | |
Bath Mats | $ 8,221 | $ 8,386 | $ 8,553 | $ 8,981 | |
Total Terry Inventory | $ 38,551 | $ 39,322 | $ 44,979 | $ 47,228 | |
Hotel Dionysus Unit 267 | Hotel Dionysus Unit 267 | ||||||||||
Market Share Report – Occupancy | Market Share Report – Average Rate | ||||||||||
For the Years Ending December 31 | For the Years Ending December 31 | ||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 1 | Year 2 | Year 3 | Year 4 | ||||
Market Occupancy | 72.5% | 72.1% | 71.0% | 73.0% | Market ADR | $ 140.00 | $ 141.23 | $ 145.62 | $ 138.00 | ||
Hotel Occupancy | 74.5% | 73.0% | 71.0% | 68.0% | Hotel ADR | $ 142.09 | $ 145.66 | $ 150.13 | $ 141.53 | ||
103% | 101% | 100% | 93% | 101% | 103% | 103% | 103% |
Market OccupancyYear 1Year 2Year 3Year 40.724999999999999980.720999999999999970.710.73Hotel OccupancyYear 1Year 2Year 3Year 40.745000000000000110.730.710000000000000080.68Hotel ADR142.09449999999998145.661055150.12536185499999141.52564582960002Market ADR140141.22999999999999145.62138
To Calculate the Impact of changes in Market Share Index for Occupancy | |||
Benchmark Index | A | Enter the benchmark index | |
Current Index | B | Enter the Current Hotel Index | |
Current Hotel Occupancy | C | Enter the Current Hotel Occupancy | |
Hotel Occupancy at Benchmark | D | DIVIDE C by B and multiply that result by A. | |
Difference in Occupancy | E | Subtract C from D | |
Availalble Room Nights | F | From the Room Revenue Report | |
Difference in Occupancy | E | From E Above | |
Difference in Occupied Rooms | G | F X E | |
Current Hotel ADR | H | From the Room Revenue Report | |
Difference in Hotel Room Revenue | I | G X H | |
Current Year Rooms Profit Margin | J | From the Income Statement | |
Improved Departmental Profit | K | I X J | |
To Calculate the Impact of changes in Market Share Index for ADR | |||
Benchmark Index | A | Enter the benchmark index | |
Current Index | B | Enter the Current Hotel Index | |
Current Hotel ADR | C | Enter the Current Hotel ADR | |
Hotel ADR at Benchmark | D | DIVIDE C by B and multiply that result by A. | |
Difference in ADR | E | Subtract C from D | |
Current Year Occupied Rooms | F | From the Room Revenue Report | |
Difference in ADR | E | From E Above | |
Difference in Hotel Revenue | G | F X E | |
Difference in Hotel Profit | G | Note that improvements in ADR flow to profit at 100% | |
To calculate the impact of changes in Direct Expenses | |||
Benchmark CPOR | A | Enter the benchmark CPOR for the specific Direct Expense | |
Hotel Current CPOR | B | Enter the current hotel CPOR for the specific Direct Expense | |
Variance | C | Subtract B from A | |
Current Year Occupied Rooms | D | From the Room Revenue Report | |
Cost Savings | E | D X C | |
To calculate the impact of changes in Labor Productivity | |||
Benchmark MHPOR | A | Enter the benchmnark for the SPECIFIC JOB | |
Current Year Hotel MHPOR | B | Enter the hotel MHPOR for the SPECIFIC JOB from the Labor Cost Report | |
Variance | C | A – B | |
Current Year hotel occupied rooms | D | From the Room Revenue Report | |
Man Hours Saved | E | C X D | |
Payroll rate per hour | F | 16.65 | From the Labor Cost report for the specific job |
PTEB % overall | G | 61.1% | From the Labor Cost report for the overall hotel |
Total Rate Per Hour | H | $ 26.82 | F X (1+G) |
Payroll and Benefit Savings | I | $ – 0 | E X H |
Hotel Dionysus Unit 267 | ||||||
Guest Satisfaction Index – Rooms Division | ||||||
For the Years Ending December 31 | ||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 4 System Benchmark | ||
I was greeted upon arrival in the driveway | 9.8 | 9.6 | 9.4 | 8.5 | 9.8 | |
I was greeted by the doorman by name | 9.9 | 9.7 | 9.5 | 8.6 | 9.9 | |
I was greeted at the front desk by name | 9.2 | 9.0 | 8.8 | 9.1 | 9.2 | |
Check-in Speed | 9.5 | 9.3 | 9.1 | 7.2 | 9.5 | |
Accuracy of Reservation | 9.8 | 9.6 | 9.4 | 9.5 | 9.8 | |
Guest room cleanliness upon arrival | 9.7 | 9.5 | 9.3 | 8.5 | 9.3 | |
Guest room temperature | 9.6 | 9.4 | 9.2 | 9.7 | 9.6 | |
Guest room lighting | 9.7 | 9.5 | 9.3 | 9.0 | 9.7 | |
Everything in working order | 9.8 | 9.6 | 9.4 | 6.2 | 9.8 | |
The concierge was knowlegable | 9.7 | 9.5 | 9.3 | 7.0 | 9.7 | |
Check-out speed | 9.7 | 9.5 | 9.3 | 6.5 | 9.7 | |
Accuracy of billing | 9.2 | 9.0 | 8.8 | 5.0 | 9.2 | |
I was thanked upon departure and asked to return | 9.1 | 8.9 | 8.7 | 8.2 | 9.1 | |
Value for price paid | 9.5 | 9.3 | 9.1 | 8.2 | 9.5 | |
Value compared to competition | 9.0 | 8.8 | 8.6 | 6.5 | 9.0 | |
I plan to return | 9.4 | 9.2 | 9.0 | 8.2 | 9.4 | |
I would recommend this hotel to my friends | 9.8 | 9.6 | 9.4 | 8.0 | 9.8 |
Hotel Dionysus Unit 267 | ||||||||||||||
Benchmark Metrics Report | ||||||||||||||
For the Years ending December 31 | ||||||||||||||
Unit 267 | Systemwide | Variance | ||||||||||||
Year 3 | Year 4 | YoY Change | Upper Quartile Benchmark Year 4 | Unit to System Benchmark | Profit Calcluations | Hotel | ||||||||
Market Share | Hotel | Difference | Revenue | Profit | Occupancy | 68.0% | ||||||||
Occupancy | 100% | 93% | -7.0% | 103% | -10% | ADR | $ 141.53 | |||||||
ADR | 103% | 103% | 0.0% | 105% | -2% | Available | 104,025 | |||||||
Occupied | 80,762 | |||||||||||||
Productivity (Man Hours Per Occupied Room) | Room Profit Margin | 68.40% | ||||||||||||
Front Office Supervisor | 0.09 | 0.10 | 11.1% | 0.08 | 25.0% | |||||||||
Front Desk Guest Agent | 0.19 | 0.17 | -10.5% | 0.16 | 6.3% | |||||||||
Housekeeping Floor Supervisor | 0.09 | 0.10 | 11.1% | 0.09 | 11.1% | |||||||||
Guest Room Attendant | 0.55 | 0.59 | 7.3% | 0.48 | 22.9% | |||||||||
Public Space Attendant | 0.08 | 0.08 | 0.0% | 0.08 | 0.0% | |||||||||
Runners | 0.10 | 0.13 | 30.0% | 0.10 | 30.0% | |||||||||
Concierge | 0.06 | 0.07 | 16.7% | 0.07 | 0.0% | |||||||||
Bellmen | 0.15 | 0.15 | 0.0% | 0.15 | 3.4% | |||||||||
Doorman | 0.17 | 0.19 | 11.8% | 0.17 | 11.8% | |||||||||
Drivers | 0.08 | 0.09 | 12.5% | – 0 | ||||||||||
Payroll Taxes and Employee Benefits | ||||||||||||||
FICA | 7.65% | 7.65% | 0.0% | 7.65% | 0.0% | |||||||||
FUTA | 2.30% | 2.31% | 0.4% | 2.31% | 0.0% | |||||||||
SUTA | 2.80% | 3.00% | 7.1% | 3.00% | 0.0% | |||||||||
Medicare | 1.45% | 1.45% | 0.0% | 1.45% | 0.0% | |||||||||
Workers Compensation | 9.00% | 9.50% | 5.6% | 7.50% | 26.7% | |||||||||
401k Match | 2.00% | 2.00% | 0.0% | 2.10% | -4.8% | |||||||||
Employee Meals | 5.45% | 6.10% | 11.9% | 5.00% | 22.0% | |||||||||
Health Care | 19.00% | 25.00% | 31.6% | 19.10% | 30.9% | |||||||||
Paid Time Off | 4.00% | 4.00% | 0.0% | 3.90% | 2.6% | |||||||||
Total Taxes and Payroll Benefits | 53.65% | 61.01% | 13.7% | 52.01% | 17.3% | |||||||||
Direct Expenses | ||||||||||||||
Amenity Expense | $ 1.96 | $ 2.02 | 3.1% | $ 1.85 | 9.2% | |||||||||
Cleaning Supplies | $ 0.65 | $ 0.78 | 20.0% | $ 0.65 | 20.0% | |||||||||
Decorations | $ 0.77 | $ 0.61 | -20.8% | $ 0.74 | -17.6% | |||||||||
Glassware Expense | $ 0.36 | $ 0.36 | 0.0% | $ 0.36 | 0.0% | |||||||||
Guest Transportation | $ 2.79 | $ 3.31 | 18.6% | $ – 0 | ||||||||||
Linen Expense | $ 2.18 | $ 2.58 | 18.3% | $ 2.10 | 22.9% | |||||||||
Miscellaneous Expense | $ 0.45 | $ 0.45 | 0.0% | $ 0.45 | 0.0% | |||||||||
Paper Supplies | $ 0.92 | $ 0.89 | -3.3% | $ 0.85 | 4.7% | |||||||||
Terry Expense | $ 1.82 | $ 2.02 | 11.0% | $ 1.62 | 24.7% | |||||||||
Uniform Expense | $ 0.51 | $ 0.65 | 27.5% | $ 0.50 | 30.0% | |||||||||
Total Direct Expenses | 12.41 | 13.67 | 10.2% | 9.12 | 49.9% | |||||||||
Hotel Dionysus Unit 267 | |||||||||
Labor Cost Analyisis | |||||||||
For the Years Ending December 31 | |||||||||
Year 1 | MHPOR | Year 2 | MHPOR | Year 3 | MHPOR | Year 4 | MHPOR | ||
Rooms Occupied | 80,762 | 79,136 | 76,968 | 73,917 | |||||
Room Revenue | $ 11,475,797 | $ 11,526,982 | $ 11,554,781 | $ 10,461,202 | |||||
Man Hours | |||||||||
Rooms Division Manager | 2,040 | 0.03 | 2,040 | 0.03 | 2,040 | 0.03 | 1,024 | 0.01 | |
Front Desk | |||||||||
Management | 4,080 | 0.05 | 4,080 | 0.05 | 4,080 | 0.05 | 4,096 | 0.06 | |
Supervisors | 5,840 | 0.07 | 5,840 | 0.07 | 6,570 | 0.09 | 7,320 | 0.10 | |
Front Desk Agents | 14,280 | 0.18 | 14,280 | 0.18 | 14,280 | 0.19 | 12,288 | 0.17 | |
Total Front Desk | 24,200 | 0.30 | 24,200 | 0.31 | 24,930 | 0.32 | 23,704 | 0.32 | |
Housekeeping | |||||||||
Management | 2,040 | 0.03 | 2,040 | 0.03 | 2,040 | 0.03 | 2,048 | 0.03 | |
Floor Supervisors | 5,840 | 0.07 | 5,840 | 0.07 | 6,570 | 0.09 | 7,320 | 0.10 | |
Guest Room Attendants | 40,381 | 0.50 | 41,151 | 0.52 | 42,332 | 0.55 | 43,611 | 0.59 | |
Public Space Attendants | 5,840 | 0.07 | 5,840 | 0.07 | 5,840 | 0.08 | 5,840 | 0.08 | |
Runners | 8,076 | 0.10 | 7,914 | 0.10 | 7,697 | 0.10 | 9,609 | 0.13 | |
Total Housekeeping | 62,177 | 0.77 | 62,784 | 0.79 | 64,479 | 0.84 | 68,428 | 0.93 | |
Guest Services | |||||||||
Concierge | 4,080 | 0.05 | 4,080 | 0.05 | 4,896 | 0.06 | 5,100 | 0.07 | |
Bell Service | 12,114 | 0.15 | 11,870 | 0.15 | 11,545 | 0.15 | 11,088 | 0.15 | |
Door Service | 11,680 | 0.14 | 11,680 | 0.15 | 13,140 | 0.17 | 13,870 | 0.19 | |
Transportation Drivers | 5,840 | 0.07 | 5,840 | 0.07 | 6,059 | 0.08 | 6,570 | 0.09 | |
Total Guest Services | 33,714 | 0.42 | 33,470 | 0.42 | 35,640 | 0.46 | 36,628 | 0.50 | |
Wage Rates Per Hour/Overtime Hours | Base Rate | OT Hrs | Base Rate | OT Hrs | Base Rate | OT Hrs | Base Rate | OT Hrs | |
Front Desk | |||||||||
Management | $ 19.61 | $ 20.00 | $ 20.40 | $ 20.81 | |||||
Supervisors | $ 15.69 | 58 | $ 16.00 | 70 | $ 16.32 | 197 | $ 16.65 | 220 | |
Front Desk Agents | $ 12.50 | 143 | $ 12.75 | 171 | $ 13.01 | 571 | $ 13.27 | 737 | |
Total Front Desk | |||||||||
Housekeeping | |||||||||
Management | $ 19.75 | $ 20.15 | $ 20.55 | $ 20.96 | |||||
Floor Supervisors | $ 15.69 | 58 | $ 16.00 | 70 | $ 16.32 | 329 | $ 16.65 | 732 | |
Guest Room Attendants | $ 8.95 | 404 | $ 9.13 | 494 | $ 9.31 | 2,540 | $ 9.50 | 5,233 | |
Public Space Attendants | $ 8.95 | 58 | $ 9.13 | 70 | $ 9.31 | 409 | $ 9.50 | 584 | |
Runners | $ 7.85 | 81 | $ 8.01 | 95 | $ 8.17 | 616 | $ 8.33 | 769 | |
Total Housekeeping | |||||||||
Guest Services | |||||||||
Concierge | $ 14.50 | 41 | $ 14.79 | 49 | $ 15.09 | 59 | $ 15.39 | 61 | |
Bell Service | $ 6.95 | 121 | $ 7.09 | 142 | $ 7.23 | 139 | $ 7.38 | 133 | |
Door Service | $ 9.95 | 117 | $ 10.15 | 140 | $ 10.35 | 158 | $ 10.56 | 166 | |
Transportation Drivers | $ 11.50 | 58 | $ 11.73 | 70 | $ 11.96 | 909 | $ 12.20 | 1,314 | |
Total Guest Service | |||||||||
Year 1 | MHPOR | Year 2 | MHPOR | Year 3 | MHPOR | Year 4 | MHPOR | ||
Payroll Expense | $ | % Room Rev | $ | % Room Rev | $ | % Room Rev | $ | % Room Rev | |
Rooms Division Manager | $ 75,000 | 0.7% | $ 76,500 | 0.7% | $ 78,030 | 0.7% | $ 39,795 | 0.4% | |
Front Desk | |||||||||
Management | $ 80,000 | 0.7% | $ 81,600 | 0.7% | $ 83,232 | 0.7% | $ 84,897 | 0.8% | |
Supervisors | $ 92,982 | 0.8% | $ 94,842 | 0.8% | $ 96,738 | 0.8% | $ 98,673 | 0.9% | |
Front Desk Agents | $ 181,178 | 1.6% | $ 184,801 | 1.6% | $ 188,497 | 1.6% | $ 192,267 | 1.8% | |
Total Front Desk | $ 354,159 | 3.1% | $ 361,243 | 3.1% | $ 368,468 | 3.2% | $ 375,837 | 3.6% | |
Housekeeping | |||||||||
Management | $ 40,290 | 0.4% | $ 41,096 | 0.4% | $ 41,918 | 0.4% | $ 42,756 | 0.4% | |
Floor Supervisors | $ 92,982 | 0.8% | $ 94,842 | 0.8% | $ 96,738 | 0.8% | $ 98,673 | 0.9% | |
Guest Room Attendants | $ 366,830 | 3.2% | $ 374,166 | 3.2% | $ 381,650 | 3.3% | $ 389,283 | 3.7% | |
Public Space Attendants | $ 53,052 | 0.5% | $ 54,113 | 0.5% | $ 55,195 | 0.5% | $ 56,299 | 0.5% | |
Runners | $ 64,349 | 0.6% | $ 65,636 | 0.6% | $ 66,949 | 0.6% | $ 68,288 | 0.7% | |
Total Housekeeping | $ 617,503 | 5.4% | $ 629,853 | 5.5% | $ 642,450 | 5.6% | $ 655,299 | 6.3% | |
Guest Services | |||||||||
Concierge | $ 60,047 | 0.5% | $ 61,248 | 0.5% | $ 62,473 | 0.5% | $ 63,723 | 0.6% | |
Bell Service | $ 85,457 | 0.7% | $ 87,166 | 0.8% | $ 88,909 | 0.8% | $ 90,688 | 0.9% | |
Door Service | $ 117,959 | 1.0% | $ 120,318 | 1.0% | $ 122,725 | 1.1% | $ 125,179 | 1.2% | |
Transportation Drivers | $ 68,167 | 0.6% | $ 69,531 | 0.6% | $ 70,921 | 0.6% | $ 72,340 | 0.7% | |
Total Guest Service | $ 331,631 | 2.9% | $ 338,264 | 2.9% | $ 345,029 | 3.0% | $ 351,930 | 3.4% | |
Total Rooms Department Payroll Expense | $ 1,378,293 | 12.0% | $ 1,405,859 | 12.2% | $ 1,433,976 | 12.4% | $ 1,422,861 | 13.6% | |
Payroll Taxes and Benefits Analysis | % PR | % PR | % PR | % PR | |||||
FICA | $ 105,439 | 7.65% | $ 107,548 | 7.65% | $ 109,699 | 7.65% | $ 108,849 | 7.65% | |
FUTA | $ 27,566 | 2.00% | $ 31,632 | 2.25% | $ 32,981 | 2.30% | $ 32,868 | 2.31% | |
SUTA | $ 27,566 | 2.00% | $ 36,552 | 2.60% | $ 40,151 | 2.80% | $ 42,686 | 3.00% | |
Medicare | $ 19,985 | 1.45% | $ 20,385 | 1.45% | $ 20,793 | 1.45% | $ 20,631 | 1.45% | |
Workers Compensation | $ 113,709 | 8.25% | $ 119,498 | 8.50% | $ 129,058 | 9.00% | $ 135,172 | 9.50% | |
401k Match | $ 27,566 | 2.00% | $ 28,117 | 2.00% | $ 28,680 | 2.00% | $ 28,457 | 2.00% | |
Employee Meals | $ 68,915 | 5.00% | $ 73,105 | 5.20% | $ 78,152 | 5.45% | $ 86,794 | 6.10% | |
Medical Benefit | $ 206,744 | 15.00% | $ 238,996 | 17.00% | $ 272,455 | 19.00% | $ 355,715 | 25.00% | |
Paid Time Off | $ 55,132 | 4.00% | $ 56,234 | 4.00% | $ 57,359 | 4.00% | $ 56,914 | 4.00% | |
Total Taxes and Payroll Benefits | $ 652,622 | 47.4% | $ 712,068 | 50.7% | $ 769,328 | 53.7% | $ 868,087 | 61.0% | |
Total Payroll and Benefit Expense | $ 2,030,915 | 17.7% | $ 2,117,927 | 18.4% | $ 2,203,305 | 19.1% | $ 2,290,948 | 21.9% | |
Hotel Dionysus Unit 267 | |||||||||
Comparative Income Statement – Room Revenue | |||||||||
For the Years Ending December 31 | |||||||||
Year 1 | % | Year 2 | % | Year 3 | % | Year 4 | % | ||
Transient | |||||||||
Revenue | |||||||||
Transient Leisure | 1,066,055 | 9.3% | 1,022,132 | 8.9% | 1,215,269 | 10.5% | 1,118,975 | 10.7% | |
Local Corporate Transient | 1,752,529 | 15.3% | 1,440,277 | 12.5% | 1,556,750 | 13.5% | 1,524,180 | 14.6% | |
National Corporate Transient | 1,775,143 | 15.5% | 1,945,148 | 16.9% | 1,892,205 | 16.4% | 1,650,319 | 15.8% | |
Qualified Discount | 458,727 | 4.0% | 439,826 | 3.8% | 570,474 | 4.9% | 962,997 | 9.2% | |
Total Transient Revenue | $ 5,052,454 | 44.0% | $ 4,847,383 | 42.1% | $ 5,234,698 | 45.3% | $ 5,256,472 | 50.2% | |
Room Nights | |||||||||
Transient Leisure | 6,461 | 8.0% | 6,014 | 7.6% | 6,942 | 9.0% | 6,800 | 9.2% | |
Local Corporate Transient | 11,307 | 14.0% | 9,021 | 11.4% | 9,467 | 12.3% | 9,861 | 13.3% | |
National Corporate Transient | 11,307 | 14.0% | 12,029 | 15.2% | 11,360 | 14.8% | 10,541 | 14.3% | |
Qualified Discount | 3,230 | 4.0% | 3,007 | 3.8% | 3,787 | 4.9% | 6,800 | 9.2% | |
Total Transient Room Nights | 32,305 | 40.0% | 30,072 | 38.0% | 31,557 | 41.0% | 34,002 | 46.0% | |
ADR | |||||||||
Transient Leisure | $ 165.00 | 116% | $ 169.95 | 117% | $ 175.05 | 117% | $ 164.55 | 116% | |
Local Corporate Transient | $ 155.00 | 109% | $ 159.65 | 110% | $ 164.44 | 110% | $ 154.57 | 109% | |
National Corporate Transient | $ 157.00 | 110% | $ 161.71 | 111% | $ 166.56 | 111% | $ 156.57 | 111% | |
Qualified Discount | $ 142.00 | 100% | $ 146.26 | 100% | $ 150.65 | 100% | $ 141.61 | 100% | |
Total Transient ADR | $ 156.40 | 110% | $ 161.20 | 111% | $ 165.88 | 110% | $ 154.59 | 109% | |
Group | |||||||||
Revenue | |||||||||
Local Corporate Group | 1,495,142 | 13.0% | 1,771,919 | 15.4% | 1,338,227 | 11.6% | 1,129,228 | 10.8% | |
National Corporate Group | 1,787,580 | 15.6% | 1,664,530 | 14.4% | 1,571,403 | 13.6% | 1,166,869 | 11.2% | |
Association Group | 2,263,307 | 19.7% | 2,023,210 | 17.6% | 2,546,687 | 22.0% | 1,816,150 | 17.4% | |
SMERF Group | 877,315 | 7.6% | 1,219,940 | 10.6% | 863,765 | 7.5% | 1,092,484 | 10.4% | |
Total Group Revenue | $ 6,423,343 | 56.0% | $ 6,679,599 | 57.9% | $ 6,320,083 | 54.7% | $ 5,204,731 | 49.8% | |
Room Nights | |||||||||
Local Corporate Group | 10,661 | 13.2% | 12,266 | 15.5% | 9,082 | 11.8% | 7,983 | 10.8% | |
National Corporate Group | 13,568 | 16.8% | 12,266 | 15.5% | 11,353 | 14.8% | 8,781 | 11.9% | |
Association Group | 16,960 | 21.0% | 14,719 | 18.6% | 18,164 | 23.6% | 13,970 | 18.9% | |
SMERF Group | 7,269 | 9.0% | 9,813 | 12.4% | 6,812 | 8.9% | 9,181 | 12.4% | |
Total Group Room Nights | 48,457 | 60.0% | 49,064 | 62.0% | 45,411 | 59.0% | 39,915 | 54.0% | |
ADR | |||||||||
Local Corporate Group | $ 140.25 | 99% | $ 144.46 | 99% | $ 147.35 | 98% | $ 141.45 | 100% | |
National Corporate Group | $ 131.75 | 93% | $ 135.70 | 93% | $ 138.42 | 92% | $ 132.88 | 94% | |
Association Group | $ 133.45 | 94% | $ 137.45 | 94% | $ 140.20 | 93% | $ 130.00 | 92% | |
SMERF Group | $ 120.70 | 85% | $ 124.32 | 85% | $ 126.81 | 84% | $ 119.00 | 84% | |
Total Group ADR | $ 132.56 | 93% | $ 136.14 | 93% | $ 139.18 | 93% | $ 130.39 | 92% | |
Total Available Rooms | 108,405 | 108,405 | 108,702 | 108,405 | |||||
Total Occupied Rooms | 80,762 | 79,136 | 76,968 | 73,917 | |||||
Total Occupancy % | 74.5% | 73.0% | 71.0% | 68.0% | |||||
Total Room Revenue | $ 11,475,797 | $ 11,526,982 | $ 11,554,781 | $ 10,461,202 | |||||
Total ADR | $ 142.09 | $ 145.66 | $ 150.13 | $ 141.53 | |||||
Total RevPar | $ 105.86 | $ 106.33 | $ 106.59 | $ 96.24 | |||||