|
|
|
Daily Forecast (REP_DAILY_FORECAST.REP with REP_DAILY_FORECAST.FMX)
The Daily Forecast report will print room nights, room revenue and catering revenue on a daily basis per booking. Catering revenue can be split out into up to 5 catering revenue type groups. Each day will have a status summary line per status and one total daily summary across all statuses.
This report incorporates the new option to print catering revenues as net or gross, depending on the application parameter Catering>Catering Revenue Price Type and the setting of the VAT (tax) percentages on the catering revenue types.
Additionally an option exists on the filter form to include or exclude events from the report if they have the flag Exclude from Forecast Reports checked. These last two points make the report the most concise revenue forecast report that OPERA S&C currently has on offer.
Note: When printing this Report help topic, we recommend printing with Landscape page orientation.
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.
Property. Only available when OPS_MHT2 license is active. Single select LOV to choose the property for which the report should be printed.
Stay Date Range. The stay date range of the bookings you wish to review on this report (e.g., stay dates between 12/01/2006 and 12/31/2006).
Block Status. Use this option to select bookings by their current status.
Revenue Types 1-5. Use this option to select which catering revenue types should be used to calculate the catering revenue figures from and in which order these revenue types should print on the report.
Note: Each revenue type field is multi-select and will allow for multiple selections of revenue types per field. When revenue types are combined, for instance FOOD and BEVERAGE, the revenue type values are likewise subtotaled. As well, the filters for Revenue Types are mutually exclusive. Once one is selected, it is not available for selection in another Revenue Type column.
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.
Market Segment. Use this filter to select bookings in a particular market segment, for example, nationwide or corporate local.
Overall Owner/Primary Owner Only. Use this filter to select bookings by their overall owner. Depending on the flag ‘Primary Owner Only’, only bookings where the selected initials are the primary booking owner will be selected. If not checked, bookings where the initials are primary or secondary owner will be chosen.
Rooms Owner/Primary Owner Only. Use this filter to select bookings by their rooms owner. Depending on the flag ‘Primary Owner Only’, only bookings where the selected initials are the primary rooms owner will be selected. If not checked, bookings where the initials are primary or secondary rooms owner will be chosen.
Catering Owner/Primary Owner Only. Use this filter to select bookings by their catering owner. Depending on the flag ‘Primary Owner Only’, only bookings where the selected initials are the primary catering owner will be selected. If not checked, bookings where the initials are primary or secondary catering owner will be chosen.
Event Revenue Net/Gross. When application setting Catering>Catering Revenue Price Type = NET and the radio button Net is selected, catering revenue figures will print as booked. If radio button Gross is selected, catering revenue figures will print with the VAT (Tax) percentage configured for each catering revenue type added to the booked revenue.
When application setting Catering>Catering Revenue Price Type = GROSS, and the radio button Gross is selected, catering revenue figures will print as booked. If radio button Net is selected, catering revenue figures will print with the VAT (Tax) percentage configured for each catering revenue type taken out from the booked revenue.
Room Revenue Net/Gross. If the radio button Net is selected, room revenue figures will print net of any generates or packages that might be configured with the rate or are added to the booking. If the radio button Gross is selected, room revenue figures will print inclusive of room generates.
Print Exclude from Forecast Events - Both/Yes/No. Will allow to include or exclude (or print exclusively) event revenue from events that have the flag ‘Exclude from Forecast Reports’ on the Event Details Tab checked.
Catering Only/Rooms Only/Both. Allows selection of bookings that have the ‘Catering Only’ flag checked, bookings that do NOT have the ‘Catering Only’ flag checked, or both types of bookings.
Copies. Determines the number of copies that will print, when the Print button is selected.
Currency. Select the currency type in which to display revenue values on this report.
Preview. Use the preview option to view the generated output of this report in PDF format.
Print. Use the Print button to print the report to the selected output.
File. Prints the generated report output to an *.rtf file.
Close. Closes this report screen.
The report will first group by event date and then by event status. Within each event status grouping, business blocks with event revenue in that status are listed. Business blocks that have revenue in various statuses (i.e. catering revenue on different status than room revenue, or events of different statuses) will be listed multiple times on the report – once under each status with the appropriate revenue for that status. Business blocks that span multiple days will print for each day they contribute revenue.
Booking details shown are: Booking Name, Booking Property, Booking Id, Overall Owner, Rooms Owner, Catering Owner, Market Segment, Catering Revenue Types 1- 5 (as selected in filter), Total Catering Revenue, Room Nights, Room Revenue, Total Revenue
Catering Revenue will print as per the regular principle; if an event is actual, the Actual/Billed revenue will print. If no Actual/Billed revenue exist (and when event is not yet actual), the Guaranteed/Expected revenues will be checked. If Guaranteed Revenue is higher than Expected Revenue, Guaranteed Revenue will print. Otherwise Expected Revenue will print. If Expected / Guaranteed Revenues do not exist, Forecast Revenues will print.
An exception to the above rule will be made when the application parameter Catering>Use Forecast Value Only is active. In this case all events will be created with the flag ‘Use Forecast Revenue Only’ checked. While this flag is checked all catering revenue in this report will only come from the forecast figures, even if expected or guaranteed figures do exist. The flag will be unchecked automatically when the event turns actual, but can also manually be unchecked earlier in the life of the event.
All revenues will be reported NET or GROSS depending on the appropriate filter selections. Please see filter section for details on calculation.
A summary per status line will print at the end of each day, as well as a total line that adds together the figures across all statuses.
At the very end of the report a status summary will print across the full date range that the report has been ordered for.
