Menu Mix

The Menu Mix report shows the transaction count, sales value, cost and gross profit for each recipe item sold through the point-of-sale system during the selected time period. The transaction count and sales value for each product comes directly from the imported menu mix file. This report helps managers see which items generate the most revenue and profit.

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 > Menu Mix
Menu Paths: Net-Chef > Reports: Sales > Menu Mix

Transactions Included: POS Depletion

Report Controls

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.

Refresh POS Data: In Connex environments, authorized users may select this button to update the report with the latest Menu Mix data. {Note}: Authorized users have the "NC-Menu Mix Report: Refresh POS Data" User Group control enabled. For information about the repoll process, click HERE.

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.
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 ]
Gross Profit = [ Sales – Cost ]
Recipe Gross Profit % = [ (Gross Profit for this recipe ¸ total Gross Profit for all recipes) x 100 ]
Ideal Cost % - Taken from the recipe record.
Cost % Variance = [ Ideal Cost % - Cost % ]
Discount (hidden by default) – Displays 'Y' or 'N' to indicate whether the item is a Discount Recipe.