Meal Type Forecast by Day (BI) (REP_MEAL_TYPE_FORECAST_BI.REP with REP_MEAL_TYPE_FORECAST_BI.FMX)

The Meal Type Forecast (BI) report is an easy to read forecast report for banquet operations. It is broken down by Catering Covers, Status, and Event Date.

Prerequisites

• This report can only be configured in a property with an active OPERA Sales and Catering or SFA license.
• This report is only available when the application parameter Catering > CATERING MEALTYPES or application function Blocks > CENTRAL DIARY is active.
• This report requires that the user be granted the Event > EVENT PRINT permission in the selected property to run the report.
• This report is a BI Publisher report. We do not recommend customizing it.
  • Report Name = Meal Type Forecast by Day
  • File Name = rep_meal_type_forecast_bi.rtf
  • Form to run = rep_meal_type_forecast_bi.fmx
  • Data Template = rep_meal_type_forecast_bi.odt

Selection Criteria

Event Dates

From. (Mandatory) Enter the calendar date to indicate the beginning of the Event period for which the report is to be filtered.

To. (Mandatory). Select the end date of the Event period when the report is filtered.

Property. Available when the OPS_MHT2 license is active. Choose the property for which the events in this report should be filtered.

Origin. Select Origins. This LOV lists all of the possible values from the internal field allotment_origion. When an Origin is selected, only events from business blocks with this Origin will be considered. If no Origin is selected, all business blocks will be considered. Possible options are:

ORS (business blocks created in the ORS application)

SFA (business blocks created in the SFA application)

PMS (business blocks created in the PMS application)

SC (business blocks created in the S&C application)

EXT (business blocks created in an External system)

Event

Definite. (Mandatory) Select one Status Code from a list of all status codes that can turn to an ACTUAL status. This selection will be used to filter by event status.

Incl Actual. (Enabled when a Status is selected in the Definite field) Select this check box to include events in an ACTUAL status in the Definite totals.

Status. (On the Books) Select Status Codes from the list of all status codes (does not include the status selected in the Definite LOV) that will represent the other status code groupings listed in the report. This selection is used to filter by event status.

Summary Statuses. (Mandatory) Select Status Codes from the list of all status codes to represent the status codes added together for the summary grouping at the beginning of the report (this filter is not dependent on the values selected in any of the other status fields).

Meal Type 1. (Mandatory) Select one Meal Type to be represented in the 1st Meal Type Column.

Meal Type 2 - 5. Select Meal Types to be represented in the 2nd – 5th Meal Type Columns. If no value is selected in a field, then no figures will be calculated for that column in the report.

Revenue (One of the options must be selected)

Net. When selected, Catering Revenue will be calculated as:

• Net Catering Price is calculated based on the Transaction Codes mapped in Revenue Type Cross Reference configuration (Configuration > Cashiering > Rev Type Cross Reference):
  • Included generates are deducted
  • Excluded generates are not added

Gross. When selected, Catering Revenue will be calculated as:

• Gross Catering Price is calculated based on the Transaction Codes mapped in Revenue Type Cross Reference configuration (Configuration > Cashiering > Rev Type Cross Reference):
  • Included generates are not deducted
  • Excluded generates are added

Currency. Select the currency you want used for calculating the report. All revenue figures will be reported in the selected currency. If no value is selected, the report will be calculated using the Base Currency of the logged in Property.

Meal Type Revenue. (Mandatory) Select the listed Active Revenue Types to be used in the Revenue calculation in the Meal Type Revenue columns.

Revenue Type 1 - 4. Select the listed Active Revenue Types to be used in the calculation for the Rev Type Columns 1-4 at the end of the report. If no value is selected in a field, then no figures will be calculated for that column in the report.

Owner. (Select Owners. If no value is selected, then all Owners listed in the LOV will be considered.)

Overall. Only Events from business blocks with this Overall Owner will be considered.

Rooms. Only Events from business blocks with this Rooms Owner will be considered.

Catering. Only Events from business blocks with this Catering Owner will be considered.

Exclude from Forecast. (1 of the 3 options must be selected)

Both. All events will be considered regardless of the Exclude from Forecast check box.

Yes. Only events marked as Exclude from Forecast will be considered.

No. Only events not marked as Exclude from Forecast will be considered.

Block Type (1 of the 3 options must be selected)

All. Select if events from all business blocks will be considered.

Catering. Select if only events from business blocks marked as Catering Only will be considered.

Rooms. Select if only events from business blocks not marked as Catering Only will be considered.

Report Data

The 1st grouping is a summary of the status codes selected in the Summary Statuses filter in the report parameter screen. The Status Codes are listed in this header in descending sequence.

The 2nd grouping is the figures for the status code selected in the Definite filter in the report parameter screen. If the Incl Actual check box is selected, then the ACTUAL status will be included with this total.

The 3rd and further groupings are for the figures for the status codes selected in the Status filter. If more than one status code is selected, then there will be more than one grouping. Each status code in this filter gets its own grouping / page. The status codes are listed in descending sequence order.

Year. The Year is displayed in the column header.

Date. Each date (with day of week) in the selected date range will print, regardless if there is data to report.

Meal Type 1 – 5. The current figures for the event types linked to this Meal Type.

Covers. Current number of attendees for the meal type in the column header. If the event is in an ACTUAL status, then the Actual Attendees are reported. If the event is not in an ACTUAL status and Guaranteed Attendees are populated, then the Guaranteed Attendees are reported. If the event is not in an ACTUAL status and Guaranteed Attendees are not populated, then the Attendees are reported.

Avg (Check) = (Revenue / Covers).

Revenue. Catering revenue for the event types linked to the meal type. Calculated using the revenue types selected in the Meal Type Revenue field in the report parameter screen. The Revenue reported is the “On the Books” figure.

If the application parameter Catering > USE FORECAST VALUE ONLY is set to N, Revenues are calculated in the following sequence by Revenue Type by event. If the event is in an ACTUAL status, billed revenue is reported for all Revenue Types. If the event is not in an ACTUAL status and Guaranteed revenue has been added, then the Guaranteed revenue is reported for that Revenue Type. If the event is not in an ACTUAL status, Guaranteed revenue has not been added and Expected revenue has been added, then the Expected revenue is reported for that Revenue Type. If the event is not in an ACTUAL status, Guaranteed revenue has not been added and Expected revenue has not been added, then the Forecasted revenue is reported for that Revenue Type.

If the application parameter Catering > USE FORECAST VALUE ONLY is set to Y, the Revenue calculation considers the Use Forecast Revenue Only check box in the Event Details Tab. If the event is in an ACTUAL status, billed revenue is reported for the event. If the event is not in an ACTUAL status and the Use Forecast Revenue Only check box is selected, the Forecast revenue is reported for the event. If the event is not in an ACTUAL status, the Use Forecast Revenue Only check box is NOT selected and Guaranteed revenue exists, then the Guaranteed revenue is reported for this event. If the event is not in an ACTUAL status, the Use Forecast Revenue Only check box is NOT selected and Guaranteed revenue does not exist, then the Expected revenue is reported for this event.

Totals by Revenue Type

Rev Type 1 – 4. Catering revenue totals for each date and qualifying Event. Calculated using the revenue types selected in the report parameter screen. The figures in these columns are not filtered by Meal Type. If no value is selected in one of the fields, then no calculation will be done for that column in the report.

At the bottom of the 1st grouping there are additional rows that are included in the 1st grouping.

• Budget (Meal Type columns) – These fields include the Budgeted Covers, Revenue, and Avg Check for each Meal Type / Month and are filtered by the Revenue Types and Block Type filter (Catering Only Y/N) selected in the report parameter screen. The Budget figures are taken from the OBI Budget Forecast module.
• Budget (Revenue Type columns) These fields include the Budgeted Covers, Revenue, and Avg Check for each Revenue Type / Month and are filtered by the Revenue Types and Block Type filter (Catering Only Y/N) selected in the report parameter screen. The Budget figures are taken from the OBI Budget Forecast module.
• Last Year. Calculation of the On the Books figures for this Meal Type as of the end of the Same Month last year. If the Date Range selected in the report parameter screen is 12/10/13 – 12/31/13, the figures in Last Year will be the figures for 12/1/12 – 12/31/12. This section includes Covers, Avg Check, and Revenue.
• Variance. (Meal Type Totals – Budget)
• Var to STLY. (Meal Type Totals – Last Year)

The Final Section is the Covers Summary by Meal Type and Day.

• Date. Each date in the date range selected in the report parameter prints, regardless if there is data to report.
• Meal Type 1 – 5. The current Covers for the event types linked to this Meal Type, filtered by the Summary Statuses selected in the report parameter screen.
• Total Covers. – Total Covers for the Date.

  Note: When currency values are too long to fully display in the allotted space in the report columns, (i.e. for values in the thousands with four digits or more and for values in the millions with seven digits or more, these values can be abbreviated so they can be accurately viewed. The application setting General > Currency Divisor Value can be configured to set the currency divisor value to K for values over 1,000 and to M for values over 1,000,000. For example, if the record is 354,000, when the currency divisor value is set to K, the value will display as 354K. If the record is 5,750,000.00, and the currency divisor value is set to M, the value will be rounded up and displayed, as in this example to 6M.