Productivity report
The Productivity report shows guestroom and event production by Sales Manager and compares it to last year's figures and this year's goals. Here are some things to keep in mind when you're reviewing the report details:
- 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.
- 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).
You should run the Productivity 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 year-to-date revenue figures against goals.
- 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 To Be Discontinued, click Productivity Report.
As indicated by the page section name of "To Be Discontinued", this report will eventually be removed and permanently replaced by the new version of the Productivity report in the Pace & Productivity section of the Amadeus Reports page. The new report allows you to export to Excel, PDF, or another format, and has been enhanced for better performance. Please try moving to the new report and let us know if you have concerns (or why you prefer this original version of the report instead) by emailing support.
- 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.
Criteria Field Description 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 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 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 Productivity report is run for all Sales Managers (the default setting); however, you can select specific Sales Managers to run it against. 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).
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. 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. Selecting Event in this picklist makes the Show Event Revenue Detail check box available.
Show Event Revenue Detail When this check box is selected, the event revenue for each month in the consumption date range will be broken down into individual parent revenue classifications (Food, Beverage, Resource, Audio Visual, Administrative Charge, Other, Function Room Rental, and any custom parent classifications). Sales Manager Totals When this check box is selected, grand totals are shown for each Sales Manager at each property. This section is displayed at the end of the report and includes grand totals for guestrooms, guestroom revenue, and/or event revenue during the consumption date range. Event Revenue Classifications Select the corporate revenue classifications you want to display in the report when Show Event Revenue Detail is selected. Custom revenue classifications (for example, Golf and Spa) are also included in the list of available choices. All revenue classifications are selected by default. Goal Classification Select one or more goal classifications (for example, 2020 Food & Beverage Goal or 2020 Rooms Goal). A goal comparison will be displayed at the end of the report for each goal classification you select. - 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 selected Sales Manager during the consumption date range. Grand totals are also provided for each Sales Manager at each property.
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 Definite 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
Same Time Last Year Net Definite Total net definite guestrooms, guestroom revenue, and event revenue on the books for the same activity date range last year. Slippage is only included for guestrooms and guestroom revenue. (New Definite) - (Lost/Downgrade) +/- (Reval) +/- Slippage
Year To Date as of <<activity end date>> New Definite New definite guestrooms, guestroom revenue, and event revenue on the books by 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)
Lost/Downgrade 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 An increase or decrease in definite guestrooms, guestroom revenue, and event revenue by the end of 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 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 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 Definite Total definite guestrooms, guestroom revenue, and event revenue on the books by the end of the activity date range. (New Definite) - (Lost/Downgrade) +/- (Reval) +/- Slippage
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 selection. Tentative Total tentative guestrooms, guestroom revenue, and event revenue on the books at the end of the activity date range. Blocked or forecasted guestroom revenue will be used depending on the Guestrooms selection. 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 separately under its associated classification, along with its start and end dates and the types of revenue is applies to.
Goal Total goal amount. For 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 (New Definites) - (Lost/Downgrade) +/- (Reval) +/- (Slippage) Variance to Goal Net Definite - Budget Amount % Variance to Goal Budget / Net Definite