Home Uncategorized Rev Management
Uncategorized

Rev Management

Two separate files: word for questions to answers, excel for analysis

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
  • Which months can you identify as high season and why?
  • Which months can you identify as low season and why?
  • What is the group and transient mix during the low season months?
  • What is the highest producing segment overall?
  • Based on this performance, what do you think the strategy of this hotel was for this year?
  • Looking at the Day of week (DOW) tab, does this hotel have higher demand on weekends or weekdays?
  • Which segment or segments would you use to increase occupancy during weekdays?
  • Which segment or segments would you use to increase ADR on weekends?

YrSum2

0

1

4

Hotel

80

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

80

Par

0

0 0 0 0 0 0 0 0 0 0 0 0

,475

53.92

4.40

2.85

7.76

.56

2.23

.31

.54

.75

109

.65

1,134

615 444

.32

1,195

359

444 851

Trans

6,782

805 125 450

.22

0 0 0 11

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 0.00 0

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

0 16 38 4 43 0 60 67 21

75 0

0.00

0.00

0.00

99

0 0 0 0 29 70 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 0.00 0

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

1,340

833

1,088

614 937 473

491.33

714.82

1,340 1,426 833 1,583 2,254 1,088 865 192 471 923

491.33 586.48 449.82 451.30 388.58 412.99 423.75

291.32

0 0.00 0

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

312

360

0

0 0 0 0 0 0 0 0 0 0 0 0

61,010,776

Paid Occ

77.0%

9,772 10,819

10,819 10,470 10,819 10,819

10,819 10,470 10,819

XYZ
Forecast 2014 Ttl Occ 80 89 86 84 75 73 83 56 63 77
Paid Occ Rev
74.4% 479.06 Actualized Days
Rooms ADR Revenue Transient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
21 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
11 1064.97 1042.64 1032.46 736.26 595.25 70 67 594.04 745.23 717.

99 125
11,332 805 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 60 586.18 12

16
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 5

29 833
4,356 760.82 3,314,141 Pkg 3

38 253 429 427 341 448 450 464 322 465 310
1050.12 1149.16 1111.28 937 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 925 987 2,367 415 768
758.56 723.01 575.42 652.80 358.05 342.57 385.21 335.02 312 418.96 627.11 809.34
11,766 569.24 6,697,656 Disc 664 683 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 378 454 272 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 6,782 6,094 8,455 7,042 6,572 6,476 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 57

 0.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 371 862 473
491.33 587.07 434.27 451.28 387.44 360 413.35 289.33 290.78 330.77 409.70 714.82
161 373.18 60,081 Gr Assn 150
369.00 373.48
Gr Gov
567 513.18 290,973 SMERF 243
535.25 775.06 685.00 539.68 563.30 353.18 303.00 520.83 488.32
929.00 91,971 Gr TnT
322.10 1180.43
Gr Othr
12,076 451.29 5,44

9,772 Total Definite 1,426 1,583 2,254 865 192 471
586.48 449.82 451.30 388.58 412.99 423.75 311.61 291.32 405.99 415.99
12,941 444.05 5,746,432 Ttl

Group 1,329 637
304.97 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
Base
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 419 287 260 278 148 206 361 343
OOO Rms
98,478 619.54 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
75.1% 77.0% 85.8% 82.4% 81.6% 72.2% 70.7% 80.0% 54.8% 61.6% 74.2%
Available 10,819 10,470 10,440

DOWSum 2014

Total Transient
Rms Rate Rev

Rms Rate Rev

70.7%

Total 94,718

74.4% 81,777 664.25 54,320,530

Group

Rms Rate Rev % of Occ

Sun

Mon 1,763

Tue

Wed

Thu

Fri

Sat

Total 12,941 444.05 5,746,432
XYZ Hotel
Occ% % 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 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%
634.17 60,066,962
Day Of Week
Full Year
Summary
1,276 435.23 555,358 9.9%
410.08 722,973 13.6%
2,293 417.79 957,984 17.7%
2,413 417.04 1,006,313 18.6%
2,160 462.38 998,742 16.7%
1,538 491.46 755,870 11.9%
1,498 500.13 749,191 11.6%

Hire a Writer
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Order Now Order Now

Order your essay today and save 30% with the discount code ESSAYHELP

Order Now