What and where is the Menu Cost & Profit report?
- Jenn Ferreris
This article provides details of the Menu Cost & Profit Report.
Overview
The Menu Cost & Profit Report helps users understand their menu item’s profitability. Clients with hierarchy data will have the capability to view modifiers added or removed to menu items. This data can be used to see potential modifiers added or removed to menu items, such as combo, number of units sold per item, plate cost %, and other cost-related data.
Decision Logic currently supports the Qu Point of Sale system.
Users will need View permissions for the Menu Cost & Profit page within Purchasing in Profile Maintenance.
Run Report
Begin by navigating to:
Reports > Purchasing > Menu Cost & Profit
Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date or Date Range.
By default, Enforce Weeks will be toggled on to select a date range.
Un-toggle Enforce Weeks to select a single date.
The green dot under a date represents the beginning of an Inventory Week Start.
The orange triangle represents the Period Start.
Select a Sales View option from the dropdown.
Click Apply.
Below is an example report.
The report is broken down by Menu Category followed by Menu Item. Users can sort a column by selecting the arrow next to a column. Available columns are:
Description - how the POS describes the item.
Sold - how many unit items were sold.
Average Price - obtained from the POS.
Average Revenue - average revenue of the item which includes upsells.
Average Base Cost - average cost for the menu item only. Excludes additions or removals.
Sales - total revenue excluding taxes.
Average Cost - average cost for the menu item which takes in account upsells and removals.
Profit - total revenue minus total cost.
Base Plate Cost % - average base cost / average price.
Total Plate Cost % - average cost / average revenue.
Clicking View provides a slide out with more details which includes modifications to the menu item.
Print or Export Report
Begin by navigating to:
Reports > Purchasing > Menu Cost & Profit
Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date or Date Range.
By default, Enforce Weeks will be toggled on to select a date range.
Un-toggle Enforce Weeks to select a single date.
The green dot under a date represents the beginning of an Inventory Week Start.
The orange triangle represents the Period Start.
Select a Sales View option from the dropdown.
Click Apply.
Click Print or Export.
2024 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
Unable to access this feature in the Decision Logic platform?
Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile or add new features.
Some features are client-specific.
If you'd like to receive news on software releases and product updates, please sign up for our email list.