Guestroom and Catering Pace report
The content of this page is specific to the Delphi product type. If you are using the Delphi Core product type, click here to access the Delphi Core-specific online help.
Use the Guestroom and Catering Pace report to measure your current pace relative to budget and compare your definite guestroom and event production to last year's actuals.
Additional information:
- To display inline budget data in the Pace report, an administrator needs to create monthly property budgets and select the Monthly checkbox 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 checkbox is not selected, all budget information displays at the end of the report.
- Guestroom information is based on picked up figures when the entire booking is marked pickup complete, not the individual room blocks. Otherwise, either forecasted or blocked numbers are used. This depends on which option is selected in the Guestrooms criteria field.
- The report uses the most current event revenue available. Forecasted revenue is used before the event is marked done and actual revenue is used after it is marked done. The event revenue budgets that display refer to the total definite revenue for the month.
- This report is for property budgets only, not sales goals for individual sales managers.
You can run the Guestroom and Catering Pace report monthly to:
- See changes in guestroom and event revenue due to new definite business, lost or downgraded business, revaluations, and slippage.
- Assess production toward your budget.
- Compare current figures with STLY figures.
To run the report
- Navigate to Amadeus Reports.
- Under Pace and Productivity, click Guestroom and Catering Pace Report.
- Complete the report criteria.
You can select multiple values for some criteria fields. To do so, press the CTRL key while selecting each value you want to include.
Field Description Beginning and Ending Activity Date Any bookings that were created or modified during the activity date range are included in the report. The most common activity date range is last month. Beginning and Ending Consumption Date Any in-house roomnights or events during this date range are included in the report. The most common consumption date range is 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–31, only the guestrooms and events during December 29-31 are included.
Here are two examples of how to 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 to the same value.
To see activity that took place last month for future groups, set the activity date range to last month and the consumption date range to the end of booking time.
Properties Select the properties to include in the report. By default, all properties are included. Sales Managers Select the sales managers to include in the report. By default, all sales managers are included. This displays all booking changes made by these users. Sales Manager Role Select the role to include in the report. By default, Booked By is selected. This displays all activities from sales managers in this booking role. Revenue Types Select the revenue type to include in the report. By default, all are included. Include Guestroom and Event Revenue Select the type of revenue to include in the report. By default, both Guestroom and Event Revenue are included. Guestroom Select to report on Blocked or Forecasted guestroom values when picked up figures are not available. Guestroom information is based on picked up figures when the entire booking is marked pickup complete, not the individual room blocks.
Show Event Revenue Detail When selected, the event revenue for each month in the consumption date range is sorted by the individual parent revenue classifications. Budget Classification Select one or more budget classifications to compare the property's production to budget values. A budget comparison displays at the end of the report for each budget classification you select. This is not applicable if you use monthly budgets.
Budget details only display when the consumption date range of the associated sales goal is within the report's consumption date range.Event Revenue Classifications Select the corporate revenue classifications to display in the report when the Show Event Revenue Detail checkbox is selected. Child revenue classifications do not display as their revenue rolls up to the parent. This is not applicable if you use monthly budgets.
- 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 displays for each month in the consumption date range.
Field Description Activity for <<activity date range>> New Definite This is the number of guestrooms, guestroom revenue, and event revenue that turned definite during the activity date range. Lost / Downgrade This is the decrease in definite guestrooms, guestroom revenue, and event revenue from bookings whose status changed to Lost, Cancelled, or Turned Down. Reval This is an increase or decrease in definite guestrooms, guestroom revenue, and event revenue. For example, an event is added to a booking during the activity date range, resulting in a positive reval. If the expected attendance for an event drops during the activity date range, a negative reval displays. Slippage This is used for bookings that remained definite and were marked pickup complete during the activity period. Slippage applies to guestrooms and guestroom revenue only. The following formulas are used to calculate these fields, and are based on your Guestroom report criteria:
(Final picked up guestrooms) - (Blocked or forecasted guestrooms)
(Final picked up guestroom revenue) - (Blocked or forecasted guestroom revenue)
If any room block on the booking has not been marked pickup complete during the activity date range, the booking is not included.
Net Change This is the final change in guestrooms, guestroom revenue, and event revenue during the activity date range. The following formula is used to calculate this field: (New Definite) - (Lost / Downgrade) +/- (Reval) +/- Slippage
Definites On the Books as of <<activity end date>> Definite This is the number of definite guestrooms, guestroom revenue, and event revenue at the end of the activity date range. The following formulas are used to calculate these fields: - Guestrooms = (Definite guestrooms at the start of the activity date range) +/- (Net Change)
- Guestroom/Event Revenue = (Definite revenue at the start of the activity date range) +/- (Net Change)
Budget This is the monthly budget goal for definite guestrooms, definite guestroom revenue, and definite event revenue. The following formulas are used to calculate these fields: - Guestroom Revenue = Definite Roomnights x Definite Average Rate
- Event Revenue = Definite Event Revenue
Variance (to Budget) This is the variance between the Definite value and the Budget value. % (Variance to Budget) This is the variance percentage between the Definite value and the Budget value. Actual Last Year This is the number of actual guestrooms, guestroom revenue, and event revenue consumed for the same activity date range last year. STLY 'STLY' stands for 'Same Time Last Year.' This is the number of definite guestrooms, guestroom revenue, and event revenue compared to the same activity date range for last year. Pace Variance to STLY Revenue This is the variance between the Definite value and the STLY value. Variance to STLY % This is the variance percentage between the Definite value and the STLY value. Tentative STLY This is the number of tentative guestrooms, guestroom revenue, and event revenue compared to the same activity date range for last year. On the Books as of <<activity end date>> Prospect Total prospect guestrooms, guestroom revenue, and event revenue at the end of the activity date range. Blocked or forecasted values are used depending on the Guestroom report criteria. Tentative Total tentative guestrooms, guestroom revenue, and event revenue at the end of the activity date range. Blocked or forecasted values are used depending on the Guestroom report criteria.