Overview
The Menu Engineering Report is a classic popularity vs profitability report and allows you to see your recipes concerning both of these metrics. By determining which Recipes are Dogs (low profitability; low popularity), Stars (high profitability; high popularity), Workhorses (low profitability, high popularity), or Puzzles (high profitability; low popularity), you can make better recipe costing and promotions moving forward.
Viewing Menu Engineering Report
- Click Reports > Reports List from the navigation.
- Click Menu Engineering under the Recipes heading.
- Under Date Period select By Period to view dates based on your audits, or By Date Range to select any Start and End Date for the period.
- Click Go to run the report.
- To see the recipes plotted on the Profitability Analysis table, click the checkbox to the left of the row. You can filter by POS Groups, POS Subgroups, and Menu List, or type directly into the box that says "Search Report..." to search by key words.
Manipulating Menu Engineering
Click directly into the values in the Cost and Price columns to make temporary tweaks to that datapoint, and see the impact this would have on your numbers. These manual edits will impact the Extra Profit column in particular, which will highlight how your Total Profit would be impacted by implementing that change. See the short video below for a walkthrough.
Keep in mind that any manual edits to Cost or Price cannot be saved because those values are live updating based on your data on Craftable and in your POS, but you can choose to export the changes out to a .xlsx file.
FAQ
How is the Price determined?
The Price on this report is pulled from the data from the POS button that has been mapped to the Recipe within Craftable.
Why do some recipes not have a check box?
Only items that have been sold during the selected date range will display a checkbox as the Quantity sold value is necessary to determine the item's profitability.
How is the axes of the grid determined?
This is based on the spread of items you select to be plotted in the graph. The system will calculate the average and display the items in the correct coordinates based on their data within the selected range.
Column Key
POS Item: Item Name from your POS
POS Item ID: The internal ID number from your POS
Recipe: Name of Recipe
Qty (Quantity Sold): The total quantity of that POS Item that was sold during the selected date range
Cost: Cost of each individual sale
Price: Average Amount charged for the Period/Date Range selected (includes Discounts)
Cost %: (Cost/Price) * 100%
Profit: Price - Cost
Total Cost: Cost * Qty Sold
Total Sales: Price * Qty Sold
Total Profit: Total Sales - Total Cost
Extra Profit: What your extra profit would have been during the selected period with the Cost and Price edits implemented.
Menu Status: Puzzle, Star, Dog or Workhorse
