Free Tool — Menu Engineering Calculator
Menu Engineering Calculator
Analyze your menu by profit and popularity — identify stars to promote, cash cows to feature, and dogs to remove or reprice.
Menu Items
| Item Name | Price (₹) | Cost (₹) | Margin (₹) | Margin % | Units Sold | Classification |
|---|---|---|---|---|---|---|
| Dal Makhani | ₹200 | ₹50 | ₹150 | 75% | 200 | ⭐ Star |
| Butter Chicken | ₹350 | ₹100 | ₹250 | 71.4% | 150 | 🧩 Puzzle |
| Paneer Tikka | ₹280 | ₹80 | ₹200 | 71.4% | 120 | 🐕 Dog |
| Biryani | ₹400 | ₹120 | ₹280 | 70% | 80 | 🐕 Dog |
How to Use
High margin + High popularity. Promote these items.
High margin + Low popularity. Increase visibility.
Low margin + High popularity. Raise prices or reduce costs.
Low margin + Low popularity. Remove or reposition.
Stop guessing which items drive profit
Menu engineering is the practice of analyzing your menu items by contribution margin and popularity to identify which items are genuinely profitable and which are eating into your margins.
This tool classifies every item into one of four categories: Stars (high profit, high popularity) that should be promoted, Cash Cows (high profit, low popularity) that need visibility, Puzzles (low profit, high popularity) that need repricing, and Dogs (low profit, low popularity) that should be removed or repositioned. Input your menu items with their prices, costs and units sold — the calculator handles the rest.
Menu engineering formulas
Contribution margin = Price − Cost. Margin % = (Price − Cost) ÷ Price × 100. Average margin % = simple average of every item's margin %, and average popularity = simple average of Units Sold. An item is high margin if its margin % is at or above the average, and high popularity if its units sold are at or above the average. Star = high margin and high popularity; Cash Cow = high margin, low popularity; Puzzle = low margin, high popularity; Dog = low on both. Total revenue = sum of Price × Units Sold. Total cost = sum of Cost × Units Sold. Total contribution = Total revenue − Total cost.
How to use the menu engineering calculator
- 1Delete the four sample dishes with the bin icon, or type over them with your own.
- 2For each dish, enter the Item Name, its menu Price and its Cost, the ingredient cost of one plate.
- 3Enter Units Sold for every dish from the same period, such as last month's sales report. Units must be whole numbers.
- 4Tap Add Menu Item for each extra dish you want in the analysis.
- 5Read the summary cards (Total Revenue, Total Cost, Total Contribution, Avg Margin %) and the count of Stars, Cash Cows, Puzzles and Dogs. Then check each dish's margin, margin % and badge in the results table, which is sorted by units sold.
- 6Click Export to Excel or Export to PDF to save the analysis.
Worked example: five dishes from one month of sales
Take five dishes and a month of sales: Veg Thali (₹200 price, ₹70 cost, 300 sold), Paneer Butter Masala (₹260, ₹78, 220), Chicken Biryani (₹320, ₹128, 250), Mushroom Tikka (₹240, ₹60, 90) and Fish Curry (₹380, ₹190, 60). Their margins are 65%, 70%, 60%, 75% and 50%, so the average margin is 320 ÷ 5 = 64%, and average units sold is 920 ÷ 5 = 184. The menu engineering calculator marks Veg Thali and Paneer Butter Masala as Stars, Chicken Biryani as a Puzzle, Mushroom Tikka as a Cash Cow and Fish Curry as a Dog. Total revenue is ₹2,41,600, total cost ₹86,960 and total contribution ₹1,54,640.
The Puzzle label does not make Chicken Biryani a weak dish. Its ₹192 margin across 250 plates is ₹48,000 of contribution, the most on the menu; it lands in Puzzle only because its 60% margin is below the 64% average. A ₹20 price rise would add ₹5,000 a month if volume holds at 250 plates. Fish Curry, the Dog, still earns ₹190 a plate, the second-highest rupee margin on the list, but spends half its price on ingredients and sold only 60 plates. Rework its cost in the recipe costing calculator or give it better menu placement before you decide to remove it.
Getting reliable menu engineering results
- Pull units sold for every dish from the same period of sales data, such as the last 30 days.
- Analyse one menu section at a time. A ₹40 chai can outsell every main course and pull the popularity average up for the whole list.
- Use a costed plate figure for Cost, not a guess. A ₹10 error on a ₹200 dish moves its margin by 5 points and can change its category.
- Leave out dishes that were added or unavailable for part of the period, since fewer selling days make them look less popular than they are.
- Before dropping a Dog or repricing a Puzzle, multiply its rupee Margin by Units Sold to see the contribution it brings in. The categories here are set by margin %, not rupee margin.
- Export to Excel each month and keep the files, so you can see which dishes move between categories.
Tools to use alongside menu engineering
Menu engineering calculator FAQs
Contribution margin is the profit per item before allocating fixed overhead costs (rent, salaries, etc.). It's the amount each sale contributes toward covering fixed costs and generating profit, calculated as Selling Price minus Cost of Goods Sold.
Items are classified by comparing their contribution margin and popularity (units sold) against the menu average. Stars are high on both, Cash Cows are high margin but low popularity, Puzzles are high popularity but low margin, and Dogs are low on both.
Stars — promote heavily, keep pricing stable. Cash Cows — increase visibility and bundling to boost sales. Puzzles — increase price or reduce costs (they're already popular, just not profitable). Dogs — remove, reposition as a loss-leader, or improve the recipe cost.
In this calculator, popularity means units or covers sold, not revenue. A low-margin item that sells in high volume is a Puzzle, not a Star, because it ties up kitchen capacity without delivering margin.
At least once a month or whenever you introduce new items or make significant price or recipe changes. Seasonal changes in popularity often shift items between categories, so you can spot shifting dynamics and adjust positioning.
No — this calculator uses ingredient cost only to find contribution margin. For a more complete profit picture, add an estimated labour cost per item (prep time, cooking time, plating) to your COGS before calculating margin.
Yes. Export to Excel saves a file named menu-engineering-report.xlsx with each item's name, price, cost, margin, margin %, units sold and classification. Export to PDF saves a landscape A4 report with the date, total revenue, total cost, total contribution, average margin, the number of items in each category and the full item table. Both files are created in your browser.
The classic method compares each dish's rupee contribution margin with the menu's weighted average and treats a dish as popular if its share of sales is at least 70% of an equal share. This calculator compares margin % with the simple average and units sold with the average units, so the same menu can sort differently. Labels differ too: a popular, low-margin dish is a Puzzle here but a Plowhorse in the classic matrix.
No. Avg Margin % is a simple average of each dish's margin %, so every item counts once however many plates it sold. For your overall margin, divide Total Contribution by Total Revenue. With chai at ₹40 (₹10 cost, 500 sold) and a thali at ₹200 (₹100 cost, 50 sold), Avg Margin % shows 62.5%, while the sales-weighted margin is ₹20,000 ÷ ₹30,000 = 66.7%.
No. Items stay only while the page is open; refreshing or closing the tab brings back the four sample dishes. To keep your analysis, use Export to Excel or Export to PDF before you leave. The exported file cannot be loaded back into the calculator, so keep your item list handy to re-enter for next month's run.
More calculators
Food Cost Percentage Calculator
Check if a dish's ingredient cost is in a healthy range for its menu price.
Try itTable Turnover Rate Calculator
See how many times each table turns over during service, and your average turn time.
Try itOnline Order Commission Calculator
See your real payout after platform commission, packaging and payment gateway charges on an online order.
Try itOptimize your menu with real-time data
Setu Dine tracks every item's cost and sales automatically, so you can run menu engineering analysis daily and spot profit-killing items before they hurt your bottom line.
Explore Setu Dine →