Free tool · No sign-up · PDF report

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:

Contribution margin (CM) = Menu price − Food cost per portion
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.

Step 1 · Your menu

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.

CategoryDishPrice (₹)Food cost (₹)Units soldRemove
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.

Step 2 · Your matrix

Your menu engineering matrix and PDF report

Menu engineering matrix: 3 Stars, 2 Plowhorses, 2 Puzzles, 2 DogsPUZZLESSTARSDOGSPLOWHORSESPopularity: menu mix vs 70% of an equal share →Contribution margin vs category average →11. Seekh Kebab (half plate): Star22. Paneer Tikka (quarter plate): Plowhorse33. Mutton Galouti (2 pcs): Puzzle44. Corn Cheese Balls (6 pcs): Dog55. Signature Biryani: Star66. Butter Chicken: Plowhorse77. Mutton Rogan Josh: Star88. Mutton Rara Masala: Puzzle99. Fish Amritsari: Dog

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.

3Stars
2Plowhorses
2Puzzles
2Dogs

9 dishes in 2 categories sold 1,256 units and earned ₹3,62,971 in contribution margin over the period.

Starters: weighted average CM ₹228 · popularity line 17.5% of the category's units
#DishPriceFood costCMFC %UnitsMenu mixClass
1Seekh Kebab (half plate)₹360₹90₹27025.0%16837.1%Star
2Paneer Tikka (quarter plate)₹320₹136₹18442.5%18540.8%Plowhorse
3Mutton Galouti (2 pcs)₹420₹105₹31525.0%6213.7%Puzzle
4Corn Cheese Balls (6 pcs)₹280₹168₹11260.0%388.4%Dog
Mains, non-veg: weighted average CM ₹324 · popularity line 14.0% of the category's units
#DishPriceFood costCMFC %UnitsMenu mixClass
5Signature Biryani₹520₹130₹39025.0%24730.8%Star
6Butter Chicken₹420₹168₹25240.0%29536.7%Plowhorse
7Mutton Rogan Josh₹480₹120₹36025.0%18122.5%Star
8Mutton Rara Masala₹500₹125₹37525.0%496.1%Puzzle
9Fish Amritsari₹450₹270₹18060.0%313.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
Reading the matrix

What to do with Stars, Plowhorses, Puzzles and Dogs

GroupWhat it meansWhat to do
StarsPopular and high-margin within their categoryKeep the recipe, portion and price steady; give them the best spot on the menu and never discount them.
PlowhorsesPopular but below the category's average marginRaise the price a little, trim the portion or swap a costly ingredient. Our menu pricing formulas show how far.
PuzzlesHigh-margin but rarely orderedPromote them: a better position on the menu, a better description, a staff recommendation or a combo.
DogsBelow both linesRework 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.

Inputs

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.

Automate it

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.

Book a Free Demo →

Calculator questions

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