Consolidated Menu Mix

The Consolidated Menu Mix report provides sales information about items sold through the POS system at the locations within the selected hierarchy. The initial retrieval shows each product sold, with the sales data consolidated across all applicable locations. Each recipe name is a link to the report details for that recipe.

The Check and Server Summary button will be available when the retrieved data set includes at least one 'Server' or 'Check Number' value. When a user clicks the button, a pop-up window will open containing the summarized data.

Menu Paths: Net-Chef > Sales: Reports > Consolidated Menu Mix
Menu Paths: Net-Chef > Reports: Sales > Consolidated Menu Mix

Transactions Included: POS Depletion

Report Controls

Hierarchy: Select the desired hierarchy level from the drop-down

Post Date: Drop-down; can select post period End Dates.

Date Range Start/Finish: Calendar widgets; can select any dates.

Group By: Category, Subcategory, Microcategory, Daypart, Customer, Revenue Center, Server, Check Number
When a user selects a primary "Group By" option other than 'N/A' or 'Check Number', the secondary "Group By" drop-down will be enabled with a list of options relevant based on the selected primary option.

Funnel (Filters): Any report column; Category, Subcategory, Microcategory, User Defined Category, Time (Start/End), PLU, Daypart, Customer, Revenue Center, Server, Check Number

Printer (Export): PDF, Excel, CSV formats

-><- , <-->: Click to minimize/maximize the report header

Report Columns:

Click any column header to sort by the data in that column; defaults to Gross Profit $ (desc).

Product Number – The company recipe number.
PLU – The POS item number for this recipe.
Recipe Name – The company recipe name; “Drill Down” link; see below for details.
Transactions – Number of transactions in which the product was sold.
% of Recipe Transactions = [ (Transactions for this recipe ¸ total Transactions for all recipes) x 100 ]
Sales – Total value of the item’s sales.
Recipe Sales % = [ (Sales for this recipe ¸ total Sales for all recipes) x 100 ]
Cost – Sum of the costs of the recipe components.
Cost % = [ (Cost ¸ Sales) x 100 ]
Ideal Cost % – Taken from the recipe record.
Cost % Variance = [ Ideal Cost % - Cost % ]
Gross Profit = [ Sales – Cost ]
Recipe Gross Profit % = [ (Gross Profit for this recipe ¸ total Gross Profit for all recipes) x 100 ]
Discount (hidden by default) – Displays 'Y' or 'N' to indicate whether the item is a Discount Recipe.

“Drill Down” Links:

Recipe Name – Opens a report with totals by location for the selected recipe.