Consolidated Menu Mix by Reporting Calendar

The Consolidated Menu Mix by Reporting Calendar 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.

Note: This report does NOT include check-level detail, to allow users to successfully retrieve the report for longer periods of time by using pre-calculated and summarized data for Reporting Calendar date ranges. Note that the on-screen title is simply "Consolidated Menu Mix".

Menu Paths: Net-Chef > Sales: Reports > Consolidated Menu Mix by Reporting Calendar
Menu Paths: Net-Chef > Reports: Sales > Consolidated Menu Mix by Reporting Calendar

Transactions Included: POS Depletion

Report Controls

Date Range Start/Finish: Drop-downs; can select Reporting Calendar dates.

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

Group By: Category, Subcategory, Microcategory, Daypart, Customer, Revenue Center
When a user selects a primary "Group By" option other than 'N/A', 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, PLU, Daypart, Customer, Revenue Center

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.