Templates and checklists · Menu engineering worksheet
Free sheet to print

Menu engineering worksheet

A menu engineering worksheet sorts your dishes into four groups by how often they sell and how much they earn. Enter units sold, selling price and food cost for each dish. The sheet works out the rest and names each dish a Star, Plowhorse, Puzzle or Dog.

What you type stays on your device. Nothing is saved or sent, so print it or download the CSV before you close the page. To make a PDF, choose "Save as PDF" in your browser's print window.

What it is for

A menu engineering worksheet sorts your dishes into four groups by how often they sell and how much they earn. Enter units sold, selling price and food cost for each dish. The sheet works out the rest and names each dish a Star, Plowhorse, Puzzle or Dog.

Read more: Menu engineering: a worked example for a cafe · Recipe costing sheet

Last reviewed 18 November 2026. A working tool for your own team, not legal advice.

How to use it

  1. List your dishes. Use the last month or two of sales from your till report.
  2. For each dish, write units sold, selling price and the food cost of one portion. Use a costed recipe if you have one.
  3. Read the contribution. It is the selling price minus the food cost, in rupees for one portion.
  4. Look at the groups. Stars sell well and earn well. Plowhorses sell well but earn less. Puzzles earn well but sell less. Dogs do neither.
  5. Change the two limits if you want a stricter or looser test. Then decide what to do with each group. Print the sheet or download the CSV.

Menu engineering worksheet

Zentaro Serve · serve.zentaro.cloud/templates/menu-engineering-worksheet
DishUnits soldSelling price (₹)Food cost per portion (₹)Contribution per portion (₹)Share of unitsGroup
Dishes counted
Units sold
Sales
Total contribution
Stars
Plowhorses
Puzzles
Dogs

How the groups are decided

  • Contribution is the selling price minus the food cost of one portion.
  • Popular means the dish's share of all units sold is at least the popular limit above. The usual limit is 70% of an equal share. An equal share is 100% divided by the number of dishes.
  • Earns well means the contribution is at least the limit above. If you leave it empty, the limit is the average contribution per dish sold.
  • Star: popular and earns well. Plowhorse: popular, earns less. Puzzle: earns well, sells less. Dog: sells less and earns less.

Worked example

Six made-up dishes. They are not from a real restaurant. Press "Fill with the example" to see them in the sheet.

  • Paneer butter masala: 300 sold, ₹260 price, ₹90 food cost, contribution ₹170, 33.33% of units. Star.
  • Veg biryani: 280 sold, ₹220 price, ₹70 food cost, contribution ₹150, 31.11% of units. Plowhorse.
  • Dal tadka: 180 sold, ₹160 price, ₹40 food cost, contribution ₹120, 20% of units. Plowhorse.
  • Chicken tikka: 60 sold, ₹340 price, ₹120 food cost, contribution ₹220, 6.67% of units. Puzzle.
  • Mushroom soup: 30 sold, ₹150 price, ₹60 food cost, contribution ₹90, 3.33% of units. Dog.
  • Fish curry: 50 sold, ₹380 price, ₹140 food cost, contribution ₹240, 5.56% of units. Puzzle.
  • Units sold in total: 900. With 6 dishes, an equal share is 16.67%. 70% of that is 11.67%, so a dish needs at least that share to count as popular.
  • Total contribution is ₹1,42,500. Divided by 900 units, the average is ₹158.33 per dish sold. A dish at or above it earns well.
  • Result: 1 Star, 2 Plowhorses, 2 Puzzles and 1 Dog.

Questions about this sheet

How does the sheet decide which dishes are popular?

A dish is popular when its share of all units sold is at least 70% of an equal share. With ten dishes, an equal share is 10%, so a dish needs 7% of units. You can change the 70%.

How does it decide which dishes earn well?

It compares each dish's contribution with the average contribution per dish sold. A dish at or above the average earns well. You can type your own limit in rupees instead.

Is what I type saved or sent anywhere?

No. What you type stays on your device. Nothing is saved or sent. Print the sheet or download the CSV before you close the page.

Want this done for you, every day?

Zentaro Serve launches in 2027. It keeps your sales, cash, stock and recipes in one place. Tell us what you run today and we will get in touch.

Talk to us Join the early access list

Last updated:

Pricing is coming soon

We are keeping pricing simple. We will share it when Zentaro Serve launches in 2027. Join early access and we will tell you first.