Menu engineering matrix generator, free with a PDF report
Enter each dish's category, menu price, food cost and units sold. The calculator sorts every dish into Stars, Plowhorses, Puzzles and Dogs within its category, plots the menu engineering matrix and gives you a PDF report to share with your chef or partner. Everything runs in your browser. For the full method, read our menu engineering guide.
How the menu engineering matrix is worked out
The calculator follows the matrix Michael Kasavana and Donald Smith set out in 1982, and compares each dish only with the other dishes in its category:
Category average CM = Σ(CM × units sold) ÷ Σ units sold
Menu mix % = Units sold ÷ Category units sold × 100
Popularity line = (100% ÷ Dishes in the category) × 0.70
A dish at or above both lines is a Star; popular but below the margin line, a Plowhorse; above the margin line but not popular, a Puzzle; below both, a Dog.
Worked example: four starters
This example uses the starters from the fictional restaurant in our guide. Over a quarter they sold 453 plates: Seekh Kebab 168 at ₹270 CM, Paneer Tikka 185 at ₹184, Mutton Galouti 62 at ₹315 and Corn Cheese Balls 38 at ₹112. The weighted average CM is ₹1,03,186 ÷ 453 = ₹228, and with four starters the popularity line is 25% × 0.7 = 17.5%. So Seekh Kebab (37.1% of plates, ₹270) is a Star, Paneer Tikka (40.8%, ₹184) a Plowhorse, Mutton Galouti (13.7%, ₹315) a Puzzle and Corn Cheese Balls (8.4%, ₹112) a Dog. The calculator below opens with these starters and five non-veg mains already filled in.
Menu engineering calculator
One row per dish. Use the menu price before GST, the ingredient cost of one portion and the units sold over the same 4 to 13 weeks. Group dishes by category, such as starters, mains, breads and beverages, with at least two dishes in each.
| Category | Dish | Price (₹) | Food cost (₹) | Units sold | Remove |
|---|---|---|---|---|---|
Paste from Excel or Google Sheets
Copy five columns in this order: category, dish, price, food cost, units sold. A header row is skipped. Pasting replaces the rows above.
Your menu engineering matrix and PDF report
The report has the matrix, every dish's class, category averages and an action list, on A4 pages. It's built in your browser; nothing is uploaded.
Report saved. Want it to update itself?
MarginMind AI in F&Bos classifies every dish from your live POS sales and recipe-linked food cost, so the matrix is current every morning. Bring this report to a free 20-minute demo and we'll run it on your own menu.
Book a MarginMind demo →9 dishes in 2 categories sold 1,256 units and earned ₹3,62,971 in contribution margin over the period.
| # | Dish | Price | Food cost | CM | FC % | Units | Menu mix | Class |
|---|---|---|---|---|---|---|---|---|
| 1 | Seekh Kebab (half plate) | ₹360 | ₹90 | ₹270 | 25.0% | 168 | 37.1% | Star |
| 2 | Paneer Tikka (quarter plate) | ₹320 | ₹136 | ₹184 | 42.5% | 185 | 40.8% | Plowhorse |
| 3 | Mutton Galouti (2 pcs) | ₹420 | ₹105 | ₹315 | 25.0% | 62 | 13.7% | Puzzle |
| 4 | Corn Cheese Balls (6 pcs) | ₹280 | ₹168 | ₹112 | 60.0% | 38 | 8.4% | Dog |
| # | Dish | Price | Food cost | CM | FC % | Units | Menu mix | Class |
|---|---|---|---|---|---|---|---|---|
| 5 | Signature Biryani | ₹520 | ₹130 | ₹390 | 25.0% | 247 | 30.8% | Star |
| 6 | Butter Chicken | ₹420 | ₹168 | ₹252 | 40.0% | 295 | 36.7% | Plowhorse |
| 7 | Mutton Rogan Josh | ₹480 | ₹120 | ₹360 | 25.0% | 181 | 22.5% | Star |
| 8 | Mutton Rara Masala | ₹500 | ₹125 | ₹375 | 25.0% | 49 | 6.1% | Puzzle |
| 9 | Fish Amritsari | ₹450 | ₹270 | ₹180 | 60.0% | 31 | 3.9% | Dog |
- Stars Keep the recipe and price; give it the best spot on the menu. Seekh Kebab (half plate), Signature Biryani, Mutton Rogan Josh
- Plowhorses Raise the price a little or trim portion or recipe cost. Paneer Tikka (quarter plate), Butter Chicken
- Puzzles Promote it: better menu position, description or staff push. Mutton Galouti (2 pcs), Mutton Rara Masala
- Dogs Rework or remove it, unless it has a clear reason to stay. Corn Cheese Balls (6 pcs), Fish Amritsari
What to do with Stars, Plowhorses, Puzzles and Dogs
| Group | What it means | What to do |
|---|---|---|
| Stars | Popular and high-margin within their category | Keep the recipe, portion and price steady; give them the best spot on the menu and never discount them. |
| Plowhorses | Popular but below the category's average margin | Raise the price a little, trim the portion or swap a costly ingredient. Our menu pricing formulas show how far. |
| Puzzles | High-margin but rarely ordered | Promote them: a better position on the menu, a better description, a staff recommendation or a combo. |
| Dogs | Below both lines | Rework the recipe or price, or take them off, unless they have a clear reason to stay. |
Run the matrix again every quarter, and whenever a big ingredient moves in price. Delivery commission can turn a Star into a Plowhorse, so enter your commission rate to see both views side by side.
Where to find the numbers for each dish
Units sold. Take an item-wise sales report from your POS for 4 to 13 weeks, avoiding festival weeks and one-off events. Every dish must cover the same period.
Food cost per portion. Add up the ingredients in one portion at today's purchase prices. If you haven't costed your recipes yet, our food cost calculator works it out ingredient by ingredient, and recipe costing software keeps it current as prices move.
Menu price. Use the price before GST, because the GST you collect isn't your revenue. If you sell the same dish at a different price on delivery, analyse the two menus separately or use the commission field.
When you outgrow the menu engineering calculator
The calculator is as current as the numbers you type in. In F&Bos, MarginMind AI reads units sold straight from the POS and food cost from recipe-linked inventory, so every dish's class follows this week's sales and this week's purchase prices. Bring your PDF report to a free demo and we'll show your own menu in it.
Menu engineering calculator FAQ
What is a menu engineering calculator?
A menu engineering calculator sorts your dishes into Stars, Plowhorses, Puzzles and Dogs from four numbers per dish: category, menu price, food cost per portion and units sold. It uses the Kasavana and Smith method from 1982 and tells you which dishes to protect, reprice, promote or rework.
How does the calculator decide if a dish is popular?
Within each category, a dish is popular if its menu mix (its share of the category's units sold) is at least 70% of an equal share. With 5 mains, an equal share is 20%, so the line is 14%.
How does it decide if a dish has a high margin?
Contribution margin is menu price minus food cost per portion. A dish is high-margin if its contribution margin is at or above its category's weighted average: the category's total contribution margin divided by the units it sold.
Why compare dishes within a category?
So a ₹50 roti isn't judged against a ₹520 biryani. Breads and drinks would always look like low-margin dishes next to mains. Give every dish a category, such as starters, mains, breads and beverages, and each is compared only with its own group.
Is my menu data stored or sent anywhere?
No. The calculator and the PDF report run entirely in your browser, and nothing you type is sent to F&Bos. If you tick "Remember my menu on this device", your dishes are saved in this browser only.
Can it show delivery margins?
Yes. Enter a delivery commission percentage and the results add each dish's delivery contribution margin, price × (1 − commission) − food cost, and its class on delivery against the same category average. Commission is reported at about 10–25% of order value; use the rate in your own aggregator agreement.
Your menu, classified every morning.
See MarginMind AI sort your own dishes from live sales in a free 20-minute demo.
Book Your Free Demo →Free 20-minute demo · Free self-setup, or assisted setup from ₹2,000 · WhatsApp: +91 79803 72217