How To Evaluate Menu Performance With Data Analytics

How to Evaluate Menu Performance with Data Analytics

Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026

Key Takeaways

  • Most UK restaurants lack real-time visibility into dish profitability because ingredient prices change weekly and manual costing takes too long.
  • A repeatable nine-step process using POS sales data and live invoice costs classifies every menu item into the Stars, Plowhorses, Puzzles, and Dogs matrix and triggers clear actions for each quadrant.
  • Contribution margin, food cost percentage, sales mix, and gross profit margin are the four core KPIs that drive menu performance evaluation against 2026 UK benchmarks.
  • Daypart analysis, attachment-rate data, and qualitative guest feedback refine the quantitative classification and reveal hidden revenue opportunities.
  • Jelly automates the workflow by scanning invoices, updating live dish costs, and generating Sales Mix and Flash Reports, and can add two percentage points to your gross profit within 90 days. Book a demo to see it in action.

Prerequisites: Data and Access You Need Before You Start

Confirm you have admin access to your POS system. Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast. Gather supplier invoices for at least the past four weeks and make sure you understand food cost percentage as a proportion of a dish’s selling price. You do not need advanced finance knowledge to follow this playbook.

Step 1: Gather Your Required Data Sources

Export item-level sales data from your POS covering a minimum of four weeks. Collect every supplier invoice for the same period at the same time. Your goal is to consolidate units sold per dish and the ingredient cost behind each dish in one place within 24 hours.

With Jelly, you photograph invoices or forward them by email, and Jelly scans every line item automatically, so you avoid manual data entry. This single step removes the most time-consuming part of the entire process.

Book a demo to see how Jelly consolidates invoice and POS data in under 24 hours.

Step 2: Define Core KPIs with 2026 UK Benchmarks

Four KPIs drive menu performance evaluation: food cost percentage, contribution margin per dish, sales mix percentage, and gross profit margin. Different UK restaurant formats target different gross profit margins in 2026:

  • Casual dining: 60–70% GP
  • Quick-service: 70% or higher GP
  • Fine dining: generally under 70% GP
  • Delivery kitchens: 65–75% GP

Use these benchmarks as your baseline targets before you classify individual items.

Step 3: Calculate Contribution Margin for Each Dish

Contribution margin is the amount remaining from sales after variable costs are removed, and it covers fixed costs and profit. The formula is straightforward: Contribution Margin = Selling Price − Food Cost. Contribution margin percentage is calculated as (Selling Price − Variable Costs) / Selling Price and shows the portion of each sales pound that covers fixed costs and profit.

For example, a dish priced at £16 with a food cost of £4.80 delivers a contribution margin of £11.20, or 70% GP. Contribution margin is central to menu engineering and pricing strategy because it highlights high-margin products and low-performing items.

Pro Tip: Jelly’s Price Alert feature flags every ingredient price movement the moment a new invoice is scanned. If a key ingredient rises and a dish’s GP percentage drops below your target, you receive an immediate alert, and you avoid manual recalculation.

Step 4: Build the Stars, Plowhorses, Puzzles, and Dogs Matrix

Menu engineering, developed by Michael Kasavana and Donald Smith at Michigan State University in 1982, classifies every menu item using popularity and profitability. Popularity means units sold relative to the category average. Profitability means contribution margin, which equals menu price minus ingredient cost. Stars carry both high contribution margin and high sales mix. Plowhorses have low contribution margin but high sales mix. Puzzles have high contribution margin but low sales mix. Dogs have both low contribution margin and low sales mix.

Calculate thresholds separately for each menu category rather than across the entire menu, because comparing starters against mains distorts the classification. Calculate the average contribution margin and average units sold within each category. Then plot each item above or below those averages to assign its quadrant.

Step 5: Layer In Daypart and Attachment-Rate Analysis

Menu performance shifts by daypart, so you need to review each time window separately. A dish classified as a Plowhorse at dinner may perform very differently at lunch, where a lower average spend makes its thin margin more damaging. Break your POS sales data by daypart, such as breakfast, lunch, dinner, and late-night, and recalculate popularity scores within each window.

Attachment-rate analysis adds another layer. Identify which items guests frequently order together. A low-margin main paired consistently with a high-margin side or dessert may earn its place on the menu when you assess the combined transaction margin. Attachment-rate data comes directly from item-level POS exports and reveals revenue opportunities that aggregate reporting hides.

Step 6: Combine Quantitative Data with Guest Reviews

Cross-reference your quantitative classification with guest feedback to avoid misleading conclusions. A dish classified as a Puzzle, which means high margin and low popularity, may underperform because of a weak description or poor menu placement rather than low demand. Check Google, TripAdvisor, and delivery platform reviews for mentions of specific dishes.

Positive sentiment on a low-selling item confirms a repositioning opportunity. Negative sentiment on a Star signals a quality issue that you should address before you test any price increase.

Step 7: Use the Decision Framework for Each Quadrant

Treat Stars as your heroes. Give them prime menu placement, feature them in server recommendations, avoid discounting, and test modest annual price increases of 5–8%. Address Plowhorses by testing a 5–8% price increase, reducing ingredient costs through smaller portions or substitutions, or reducing menu prominence.

Support Puzzles with better menu positioning, rewritten sensory descriptions, and high-quality photos, which can increase orders on digital or delivery menus by 25–35%, along with modest price adjustments. Remove Dogs unless they serve a strategic purpose such as dietary accommodation or price anchoring. Many restaurants find that 20–30% of their menu consists of Dogs, and removing them simplifies operations and increases average check.

Troubleshooting: If more than 40% of your menu falls into the Dog quadrant, stale pricing is the likely issue rather than poor dish selection. Check when you last updated selling prices against current invoice costs before you remove items.

Step 8: Automate Menu Analysis and Reporting with Jelly

Manual analysis works as a one-off exercise, but repeating it every month without automation quickly becomes unmanageable. Jelly automates the complete workflow. Invoices are scanned on arrival, ingredient costs update every dish recipe in real time, and the Sales Mix report, generated by connecting your POS in under five minutes, plots popularity against profitability automatically.

The Flash Report provides a daily or weekly gross profit view without manual calculation. Price Alerts surface supplier price movements the moment they occur, so you catch margin erosion before it compounds.

Jelly charges a flat £129 per month per location with no per-user fees. Operators consistently report saving 10–20 hours of admin per month and adding two percentage points to gross margins within the first 90 days. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue.

Schedule a chat to see Jelly’s Sales Mix and Flash Reports in action.

Step 9: Measure Success and Track Your 90-Day Lift

Set two concrete success criteria from day one so you can judge whether the framework is working. First, identify at least three items to re-price or remove within the first week of completing the matrix. This immediate action confirms you can execute the framework and starts shifting your mix toward higher-margin dishes.

Second, target a two-percentage-point improvement in gross profit margin within 90 days. This lift represents the cumulative result of weekly pricing and menu decisions compounding over time. Gross profit percentage is calculated as ((Selling Price − Cost Price) / Selling Price) × 100. Track this figure weekly using Jelly’s Flash Report to confirm the trajectory.

Troubleshooting: If GP is not improving after 30 days, check whether all supplier invoices are being captured in Jelly. Missing invoices create understated food costs and a falsely optimistic GP reading. Jelly’s Insights Dashboard shows total spend by supplier, which makes gaps immediately visible.

Advanced Next Steps for Multi-Site and Delivery Menus

Once you establish the workflow for a single site, you can replicate the process across locations. Compare quadrant classifications site by site to identify where a dish performs as a Star in one venue but a Dog in another. This comparison highlights training, pricing, or local preference issues.

Delivery menu work sits alongside this process. Jelly’s Delivery Menu Creation tool duplicates existing menu items and factors in delivery commission overheads, so you see a dish’s true delivery margin before you list it on a platform.

Frequently Asked Questions

How do you calculate food cost percentage?

Calculate food cost percentage by dividing the total ingredient cost of a dish by its selling price, then multiplying by 100. For example, if a dish costs £4.50 to make and sells for £15.00, the food cost percentage is 30%. As a general benchmark, most UK restaurants target a food cost percentage between 28% and 35%, though this varies by restaurant type and service model.

The challenge lies in keeping this figure accurate when supplier prices change frequently. Jelly updates dish costs automatically every time a new invoice is scanned, so food cost percentage stays current without manual recalculation.

What are Stars, Plowhorses, Puzzles, and Dogs on a menu?

These four categories come from the menu engineering framework developed in 1982 and classify every dish based on two dimensions. The first is popularity, measured as units sold relative to the category average. The second is profitability, measured as contribution margin relative to the category average.

Stars are popular and profitable, so you protect them and consider modest price increases. Plowhorses are popular but low-margin, so you look for ways to reduce their cost or gently raise their price. Puzzles are high-margin but low-selling, so they need better positioning, descriptions, or promotion. Dogs are low on both dimensions and are candidates for removal unless they serve a specific strategic purpose such as catering to dietary requirements or anchoring the perception of value elsewhere on the menu.

How often should restaurants run menu engineering analysis?

Run a full menu engineering review quarterly for established menus. Use monthly checks when a menu has recently changed or when food cost percentage has been above target for two or more consecutive months. Trigger an immediate review after a significant supplier price increase, a major competitor menu change, or a notable shift in a dish’s sales volume.

With Jelly, the underlying data, including live dish costs and POS sales mix, updates continuously. Operators can run an ad hoc review at any point rather than waiting for a scheduled cycle.

What is a healthy contribution margin for a UK restaurant?

Contribution margin varies by dish type, service format, and price point, so no single universal figure applies. The more useful benchmark is gross profit margin at the menu level. In 2026, UK casual dining restaurants typically target 60–70% gross profit, quick-service restaurants aim for 70% or above, and fine dining operations generally run under 70% due to higher ingredient quality.

For individual dishes, a contribution margin that sits above the category average is the threshold that matters for menu engineering classification. For instance, if a dish priced at £18 has a food cost of £5.40, the 70% GP may be strong in a casual dining category but weak in a quick-service category where the average is 75%.

Conclusion: Turn Data into Daily Profit Decisions

The nine steps in this playbook form a repeatable system that replaces guesswork with daily, actionable insight. You move from consolidating data sources and calculating contribution margins, through building the four-quadrant matrix and applying per-quadrant actions, to automating the workflow and tracking a 90-day GP lift.

Manual spreadsheet processes cannot keep pace with the speed at which supplier prices move in 2026. Jelly connects invoice costs and POS sales data in real time, so analysis that once took days of admin runs continuously in the background. The result is faster decisions, protected margins, and a clear view of exactly which three dishes to act on this week.

Book a demo and see how Jelly delivers the GP lift described above.