Rev Management

profileGNate94
XYZHotelYearSummary2.xlsx
Home>Business & Finance homework help>Accounting homework help>Rev Management

YrSum2014

XYZ Hotel
Forecast 2014 Ttl Occ 80 80 89 86 84 75 73 83 56 63 80 77
Paid Occ RevPar 0
74.4% 479.06 Actualized Days 0 0 0 0 0 0 0 0 0 0 0 0
Rooms ADR Revenue Transient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
21,475 895.28 19,226,064 Retail 1,736 1,861 2,653 1,730 1,639 1,565 1,535 1,694 1,198 1,573 1,763 2,528
1153.92 1064.97 1042.64 1032.46 736.26 595.25 704.40 672.85 594.04 745.23 717.99 1257.76
11,332 805.56 9,128,557 TMC 1,070 984 1,359 1,079 657 725 754 902 570 933 1,252 1,047
1024.08 1074.63 955.71 868.79 658.51 583.87 570.91 647.31 525.57 602.23 586.18 1216.31
13,900 469.98 6,532,744 CorpLRA 1,109 906 1,134 1,125 1,336 1,584 1,750 1,250 1,235 771 1,085 615
522.96 516.68 581.04 570.10 422.73 369.78 379.78 377.13 356.00 481.07 529.54 833.75
4,356 760.82 3,314,141 Pkg 338 253 429 427 341 448 450 464 322 465 310 109
1050.12 1149.16 1111.28 937.65 609.84 608.78 763.49 550.15 505.78 621.16 626.75 603.96
9,976 476.83 4,756,808 Fit 923 319 444 635 1,134 925 987 2,367 615 444 415 768
758.56 723.01 575.42 652.80 358.05 342.57 385.21 335.02 312.32 418.96 627.11 809.34
11,766 569.24 6,697,656 Disc 664 683 1,195 1,195 1,012 870 928 978 1,030 1,111 1,056 1,044
683.38 626.21 615.44 633.08 506.54 455.27 482.39 445.59 401.95 472.66 514.85 1005.02
8,614 504.67 4,347,203 OTA 942 1,088 1,241 851 453 359 378 454 272 444 851 1,281
425.37 381.63 514.22 503.46 395.68 712.49 383.63 330.60 388.37 376.92 449.24 842.53
81,777 664.25 54,320,530 Total Trans 6,782 6,094 8,455 7,042 6,572 6,476 6,782 8,109 5,242 5,741 6,732 7,392
824.02 799.43 807.77 761.83 534.08 491.37 515.01 489.48 444.09 570.00 587.46 1052.73
5,588,482 4,871,735 6,829,657 5,364,822 3,509,984 3,182,083 3,492,783 4,140,997 2,331,053 3,272,364 3,954,785 7,781,785
11,249 445.08 5,006,747 Gr Corp 1,340 1,410 795 1,568 2,032 1,018 805 125 450 371 862 473
491.33 587.07 434.27 451.28 387.44 360.22 413.35 289.33 290.78 330.77 409.70 714.82
161 373.18 60,081 Gr Assn 0 0 0 11 150 0 0 0 0 0 0 0
0.00 0.00 0.00 369.00 373.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0.00 0 Gr Gov 0 0 0 0 0 0 0 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
567 513.18 290,973 SMERF 0 16 38 4 43 0 60 67 21 243 75 0
0.00 535.25 775.06 685.00 539.68 0.00 563.30 353.18 303.00 520.83 488.32 0.00
99 929.00 91,971 Gr TnT 0 0 0 0 29 70 0 0 0 0 0 0
0.00 0.00 0.00 0.00 322.10 1180.43 0.00 0.00 0.00 0.00 0.00 0.00
0 0.00 0 Gr Othr 0 0 0 0 0 0 0 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
12,076 451.29 5,449,772 Total Definite 1,340 1,426 833 1,583 2,254 1,088 865 192 471 614 937 473
491.33 586.48 449.82 451.30 388.58 412.99 423.75 311.61 291.32 405.99 415.99 714.82
12,941 444.05 5,746,432 Ttl Group 1,340 1,426 833 1,583 2,254 1,088 865 192 471 923 1,329 637
491.33 586.48 449.82 451.30 388.58 412.99 423.75 304.97 291.32 385.78 396.83 614.82
658,388 836,327 374,700 714,403 875,854 449,338 366,547 58,555 137,214 356,079 527,386 391,640
0 0.00 0 Base 0 0 0 0 0 0 0 0 0 0 0 0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
943,814 Extra Revenue 105,633 120,560 139,338 78,181 59,366 66,619 92,024 18,049 32,035 83,314 90,344 58,350
94,718 644.13 61,010,776 Ttl Paid Rms 8,122 7,520 9,288 8,625 8,826 7,564 7,647 8,652 5,720 6,664 8,061 8,029
782.14 775.08 790.66 713.90 503.65 488.90 516.72 487.47 437.12 556.99 567.24 1025.26
3,760 Comp Rms 480 306 312 419 287 260 278 360 148 206 361 343
0 OOO Rms 0 0 0 0 0 0 0 0 0 0 0 0
98,478 619.54 61,010,776 Total Rms 8,602 7,826 9,600 9,044 9,113 7,824 7,925 9,012 5,868 6,870 8,422 8,372
Ttl Rate 738.49 744.78 764.97 680.83 487.79 472.65 498.59 468.00 426.09 540.29 542.93 983.25
Ttl Rev 6,352,503 5,828,622 7,343,696 6,157,406 4,445,204 3,698,039 3,951,354 4,217,601 2,500,302 3,711,758 4,572,516 8,231,775
Paid Occ 75.1% 77.0% 85.8% 82.4% 81.6% 72.2% 70.7% 80.0% 54.8% 61.6% 77.0% 74.2%
Available 10,819 9,772 10,819 10,470 10,819 10,470 10,819 10,819 10,440 10,819 10,470 10,819

DOWSum 2014

XYZ Hotel
Total Transient
Rms Rate Rev Occ% Rms Rate Rev % of Occ
Sun 12,602 611.62 7,707,606 69.5% 11,326 631.49 7,152,248 13.8%
Mon 11,788 584.97 6,895,620 65.0% 10,025 615.73 6,172,647 12.3%
Tue 12,177 586.53 7,142,151 67.1% 9,884 625.67 6,184,166 12.1%
Wed 13,067 619.82 8,099,182 70.7% 10,654 665.75 7,092,869 13.0%
Thu 14,016 645.62 9,049,012 77.2% 11,856 679.00 8,050,270 14.5%
Fri 15,282 680.91 10,405,679 84.2% 13,744 702.11 9,649,809 16.8%
Sat 15,786 682.11 10,767,712 87.0% 14,288 701.18 10,018,521 17.5%
Total 94,718 634.17 60,066,962 74.4% 81,777 664.25 54,320,530
Day Of Week
Full Year Group
Summary Rms Rate Rev % of Occ
Sun 1,276 435.23 555,358 9.9%
Mon 1,763 410.08 722,973 13.6%
Tue 2,293 417.79 957,984 17.7%
Wed 2,413 417.04 1,006,313 18.6%
Thu 2,160 462.38 998,742 16.7%
Fri 1,538 491.46 755,870 11.9%
Sat 1,498 500.13 749,191 11.6%
Total 12,941 444.05 5,746,432