Daily Catering Forecast (rep_ev_forecast.rep with rep_ev_forecast.fmx)

Prerequisite for Daily Catering Forecast

The daily Catering Forecast is a detailed catering report that can print the forecast figures per day, per event type, and divided into the selected revenue types. Each event is listed separately with a summary for each event type. It a great tool for the catering department to project their expected revenues in minute detail at any time for any time into the future.

SELECTION CRITERIA

Property. Select the property for which the report should be printed.

Date Range. This represents the event date range that the report should cover.

Bus-Block ID. It is possible to select a single business block or a range of business blocks for the report.

Note:

When selecting a Master Block ID in the Bus. Block filter, OPERA will also include the Sub Block IDs linked to that Master. The report will then print all Events linked to the Master and its Sub Blocks. If a Sub Block ID is selected, only Events linked to that Sub Block will be printed.

Note:

If no Account is connected to a Business Block, the Business Block Name will print in the Account field on this report. Also, the Agent Name will print if no Company is attached and the Source Name will print if no Company or Agent is attached.

Event Type. Allows you to select the event types that should be included or excluded.

Note:

Alternate Events are excluded from all catering calculations on this report.

Catering Manager. It is possible to only print event for a specific catering manager or a range of catering managers. The report will rely on the catering manager initials that have been selected on the booking catering tab for this filter.

Event Status. Allows you to select the event statuses to include or exclude. Typically, lost or canceled events would not be included in the forecast. Alternatively, it is also possible to select only lost and canceled events to get an idea of the lost revenue from the cancellations over the selected date range.

Event Status Sub-Total 1 and 2. Allows the sub-totaling of different statuses. This could be used to get a sub-total for production statuses as one and another sub-total for return-to-inventory statuses as the other. This would allow you to print the report as forecast and lost/canceled overview without having to print it twice. Or it could be used to group non- deduct statuses into one sub-total and deduct inventory statuses into the other sub-total.

Event Type for Average Check. Allows you to select event types to include in the average check calculation. If the average check is used for Food and Beverage purposes, this would typically only be event types that include food and beverage servings, such as Lunch or Dinner, and not event types like Setup that generates only function space revenue if at all.

Revenue Type 1-4. Up to four revenue types or groupings of revenue types can be included for printing on the report at any one time. These are represented as separate revenue columns on the report body and described in the report footer. The check box in front of each revenue type determines whether the revenue of this type (if checked) should be included in the average check calculation. Again, average checks could be based solely on Food and Beverage revenue types and events, or alternatively could be calculated for any catering revenue that gets generated.

Events - All/Catering Only/Rooms with Catering. These options allow you to decide, based on the type of block, which events will be included in the results.

Print Exclude from Forecast Event - Both/Yes/No. Select this option to either include or exclude certain events. When Both is selected, the report prints all qualifying events. When Yes is selected, the report prints only events that have had the Exclude from Forecast Reports flag checked. When No is selected, the report prints only events that have NOT been marked as Exclude from Forecast Reports.

REPORT DATA

The report is sorted in date order starting with first date selected in the date range filter. Within each date, the events are grouped by event type. For each event, the report displays the following columns: Account name, booking ID, booking status, catering owner initials, rooms owner initials, number of covers, revenues in four columns as selected per type on the filter form, total revenue, total average check revenue (this only show the revenue of those event types and revenue types that have been selected for calculation of the average check on the filter form), and the average check value. This is calculated by dividing the average check revenue by number of covers of those event types that have been selected for average check calculation.

Revenues are calculated in the following sequence by revenue type by event. If billed revenue exists, show billed revenue. If no billed revenue exists, show actual revenue. If no actual revenue exists, show guaranteed revenue. If no guaranteed revenue exists, show expected revenue. If no expected revenue exists, show forecasted revenue. If no forecasted revenue exists, show zero.

For each day, revenues are subtotaled per event type. As a summary for each day, the sub- totals for selected statuses are printed (if so selected on the filter form) followed by a total for the day.