Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How is the hotel forecasted to perform compared to the previous year? Summaries Group Weekday Transient Weekday Total Hotel Weekday Rms ADR(G) Revenue(G) Rms ADR(G)
How is the hotel forecasted to perform compared to the previous year?
| Summaries | Group Weekday | Transient Weekday | Total Hotel Weekday | ||||||||
| Rms | ADR(G) | Revenue(G) | Rms | ADR(G) | Revenue(G) | Rms | ADR(G) | Revenue(G) | |||
| Forecast | 1,794 | $215.90 | $387,320 | 6,371 | 250.38 | $1,595,141 | 8,165 | 242.80 | $1,982,461 | ||
| Last Year | 2,358 | $232.43 | $548,059 | 6,266 | 277.67 | $1,739,869 | 8,624 | 265.30 | $2,287,928 | ||
| Variance to LY | (564) | -$16.53 | ($160,740) | 105 | -$27.29 | -$144,728 | (459) | -$22.50 | ($305,467) | ||
| Budget | 1,684 | $240.00 | $404,160 | 6,348 | 293.65 | $1,864,108 | 8,032 | 282.40 | 2,268,268 | ||
| Variance to Budget | 110 | -$24.10 | ($16,840) | 23 | -$43.28 | -$268,967 | 133 | -$39.60 | ($285,807) | ||
| Group Weekend | Transient Weekend | Total Hotel Weekend | |||||||||
| Rms | ADR(G) | Revenue(G) | Rms | ADR(G) | Revenue(G) | Rms | ADR(G) | Revenue(G) | |||
| Forecast | 605 | 241.73 | $146,247 | 2,254 | 232.89 | $524,944 | 2,859 | 234.76 | $671,192 | ||
| Last Year | 926 | 205.94 | $190,703 | 2,024 | 199.66 | $404,108 | 2,950 | 201.63 | $594,812 | ||
| Variance to LY | (321) | $35.79 | -$44,456 | 230 | $33.24 | $120,836 | (91) | $33.13 | $76,380 | ||
| Budget | 662 | 189.00 | $125,118 | 1,748 | 203.34 | $355,430 | 2,410 | 199.40 | $480,548 | ||
| Variance to Budget | (57) | $52.73 | $21,129 | 506 | $29.56 | $169,514 | 449 | $35.37 | $190,644 | ||
| Group Monthly Total | Transient Monthly Total | Total Hotel for the Month | |||||||||
| Rms | ADR(N) | Revenue(N) | Rms | ADR(N) | Revenue(N) | Rms | ADR(N) | Revenue(N) | |||
| Forecast | 2,399 | 222.41 | $533,567 | 8,625 | 245.81 | 2,120,085 | 11,024 | 240.72 | $2,653,653 | ||
| Last Year | 3,284 | 224.06 | $735,807 | 8,290 | 259.26 | 2,149,266 | 11,574 | 249.07 | $2,882,740 | ||
| Variance to LY | (885) | -$1.65 | -$202,239 | 335 | -$13.45 | -29,181 | (550) | -$8.35 | -$229,087 | ||
| Budget | 2,346 | 223.53 | $524,401 | 8,096 | 274.15 | 2,219,538 | 10,442 | 263.25 | $2,748,816 | ||
| Variance to Budget | 53 | -$1.12 | $9,167 | 529 | -$28.35 | -99,452 | 582 | -$22.53 | -$95,163 | ||
Step by Step Solution
★★★★★
3.37 Rating (129 Votes )
There are 3 Steps involved in it
Step: 1
The hotel is forecasted to perform worse compared to the previous year in terms ...
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advanced Accounting
Authors: Gail Fayerman
1st Canadian Edition
9781118774113, 1118774116, 111803791X, 978-1118037911
