Guestroom and Catering Pace report
Using the Guestroom and Catering Pace report, you can measure your current pace relative to budget and compare your definite guestroom and event production to last year's actuals. Here are some things to keep in mind when you're reviewing the report details:
- To display inline budget data in the Pace report, an administrator must first create monthly property budgets and select the Monthly check box on the Sales Goal page. This tells the report to display the following columns: Budget, Variance (to budget), % (variance to budget), Actual Last Year, and Tentative STLY (same time last year). If this check box is not selected, all budget information will be displayed at the end of the report.
- Guestroom information is based on pickup figures when the entire booking is marked pickup complete (not its individual room blocks). Otherwise, either forecast or blocked numbers are used (depending on which option is selected in the Guestrooms criteria field).
- The report uses the most current event revenue available: forecast revenue before the event is marked done and actual revenue after it is marked done. The event revenue budgets that are displayed pertain to the total definite revenue for the month—you won't see a comparison against individual revenue classifications.
- This report pertains to property budgets only, not sales goals for individual Sales Managers.
You should run the Guestroom and Catering Pace report monthly to do the following:
- See changes in guestroom and event revenue due to new definite business, lost/downgraded business, revaluations, and slippage.
- Assess production toward your budget.
- Compare current figures with Same Time Last Year (STLY) figures.
- Assess the available pipeline based on the number of prospect and tentative bookings.
To run the report
- Navigate to Amadeus Reports.
- Under Pace and Productivity, click Guestroom and Catering Pace Report.
- Complete the report criteria.
Some of the criteria fields allow you to select multiple values. To do so, press the CTRL key while clicking each value you want to include in the report.
Beginning/Ending Activity Date Any bookings that were created or modified during the activity date range will be included in the report. Activity date range is typically last month. Beginning/Ending Consumption Date Any roomnights or events that are in house during this date range will be included in the report. Consumption date range is typically the first day of last month through the end of booking time. Consumption refers to the actual dates that revenue is generated, regardless of the booking's arrival and departure dates. For example, if a booking is in house December 29 – January 2, and you run the report using a consumption date range of December 1 – December 31, only those guestrooms and events on Dec. 29, Dec. 30, and Dec. 31 will be included.
Here are a few examples of how you might set the activity and consumption date ranges for the Pace report:
- To see activity that took place in the month for the month, set both date ranges the same.
- To see activity that took place last month for groups that will be in house anytime in the future, set the activity date range to last month and the consumption date range to the end of booking time.
Properties By default, all properties will be included in the report. If needed, select only those properties you want to report on. Sales Managers Booking changes made by these Sales Manager during the activity date range will be included in the report. Typically, the Pace report is run for all Sales Managers (the default setting); however, you can select specific Sales Managers to run it against. Sales Manager Role Activity from Sales Managers in this booking role will be included in the report: Booked By (default), Catering Manager, or Service Manager. Revenue Types By default, all bookings that meet your search criteria will be included in the report. If needed, select to include only those bookings classified as Banquet, Catering, and/or In-House. Include Guestroom/Event Revenue By default, both Guestroom and Event Revenue will be included in the report. If needed, select to run the report for one type of revenue only. Guestrooms Select to report on Blocked or Forecasted guestroom values when pickup figures are not available. Guestroom information is based on pickup figures when the entire booking is marked pickup complete (not its individual room blocks).
Show Event Revenue Detail When selected, the event revenue for each month in the consumption date range will be broken down into the individual parent revenue classifications and displayed on the report. This includes Food, Beverage, Resource, Audio Visual, Administrative Charge, Other, Function Room Rental, and any other active parent revenue classifications. This allows you the ability to view all revenue streams in more detail.
Budget Classification Not applicable if you use monthly budgets.
To compare the property's production to budget values, select one or more budget classifications. A budget comparison will be displayed at the end of the report for each budget classification you select.
Budget details are only displayed when the consumption date range of the sales goal associated to the budget classification falls entirely within the report's consumption date range.
Event Revenue Classifications Not applicable if you use monthly budgets.
Select the corporate revenue classifications you want to display in the report when the Show Event Revenue Detail check box is selected. Custom revenue classifications (for example, Golf and Spa) are also included in the list of available choices. Child revenue classifications are not displayed; the revenues for these will roll up to the parent.
- Click Generate Report to view the report on-screen or Generate PDF to view the report as a PDF file that you can save or print.
- Review the report data.
The following information is displayed for each month in the consumption date range:
Activity for <<activity date range>> New Definite Guestrooms, guestroom revenue, and event revenue that turned definite during the activity date range. Lost/Downgrade The decrease in definite guestrooms, guestroom revenue, and event revenue from bookings whose status changed to Lost, Cancelled, or Turned Down during the activity date range. Reval An increase or decrease in definite guestrooms, guestroom revenue, and event revenue during the activity date range. For example, a welcome dinner is added to a booking during the activity date range, resulting in a positive reval. Or, the expected attendance for an event drops by 10% during the activity date range, resulting in a negative reval. Slippage Slippage applies to guestrooms and guestroom revenue only. The following calculations use blocked or forecasted numbers based on your Guestrooms report criteria: (Final picked up guestrooms) - (Blocked or forecasted guestrooms)
(Final picked up guestroom revenue) - (Blocked or forecasted guestroom revenue)
Slippage is only calculated for bookings that have been marked pickup complete during the activity date range. If any room block on the booking has not been marked pickup complete during that period, the booking is not included.
Net Change The final change in guestrooms, guestroom revenue, and event revenue during the activity date range. Slippage is only included for guestrooms and guestroom revenue. (New Definite) - (Lost/Downgrade) +/- (Reval) +/- Slippage
Definite On the Books as of <<activity end date>> Definite Definite guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range. - Guestrooms: (Definite guestrooms at start of activity date range) +/- (Net Change)
- Guestroom/Event Revenue: (Definite revenue at start of activity date range) +/- (Net Change)
Budget Monthly budget goal for definite guestrooms, definite guestroom revenue, and definite event revenue. - Guestroom Revenue = Definite Roomnights x Definite Average Rate
- Event Revenue = Definite Event Revenue
Variance (to Budget) Definite - Budget % (Variance to Budget) Definite / Budget Actual Last Year Actual guestrooms, guestroom revenue, and event revenue consumed for the same activity date range last year. STLY (Same Time Last Year) Definite guestrooms, guestroom revenue, and event revenue on the books for the same activity date range last year. Pace Variance to STLY Revenue Definite - STLY Variance to STLY % Definite / STLY Tentative STLY Tentative guestrooms, guestroom revenue, and event revenue on the books for the same activity date range last year. On the Books as of <<activity end date>> Prospect Total prospect guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range. Blocked or forecasted values will be used depending on the Guestrooms report criteria. Tentative Total tentative guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range. Blocked or forecasted values will be used depending on the Guestrooms report criteria. Explore more...