Written by: JJ Tan, Founder, Jelly | Last updated: 14 October 2026
Key Takeaways
- Food cost percentage shows how much of each food pound goes on ingredients. Calculate it as ingredient cost divided by ex-VAT selling price.
- UK supplier prices move fast, with the Foodservice Price Index at 154.1 and food inflation forecast to reach 9% by late 2026, so regular recalculation protects margins.
- The correct formula uses ex-VAT selling prices on both sides. Strip VAT from standard-rated items by dividing by 1.2 to avoid understating food cost percentage.
- Benchmarks vary by concept. Full-service restaurants often target 28–35%, gastropubs 30–35%, fine dining 26–32%, and quick service 20–28%.
- Jelly scans invoices, updates ingredient costs in real time, and keeps GP margins live, so UK operators maintain accurate food cost percentages without spreadsheets.
The Problem: Why Food Cost Percentage Decays In UK Hospitality
Food cost percentage measures the share of food sales revenue that ingredient costs consume. It directly sets gross profit margin. In UK hospitality, where supplier prices move weekly, a food cost percentage that looked healthy last month can quietly turn loss-making this month.
The UK Foodservice Price Index reached 154.1 in August 2026, with annual inflation at 2.7%. The Food and Drink Federation expects food inflation to reach at least 9% by the end of 2026, driven by energy costs, an 80% surge in red diesel, and global shipping disruption. UK beef production is forecast to decline by 1.3% year on year, North Sea cod quotas have fallen by 44%, and whole-bird poultry costs have risen between 5% and 10%, influenced by Avian Influenza and welfare rules.
A food cost percentage calculated once is a snapshot, and supplier prices change weekly. Without a system that updates ingredient costs automatically, margins decay silently, so the calculation has to be repeated, not filed away. There is a second trap as well. The selling price in the formula must be ex-VAT, or the percentage is wrong from the start. VAT treatment appears in detail below.
Core Formulas For Calculating Food Cost Percentage
UK operators use three main food cost percentage formulas, depending on whether they are costing a dish, setting a price, or reviewing a period.
Per-Dish Food Cost Percentage: (ingredient cost per dish ÷ ex-VAT selling price) × 100. Example: a pub main with beef, potatoes, and vegetables costs £3.50 in ingredients and sells for £14.00 ex-VAT. Food cost percentage = (£3.50 ÷ £14.00) × 100 = 25%.
Target Pricing Formula: ex-VAT selling price = ingredient cost ÷ target food cost percentage. Example: if ingredient cost is £3.50 and the target food cost is 30%, ex-VAT selling price = £3.50 ÷ 0.30 = £11.67.
Period Stock Formula: (opening stock + purchases − closing stock) ÷ food sales × 100. Example: opening stock £4,000 + purchases £3,600 − closing stock £3,800 = £3,800 cost of sales. Food sales £12,000. Food cost percentage = (£3,800 ÷ £12,000) × 100 = 31.7%.
All three formulas use ex-VAT figures on both sides. Food cost percentage is calculated as cost of sales divided by food sales multiplied by 100, using ex-VAT figures on both sides.
UK Food Cost Percentage Benchmarks By Business Type
Benchmarks give a starting point for UK hospitality, and the ranges vary by business type.
- Full-service restaurants: 28–35% food cost
- Gastropubs: 30–35%
- Fine dining: 26–32% in MenuPricer’s UK guide, with some sources citing higher ranges
- Catering and events: 25–35%
- Quick service and fast food: 20–28%
A pub with a wet-led sales mix will show a different profile from a food-led restaurant, even at the same food cost. The 2022 UKHospitality/Christie & Co Benchmarking Report found pub food GP averaged 66.0%, implying an approximate food cost of 34%. Treat these UK benchmarks as starting points and track your own weekly. For fine dining, a food cost above 40% is the warning zone, while full-service casual dining warns above 35%, fast casual above 33%, and catering and food trucks above 38%.
Delivery-heavy operations face a different margin picture. Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery commissions, and achieves actual gross profits 2–3% higher on average.
UK VAT Rules That Affect Food Cost Percentage
Accurate food cost percentage in the UK depends on using ex-VAT selling prices. HMRC’s method for stripping standard-rate VAT out of a gross price is to divide the VAT-inclusive price by 1.2.
HMRC’s food VAT guidance distinguishes zero-rated food products from standard-rated exceptions, so operators should avoid a blanket VAT rate for every food item. However, food served for consumption on restaurant, pub, or café premises is generally standard-rated at 20%, even if the same item would be zero-rated in a supermarket.
To strip VAT from a selling price at the standard 20% rate, use this formula: ex-VAT selling price = VAT-inclusive selling price ÷ 1.2. Example: a dish sold at £12.00 inc VAT has an ex-VAT selling price of £10.00. If ingredient cost is £3.00, food cost percentage = (£3.00 ÷ £10.00) × 100 = 30%.
Using the VAT-inclusive sticker price directly understates the true food cost percentage. A dish that appears to run at 25% food cost against the inc-VAT price actually runs at 30% against the ex-VAT price. That gap creates false confidence and underpriced menus. Whether cost of sales is calculated including or excluding VAT can make a pub’s GP% appear off by several points without any operational issue. Divide by 1.2 before calculating food cost percentage on standard-rated supplies.
Basic unprocessed foodstuffs such as many meats, fish, fruit, vegetables, cereals, flour, bread, and milk products can qualify for zero rating when sold in qualifying circumstances. A zero-rated purchase has no input VAT to reclaim, so its net cost equals the full invoice amount. Operators with mixed sales profiles should separate standard-rated and zero-rated revenue before calculating food cost percentage.
How To Calculate Food Cost Percentage In Excel
Excel can handle basic food cost percentage calculations when menus and sites remain small.
A simple Excel setup uses this column structure:
- Column A: Ingredient
- Column B: Pack cost
- Column C: Pack size
- Column D: Quantity used
- Column E: Calculated cost (formula: =(B2/C2)*D2)
Sum the ingredient costs into a dish cost cell, then calculate food cost percentage with: =dish cost / ex-VAT selling price.
The limitations grow quickly. Static recipe spreadsheets lag behind supplier price changes, so dish costs and margins rely on historic prices, and manual re-costing time balloons as recipes and ingredients increase. A dish that was profitable last week can be loss-making today, and Excel will not show the change until every ingredient cost is updated by hand. One mid-sized restaurant group ran at a 38% food cost for six weeks before its spreadsheet-based reconciliation caught the issue.
For multi-site operators, the problem compounds. A finance director at a six-location casual dining group spends the first two days of every week opening six spreadsheets, pulling purchase data from each branch, cross-referencing POS sales, and manually calculating food cost percentage per site, consuming nine hours of finance time per week.
See how Jelly replaces the spreadsheet
Is There A Free Food Cost Calculator For UK Restaurants?
Free web calculators and mobile apps help with one-off dish costing. A free calculator can work for single-site operators with stable supplier prices and manual invoice entry. It fails once multiple suppliers, weekly price changes, multi-site operations, or live margin tracking enter the picture.
The table below shows why free calculators and spreadsheets stop working as soon as supplier prices change or a second site opens, and how an automated system handles those cases.
| Metric | Free Calculator | Spreadsheet | Jelly |
|---|---|---|---|
| Updates With Supplier Price Changes | No | Manual | Automatic |
| Multi-Site Support | No | Limited | Yes |
| POS Integration | No | No | Yes |
| Invoice Scanning | No | No | Yes |
Jelly scans every invoice line item, updates ingredient costs in real time, and recalculates live dish GP margins, so food cost percentage stays current without spreadsheet work. That data has to come from somewhere, which is why Jelly integrates with Square, Epos Now, Toast, and Lightspeed for POS, and Xero for accounting. Pricing is a flat £129/month per location, with initial value typically generated in the first week of onboarding.
Keeping Food Cost Percentage Accurate As Prices Change
Food cost percentage behaves as a live metric that decays the moment a supplier changes a price. A practical workflow runs like this: invoice arrives → line-item prices captured → ingredient costs updated → dish costs and GP margins recalculated → alerts flag margin drops.
Jelly automates this full workflow. Invoices arrive by email or photo, every line item is digitised, and the Price Alert feature flags each supplier price increase or decrease. Jelly’s Price Alert feature provides real-time insight into ingredient price changes, supporting pricing decisions, supplier switches, or better deals. Murat Kilic, Chef-Owner of Amber in East London, has used Jelly since 2020 and saves £3,000–£4,000 per month through credits, better buying, and tighter menu controls.
Jelly’s Flash Report gives daily, weekly, or monthly GP margin visibility. Sales Mix then turns that into menu engineering by showing which dishes are most popular and which are most profitable, so you can compare them side by side. Jelly users cut food costs by about 3% on average in the first three months and add roughly two percentage points to gross margins. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue.
For more detail by concept, see the guide to maintaining a 28–35% food cost for pubs, the UK food cost percentage calculator for restaurants, and the hotel food cost percentage formula step-by-step guide.
Get live margin alerts for your menu
Frequently Asked Questions
How Do You Calculate 30% Food Cost?
Use the target pricing formula. Ex-VAT selling price = ingredient cost ÷ 0.30. If ingredient cost is £3.00, the required ex-VAT selling price is £10.00. Divide any VAT-inclusive menu price by 1.2 first so the calculation uses ex-VAT figures, as shown in the VAT section above.
What Is The Ideal Food Cost Percentage For UK Hospitality?
The ideal range depends on concept and sales mix. Full-service restaurants often sit around 28–35%, while quick service tends to run lower at 20–28%. The benchmarks table above sets out the full picture. The key point is to track your own food cost weekly and set targets that reflect your labour model and overheads.
Do Free Food Cost Calculators Handle Multiple Suppliers?
Free calculators work for a one-off dish costing on a single site. As the comparison table shows, they do not update when supplier prices change or connect invoice data to dish costs. They also lack integrations with POS and accounting systems, so they cannot keep margins live across multiple suppliers or locations.
What Is The Main Limitation Of Calculating Food Cost In Excel?
The Excel setup described above works technically, but every ingredient cost must be updated manually whenever a supplier changes a price. That workload becomes unmanageable once menus grow, prices move weekly, or more than one site is involved.
How Does Jelly Keep Food Cost Percentage Accurate Automatically?
Jelly captures supplier invoices by email or photo and digitises every line item without manual data entry. That includes quantity, SKU, price, and tax. When a supplier changes a price, the Price Alert feature flags it immediately. Because ingredient costs update with every new invoice, the gross profit margin for every dish in the Cookbook stays live. The Flash Report then provides daily, weekly, or monthly GP visibility from invoice costs and POS sales data. Jelly integrates with Square, Epos Now, Toast, and Lightspeed for item-level sales data, and with Xero for accounting. Setup usually takes under a week, and operators often see meaningful GP improvements within the first three months.
Conclusion
Food cost percentage functions as a live metric that decays the moment a supplier changes a price. UK operators need the right formulas, correct VAT treatment, realistic benchmarks for their concept, and a workflow that keeps the number current as invoices land.
Jelly gives UK hospitality operators automated invoice scanning, real-time dish costing, and live GP margins without spreadsheet overhead. At £129/month per location with no per-user charges, it suits growing restaurants, pubs, and boutique hotels that want tight operational control across one site or many.
