Revenue Forecasting
GNate94
XYZHotelforecastingexercise.1.xlsxCvrMay14
| PROJECTION VARIANCE REPORT - May14 | ||||||||||||||||||||||||||||||
| XYZ Hotel | Rooms: 349 | |||||||||||||||||||||||||||||
| As of March 15, 2014 | Days in May14: 31 | |||||||||||||||||||||||||||||
| Forecast | PrevFcst | Budget | Actual2013 | Forecast - PrevFcst | Forecast - Budget | Forecast - Actual2013 | ||||||||||||||||||||||||
| Rms | Rate | Rev | Rms | Rate | Rev | Rms | Rate | Rev | Rms | Rate | Rev | Rms | Rate | Rev | Rms | Rate | Rev | Rms | Rate | Rev | ||||||||||
| Retail | 0 | 0.00 | 0 | 1,639 | 736.26 | 1,206,728 | 1,648 | 707.18 | 1,165,429 | 1,589 | 686.42 | 1,090,715 | -1,639 | -736 | -1,206,728 | -1,648 | -707.18 | -1,165,429 | -1,589 | -686.42 | -1,090,715 | |||||||||
| TMC | 0 | 0.00 | 0 | 657 | 658.51 | 432,644 | 658 | 600.76 | 395,300 | 622 | 583.27 | 362,792 | -657 | -659 | -432,644 | -658 | -600.76 | -395,300 | -622 | -583.27 | -362,792 | |||||||||
| CorpLRA | 0 | 0.00 | 0 | 1,336 | 422.73 | 564,769 | 1,067 | 475.42 | 507,273 | 1,014 | 466.09 | 472,619 | -1,336 | -423 | -564,769 | -1,067 | -475.42 | -507,273 | -1,014 | -466.09 | -472,619 | |||||||||
| Pkg | 0 | 0.00 | 0 | 341 | 609.84 | 207,954 | 562 | 610.95 | 343,354 | 540 | 598.97 | 323,443 | -341 | -610 | -207,954 | -562 | -610.95 | -343,354 | -540 | -598.97 | -323,443 | |||||||||
| Fit | 0 | 0.00 | 0 | 1,134 | 358.05 | 406,029 | 1,134 | 542.74 | 615,463 | 1,070 | 375.27 | 401,536 | -1,134 | -358 | -406,029 | -1,134 | -542.74 | -615,463 | -1,070 | -375.27 | -401,536 | |||||||||
| Disc | 0 | 0.00 | 0 | 1,012 | 506.54 | 512,616 | 904 | 463.27 | 418,796 | 822 | 454.19 | 373,342 | -1,012 | -507 | -512,616 | -904 | -463.27 | -418,796 | -822 | -454.19 | -373,342 | |||||||||
| OTA | 0 | 0.00 | 0 | 453 | 395.68 | 179,243 | 454 | 431.46 | 195,883 | 439 | 400.31 | 175,737 | -453 | -396 | -179,243 | -454 | -431.46 | -195,883 | -439 | -400.31 | -175,737 | |||||||||
| Ttl Trans | 0 | 0.00 | 0 | 6,572 | 534.08 | 3,509,984 | 6,427 | 566.59 | 3,641,499 | 6,096 | 524.96 | 3,200,185 | -6,572 | -534 | -3,509,984 | -6,427 | -566.59 | -3,641,499 | -6,096 | -524.96 | -3,200,185 | |||||||||
| Gr Corp | 0 | 0.00 | 0 | 2,032 | 387.44 | 787,284 | 1,612 | 356.94 | 575,392 | 1,029 | 362.66 | 373,180 | -2,032 | -387 | -787,284 | -1,612 | -356.94 | -575,392 | -1,029 | -362.66 | -373,180 | |||||||||
| Gr Assn | 0 | 0.00 | 0 | 150 | 373.48 | 56,022 | 60 | 599.00 | 35,940 | 44 | 597.48 | 26,289 | -150 | -373 | -56,022 | -60 | -599.00 | -35,940 | -44 | -597.48 | -26,289 | |||||||||
| Ttl Group | 0 | 0.00 | 0 | 2,182 | 386.48 | 843,306 | 1,672 | 365.63 | 611,332 | 1,073 | 372.29 | 399,469 | -2,182 | -386 | -843,306 | -1,672 | -365.63 | -611,332 | -1,073 | -372.29 | -399,469 | |||||||||
| Total Rooms | 0 | 0.00 | 0 | 8,754 | 497.29 | 4,353,290 | 8,099 | 525.11 | 4,252,831 | 7,169 | 502.11 | 3,599,653 | -8,754 | -497.29 | -4,353,290 | -8,099 | -525.11 | -4,252,831 | -7,169 | -502.11 | -3,599,653 | |||||||||
| Rev % growth or decline | -100.0% | 2.4% | 18.1% | 0.0% | -100.0% | -100.0% | ||||||||||||||||||||||||
| Compared to budget | Compared to budget | Compared to Last Year | ||||||||||||||||||||||||||||
