How to Quickly Spot Unprofitable Menu Items & Boost Profits

How to Spot Unprofitable Menu Items in Under an Hour

Written by: JJ Tan, Founder, Jelly | Last updated: 3 August 2026

Key Takeaways for UK Operators

  • Contribution margin is menu price (ex-VAT) minus portion cost from live supplier invoices, and UK operators typically target 65–75% gross profit per dish.
  • This seven-step process uses 30-day POS data and scanned invoices inside Jelly to classify every dish as Star, Plowhorse, Puzzle or Dog in under an hour.
  • Dogs should be removed or reformulated, and Plowhorses need repricing or ingredient swaps to stop margin erosion on high-volume items.
  • Price Alerts notify you the same week any supplier cost changes, so a Star does not quietly become a Plowhorse without your knowledge.
  • Book a demo and see the full process live in Jelly at schedule a chat.

Fast Menu Engineering Using Live Data

The menu engineering matrix, originally developed by Kasavana and Smith at Michigan State University in 1982, plots every dish by contribution margin and popularity. Running it manually takes hours. The seven steps below compress that work into under one hour by using live POS and invoice data inside Jelly.

Step 1 — Export 30 Days of POS Sales Data

Pull item-level sales counts for the last 30 consecutive days from your POS. Shorter periods are distorted by random events or seasonality, so 30 days is the minimum reliable window. Jelly connects to your POS through a real-time API, setup takes about five minutes, and item-level data appears the moment each transaction completes.

Step 2 — Import Scanned Invoices into Jelly

Photograph or email every supplier invoice to Jelly. The platform scans every line item, including quantity, SKU, price and tax, so ingredient costs stay current without manual data entry. Amber restaurant in East London has used this automated invoice processing since 2020, saving £3,000–£4,000 per month through tighter cost control.

Step 3 — Map Ingredients to Dishes

In Jelly’s Kitchen section, build or confirm each dish recipe by clicking on ingredients already populated from scanned invoices. Jelly handles all unit conversions and yield adjustments automatically. Work that previously took 28 minutes per dish in a spreadsheet now takes about three minutes in Jelly.

Step 4 — Calculate Contribution Margins

Contribution margin per dish equals menu price (ex-VAT) minus portion cost from live invoices. Contribution margin percentage equals (menu price − plate cost) ÷ menu price × 100. Jelly updates ingredient costs with every new invoice, so every dish margin stays live. The table below demonstrates how four common UK dishes fall into different matrix quadrants based on their actual margins and popularity, and the Beef Burger row shows a classic Plowhorse pattern where high volume hides a below-target 60% margin.

Dish Menu Price (ex-VAT) Portion Cost Contribution Margin CM % Matrix Quadrant
Grilled Sea Bass £22.00 £7.70 £14.30 65% Star
Beef Burger £14.00 £5.60 £8.40 60% Plowhorse
Truffle Risotto £18.00 £5.40 £12.60 70% Puzzle
Chicken Caesar Salad £12.00 £5.40 £6.60 55% Dog

Step 5 — Plot the Four-Quadrant Matrix

Calculate your menu’s average contribution margin and average popularity threshold. The popularity threshold equals (1 ÷ number of menu items) × 0.70, so on a 20-item menu that is 3.5% of total units sold. Plot every dish on the matrix. Above-average margin and popularity equals Star. Below-average margin and above-average popularity equals Plowhorse. Above-average margin and below-average popularity equals Puzzle. Below-average on both equals Dog.

Step 6 — Flag Dogs and Plowhorses for Immediate Action

Dogs are candidates for removal or reformulation. Plowhorses are volume sellers that erode margin. Repricing a Plowhorse or replacing a Dog can improve overall profitability and reduce kitchen complexity.

Step 7 — Set Price Alerts in Jelly

Activate Jelly’s Price Alert feature for every key ingredient. Any supplier price movement triggers an immediate notification, so a dish that was a Star on Monday does not become a Plowhorse by Friday without your knowledge.

See the seven-step process live in a demo with your own POS data.

Using Price Alerts to Negotiate with Suppliers

Annual foodservice inflation in the UK stood at 2.9% year-on-year in June 2026, with fish prices rising 2.7% month-on-month, meat and poultry up 2% month-on-month, and coffee, tea and cocoa up 1.8% month-on-month. These figures hit dish-level contribution margins directly and compound every week.

Jelly’s Price Alert feature surfaces every increase and decrease in the same week it appears on an invoice. That data gives chefs and operators the evidence to call a supplier, request a credit note, or switch to an alternative source before the margin damage builds. Sushi Revolution in South London uses Jelly to set separate gross profit targets for dine-in and delivery menus, accounting for 30% delivery commissions, and consistently achieves actual gross profits 2–3% above target. Their monthly stocktake now takes 5–20 minutes, down from 2–3 hours previously.

The practical sequence when a Price Alert fires follows a simple flow.

  1. Identify which dishes use the affected ingredient, because this shows the scope of the margin impact.
  2. Check whether the margin drop moves any Star into Plowhorse territory, since high-volume dishes cause the greatest damage when costs rise.
  3. Contact the supplier with the invoice evidence to negotiate a credit note or better rate, using Jelly’s data as concrete proof of the increase.
  4. If the supplier cannot hold the price, adjust the menu price or substitute the ingredient before the next service, so margin erosion does not compound over multiple weeks.

Monthly Review Cadence for £500k+ Sites

Quarterly is the minimum recommended frequency for a full menu engineering review, with an immediate review triggered whenever food cost percentage rises above target. Operators with volatile ingredient categories such as fish, meat and cocoa benefit from a tighter cadence.

A practical cadence for £500k+ UK operators looks like this.

  • Monthly: Rerun the matrix for your top 10 dishes. These dishes often drive a substantial proportion of food revenue and face the most ingredient volatility.
  • Quarterly: Run a full matrix across the entire menu, recalculate food costs, and adjust Plowhorse pricing.
  • Immediately: Rerun affected dishes any time a supplier price movement exceeds 10% on a key ingredient, or after any new dish launch.

With Jelly, the monthly top-10 review takes under 30 minutes because invoice costs and POS sales data are already live. As noted with Sushi Revolution earlier, the monthly top-10 review fits into a short session because the heavy lifting on stock and pricing already happens in Jelly.

Common Menu Engineering Mistakes

Three recurring pitfalls consistently erode gross profit for operators who run menu engineering manually.

  1. Stale costs. Spreadsheet recipe costs are updated infrequently, so a dish costed at £4.20 in January may cost £5.10 by June after successive supplier increases. Jelly removes this risk by updating every dish cost automatically when a new invoice is scanned.
  2. Missing refunds in POS exports. Discounts and refunds applied at the transaction level can inflate apparent sales volume for a dish and misclassify a Dog as a Plowhorse. Jelly processes all discount and refund calculations at the individual line level, which keeps margin data clean.
  3. Spreadsheet drift. Multiple team members editing different versions of a costing sheet produce conflicting figures. A single Jelly account gives owners, finance managers and chefs one live source of truth, and management can view insights directly without relying on manual reports.

Advanced Tips for Delivery and Multi-site Operators

Delivery menu costing. A dish priced at £14 on the dine-in menu generates a very different contribution margin on a delivery platform that charges 30% commission. Contribution margins usually run lower on delivery orders because of these commissions. Jelly’s Delivery Menu Creation feature lets operators duplicate existing dishes, factor in commission overheads, and set a separate, profitable delivery price.

Multi-site roll-outs. Jelly charges a flat £129 per month per location with no per-user fees, which makes it straightforward to replicate the same matrix process across two to five sites. Each site’s POS connects independently, so operators can compare Stars and Dogs across locations and standardise the highest-margin dishes.

POS integration setup. Connecting your supported POS takes about five minutes. Open Jelly, click Integrations, sign in to the POS, grant permissions, and select which categories to sync. The only common friction point is lacking admin access to the POS account, and Jelly flags this requirement upfront.

See your POS connect in real time during a live demo.

Frequently Asked Questions

How often should I rerun the matrix?

Run a full matrix across your entire menu every quarter. Run a focused review of your top 10 dishes every month, because these dishes usually account for most food revenue and face the greatest ingredient cost swings. Trigger an immediate review any time a supplier price moves more than 10% on a key ingredient, or when you launch a new dish. With Jelly keeping invoice costs and POS sales data live, the monthly top-10 review takes under 30 minutes instead of the 4–6 hours a manual setup requires.

Who should own the monthly review?

The most effective arrangement uses a joint owner between the Head Chef and the Operations or Finance Manager. The chef owns recipe accuracy and ingredient substitution decisions. The finance or operations lead owns pricing decisions and supplier negotiations. Jelly gives both roles direct access to the same live data and removes friction when management lacks a chef background and previously relied on manually compiled reports.

What happens with seasonal menus?

Cost seasonal dishes in Jelly before they go live, using the most recent invoice prices for seasonal ingredients. Run a mini matrix review at the start of each seasonal menu change rather than waiting for the next quarterly cycle. Seasonal ingredients, particularly fish and produce, sit among the most volatile cost categories in UK foodservice, so Price Alerts are especially valuable here. Any mid-season supplier price movement triggers an immediate notification, so you can reprice or substitute before margin erosion compounds.

How does this affect gross profit?

Identifying and acting on Dogs and Plowhorses has a direct and measurable impact on gross profit. Removing a low-margin, low-volume Dog reduces kitchen complexity and frees labour for higher-margin dishes. Repricing a Plowhorse, or introducing a premium variant, converts high-volume sales into higher-margin sales. Jelly customers see gross margins increase by an average of two percentage points in the first three months, and operators such as The Howard Arms have reached 80% gross profit after previously being told 60% was the ceiling. The compounding effect of monthly reviews, live cost updates and immediate supplier action on Price Alerts sustains that improvement over time rather than delivering a one-off gain.

Conclusion: Protect Your Margins Today

The seven-step process of exporting 30-day POS data, importing scanned invoices, mapping ingredients to dishes, calculating contribution margins, plotting the four-quadrant matrix, flagging Dogs and Plowhorses, and setting Price Alerts gives UK operators a repeatable, sub-one-hour method to identify unprofitable menu items using live data instead of stale spreadsheets. With the inflation pressures detailed earlier, the cost of running this process only quarterly, or not at all, appears as silent gross profit erosion that compounds every week.

Jelly keeps invoice costs, dish margins and Price Alerts live so the matrix never goes out of date. Operators like Amber, mentioned in Step 2, demonstrate the sustained savings possible with this approach. The same process applies to any £500k+ restaurant, pub or boutique hotel ready to move from manual costing to automated margin control.

Run your first live matrix in under an hour with a demo.