Productivity 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.
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.
- This report is only available with version R31 or higher.
- The data in the report can be delayed by up to 15 minutes. If the data does not match what you expect to see, run the report again.
- This report only provides booking totals. To see a list of the individual bookings, run the Productivity Verification report using the same criteria.
You can run the Productivity report monthly to:
- See changes in guestroom and event revenue due to new definite business, lost business, revaluations, and slippage.
- Assess revenue figures against a sales manager's goals.
- Compare current figures with previous years' figures.
To run the report
- Navigate to Amadeus Reports.
- Under Pace and Productivity, click Productivity Report.
- Complete the report criteria.
Field Description
Beginning and Ending Activity Date Any bookings that were created or modified during the activity date range are included in the report. 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.
Compare To Select to display data from last year, or up to 5 years ago. By default, last year is selected. Properties Select which properties to include in the report. By default, all properties you have access to are included. Include Select which type of information you want to include in the report: Guestroom Revenue, Event Revenue, Goal Comparison, or Sales Manager Total. By default, all types are selected. Guestroom Select to report on Agreed, Blocked, Forecasted, or Picked Up guestroom values. If you select Agreed, Blocked, or Forecasted, guestroom information is based on picked up figures when the entire booking is marked pickup complete
If you select Picked Up, guestroom information is always based on picked up figures whether marked complete or not.
Revenue Classifications Select the corporate revenue classifications to display Select which users to include in the report. By default, booking changes made by all users are included. User Role Select which user role to include in the report. By default, Booked by is selected. 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. Booking Market Segments Select the booking market segments to include in the report. By default, all are selected. Booking Types Select the booking types to include in the report. By default, all are selected. Revenue Types Select which revenue type to include in the report. By default, only bookings classified as Banquet are included. 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. - Click View Report.
The following information displays for each selected property, year, and Sales Manager, and is grouped into the following time periods:
- Report Activity - These values are the totals for the report's activity date range.
- Same Time - These values are the totals for the same consumption date range and activity date range as the previous year, two years, or three years ago.
- Year To Date - These values are the totals for the specified consumption date range, using an activity date range from the start of this year to the report's ending activity date.
Field Description
Report Activity New Definite This is the number of guestrooms, guestroom revenue, and event revenue that turned definite during the activity date range. Lost 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) +/- (Reval) +/- (Slippage)
On the Books Prospect This is the total number of prospect guestrooms, guestroom revenue, and event revenue at the end of the activity date range. Tentative This is the total number of tentative guestrooms, guestroom revenue, and event revenue at the end of the activity date range. 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) +/- (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.
Next steps
- To export the report data, click Export (
) and select a format. - To scroll through a multipage report, use First Page (
), Previous Page (
), Next Page (
), and Last Page (
). - To change the report zoom, use the Zoom drop-down list.
- To print the report as a PDF, click Print (
). - To use the search field, enter the first few characters of the word you want to find and press Enter or click Find. Click Find Next to view the next instance that matches your search criteria.