Menu Cost Report (rep_menu_cost.rep with rep_menu_cost.fmx)

Prerequisites for Menu Cost Report

The Menu Cost report (Miscellaneous>Reports) shows booked menus per day with revenue versus cost information.

SELECTION CRITERIA

Property. Select the property for the report you are printing.

To/From Date Range. Select a To and From date range. Only events scheduled within this time frame are included in the report.

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

Note:

When selecting a Master Block ID in the Bus. Block filter, OPERA Cloud includes the Sub Block IDs linked to that Master. The report then prints 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 print.

Event Status. Select one, multiple, or all event statuses to appear in the report.

Menu Class. Select one, multiple, or all menu classes to appear in the report.

Menu. Select one, multiple, or all menus to appear in the report.

Print Menu Details. When selected, this option allows the menu details to appear in the report.

Print Package Menus. When selected, this option allows package menus to appear in the report. For Package Menus however, cost is calculated from the event, and revenue is 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 prints 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.