Menu Engineering Worksheet: Using the Profitability Matrix in Practice

Menu engineering is one of the highest-return analytical activities a restaurant operator can do. According to Restaurant Peers’ analysis, restaurants that invest in systematic menu engineering see profits increase by 10–15% or more. Yet most operators either never do it or do it once and treat the results as permanent, when the whole point is regular, data-driven iteration.

The barrier is usually practical: the methodology sounds conceptually clear but feels opaque when you are sitting in front of a blank spreadsheet and a month of POS data. This guide walks through the complete process from data collection to strategic action, using the tools actually available to most operators.

What the Matrix Measures and Why It Matters

Menu engineering evaluates every menu item on two dimensions simultaneously: popularity (how often it sells) and profitability (how much money it makes per unit sold). The key insight is that these two dimensions do not always correlate, and the combination of both dimensions tells a different story than either alone.

An item that sells 200 units per week but generates only $3.50 in contribution margin (CM) contributes $700 to covering your fixed costs. An item that sells 40 units but generates $17.50 in CM contributes $700 to the same. They look identical from a financial contribution perspective but require entirely different management responses.

The matrix provides four classification zones based on whether each metric is above or below the menu average. This relative comparison — above or below average for your menu, in your market, with your customers — is more useful than comparing to industry benchmarks, because the benchmarks abstract away the specifics of your concept and cost structure.

Step 1: Gather the Data You Need

You need two pieces of information per menu item for a specific time period: the number of units sold and the food cost per portion. The time period should be long enough to smooth out weekly variability — a full month is the minimum; a full quarter is better for detecting true patterns.

Units sold come directly from your POS system’s PMIX (product mix) report. If your POS cannot generate a PMIX report, you need a different POS or to start recording sales manually. This data is non-negotiable for menu engineering.

Food cost per portion comes from your recipe costing cards. If you do not have current recipe costing cards, completing them is the prerequisite for the menu engineering worksheet, not an optional enhancement. SpotOn’s menu engineering methodology makes the dependency explicit: “inputting item names, prices, costs, and sales quantities” is the foundation upon which the analysis rests.

The time period for your PMIX data should match when your recipe costs were accurate. If you updated food costs last quarter but are analyzing this quarter’s sales, price changes in the interim may have shifted actual costs enough to invalidate the margin calculations. Keep the cost and sales data from the same period.

Step 2: Calculate Contribution Margin for Each Item

Contribution margin is the correct profitability metric for menu engineering — more accurate than food cost percentage for this purpose, as Meez’s analysis of the two metrics demonstrates. The formula is simple:

Contribution Margin = Menu Price − Food Cost Per Serving

A dish priced at $14.40 with a food cost of $3.65 yields a contribution margin of $10.75. That $10.75 is the amount that dish contributes toward covering labor, rent, overhead, and ultimately profit every time it is ordered.

For the Lightspeed menu engineering worked example: a salmon dish at $28 with a $9 portion cost yields a $19 contribution margin. But if salmon sells 120 times per month while pizza sells 500 times per month at a $7.88 contribution margin, the pizza generates $3,940 in monthly contribution versus $2,280 for salmon. This is exactly why popularity and profitability must be analyzed together — the per-plate margin does not tell the full story.

Create a spreadsheet with these columns for each menu item:

• Item name
• Category (appetizer, entree, etc.)
• Units sold (from PMIX)
• Menu price
• Food cost per portion (from recipe cards)
• Contribution margin (calculated: menu price − food cost)
• Total contribution (calculated: units sold × contribution margin)

Step 3: Calculate the Gross Profit Margin (Optional)

SpotOn’s worksheet methodology uses gross profit margin as the primary metric rather than contribution margin in dollar terms. The calculation:

1. Gross Profit = Item Price − Item Cost
2. Gross Profit Margin = (Gross Profit ÷ Item Price) × 100
3. Food Cost Percentage = 100 − Gross Profit Margin

SpotOn’s worked example: a $15.50 item with a $5.75 cost yields $9.75 gross profit, a 63% gross profit margin, and a 37% food cost percentage. SpotOn recommends targeting an average gross profit margin of approximately 70% across the menu.

Both approaches — dollar contribution margin and gross profit margin percentage — are valid. The Lightspeed and Meez approaches prefer dollar CM because it directly measures cash flow contribution. The SpotOn approach uses percentage because it provides a standardized benchmark across items at different price points. Using both gives a more complete picture: which items generate the most cash (dollar CM) and which are most efficient per sales dollar (gross margin %).

Step 4: Classify Items Using Menu Averages

Determine the menu average for each metric:

• Average popularity: Total units sold across all items ÷ number of menu items
• Average contribution margin: Total contribution dollars ÷ total units sold

Items above average in both metrics are classified as Stars. Above average popularity, below average contribution margin = Plowhorses (also called Workhorses). Below average popularity, above average contribution margin = Puzzles. Below average in both = Dogs.

Note that these classifications are relative to your menu’s own averages. A Plowhorse in your classification might be highly profitable by absolute standards — it is “low” only relative to your menu’s best items. The classification guides strategy, not absolute judgment.

A reminder from the YouTube menu engineering extract: Gallup polling data shows that guests look at a menu for only 109 seconds before ordering. This 109-second window is the entire playing field for menu psychology and positioning work. Items classified in each quadrant need different interventions, and those interventions must work within that brief window of attention.

→ Read more: Menu Engineering: A Data-Driven System to Boost Restaurant Profits by 10-15%

Step 5: Develop Specific Strategies for Each Quadrant

Stars — High Popularity, High Contribution Margin

These are your best performers. Protect them. Promote them. Do not change them unnecessarily. Restaurant Peers’ analysis recommends: “prominently feature Stars, maintain quality, protect margins, and use them as brand ambassadors in marketing materials.” SpotOn notes that Stars should occupy the most visible positions on the menu — top-left of each section — to capitalize on the attention they already attract.

The temptation is to raise Star prices to capture more margin. Be cautious. Stars are Stars partly because their price-to-value relationship is working. A price increase that reduces their popularity can demote them to Puzzles or worse. If you need margin improvement on Stars, the safer path is cost reduction through ingredient negotiation or slight portion adjustment rather than price increases.

Plowhorses — High Popularity, Low Contribution Margin

Plowhorses are the most common source of menu engineering improvement opportunity. Customers love them, but they are not generating the margin they should. The Lightspeed analysis outlines the strategy options: raise prices incrementally, negotiate lower ingredient costs with suppliers, reduce portion sizes slightly, or bundle them with high-margin sides and beverages to improve per-ticket profitability.

The McDonald’s model — discussed in the menu engineering YouTube extract — is the canonical Plowhorse example at scale. The Big Mac has a food cost approaching 40%, which makes it a Plowhorse by definition. But it exists to sell fries and drinks (high-volume Stars with sub-10% food costs) through combo structures. Your Plowhorses may play the same role if they draw customers who then add high-margin beverages and sides.

For pricing adjustments on Plowhorses: incremental increases of $0.50–$1.00 per menu reprint are typically absorbed without customer complaint. Larger jumps create visible resistance.

Puzzles — Low Popularity, High Contribution Margin

Puzzles would be Stars if more people ordered them. The question is why they are underordered, and several causes are common: poor menu placement (buried in the middle of a category), uninspiring description, unfamiliar dish names, or inadequate server recommendation.

Restaurant Peers’ strategy for Puzzles is specific: “improve menu visibility through better placement, rewrite descriptions to be more appealing, offer server incentives for recommending them, feature them as daily specials, or pair them with popular items in promotional bundles.”

Server incentives (a modest commission or recognition for selling specific Puzzles) have a measurable impact. Research from Qamarero’s menu optimization guide found that sales of individual items increase by 27% when descriptive language is used, with sensory adjectives being particularly effective. A Puzzle that currently reads “Pan-Seared Duck Breast — $26” may convert much better as “Duck Breast, slow-rendered until the skin shatters, paired with cherry gastrique and roasted farro — $26.”

Dogs — Low Popularity, Low Contribution Margin

Remove them or rework them completely. Dogs occupy menu real estate, complicate kitchen operations, require unique ingredients that may spoil, and dilute kitchen focus. Restaurant Peers recommends removal unless the item “has strategic value such as completing a category or serving a niche dietary need.”

The exception case: an item that is genuinely needed to serve a specific dietary need (a vegan option in a predominantly meat-forward menu, a gluten-free choice for a family with a member who has celiac) may justify keeping even without strong margin or volume performance. The test is whether removing it would cause a measurable loss of customers who currently visit specifically for that option.

→ Read more: Menu Copywriting: Writing Descriptions That Sell

Step 6: Redesign the Menu Based on Findings

Once items are classified, the physical (or digital) menu should reflect the analysis:

• Stars in the most visible positions per category (typically the first position, with visual differentiation if the design supports it — a box, a label, a photograph)
• Puzzles repositioned to better visibility; descriptions rewritten
• Plowhorses maintained in their current position but identified for gradual price adjustment
• Dogs removed from the menu or flagged for reformulation

SpotOn’s analysis of menu design psychology includes the finding that one graphic element per page increases sales by up to 30%. This is the argument for photographing and featuring a Star item: the visual anchor for each menu section draws attention toward the item you have intentionally selected for that role.

Step 7: Measure Impact and Repeat

Menu engineering is not a one-time exercise. Lightspeed recommends reviewing menus “at least seasonally or whenever food costs shift significantly.” Meez recommends quarterly reviews for most operations, monthly for high-volume or seasonal concepts.

After implementing changes, set a 4–6 week measurement window before evaluating impact. Sales behavior has momentum — customers who have ordered a particular dish habitually may continue doing so for several weeks even after positioning changes. Give the new menu enough time to generate meaningful data before drawing conclusions.

The comparison is straightforward: pre-change PMIX versus post-change PMIX. Did Puzzle items that were repositioned gain volume? Did Plowhorse price adjustments affect order frequency? Are Stars maintaining their performance in their new prominent positions? These questions are answerable with POS data alone, and the answers should directly inform the next round of adjustments.

Menu engineering done quarterly produces compound improvement over time. Each cycle identifies new opportunities that the previous cycle created or revealed. The 10–15% profit improvement cited by Restaurant Peers is an achievable target — but it arrives through accumulated, data-driven iteration rather than a single menu overhaul.

→ Read more: Menu Design and Layout: The Visual Psychology That Drives What Guests Order → Read more: Menu Profit Margin Optimization: Strategies to Maximize Restaurant Profitability