RAS Pantry Resource

Menu Engineering Worksheet

Classify every menu item as Star, Plowhorse, Puzzle or Dog, then act on each with a clear playbook.

12
min read
Owners, Chefs, GMs
Menu Worksheet + Decision Matrix

How to use (60–90 minutes)

  1. Export a sales report for the last 4–8 weeks.
  2. Fill in the worksheet table for your top 20–50 items.
  3. Calculate contribution margin + classify each item.
  4. Write your action plan (what changes next menu cycle).

Worksheet (fill-in)

Category Item Price Plate cost CM (Price−Cost) Qty sold Total CM Complexity (L/M/H) Travel score (1–5) Class (Star/PH/Puz/Dog) Decision

Classification rules (simple)

🧭

Set your thresholds using your data:

  • High popularity: above median Qty sold
  • High profitability: above median Contribution Margin (CM)
  • Star: high pop + high profit → feature + protect quality
  • Plowhorse: high pop + low profit → re-portion / re-price / add-ons
  • Puzzle: low pop + high profit → rename / reposition / photo / staff script
  • Dog: low pop + low profit → remove or replace

Action Plan (premium)

Category Item Issue Action Owner Due date

Start here (2 minutes)

🎯
Objective: classify every item on your menu by popularity and profitability, then act on each one. Promote your Stars. Re-cost your Plowhorses. Reposition your Puzzles. Remove your Dogs.
⏱️

Reading time: 12 minutes. First worksheet run: 60 to 90 minutes. Quarterly refresh: 45 minutes.

📌

Why this matters: menus drift. Items get added without anyone removing the ones they replaced. Costs creep up while prices stay still. The result is a menu that looks busy but earns less. Menu engineering is the single fastest way to lift margin without changing a supplier or training a single staff member.

What you'll need

Input Where to get it Notes
Sales report (last 4 to 8 weeks) POS export by item Use a longer window if you ran a promo recently
Plate cost per item Recipe cards / costing sheet If you don't have these, this worksheet is also a forcing function to build them
Selling price per item Menu / POS Include any active modifiers separately if material
Complexity rating (Low / Medium / High) Kitchen lead's judgement How hard is it to make consistently under pressure
Travel score (1 to 5) - delivery brands only Service team's judgement How well does the dish survive 25 minutes in a bag
Cadence What to do Owner Time
Weekly Pull top sellers and bottom 10. Flag anything moving classification (e.g. former Star slipping into Plowhorse). GM 15 min
Monthly Update plate costs for top 20 items. Supplier prices move. Yours should too. Chef / Finance Lead 60 min
Quarterly Full menu engineering pass. Re-run the worksheet. Make 3 to 5 menu decisions and commit to them. Owner + Chef 2 to 3 hours
Annually Menu redesign or restructure. Consider category rebalancing, photo refresh, descriptions, menu architecture. Owner + Chef + Marketing 1 to 2 days

Rules to keep the cycle honest

  • Never remove a Dog without naming what fills the gap. Empty slots get filled by accident.
  • Never re-classify based on a single week's data, especially after a promo.
  • Always test price changes on Plowhorses with a 4 to 6 week measurement window.
  • Train front of house on every Star and Puzzle. They are your best sales tool.

Quick Navigation