Menu Engineering Worksheet
About This Resource
Menu engineering is the science of designing your menu for maximum profitability. This worksheet walks you through the classic Boston Consulting Group-style matrix adapted for restaurants: Stars (high profit, high popularity), Plowhorses (low profit, high popularity), Puzzles (high profit, low popularity), and Dogs (low profit, low popularity). For each quadrant, you get specific strategies — price increases, repositioning, bundling, or removal — backed by data.
What's Included
Who Is This For?
Restaurant operators who want to make data-driven decisions about their menu. Particularly valuable before a menu redesign or during seasonal menu planning.
Quick Start Guide
- 1List all menu items with their food cost and sales volume
- 2The worksheet automatically categorizes each item into the matrix
- 3Review the recommendations for each quadrant
- 4Implement changes and re-analyze after 30 days
The Resource
Understanding the Menu Matrix
Menu engineering categorizes every dish into one of 4 quadrants based on two metrics: popularity (how often it's ordered) and profitability (contribution margin — the dollar amount you keep after food cost). ⭐ Stars = High popularity + High profit → Promote heavily, feature on the menu 🐴 Plowhorses = High popularity + Low profit → Increase price gradually or reduce portion cost 🧩 Puzzles = Low popularity + High profit → Better descriptions, server recommendations, menu placement 🐕 Dogs = Low popularity + Low profit → Remove, replace, or completely reimagine
Step 1: Gather Your Data
- 1Pull sales data for the last 90 days from your POS: item name, quantity sold, selling price
- 2Calculate the food cost per item using your standardized recipes (or actual cost if you track it)
- 3Calculate contribution margin per item: Selling Price − Food Cost = Contribution Margin
- 4Calculate popularity: each item's sales as a percentage of total items sold in its category
- 5Calculate the average contribution margin and average popularity across all items
Step 2: Classify Each Item
| Category | Popularity | Profit | Action |
|---|---|---|---|
| ⭐ Star | Above average | Above average | Maintain quality, prominent menu placement, slight price increases OK |
| 🐴 Plowhorse | Above average | Below average | Reduce portion slightly, substitute cheaper ingredients, increase price 5-8% |
| 🧩 Puzzle | Below average | Above average | Better menu description, train servers to recommend, reposition on menu |
| 🐕 Dog | Below average | Below average | Remove from menu, replace with a new dish, or completely rework the recipe |
Step 3: Take Action
0/7 completed
Frequently Asked Questions
You need two things per menu item: food cost (or cost percentage) and sales volume over a consistent period (ideally 30+ days). Your POS system should have both.
Run the analysis quarterly or whenever you're planning a menu change. Seasonal restaurants should analyze at the start and end of each season.
Dogs (low profit, low popularity) should be removed, repositioned with better descriptions/photos, or reformulated to reduce cost. The worksheet includes specific strategies for each scenario.
Menu Engineering Worksheet
PDF Worksheet · 45 min analysis
Download coming soon — document is being finalized.
Related Resources
View allMenu Pricing Calculator
Excel template with advanced formulas for maximum menu profitability.
Digital Menu Design Guide
Best practices for digital menus that drive orders and enhance UX.
Cost Control Checklist
Track and manage food costs, labor costs, and overhead systematically.