Monthly Catering Forecast (rep_month_forecast.rep with rep_month_forecast.fmx)
Prerequisites for Event Reports
This report is another option to use for forecasting event revenues. Where the Daily Event Forecast report breaks down the revenue into daily sub-totals, this report only prints the total revenue per event type per status type, followed by a breakdown of revenues into the selected revenue types by status type for each calendar month that falls within the selected date range.
SELECTION CRITERIA
Property. Select the property for the report.
Date Range. This represents the event date range that the report should cover.
Account. Select specific accounts to run in this forecast.
Event Type. Select event types to include or exclude.
Note:
Alternate Events are excluded from all catering calculations on this report.
Average Check. The revenue of the event types selected here are the basis for calculation of the average check.
Catering Manager. It is possible to only print the events for a specific catering manager or a range of catering managers. The report relies on the catering manager initials selected on the booking catering tab for this filter.
Event Status 1 – 4. You can summarize revenues for up to four events status codes. It is possible to combine several statuses into one total by selecting them into the same line.
Revenue Types 1 –4. You can include up to four revenue types or groupings of revenue types to print on the report at any one time. These are represented as separate revenue columns on the report body. The check box in front of each revenue type determines whether the revenue of this type/these types (if checked) should be included in the average check calculation. 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 DATE
The report is sorted in calendar month order starting with the first month covered by the selected date range. The first summary area of the report lists the event types that have been used during that month in rows. The total revenue associated with these event types in that month is shown next, divided into the selected status types. This is followed by a column that shows the total Food and Beverage Revenue per event type across all status types. This is calculated from the revenue types flagged as Food and Beverage revenue type in revenue type configuration. The number of covers per event type is printed next, followed by the Average Check, which in this part of the report is calculated by dividing the Food and Beverage revenue by the number of covers (irrespective of the revenue types selected for the average check on the report order form).
The second summary section for each month lists the status types beneath each other. The revenue associated with each status is printed next, divided into the revenue types selected on the report order form. Two revenue totals are printed in the next two columns; the first one being the total of all revenue types flagged for average check calculation, followed by a total of all other revenue, irrespective of the selected revenue types. The covers for each status type follow. The last column is again the average check column, but in this case the calculation is based on the total of selected revenue types divided by the number of covers.
The grand total summary of the report repeats the pattern of the second summary per month. Statuses are listed per row, with two lines per status – dividing the bookings into Sales Only and Sales and Catering revenues. Sales Only includes only those bookings for which the Catering Only flag is off, whereas the Sales and Catering rows include the revenues for all bookings irrespective of the setting of the Catering Only flag. The revenues are broken down in up to four selected revenue types. The total revenue per status row is shown in two columns, one summarizing the revenue of the revenue types selected for average rate calculation, the second column summarizing the rest revenues. Total number of covers per status row print next, followed by the average check, which is calculated by dividing the Total (Sel.) column by the number of covers.
All revenues are calculated downwards cascading, meaning, if actual revenue exists, actual revenue will print. If no actual revenue exists, guaranteed revenue is checked and printed. If no guaranteed revenue exists, expected revenue is checked and printed. If expected revenue also does not exist, the forecasted revenue is printed. The same is valid for covers.
![The report image shows total revenue per event for all statuses and for all 4 revenue types, with total covers and average check amount, all for the month of June. The report image shows total revenue per event for all statuses and for all 4 revenue types, with total covers and average check amount, all for the month of June.](img/rpt_monthly_catering_forecast.png)
Parent topic: Event Reports