July 28, 2026

A restaurant can be busy, produce strong sales, and still leave profit on the table every shift. The problem is often sitting in plain sight on the menu. If you are asking how to build a menu mix report, the goal is not simply to identify your best sellers. The goal is to see which menu items produce cash, which items consume labor and inventory for too little return, and what needs to change.

A menu mix report turns POS sales data into a management tool. Used correctly, it gives an owner or manager a disciplined basis for pricing decisions, menu redesign, server training, purchasing controls, and promotions. Used carelessly, it can lead to bad decisions based on a single busy weekend or inaccurate recipe costs.

Start With a Clean, Meaningful Sales Period

Choose a reporting period long enough to reflect normal customer behavior. Four weeks is often a practical starting point. A single week may be distorted by weather, a festival, a holiday, a large party, or an unusual promotion. A full quarter may hide a recent change in price, product quality, staffing, or demand.

Pull item-level sales data from your POS for the period. You need the number of units sold for every menu item, not just total sales dollars. Use net sales where possible, removing voids, refunds, and obvious POS errors. If your POS combines items that should be evaluated separately, such as a burger with and without premium add-ons, clean that data before you begin.

Do not mix categories without a reason. Appetizers, entrees, desserts, beer, wine, and cocktails have different check averages, purchasing patterns, and customer expectations. Build separate reports for each major category first. You can later look at the full menu, but category-level analysis produces clearer operational decisions.

Build the Core Menu Mix Report Columns

A useful menu mix report can be built in a spreadsheet even if your POS does not offer menu engineering tools. Create one row for each item and include the following columns:

Menu item name and category

Menu price

Units sold during the reporting period

Net sales dollars

Standard plate cost

Contribution margin per item

Food cost percentage

Menu mix percentage

Popularity index and contribution margin index

The discipline is in the inputs. Your standard plate cost must come from current, tested recipes and current vendor prices. A theoretical food cost based on an old recipe or a case price from six months ago is not good enough. If the recipe calls for six ounces of salmon, but the line regularly portions eight ounces, the report will overstate margin and give you false confidence.

For beverages, use a standard pour cost and current bottle or keg costs. For menu items with meaningful packaging, condiments, or garnish costs, include them. Small costs repeated hundreds of times become material quickly.

Calculate Contribution Margin First

Contribution margin is the dollar amount left after the direct cost of the item is paid. It is the most important number in the report because it tells you how much each sale contributes toward labor, occupancy, overhead, debt service, and owner profit.

Use this formula:

Contribution Margin = Menu Price - Standard Plate Cost

If an entree sells for $24 and has a standard plate cost of $7.20, its contribution margin is $16.80. Its food cost percentage is 30 percent. Both numbers matter, but they answer different questions.

Food cost percentage is useful for purchasing and price discipline. Contribution margin is more useful when deciding what to sell more often. A $15 item at a 20 percent food cost produces a $12 contribution margin. A $34 item at a 35 percent food cost produces a $22.10 contribution margin. The second item has a higher food cost percentage but produces substantially more dollars per sale.

Do not remove an item solely because its food cost percentage looks high. The correct decision depends on its contribution margin, sales volume, labor requirements, waste risk, and role in the guest experience.

Measure Popularity With Menu Mix Percentage

Menu mix percentage tells you the share of category sales represented by an item. Calculate it using units sold, not sales dollars:

Menu Mix % = Item Units Sold / Total Category Units Sold

Suppose your entree category sold 1,000 total units and the chicken dish sold 140 units. Its menu mix percentage is 14 percent.

Next, establish the expected popularity level. The simplest method is to divide 100 percent by the number of items in the category. If you have 10 entrees, an even share would be 10 percent per item. Many operators use 70 percent of that average as the threshold for acceptable popularity. In this example, 7 percent is the popularity benchmark.

This is a useful starting point, not a law. A premium steak, vegan entree, or seasonal special may not be expected to sell at the same rate as a familiar chicken dish. Still, if a menu item sells far below its expected share, you need a reason. “It has always been on the menu” is not a reason.

Compare Each Item Against the Category Average

To determine whether an item has strong or weak margin, calculate the weighted average contribution margin for the category. Multiply each item’s contribution margin by its units sold, add those totals, and divide by total category units sold.

Weighted Average Contribution Margin = Total Category Contribution Margin / Total Category Units Sold

Now compare each item to both benchmarks: expected popularity and weighted average contribution margin. This creates four practical menu engineering groups.

Stars: Popular and Profitable

Stars sell above the popularity threshold and generate above-average contribution margin. Protect them. Keep the recipe, presentation, portion, and execution consistent. Feature them in server training and place them where guests can find them easily.

A Star can still be improved. A modest price increase, a lower-cost garnish, or a better purchasing specification may increase its margin further. Make changes carefully. An item that drives repeat visits should not be damaged by an aggressive cost-cutting decision.

Plowhorses: Popular but Low Margin

Plowhorses are customer favorites that do not generate enough contribution margin. They are common in independent restaurants: the generous pasta dish, the oversized sandwich, the underpriced brunch plate, or the cocktail with a heavy pour.

Do not automatically remove a Plowhorse. Its popularity has value. Instead, investigate portion size, plate cost, price, add-on opportunities, and production labor. A $1 price increase, a one-ounce portion adjustment, or a side substitution may materially improve the result without creating guest resistance.

Puzzles: Profitable but Not Popular

Puzzles have strong contribution margin but weak sales. These items deserve attention because they may be a merchandising problem rather than a product problem.

Ask whether the name is clear, the description sells the value, the placement is weak, or servers fail to recommend it. Check whether the item is available consistently and whether it photographs or presents well. A high-margin item that no one notices does not improve profitability.

Test one change at a time. Rename it, improve the description, move it within the category, feature it as a server recommendation, or pair it with a profitable beverage. Then measure the result over a meaningful period.

Dogs: Low Popularity and Low Margin

Dogs are low-margin items with low demand. They tie up inventory, add prep complexity, create training burden, and increase the likelihood of waste. In a small independent operation, they can quietly drain profit every day.

Before removing one, consider whether it serves a necessary dietary need or supports a broader menu identity. If not, take it off. Menu reduction is often a profit improvement strategy because it concentrates purchasing, simplifies execution, and reduces the number of decisions your kitchen must make during service.

Turn the Report Into Operating Decisions

The report is not finished when the spreadsheet is complete. Review it with your chef, kitchen manager, bar manager, and service leaders. The conversation should focus on actions and owners, not opinions.

For each item, decide whether to hold, reprice, re-cost, re-portion, promote, reposition, redesign, or remove it. Record the action, the person responsible, and the date you will review the result. Menu engineering without follow-through is just accounting.

Also compare the report to actual food and beverage cost on your profit and loss statement. If theoretical plate costs suggest a 28 percent food cost but the P&L shows 35 percent, your problem may be purchasing, receiving, portion control, waste, theft, comps, or inaccurate recipes. A menu mix report identifies what should be happening. Your operating controls explain what is actually happening.

Review Monthly, Not Once a Year

Menu mix changes with seasons, staffing, price changes, local competition, and guest habits. In Ithaca and the Finger Lakes, tourism cycles, college calendars, weather, and event traffic can materially affect demand. Review major categories monthly and conduct a deeper review after a menu change or significant vendor cost movement.

The best menu is not the one with the most items or the most attractive descriptions. It is the one that gives guests a clear reason to return while producing enough contribution margin to support a healthy restaurant. Build the report, challenge the weak assumptions behind it, and make the next menu decision based on dollars rather than habit.