Menu Engineering Matrix Calculator

How to Use This Tool

Follow these steps to generate a menu engineering matrix category for your menu item:

1. Enter the details of the menu item you want to analyze in the Item Details section. Include selling price, COGS cost per unit, and total units sold in your chosen period (e.g., last 30 days).
2. Input your business’s benchmark averages in the Benchmark Averages section: the average contribution margin per item across all menu offerings, and the average number of units sold per item.
3. Select your local currency from the dropdown to display results in the correct format.
4. Click the Calculate Matrix Category button to view your item’s category, profitability, popularity, and recommended actions.
5. Use the Reset Form button to clear all inputs and start a new analysis.

Formula and Logic

Menu engineering categorizes items based on two core metrics: contribution margin (profitability) and sales volume (popularity).

• Contribution Margin per Unit = Selling Price per Unit - COGS (Cost of Goods Sold) per Unit
• Contribution Margin Percentage = (Contribution Margin / Selling Price) * 100

An item is considered high profitability if its contribution margin is greater than or equal to your average menu-wide contribution margin. It is considered high popularity if its total units sold is greater than or equal to your average menu-wide units sold per item.

The four matrix categories are determined by combining these two metrics:

• Stars: High profitability + High popularity
• Puzzles: High profitability + Low popularity
• Plowhorses: Low profitability + High popularity
• Dogs: Low profitability + Low popularity

Practical Notes

Menu engineering is most effective when using data from a consistent 30- to 90-day period to account for seasonal fluctuations. For food service businesses, COGS should include all direct costs for the item: ingredients, packaging, and any condiments served with the dish.

• Recalculate benchmarks quarterly as you adjust menu pricing, supplier costs, or add/remove items.
• High-volume Plowhorses often cover fixed overhead costs, even with low margins. Avoid raising prices too aggressively on these items to prevent losing regular customers.
• Puzzles are often underpromoted high-margin items. Moving them to the top right of your menu or adding a chef’s pick badge can boost sales without increasing costs.
• Dogs may still have value if they fill a dietary niche (e.g., vegan, gluten-free) even with low sales. Evaluate non-financial factors before removing them.

Why This Tool Is Useful

Small food service operators often rely on gut instinct to adjust menus, leading to missed profit opportunities. This tool replaces guesswork with data-driven categorization to help you:

• Identify which items are driving profits vs. dragging down margins
• Prioritize marketing and promotion spend on high-impact items
• Reduce waste by removing or reworking unprofitable, low-demand offerings
• Optimize pricing strategies across your entire menu to boost overall profit margins

Frequently Asked Questions

What counts as COGS for a menu item?

COGS (Cost of Goods Sold) includes all direct costs required to produce the item: raw ingredients, packaging, condiments, and any side dishes served with the main item. Do not include fixed costs like rent, labor, or utilities in this figure.

How often should I recalculate my benchmark averages?

Recalculate your menu-wide average contribution margin and average units sold every 30 to 90 days. This accounts for seasonal menu changes, supplier price adjustments, and shifting customer demand. Use a consistent time period for all items when calculating averages.

Can I use this tool for non-food menu items?

Yes, this tool works for any product-based business with a fixed set of offerings, including retail, e-commerce, and hospitality. Simply adjust the COGS field to reflect the direct cost of producing or sourcing each product, and use units sold for the analysis period.

Additional Guidance

When analyzing your full menu, plot all items on a 2x2 matrix with profitability on the Y-axis and popularity on the X-axis to visualize your entire menu’s performance at once. Use this tool to analyze each item individually, then aggregate results to inform large-scale menu changes.

• Test price changes on Plowhorses in small increments (e.g., 5-10%) to avoid losing customers, and track sales volume for 2 weeks after each change.
• For Puzzles, run limited-time promotions (e.g., 20% off this week only) to test if increased demand justifies the temporary margin reduction.
• Review your menu engineering matrix alongside customer feedback data to ensure you are not removing items that have high customer satisfaction despite low sales volume.