How to Run a Menu Profitability Analysis

A menu profitability analysis is a periodic review that scores every item by two measures — how much profit it contributes and how often it sells — then sorts each dish into a category that tells you exactly what to do with it. Run it every quarter and you stop guessing about your menu and start managing it with data. Here's how to do it in six steps.

Step 1: Gather 60-90 days of sales data

Pull item-level sales from your POS for a representative period — long enough to smooth out a slow week, short enough to reflect current prices. For each item you need units sold and price. Cobblestone POS exports this for free (no monthly fee, versus roughly $470+/mo for comparable Toast reporting), so a full menu analysis costs you nothing but the time to run it.

Step 2: Cost every plate

For each item, calculate the plate cost — the as-served cost of all ingredients. If your recipes aren't costed yet, work through how to cost out a recipe step by step first. Accuracy here decides the accuracy of everything downstream.

Step 3: Calculate contribution margin

For each item, subtract plate cost from price to get contribution margin per menu item. Multiply by units sold to get each item's total contribution. Sum those totals — that's the profit your menu actually generated.

Step 4: Find your two benchmarks

The analysis compares each item to the menu average:

• Average contribution margin = total contribution ÷ total units sold. Items above the line are "high margin."
• Average popularity = if you have N items, the average share each would sell if demand were even is 1 ÷ N. Multiply by 0.7 (a common threshold) to set the popularity bar. Items selling above that share are "high popularity."

Step 5: Sort every item into four categories

This four-box view is the heart of menu engineering. The power is that each box comes with a different prescription — you don't treat every underperformer the same way.

Step 6: Take action, then re-measure

• Stars: Put them where the eye lands first and make sure staff recommend them. Guard their quality and portion — these carry your profit.
• Plow Horses: They're popular, so small changes scale. A modest price bump or a cheaper garnish can move real money without denting demand.
• Puzzles: People aren't finding or choosing them. Move them to a prime spot, rewrite the description, or bundle them.
• Dogs: Try one fix (reposition or reprice). If it still doesn't move, cut it — unless it shares ingredients with winners or plays a needed role like a vegetarian option.

After you make changes, wait a quarter and run the analysis again. Menu management is a loop, not a one-time project.

How often to run it

Quarterly is the sweet spot for most independents — often enough to catch drift from rising ingredient prices, rare enough that you have real data between reviews. Also run it any time a major ingredient cost spikes or you overhaul the menu.

Takeaway: A menu profitability analysis turns opinions into categories with clear actions. Cost every plate, compare margin and popularity to the menu average, sort into Stars, Plow Horses, Puzzles, and Dogs, then feature, fix, or cut accordingly — and repeat every quarter.

The worksheet above does the sorting for you: enter price, plate cost, and units sold for each dish and it flags every item's category automatically.