· Orqestra Team · 8 min read

Menu Engineering Worksheet (Template + 8-Item Example)

A menu engineering worksheet that sorts every dish into Stars, Plowhorses, Puzzles and Dogs using the Kasavana and Smith thresholds, with an 8-item example.

A menu engineering worksheet lists every item in a menu category with units sold, menu mix %, price, food cost, contribution margin, and total contribution, then sorts each item into one of four boxes: Star, Plowhorse, Puzzle or Dog. An item is popular if its menu mix is at least 70% of the average share (70% × 1 ÷ number of items), and profitable if its contribution margin is above the category's weighted average contribution margin. That is the Kasavana and Smith method, and it works in a spreadsheet with one sales report and your recipe costs.

This article gives the thresholds with their source, the worksheet layout, numbered steps, a worked example with eight entrées classified, and what to do with each box.

The two thresholds

Menu engineering was developed by Michael Kasavana and Donald Smith, published in 1982 (NetSuite). Their point was that food cost percentage alone does not tell you which items make money, because you deposit dollars, not percentages. Each item is judged on two axes.

Popularity. An item is popular when its share of sales is at least 70% of what it would get if every item sold equally. A 1995 FIU Hospitality Review paper describing the method states it this way: if an item's selection rate exceeded 70 percent of the average popularity (total selections in the class divided by the number of items in the class), it was classified as popular, and for a class of eight items the cutoff is (100% ÷ 8) × 70% = 8.75% (FIU Hospitality Review, LeBruto, Quain and Ashley, 1995).

  • Popularity threshold = 70% × (100% ÷ number of items in the category)

Profitability. Contribution margin (CM) is selling price minus food cost. The threshold is the weighted average CM for the category: total contribution dollars divided by total units sold. The same FIU paper describes computing each item's CM, multiplying by units sold, totaling, and dividing by total items sold to get the weighted average; items above it are high CM, items at or below it are low CM.

  • Contribution margin = Menu price − Food cost
  • Weighted average CM = Sum of (CM × units sold) ÷ Total units sold

Use a simple average CM only if you have no sales data yet. The weighted version is the original method and is what the example below uses.

Worksheet layout

One row per item, one worksheet per category (entrées, appetizers, desserts, drinks). Mixing categories breaks the popularity threshold because a dessert never competes with a steak for the same order.

ItemSoldMenu mix %PriceFood costCMCM × soldPopularityProfitCategory
= sold ÷ total sold= price − food costHigh or LowHigh or LowStar / Plowhorse / Puzzle / Dog

The last three columns are the output. The classification rule:

PopularityProfitCategory
HighHighStar
HighLowPlowhorse
LowHighPuzzle
LowLowDog

Steps

  1. Pick one category and a period of at least four weeks. Pull units sold per item from the POS item sales report. Shorter periods let one busy Saturday decide an item's fate.
  2. Enter each item's current menu price.
  3. Enter each item's plate food cost from the recipe card. If you have not costed recipes, the food cost percentage guide shows how, and the menu price calculator does the per-plate math.
  4. Compute CM = price − food cost for each row, and CM × sold.
  5. Total the sold column and the CM × sold column. Weighted average CM = total CM dollars ÷ total sold.
  6. Compute menu mix % = sold ÷ total sold for each row.
  7. Compute the popularity threshold = 70% × (100% ÷ number of items).
  8. Mark popularity High if menu mix % is at or above the threshold, otherwise Low. Mark profit High if CM is above the weighted average, otherwise Low.
  9. Assign the category from the two marks, then decide an action per item (next section).
  10. Rerun the worksheet after the next menu change and compare.

Worked example: eight entrées

A single-location Indian restaurant doing about $95,000 a month. Entrée category, four weeks of sales, 1,000 entrées sold.

Popularity threshold = 70% × (100% ÷ 8) = 8.75%.

ItemSoldMenu mix %PriceFood costCMCM × soldPopularityProfitCategory
Butter chicken21021.0%$17.00$5.10$11.90$2,499.00HighHighStar
Chicken tikka masala18018.0%$17.00$5.40$11.60$2,088.00HighLowPlowhorse
Lamb rogan josh707.0%$21.00$8.40$12.60$882.00LowHighPuzzle
Paneer tikka masala15015.0%$16.00$4.00$12.00$1,800.00HighHighStar
Chana masala12012.0%$14.00$2.50$11.50$1,380.00HighLowPlowhorse
Shrimp curry606.0%$22.00$8.60$13.40$804.00LowHighPuzzle
Vegetable biryani14014.0%$15.00$3.60$11.40$1,596.00HighLowPlowhorse
Fish curry707.0%$20.00$8.80$11.20$784.00LowLowDog
Total1,000100%$11,833.00

Weighted average CM = $11,833.00 ÷ 1,000 = $11.83.

How a few rows were classified:

  • Butter chicken: 21.0% is above 8.75%, so popular. CM $11.90 is above $11.83, so high profit. Star.
  • Chicken tikka masala: 18.0% is popular, but CM $11.60 is below $11.83. Plowhorse. It sells a lot and makes 23 cents less than average per plate.
  • Shrimp curry: 6.0% is below 8.75%, not popular. CM $13.40 is the highest on the sheet. Puzzle.
  • Fish curry: 7.0% is not popular and CM $11.20 is below average. Dog.

Notice what the worksheet does not say. Chana masala has the lowest food cost percentage on the sheet (17.9%) and is still a Plowhorse, because at $14 it contributes $11.50 per plate against an average of $11.83. Lamb rogan josh has a 40% food cost and is a Puzzle, because it brings in $12.60 per plate. Dollars per plate, not percentage, decides the box. That is the whole point of the method.

What to do in each box

Stars (popular and profitable). Protect them. Keep the recipe, portion and quality exactly as they are, put them in the best spots on the menu, and test a small price increase. The FIU paper notes Kasavana and Smith suggested stars "should be tested for price elasticity by raising the selling price." In the example, butter chicken at $17.50 would add about $105 a month at current volume if sales hold.

Plowhorses (popular, below-average margin). These carry your volume, so do not remove them. Raise contribution without losing the sale: a modest price increase, a cheaper garnish or side, a slightly smaller portion, or a lower-cost supplier for the main ingredient. Chicken tikka masala at $17.50 moves its CM to $12.10, above the average, and turns it into a Star if volume holds. Watch the sales count after the change; if it drops below the popularity threshold the item becomes a Puzzle, which is worse.

Puzzles (unpopular, high margin). You want more people to order these. Move them to a high-visibility spot, rename or re-describe them, have servers recommend them, feature them as a special, or lower the price a little if that pulls volume. Shrimp curry at $13.40 CM has room to drop to $20 and still beat the average.

Dogs (unpopular, low margin). Replace them or drop them. The FIU paper reports Kasavana and Smith suggested dogs be alternated on the menu with similar items or eliminated. If a Dog has to stay (a signature dish, a dietary need), reprice it or re-cost it so it at least stops losing ground. Fish curry at $22 with the same food cost would have a $13.20 CM and move to Puzzle.

CategoryKeep?Main lever
StarYesPlacement, small price test
PlowhorseYesRaise CM: price, portion, ingredient cost
PuzzleYesRaise volume: placement, description, server push
DogUsually notReplace, or reprice if it must stay

Changes to a few items ripple through the rest. Raising two Plowhorse prices lifts the weighted average CM, which can push a marginal Star back over the line. Rerun the worksheet after every menu change rather than reclassifying once a year. If your POS reporting already tracks item sales and menu mix by period, as the sales analytics feature in Orqestra does, the sold and mix columns refresh on their own and the worksheet becomes a monthly habit instead of a project. Menu changes also move your average check, so watch it alongside the worksheet; the average ticket guide covers that side.

Common mistakes

  • Ranking by food cost percentage. The lowest food cost % item on the sheet above is a Plowhorse. Use contribution dollars.
  • Mixing categories on one worksheet. The 70% threshold assumes items compete with each other. Desserts and entrées do not.
  • Using a simple average CM when you have sales data. The weighted average is the method. A simple average overweights items nobody orders.
  • Too short a period. Two weeks of sales with a holiday in them will misclassify half the menu. Use four weeks or more.
  • Stale recipe costs. If food costs are from last year's invoices, every CM is wrong by the same amount in the same direction, and the Plowhorse and Star lines move. Re-cost before you classify.
  • Cutting Plowhorses. They are your volume. Fix the margin, keep the item.
  • Raising a Plowhorse price without watching the count. If it drops below the popularity line you have made a Puzzle out of a workhorse.
  • Classifying once. Every price or portion change moves the average. Rerun the sheet after each change.