|
|
|
Monthly Catering Forecast (REP_MONTH_FORECAST.REP with REP_MONTH_FORECAST.FMX)
This 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 will only print 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.
Note: This report requires that the user be granted the EVENT 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. Available when OPS_MHT2 license is active. Choose the property for which the report should be printed.
Date Range. This represents the event date range that the report should cover.
Account. Select one or more specific account for which to run this forecast.
Event Type. Select one or more event types that should be included or excluded.
Note: Alternate Events are excluded from all catering calculations on this report.
Average Check. The revenue of the event types selected here will be taken as basis for calculation of the average check.
Catering Manager. It is possible to only print events 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 1 – 4. Select up to four events status codes to summarize the revenues for. It is possible to combine several statuses into one total by selecting them into the same line.
Revenue Types 1 –4. Up to 4 revenue types or groupings of revenue types can be included to print on the report at any one time. These will be represented as separate revenue columns on the report body. The check box in front of each revenue type determines if the revenue of this type/these types (if checked) should be included in the average check calculation. Average checks could be based solely on F&B revenue types and events, or alternatively could be calculated for any catering revenue that gets generated.
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.
Note: Currency values in this report can be represented by an abbreviation when the application setting General>Currency Divisor Value is configured. For example, if values recorded in this report are too long to accurately display in the allotted space, such as 354,000, the currency divisor value set to K for 1000 can change that display to 354K so that all values over 1000 will display shortened and without decimals. The divisor value can also be set to M, which will shorten all amounts over 1 million by 5 digits and print them without decimals.
Events - All/Catering Only/Rooms with Catering. These options allow you to decided which types of events to view 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 all qualifying events will print. When Yes is selected, only events that have had the Exclude from Forecast Reports flag checked will print (the Exclude from Forecast Reports flag is accessible on the Events Screen Details tab). When No is selected only events that have NOT been marked as Exclude from Forecast Reports will print.
The report is sorted in calendar month order starting with the first month that is covered by the selected date range.
The first summary area of the report will list the event types that have been used during that months in rows. The total revenue that is 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 F&B Revenue per event type across all status types. This is calculated from those revenue types that are flagged as F&B 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 F&B revenue by the number of covers (irrespectively of the revenue types that have been selected for the average check on the report order form).
The second summary section for each month lists the status types underneath each other. The revenue that is associated with each status is printed next, divided into the revenue types that have been 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 that were flagged to be used for average check calculation, followed by a total of all other revenue, irrespectively 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 into the 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 that have been 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.
