|
|
|
Post Conference Report (REP_INDIVIDUAL_POSTCON.REP with REP_INDIVIDUAL_POSTCON.FMX)
The Post Convention report only displays when the OPS <version number> Sales & Catering license code is active. This report is an ideal recap after any group or catering booking as it compares room nights and revenue as well as catering revenue as it was originally booked versus the actual materialization of the booking. For room nights and room revenue multiple figures can be printed, utilizing the block grid snapshot functionality.
The report can be printed for selected group bookings or using a list of filter criteria to define which bookings should be included. In any case, the report will print a separate sheet for each booking. No summary of multiple bookings is available with this report.
Note: This report requires that the user be granted the BLOCK PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.
Departure Date Range. Will include all group booking that have departed within the selected date range. For this report is makes more sense to filter by departure date than arrival date, as it is a post-booking report and only makes sense to print after booking actualization.
Stay Date Range. Bookings that have at least one date within the defined stay date range filter will be included in this report. Please note that still all booking figures will print, not only the dates that fall within the stay date pattern.
For example, if the report is ordered to be printed for a stay date range of 01/01/2004 to 01/31/2004 and a booking is in-house from the 01/29/2004 to the 02/03/2004, this booking will be printed with all its figures for January and February – not just the January figures.
Property. Available when OPS_MHT2 license is active. Choose the property for which the report should be printed.
Account Name. Filter this report by selecting one or more specific account names.
Grid Type Original Block. The LOV will show a list of available block grid snapshot types to choose from. Block snapshots either need to be configured for auto-activation in the configuration option or manually created for each booking from the block grid header right click option ‘Snapshots’. Typically the INITIAL snapshot would be selected for this filter field. The figures will appear in the report section headed ‘Original Block’. If a snapshot is selected in this filter that has not been created, or if this field is left blank, the section ‘Original Block’ will stay empty. Please note that if no snapshot is selected, the ‘real’ original block grid is NOT automatically printed on the report.
Grid Type Final Block. The LOV will show a list of available block grid snapshot types to choose from. Block snapshots either need to be configured for auto-activation in the configuration option or manually created for each booking from the block grid header right click option ‘Snapshots’. Typically the CURRENT snapshot would be selected for this filter field. The figures will appear in the report section headed ‘Final Block (Current)’. If a snapshot is selected in this filter that has not been created, or if this field is left blank, the section ‘Final Block’ will stay empty. Please note that if no snapshot is selected, the ‘real’ current block grid is NOT automatically printed on the report.
Business Block ID. Select one or more specific block identifications to display in the results.
Business Block Status. Select one or more specific block statuses to display in the results of the report.
Room Sales Manager. Filter this report by selecting one or more specific room sales managers.
Catering Sales Manager. Filter this report by selecting one or more specific catering sales managers.
Revenue Type 1- 4. Select one or more catering revenue types to print in the catering section of the report. The four fields can be used to print single revenue types, or a combination of several revenues types as required.
Note: When the application parameter Use Forecast Value Only is set to Y and an Event has an F&B Minimum Rate Code attached, forecasted revenue will not be reported or recorded for the Revenue Types that are configured to contribute to the F&B Minimum. If the Rate Code is changed to one that does not require a minimum and expected revenue has not been added to those revenue types, the forecasted revenue for revenue types configured to contribute to the F&B Minimum will be reported.
Event Type. Select one or more event types for which covers should be counted for. Please note this filter does not have any influence on the revenue that will print on the report (always catering revenue of all events), but only on the number of total covers reported. Event that are lost or cancelled (return-to-inventory status) are not calculated into this report in any case.
Currency. Select the currency in which the revenues on this report will display.
This landscape format report is divided into five distinct sections.
The first block of data contains booking details including the booking name, internal booking ID, internal account ID, the block code, rooms owner, catering owner, booking arrival and departure dates and booking status. Master/Sub-Allocations will be indicated as such under the Business Block ID.
The following section prints the primary address, telephone, fax, email and website information for the primary company, company contact, travel agent, travel agent contact, source and source contact. At the far right of this section the Status change history is displayed with the status turned and date the status was changed will print.
The third section contains the group room information. A separate row is printed for each date the booking was in-house with a summary row at the bottom. The information that is printed across is as follows:
Original Block room nights, average rate and revenue. This information is taken from the snapshot that has been selected in the ‘Grid Type Original Block’ Filter. The revenue and average rate shown are as entered on the booking without calculating out inclusive taxes and packages if any exists.
Note: For a Master Allocation the 'Original Block' figures are the selected Snapshot for the Master Allocation only and do not include Sub-Allocations.
Contract Block room nights, average rate and revenue. This information is taken from the contract grid of the room block (created / updated through right click on block grid header – option ‘Contract’). The revenue and average rate shown are as entered on the booking without calculating out inclusive taxes and packages if any exists.
Note: For a Master Allocation the 'Contract Block' figures are the contract numbers for the Master Allocation only and do not include Sub-Allocations.
Final Block (Current) room nights, average rate and revenue. This information is taken from the snapshot that has been selected in the ‘Grid Type Final Block’ Filter. The revenue and average rate shown are as entered on the booking without calculating out inclusive taxes and packages if any exists.
Note: For a Master Allocation the 'Final Block' figures are the selected Snapshot for the Master Allocation only and do not include Sub-Allocations.
Picked-up room nights, average rate and revenue. This information is taken from the picked–up reservations of the block in an integrated S&C and PMS OPERA system. The revenue and average rate shown are NET of any inclusive taxes or packages in this area. Please note that in an S&C stand-alone environment the pick-up grid will print as it has been entered into the pickup grid page on the block grid (right click on the block grid header). In this case the revenue and average rate are as entered on the booking without calculating out inclusive taxes and packages if any exists.
Contract vs. Pick-up wash calculates the variance between the room nights and revenue as entered into the contract grid and the picked-up information as explained in the previous paragraph. The variance is expressed as a percentage value.
The fourth section of the report deals with catering data. Again, a separate row is printed for each date for which catering events are attached to this booking. This section will sum the catering revenues for all of the Sub-Allocations linked to a Master.
The original booking covers, average check and revenue are taken from the FORECASTED catering revenue figures.
The final booking covers, average check and revenue are taken from the EXPECTED/GUARANTEED catering revenue figures.
The picked-up covers, average check, revenue breakdown by selected catering revenue types (as defined on the filter) and revenue total is taken from the BILLED/ACTUAL catering revenue figures.
The last section of the report shows the variance of original to pick-up in percent for number of room nights and room revenue, for each of the selected catering revenue types (Rev. Type 1 - 4 as selected on the report FMX) and total catering revenue. The following line shows the variance of final to pick-up in percent for the same booking elements.
RevPor represents the revenue per occupied room and is calculated by taking the total picked-up revenue (rooms and catering) divided by number of picked-up room nights.
F&B RevPar represents the F&B revenue per occupied room only.
Note: All revenue types linked to the revenue group F&B (hard-coded) are considered in the above F&B RevPor calculation, irrespectively if the revenue type is marked as F&B or not.
