← Back to blog

Operators: Run a Spreadsheet Menu Mix in 2–4 Weeks

October 1, 2026
Operators: Run a Spreadsheet Menu Mix in 2–4 Weeks

Menu mix analysis (menu engineering) classifies each dish by popularity and profit so you can prioritize price, recipe, or merchandising actions that increase total contribution dollars. Run correctly, it turns a static menu into a ranked action list: which items to raise in price, which to rework, which to promote harder, and which to retire. The output is not a grade on your menu. It is a set of decisions you can make this week.


TL;DR:

  • Items with high contribution margins often sell infrequently, so balancing profitability with popularity is crucial for overall menu performance.
  • Labeling a dish as a "Star" without considering actual sales volume and labor costs can lead to overestimating its contribution.
  • Regularly analyzing sales data and margins within categories helps prevent underperforming dishes from skewing menu decisions.
  • Cuts should only be made after checking if low-selling items share ingredients or prep with high-performing dishes to avoid increasing costs elsewhere.
  • Monthly review cycles with clean, consistent data are more effective than annual assessments for maintaining an optimized menu.

Wits' End Solutions
Turn Menu Data Into Better Decisions
Wits' End helps hospitality operators develop menus, improve operations, and use analytics to guide practical business decisions.
Explore Wits' End Solutions

Table of Contents

What menu mix analysis measures and why it matters

Menu mix analysis comes from the Kasavana–Smith model, a two-axis framework built in 1982 that plots each item by how often guests order it against how much profit it contributes per sale. The insight behind it still holds: popularity and profitability answer different questions, and a menu built around one while ignoring the other tends to underperform on both.

A dish can sell constantly and still drag down your bottom line if its contribution margin is thin. Another can carry excellent margin and barely move because nobody orders it. Menu mix analysis forces both numbers onto the same page so pricing, recipe, and merchandising decisions get made together instead of in isolation.

Run the analysis after a food cost spike, whenever you refresh the menu, and as a recurring monthly check. Waiting for an annual review means months of selling underpriced or mislabeled items before anyone notices.

How to calculate menu mix percentage and contribution margin

Menu mix percentage, sometimes called sales mix, tells you how popular an item is relative to others in its category.

Menu mix % = item units sold ÷ total category units sold × 100

Kasavana and Smith's model treats an item as popular once it reaches 70% of its category's average popularity share.

Contribution margin = selling price minus food cost per item.

Weighted average contribution margin sums each item's contribution margin multiplied by its units sold, then divides by total units sold across the category, per the labor-inclusive Kasavana and Smith model.

Worked example: your appetizer category sold 1,200 total units last month, and your fried calamari sold 240 of them.

  1. Divide 240 by 1,200 to get 0.20.
  2. Multiply by 100 to get a 20% menu mix.
  3. Compare that 20% against your category's popularity cutoff to flag it as popular or not.
  4. Subtract food cost from price to get its contribution margin in dollars.
  5. Compare that dollar figure against the category's weighted average contribution margin.

Kasavana-Smith menu engineering matrix explained

Once every item has a menu mix percentage and a contribution margin, plot them on a two-by-two grid. Each quadrant calls for a different move.

  • Stars: high popularity, high contribution margin. Protect the recipe and price, and use them to anchor the menu.
  • Plowhorses: high popularity, low contribution margin. Test a price increase, trim portion cost, or rework the recipe without hurting volume.
  • Puzzles: low popularity, high contribution margin. Reposition on the menu, retrain staff to suggest them, or feature them as a limited-time item.
  • Dogs: low popularity, low contribution margin. Cut them unless they serve a strategic purpose, like a vegan option that fills a gap.

Pro Tip: Before cutting a Dog, check whether it shares prep or inventory with a Star. Removing it might raise your food cost elsewhere.

Some operators add labor as a third axis, which expands the grid to eight cells instead of four and often reshuffles which items get flagged as priorities.

Where the standard matrix misleads you

The classic model has a real blind spot: contribution margin per item is not weighted by sales volume, so a high-margin item can look great on paper while contributing almost nothing in total dollars if demand is thin. A small margin improvement on your best-selling entree usually beats a large percentage gain on a dish that sells twice a week.

Before acting on quadrant labels alone, layer in a few more variables.

  • Add labor minutes per item, since a Star that takes a line cook eight minutes to plate may cost more than its margin suggests.
  • Factor in packaging or third-party delivery fees for off-premise orders, which quietly erode contribution margin.
  • Check kitchen capacity: promoting a Puzzle that bottlenecks your fryer station can slow the whole ticket time.
  • Compare items only within the same category and daypart, since mixing entrees with desserts or lunch with dinner distorts the baseline.

Running the analysis: inputs, layout, and cadence

You do not need specialized software to start. A spreadsheet with clean inputs gets you most of the way there.

Required inputs per item: name, units sold, price, food cost, labor minutes, category, daypart, and sales channel.

  1. Pull raw sales data by item for a defined window, ideally two to four weeks minimum.
  2. Group items into their menu categories and calculate category-level unit totals.
  3. Calculate each item's menu mix percentage against its category total.
  4. Calculate contribution margin and compare it to the category's weighted average.
  5. Plot each item into its quadrant and flag it for action.

Pro Tip: Keep dayparts and channels in separate tabs. A burger that is a Star at dinner can be a Dog at lunch, and averaging the two hides both facts.

Run a quick check weekly on your top ten sellers, rebuild the full matrix monthly, and treat quarterly reviews as the point to reconsider pricing structure or menu layout. Avoid acting on any item with fewer than roughly 30 to 50 category sales in your window since the sample is too thin to trust.

Running the analysis: inputs, layout, and cadence — overview diagram

KPIs and tests to run after the analysis

The matrix tells you where to look. These numbers tell you whether your changes worked.

  • Track total contribution dollars by category, not just per-item margin percentage.
  • Watch labor minutes per sale for items you flagged as high effort.
  • Monitor category mix shifts month over month to catch a Star losing ground before it becomes a Plowhorse.
  • Track average check alongside item-level changes, since a price test on one dish can shift ordering patterns elsewhere.

Test one variable at a time: a price increase on a Plowhorse, a new menu position for a Puzzle, or a staff suggestion script for a slow-moving Star. Give each test a defined window and compare it against a similar prior period before calling it a win.

Practitioner checklist for running this in a live kitchen

Before trusting any output, verify recipe costs against actual purchase invoices rather than theoretical costing sheets, since ingredient prices drift faster than most menus get updated. Check POS category tags for consistency: an item miscoded into the wrong category will distort every mix percentage above it. Reconcile portion sizes and waste against your inventory counts, since a recipe that assumes zero waste will always overstate contribution margin.

Common errors we see across client kitchens: blending lunch and dinner sales into one daypart, tagging a modifier as a standalone item, and ignoring third-party delivery fees when calculating contribution margin for off-premise orders. Each one quietly skews the matrix toward the wrong conclusion.

Connecting these checks to cost visibility matters more now than it used to. National Restaurant Association data from 2025 show operators working with tight prime costs and labor shares, which leaves little room for a mispriced Plowhorse or a mistagged Dog to go unnoticed.

Practitioner checklist for running this in a live kitchen — overview diagram

Why the formulas matter less than the discipline behind them

The formulas in this guide are not the hard part. Any manager can divide units sold by a category total. The part that actually determines whether menu mix analysis pays off is the discipline to run it on a fixed schedule, with clean category and daypart segmentation, and to treat the quadrant labels as a starting point rather than a verdict.

Most operators who try this once and stop are reacting to a single bad month instead of building a habit. The conventional advice oversells the two-by-two grid as a complete answer. It is not: a Star with a labor cost you never measured is not actually a Star, and a Dog that shares prep with your bestseller might not deserve to be cut. Prioritize total contribution dollars over percentage margins, and prioritize consistency of measurement over sophistication of the model. A simple spreadsheet run every month beats an elaborate one run once a year.

— Chris

How Wits' End turns menu data into profit decisions

Running the matrix by hand gets you insight. Turning that insight into a priced, staffed, and merchandised menu change is where most teams stall, and it is where our work picks up.

  • Advanced Analytics builds the reporting layer so mix percentage and contribution margin update automatically.
  • Cost Controls ties recipe costing to your actual purchase invoices.
  • Task Force support steps in when a menu overhaul needs hands on the floor.
  • New Opening Support builds the menu engineering discipline in from day one.

A typical engagement starts with a quick audit of your current menu data, moves into a prioritized roadmap of price, recipe, and merchandising actions, and continues with implementation support until the changes show up in your numbers. See the full range of services to find where your menu needs the most help.

Sources

FAQ

What is the 30/30/30 rule for restaurants?

It is a planning heuristic rather than a fixed standard, and actual splits vary widely by concept and market.

What are the 5 principles of menu planning?

Common frameworks for menu planning emphasize balance in flavor and preparation method, variety across the menu, contrast in color and texture, eye appeal, and nutritional consideration. Definitions vary by source, so treat this as a general planning lens rather than a fixed checklist.

What are the 7 menu pricing methods?

Restaurants commonly use approaches such as cost-plus pricing, contribution margin pricing, competitive pricing, psychological pricing, value-based pricing, prime cost pricing, and bundle or combo pricing. Most operators blend more than one method depending on the item and category.

How do you calculate menu mix percentage?

Menu mix percentage equals an item's units sold divided by the total units sold in its comparable category, multiplied by 100. For example, 240 units sold out of a 1,200-unit category total works out to a 20% menu mix.