Productivity report
The content of this page is specific to the Delphi product type only. If you are using the Delphi Core product type and want to learn more about the Delphi product type, contact your sales representative.
The Productivity report displays guestroom and event production by sales manager and compares it to last year's figures and this year's goals.
Additional information:
- The report uses the most current event revenue available. It uses forecasted revenue before the event is marked done and actual revenue after it is marked done.
- 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 depending on which option is selected in the Guestroom criteria field.
You can run the Productivity report monthly to:
- See changes in guestroom and event revenue due to new definite business, lost or downgraded business, revaluations, and slippage.
- Assess year-to-date revenue figures against goals.
- Compare current figures with Same Time Last Year (STLY) figures.
To run the report
- Navigate to Amadeus Reports.
-
Under To Be Discontinued, click Productivity Report.
This report is due to be replaced by the new version of the report in the Pace & Productivity section of the Amadeus Reports page. With the new report, you can export to Excel, PDF, or another format. The new report has also been enhanced for better performance. Start using the new report and email support if you have concerns, or to tell us why you prefer this original version.
- 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 roomnights or events that are in-house 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 those guestrooms and events on December 29-31 are included.
Here are two examples of how to set the activity and consumption date ranges for the Productivity 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 future groups, set the activity date range to last month and the consumption date range to the end of booking time.
Properties Select which properties to include in the report. By default, all properties you have access to are included. Sales Managers Select which sales managers to include in the report. By default, booking changes made by all sales managers are included. Guestroom Select to report on Blocked or Forecasted guestroom values when picked up figures are not available. When picked up figures are available, those values are used whether the booking is marked complete or not.
Sales Manager Role Select which sales manager role to include in the report. By default, Booked by is selected. Include Guestroom/Event Revenue Select which type of information you want to include in the report. By default, both Guestroom and Event Revenue are selected. 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. This includes Food, Beverage, Resource, Audio Visual, Administrative Charge, Other, Function Room Rental, and any other custom parent classifications. This checkbox becomes available when Event Revenue is selected in the Include Guestroom/Event Revenue section.
Sales Manager Totals When selected, grand totals are shown for each Sales Manager at each property. This section displays at the end of the report and includes grand totals for guestrooms, guestroom revenue, and event revenue during the consumption date range. Goal Classifications Select which goal classifications to include in the report. A goal comparison displays at the end of the report for each selected goal classification. Event Revenue Classifications Select the corporate revenue classifications to display when Show Event Revenue Detail is selected. By default, all revenue classifications are selected. - 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 selected Sales Manager during the consumption date range. Grand totals also display for each Sales Manager at each property.
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 Definite This is the final change in guestrooms, guestroom revenue, and event revenue during the activity date range. Slippage is only included for guestrooms and guestroom revenue. The following formula is used to calculate this field: (New Definite) - (Lost / Downgrade) +/- (Reval) +/- Slippage
Same Time Last Year Net Definite This is the total net definite guestrooms, guestroom revenue, and event revenue for the same activity date range last year. Slippage is only included for guestrooms and guestroom revenue. The following formula is used to calculate this field: (New Definite) - (Lost / Downgrade) +/- (Reval) +/- Slippage
Year To Date as of <<activity end date>> New Definite This is the number of new 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)
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 by the end activity date range. Reval This is an increase or decrease in definite guestrooms, guestroom revenue, and event revenue by the end of the activity date range. 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 an increase or decrease in definite guestrooms and guestroom revenue, due to pickup, by the end of the activity date range. The following calculations use blocked or forecasted numbers based on your Guestroom 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 Definite This is the total number of definite guestrooms, guestroom revenue, and event revenue by the end of the activity date range. The following formula is used to calculate this field: (New Definite) - (Lost / Downgrade) +/- (Reval) +/- (Slippage)
On the Books as of <<activity end date>> Prospect This is the total number of 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 selection. Tentative This is the total number of 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 selection. Goal Classification This section compares guestroom and event production to the sales manager's goals. This data is only available if you selected at least one goal classification in the report criteria. Each user goal is listed under its associated classification, along with its start and end dates and the type of revenue it applies to.
Goal This is the total goal amount. The following formula is used to calculate each sales goal: - Guestroom Revenue Budget = Definite Roomnights x Definite Average Rate
- Event Revenue Budget = Definite Event Revenue
User goals are specified using the Sales Goals section of the Property page.
Net Definite The following formula is used to calculate this field: (New Definites) - (Lost / Downgrade) +/- (Reval) +/- (Slippage) Variance to Goal This is the variance between the Net Definite value and the Budget amount. % Variance to Goal This is the variance percentage between the Net Definite value and the Budget amount.