Menu Cost Report (REP_MENU_COST.REP with REP_MENU_COST.FMX)

The Menu Cost report (Miscellaneous>Reports) is used to show booked menus per day with revenue versus cost information.

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.

Selection Criteria

Property. Available when OPS_MHT2 license is active. Choose the property for which the report should be printed.

To/From Date Range. Select a To and From date range; only events scheduled within this time frame will be included in the report.

Business Block.  Select a business block to run this report, or select multiple business blocks at once.

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.

Event Status. Select one, multiple or all event statuses to display on this report.

Menu Class. Select one, multiple or all menu classes to display on this report.

Menu. Select one, multiple or all menus to display on this report.

Print Menu Details. When selected, this option allows the menu details to display on this report.

Print Package Menus. When selected, this option allows package menus to display on this report. For Package Menus however, cost will be calculated from the event and revenue will be calculated from the revenue split in the menu configuration.

Note: A (P) denotes a package menu when they are included in this report.

Report Data

The report will print information about booked menus for the events that fall into the selection criteria defined on the report order form.  The information is grouped and summarized by date and within each date by menu class. The report shows the menu name, menu item name, event id, included in menu flag, quantity, price per person, total menu price, cost per person, total cost per event and the variance between total menu/menu item revenue and total menu/menu item cost for each menu and menu item listed Subtotals are listed at the bottom of the following columns in each table; Quantity, Price, Total Menu, Cost, Total Cost and Variance.