--- title: Menu Engineering Worksheet description: This report will detail all product and sales for a specified date range. It will analyze the products within their sales group and determine whether they have high or low popularity and profitability --- [Skip to content](https://learn.tracrite.net/menu-engineering-worksheet#main-content) English Show submenu for translations ![logo-white-1.png\]](https://learn.tracrite.net/hs-fs/hubfs/logo-white-1.png?height=40&name=logo-white-1.png) - [Default HubSpot Blog](https://tracrite-6251099.hs-sites.com/blog) Open main navigation Close main navigation - [Default HubSpot Blog](https://tracrite-6251099.hs-sites.com/blog) - English Show submenu for translations - Go to tracrite.net Go to tracrite.net Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://learn.tracrite.net/?hsLang=en) 2. [Reports](https://learn.tracrite.net/reports?hsLang=en) 3. [Sales](https://learn.tracrite.net/reports?hsLang=en#sales) # Menu Engineering Worksheet This report will detail all product and sales for a specified date range. It will analyze the products within their sales group and determine whether they have high or low popularity and profitability. This report will determine problem areas on your menu. ![090a844b-7cb4-4194-925b-df65594a5394](https://learn.tracrite.net/hs-fs/hubfs/090a844b-7cb4-4194-925b-df65594a5394.png?width=688&name=090a844b-7cb4-4194-925b-df65594a5394.png) The below table will provide the breakdown of how the menu class is determined on the report: | **Menu Class** | **Detail** | | --- | --- | | Star | Profitability and Popularity are high. | | Workhorse | Profitability is low, but Popularity is high. | | Challenge | Profitability is high, but Popularity is low. | | Dog | Profitability and Popularity are low. | This table will explain what each header on the report represents and how the fields are calculated: | **Header** | **Detail** | | --- | --- | | Product | Product that was sold. | | Sold | Amount of the product sold. | | Gross Sales | Total amount of sales brought in from the product. | | Popularity % | Calculated based on the product sold against the total sold for the sales group. Ex. Beef Dip sold 287 out of 2139 = 0.13714, or 13.714% | | Avg Price | Calculated from the gross sales divided by the quantity sold. | | Avg Cost | Based on the recipe's costing at the time of the sales entry. | | Avg Margin | Calculated from Average Price - Average Cost. | | % Cost | Calculated from Average Cost / Average Price. | | Profitability | High or low if the products average margin is over or under the average item profits. **Calculations:** Average Item Profit = Group Average Price - Group Average Cost Group Average Cost = Total Average Cost / Number of Products in the Group | | Popularity | High or low if the popularity % is over or under the Menu Popularity Factor. **Calculation:** Menu Popularity Factor = 20% of the number of products in the group. Ex. Main Dish has 9 products. The recipe formula is 1/9\*0.80 = 0.889 or 8.89%. | | Menu Class | The menu class is determined based on how popular and profitable the product is within its sales group. Refer to the menu class table to see how the menu class is determined. |   - [OC Pro](https://learn.tracrite.net/oc-pro?hsLang=en#main-content) - [Getting Started](https://learn.tracrite.net/oc-pro?hsLang=en#getting-started) - [Setup](https://learn.tracrite.net/oc-pro?hsLang=en#setup) - [Preferences](https://learn.tracrite.net/oc-pro?hsLang=en#preferences) - [Security](https://learn.tracrite.net/oc-pro?hsLang=en#security) - [Utilities](https://learn.tracrite.net/oc-pro?hsLang=en#utilities) - [Nutrition](https://learn.tracrite.net/oc-pro?hsLang=en#nutrition) - [Enterprise](https://learn.tracrite.net/oc-pro?hsLang=en#enterprise) - [Main Menu Dashboard](https://learn.tracrite.net/oc-pro?hsLang=en#main-menu-dashboard) - [Items](https://learn.tracrite.net/oc-pro?hsLang=en#items) - [Count Inventory](https://learn.tracrite.net/oc-pro?hsLang=en#count-inventory) - [Case Size Overview](https://learn.tracrite.net/oc-pro?hsLang=en#case-size-overview) - [Setting Item Par Levels](https://learn.tracrite.net/oc-pro?hsLang=en#setting-item-par-levels) - [Prep/Batch Recipes](https://learn.tracrite.net/oc-pro?hsLang=en#prep-batch-recipes) - [Setting Prep Par Levels](https://learn.tracrite.net/oc-pro?hsLang=en#setting-prep-par-levels) - [Prep / Batch Recipe Scaling](https://learn.tracrite.net/oc-pro?hsLang=en#prep-batch-recipe-scaling) - [Menu Product Recipes](https://learn.tracrite.net/oc-pro?hsLang=en#menu-product-recipes) - [Invoices](https://learn.tracrite.net/oc-pro?hsLang=en#invoices) - [Ordering Stock](https://learn.tracrite.net/oc-pro?hsLang=en#ordering-stock) - [Sales Mix](https://learn.tracrite.net/oc-pro?hsLang=en#sales-mix) - [Daily Sales Summary – Viewing and Entering](https://learn.tracrite.net/oc-pro?hsLang=en#daily-sales-summary-viewing-and-entering) - [Item and Recipe Management](https://learn.tracrite.net/oc-pro?hsLang=en#item-and-recipe-management) - [Budget Worksheet](https://learn.tracrite.net/oc-pro?hsLang=en#budget-worksheet) - [Reports](https://learn.tracrite.net/oc-pro?hsLang=en#reports) - [Tracking Waste](https://learn.tracrite.net/oc-pro?hsLang=en#tracking-waste) - [Catering Events](https://learn.tracrite.net/oc-pro?hsLang=en#catering-events) - [Buffet Wizard](https://learn.tracrite.net/oc-pro?hsLang=en#buffet-wizard) - [Export Accounting Data](https://learn.tracrite.net/oc-pro?hsLang=en#export-accounting-data) - [General Information](https://learn.tracrite.net/oc-pro?hsLang=en#general-information) - [Manuals and Resources](https://learn.tracrite.net/manuals-and-resources?hsLang=en) - [Release History](https://learn.tracrite.net/release-history?hsLang=en#main-content) - [OC Pro](https://learn.tracrite.net/release-history?hsLang=en#oc-pro) - [OC Enterprise](https://learn.tracrite.net/release-history?hsLang=en#oc-enterprise) - [OC Premier](https://learn.tracrite.net/release-history?hsLang=en#oc-premier) - [Reports](https://learn.tracrite.net/reports?hsLang=en#main-content) - [Accounting](https://learn.tracrite.net/reports?hsLang=en#accounting) - [Inventory](https://learn.tracrite.net/reports?hsLang=en#inventory) - [Purchasing](https://learn.tracrite.net/reports?hsLang=en#purchasing) - [Recipes](https://learn.tracrite.net/reports?hsLang=en#recipes) - [Sales](https://learn.tracrite.net/reports?hsLang=en#sales) - [Usage Summary](https://learn.tracrite.net/reports?hsLang=en#usage-summary) - [OC Enterprise](https://learn.tracrite.net/oc-enterprise?hsLang=en#main-content) - [Security](https://learn.tracrite.net/oc-enterprise?hsLang=en#security) - [Setup](https://learn.tracrite.net/oc-enterprise?hsLang=en#setup) - [Nutirition](https://learn.tracrite.net/oc-enterprise?hsLang=en#nutirition) - [Utility](https://learn.tracrite.net/oc-enterprise?hsLang=en#utility) - [Recipe](https://learn.tracrite.net/oc-enterprise?hsLang=en#recipe) - [Items](https://learn.tracrite.net/oc-enterprise?hsLang=en#items) - [Company](https://learn.tracrite.net/oc-enterprise?hsLang=en#company) - [Glossary](https://learn.tracrite.net/oc-enterprise?hsLang=en#glossary) - [Preps](https://learn.tracrite.net/oc-enterprise?hsLang=en#preps) - [Products](https://learn.tracrite.net/oc-enterprise?hsLang=en#products) - [Reports](https://learn.tracrite.net/oc-enterprise?hsLang=en#reports) - [Suppliers](https://learn.tracrite.net/oc-enterprise?hsLang=en#suppliers) - [Default HubSpot Blog](https://tracrite-6251099.hs-sites.com/blog) [![](https://api.hubapi.com/avatars/v1/signed-uris/1ClUKEAgEEgx0cmFjcml0ZS5uZXQYnvWx6gUg6reLBConYnJhbmRpbmc6YXBpOndlYjp1c2VyLXRyYWZmaWM6dXMtZWFzdC0xMg0xNzIuMTYuMzguMTI2EhkAew3HZKadIciZ_sVXdE0a3C1fTdj-xxc4)](http://tracrite.net) tracrite.net Help Center Copyright © 2026, TracRite Software Inc.