Free Menu Engineering Worksheet | Restaurant Menu Optimization
About This Menu Engineering Worksheet
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 in This PDF Worksheet
Who Should Use This Menu Engineering Worksheet?
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
Yes. The worksheet is free with no email required. It walks you through the full Stars/Plowhorses/Puzzles/Dogs matrix with step-by-step instructions and action recommendations for each category.
Menu engineering is the process of analyzing every dish on your menu by two metrics — profitability (contribution margin) and popularity (sales volume) — then making strategic decisions about pricing, placement, descriptions, and removal. Restaurants that run regular menu engineering analysis typically see a 3-7% increase in overall contribution margin within 90 days, purely from pricing and placement adjustments.
You need two pieces of data per menu item: (1) quantity sold over the last 30-90 days, and (2) food cost per portion. Most POS systems (Toast, Square, Lightspeed, Aloha) can export this as a report. You calculate contribution margin by subtracting food cost from your selling price.
Contribution margin = Selling Price − Food Cost. For example, a pasta dish that sells for $18 with a food cost of $4.50 has a contribution margin of $13.50. That $13.50 is what goes toward covering labor, rent, and profit. Menu engineering uses this number — not food cost percentage — to identify your most profitable items.
Run the analysis quarterly as a minimum. Also run it before any planned menu change, at the end of each season (for seasonal restaurants), or any time food costs spike significantly. Your menu is a living document — what was a Star six months ago may have become a Plowhorse if your supplier costs changed.
Dogs (low profit, low popularity) have three options: remove them entirely, reimagine them with a lower food cost or higher price point, or reposition them as a bundle component. Don't keep Dogs on your menu out of sentiment — every item takes up visual space that could feature a Star. The worksheet includes specific strategies for each scenario.
Yes. The Stars/Plowhorses/Puzzles/Dogs framework applies to any food or beverage menu. For bars, you apply it to cocktails and draft beers. For cafés, apply it to food items and specialty drinks. The contribution margin calculation and action strategies are identical regardless of format.
Best-sellers by quantity (Plowhorses) are popular but often not your most profitable — they may have high food costs that eat into your margin. Menu engineering finds your Stars: the items that are both popular AND highly profitable. Focusing only on sales volume can lead you to promote items that are actually hurting your bottom line.
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.