Written by: JJ Tan, Founder, Jelly
Key Takeaways
- Food cost percentage uses this formula: (COGS ÷ net-of-VAT food sales) × 100, where COGS equals opening stock plus purchases minus closing stock.
- Accurate results depend on four inputs: a full stocktake, supplier invoices, net-of-VAT sales figures, and current recipe costs.
- UK operators must always use VAT-exclusive sales figures, because gross prices understate the true food cost percentage.
- Recipe-level plate costing follows the same logic: total dish cost divided by net selling price, multiplied by 100, with yield adjustments.
- Jelly automates invoice scanning, stock valuation, and dish costing so UK operators always work from current, accurate food cost data.
See Jelly in Action for Your Kitchen
Before You Begin Your Food Cost Calculation
Accurate food cost percentage starts with four inputs prepared in advance.
- A stocktake sheet recording opening and closing stock values for the period
- Supplier invoices for all food deliveries received during the period
- Food sales figures from the POS or till, net of VAT, discounts, and voids
- Recipe and ingredient data for any single-dish plate cost calculations
Ownership typically sits with the owner, finance manager, or head chef, and the kitchen and finance teams both feed into it. How often you run the calculation depends on the format. High-volume or thin-margin operations should run the period calculation weekly, while most sites can manage monthly. The single-dish calculation follows a different rhythm and should be revisited whenever a recipe changes or a supplier invoice arrives with a new price.
Cut Admin Time on Stock and Invoices
Why Accurate Food Cost Percentage Matters
Most operators get the formula right and the inputs wrong. A two-point swing in food cost percentage on £1 million of sales equals £20,000 of pretax profit, which often separates a healthy year from a break-even one. Calculating on stale stock values, gross sales figures, or outdated ingredient prices produces a number that looks plausible yet does not support confident decisions.
Getting the inputs right is what makes the number usable. You can see your margin clearly, react to a supplier price change within days rather than at month-end, and compare sites on the same basis. A one-percentage-point improvement in food cost on £1 million of annual food sales adds £10,000 to the bottom line without changing a menu price or adding a cover.
Find Hidden Margin in Your Current Menu
The Food Cost Percentage Formula
The core formula stays the same across formats.
Food Cost % = (Cost of Goods Sold ÷ Food Sales) × 100
The period COGS formula:
COGS = Opening Stock + Purchases − Closing Stock
The single-dish formula:
Plate Cost % = (Total Dish Cost ÷ Menu Selling Price) × 100
Each formula is self-contained. COGS is calculated first, then divided by net-of-VAT food sales. The plate cost formula operates independently at recipe level and does not require a stocktake.
The four steps below walk through the period calculation from opening stocktake to final percentage.
How to Calculate the Food Cost Percentage Step by Step
Step 1: Record Opening Stock
Objective: Establish the value of all food stock at the start of the period.
Action: Conduct a physical stocktake of every storage area, including walk-in fridges, freezers, dry stores, and prep areas. Value each item at the price actually paid, not the menu price.
Inputs: Stocktake sheet and supplier invoices for valuation reference.
Success looks like: A complete, dated stocktake sheet with every storage area counted. Count at the same time on the same day each period, ideally after close and before any deliveries arrive.
Step 2: Add Purchases
Objective: Capture all food deliveries received during the period.
Action: Total supplier invoices for food items received. Focus on what arrived on site, not what was ordered or paid. Subtract any returns or credit notes.
Inputs: Supplier invoices and delivery notes.
Success looks like: A purchases figure that matches deliveries received, net of returns and credits. Purchases must be recorded at the actual invoiced price rather than the contracted price, because supplier surcharges or higher-priced substitutions must be reflected in the P&L.
Step 3: Subtract Closing Stock to Get COGS
Objective: Calculate the value of food consumed in service.
Action: Conduct a closing stocktake using the same method as the opening count. Subtract the closing stock value from the sum of opening stock and purchases.
Inputs: Closing stocktake sheet.
Success looks like: COGS = Opening Stock + Purchases − Closing Stock. A stocktake wrong by 3% in either direction can swing a restaurant’s COGS percentage by a full point, and a single inaccurate stocktake contaminates two months of data because the current month’s closing stock becomes next month’s opening stock.
Step 4: Divide by Food Sales and Multiply by 100
Objective: Express COGS as a percentage of food sales.
Action: Divide COGS by net-of-VAT food sales, then multiply by 100.
Inputs: POS food sales figures, net of VAT.
Success looks like: A food cost percentage calculated on a like-for-like basis that you can compare to benchmarks and track across periods.
Worked GBP Example: Period Calculation
The table below applies the four steps to a single September period so you can see how stock and sales flow into the final percentage.
| Line Item | Amount |
|---|---|
| Opening Stock (1 September) | £8,500 |
| Purchases (September) | £22,000 |
| Closing Stock (30 September) | £7,800 |
| COGS | £22,700 |
| Food Sales (net of VAT) | £68,000 |
| Food Cost % | 33.4% |
The VAT Point for UK Menus
In the UK, consumer-facing menu prices are VAT-inclusive by law, so the price printed on the menu already contains the standard 20% VAT. Food cost percentage must be calculated against the VAT-exclusive portion of revenue. Using the VAT-inclusive sticker price directly understates the true food cost percentage, and the operator overestimates margin.
HMRC confirms that restaurant and hot takeaway food sales are standard-rated at 20% VAT, meaning gross food sales include a VAT element that is not turnover. To remove standard-rate VAT from a gross figure, divide the gross total by 1.20, so £81,600 of gross food sales becomes £68,000 of net food sales. Subtracting 20% directly from the gross figure gives the wrong answer.
See How Jelly Handles VAT-Exclusive Costing
How to Calculate Food Cost for a Recipe
Recipe-level costing uses the plate cost formula to set the margin for each dish.
Plate Cost % = (Total Dish Cost ÷ Menu Selling Price) × 100
To cost a dish, list every ingredient in one standard portion and derive each ingredient’s unit cost from the latest supplier invoice. Multiply the quantity used by that unit cost for each line. Include small or “invisible” items such as cooking oils, garnishes, seasoning and sauces, because each is minor but the cost adds up over hundreds of servings.
Yield affects the real cost of many ingredients. A yield factor accounts for trim, bones, peels and cooking shrink that never reach the plate. If an ingredient yields 85% usable after prep, its raw cost is divided by 0.85 to get the true cost of what reaches the plate. Ignoring yield systematically understates every protein dish on the menu.
The menu selling price used in the formula must be net of VAT. A dish listed at £10.20 on the menu has a net selling price of £8.50 (£10.20 ÷ 1.20).
Worked GBP Example: Single Dish
Costing a single chicken burger shows how individual ingredient costs add up to a plate cost percentage.
| Ingredient | Cost |
|---|---|
| Chicken breast (180g) | £1.45 |
| Burger bun | £0.35 |
| House sauce (30ml) | £0.22 |
| Garnish and salad | £0.38 |
| Total Dish Cost | £2.40 |
| Menu Selling Price (net of VAT) | £8.50 |
| Plate Cost % | 28.2% |
This calculation is distinct from the period food cost calculation. Plate cost sets the theoretical margin for a single dish. The period calculation reveals whether that margin is being achieved in practice.
Keep Every Dish Cost Up to Date
Food Cost Percentage Formula in Excel
A basic period calculation spreadsheet uses three input rows and two formula cells.
- COGS cell:
=B1+B2-B3(opening stock + purchases − closing stock) - Food cost % cell:
=(B4/B5)*100(COGS ÷ net food sales × 100)
A recipe costing sheet needs columns for ingredient name, pack size, pack price, unit cost (pack price/pack size), recipe quantity, and extended cost (unit cost × recipe quantity). The sum of the extended cost column is the plate cost. Divide by the net selling price and multiply by 100 for the plate cost percentage.
Common spreadsheet mistakes that distort results include several recurring patterns.
- Spreadsheet version drift: Multiple copies of the same template across sites or team members produce inconsistent results that cannot be compared.
Those issues all stem from manual inputs. The table below shows where a manual spreadsheet stops being workable and where Jelly keeps data current through automation.
| Method | Setup Time | Price Update | Accuracy |
|---|---|---|---|
| Manual spreadsheet | Immediate | Manual | Prone to drift |
| Jelly | First week | Automatic via invoice scanning | Real-time |
Replace Spreadsheets with Automatic Invoice Scanning
Ideal Food Cost Percentage for UK Venues
Trade sources quote typical UK food cost percentage ranges by format.
- Full-service restaurants: 28–35%
- Gastropubs: 30–35%
- Fine dining: 26–32%
- Fast casual: 28–33%
- Café and coffee shop: 20–28%
These figures act as benchmarks rather than fixed targets. Below 28% may suggest under-portioning or unusually aggressive pricing. Above 35% points to a margin problem from over-ordering, waste, portion drift, or pricing that has not kept pace with supplier costs. The right target is the one the financial model requires for that specific concept.
Food cost percentage and gross profit margin are arithmetic inverses, so a 30% food cost equals a 70% food GP margin. Most full-service venues should run 60–70% blended GP across combined food and drink, and consistently below 60% indicates structural margin pressure regardless of how full the room is.
Check Your Targets Against UK Benchmarks
Common Mistakes and Troubleshooting
- Using gross instead of net sales: Understates food cost percentage. Correct by dividing gross food sales by 1.20 before using the figure as the denominator.
- Omitting opening stock: Dividing purchases by sales is purchase cost, not food cost, and the two are only equal if stock levels did not change, which they almost never do.
- Stale ingredient prices: Recipe costs become inaccurate as soon as a supplier invoice changes. Update when invoices arrive, not quarterly.
- Ignoring wastage: According to WRAP research, hospitality food waste typically arises 45% during preparation, 34% from customer plates and 21% from spoilage. Waste not recorded separately inflates closing stock and makes food cost appear lower than it is.
- Mixing food and beverage sales: Including beverage revenue in the denominator artificially lowers food cost percentage because drink cost typically runs 18–24%, which can hide a real food cost problem.
- Treating a single period as a trend: One late delivery counted in the wrong period, or a large catering order that lands across a count date, can distort a result without signalling any real problem. Review three periods before acting on a structural change.
Stabilise Your Food Cost Numbers
How to Measure Success
A correctly calculated food cost percentage rests on three things. It is built on net-of-VAT food sales. Its COGS comes from a proper stocktake using consistent timing and valuation. Its ingredient prices reflect the most recent supplier invoices.
Directional indicators that the process is working include several practical signs.
- Reduced admin time spent reconciling invoices and stocktake sheets
- Fewer invoice discrepancies caught late or missed entirely
- Faster reaction to supplier price changes, within days rather than at month-end
- Clearer margin tracking across sites, with per-location figures rather than a blended average that masks outliers
Stuart Noble, Head Chef at Cairn Lodge Hotel, on using Jelly: “Price hikes were crushing our margins — I felt helpless. With Jelly, every dish cost is up-to-date at my fingertips. We slashed food costs by 5% in a month — it’s a game changer!”
See How Operators Like You Cut Food Cost
Advanced Tips and Next Steps
Multi-site operators need per-venue food cost percentages rather than a single blended figure. A blended 32% across three locations could mask one site running at 40% and dragging down two well-managed kitchens. Stock transferred between sites is neither a purchase nor a sale and must be handled as an internal transfer at both locations to avoid inflating one site’s purchases.
Standardising recipe costing across sites ensures that theoretical food cost is calculated on the same basis everywhere, which makes variance analysis meaningful. When a supplier raises a price, the impact on every dish using that ingredient becomes visible immediately rather than surfacing weeks later in a monthly report.
That visibility also changes supplier negotiations, as one operator found. Murat Kilic, Chef-Owner at Amber restaurant in East London, saves £3,000–£4,000 per month through credits, better buying, and tighter menu controls, driven by real-time price alerts that surface changes the same week they happen.
Jelly automates the invoice scanning, stock valuation, and dish costing that sit behind the formula. Ingredient prices update with every new invoice, dish margins update in real time, and the Price Alert feature flags every supplier price movement before it compounds across weeks of trading. What used to take 28 minutes to cost a single menu item takes 3 minutes in Jelly’s Kitchen section.
Scale Food Cost Control Across All Your Sites
Frequently Asked Questions
How Do I Calculate Food Cost for a Recipe?
List every ingredient in one standard portion, including garnishes, sauces, and cooking oils. Derive each ingredient’s unit cost from the latest supplier invoice. Apply a yield factor for any ingredient that loses weight during prep or cooking by dividing the raw cost by the usable yield percentage to get the true cost per usable unit. Multiply each ingredient’s adjusted unit cost by the quantity used in the recipe, then sum all lines to get the total dish cost. Divide by the menu selling price net of VAT and multiply by 100. Using the worked example above, the £2.40 dish at £8.50 net returns 28.2%.
Is There a Free Food Cost Calculator for Excel?
Basic templates are available and can be built quickly using the formulas described in this guide. The limitation is that they require manual data entry for every invoice and do not update automatically when supplier prices change. A template built today will drift from reality within weeks unless someone updates every affected ingredient cost each time a new invoice arrives. Jelly automates the inputs behind the formula, so ingredient costs update with every scanned invoice and dish margins stay current without manual effort.
How Do I Make a Food Cost Spreadsheet?
For the period calculation, create rows for opening stock, purchases, and closing stock. Add a COGS row calculated as opening stock plus purchases minus closing stock. Add a food cost percentage row calculated as COGS divided by net-of-VAT food sales, multiplied by 100. For recipe costing, create columns for ingredient name, pack size, pack price, unit cost (pack price divided by pack size), recipe quantity, yield percentage, adjusted unit cost (unit cost divided by yield), and extended cost (adjusted unit cost multiplied by recipe quantity). Sum the extended cost column for total dish cost, then divide by the net selling price and multiply by 100.
What Is the Target Food Cost Percentage for Menu Pricing?
The UK ranges quoted earlier — 28–35% for full-service, 30–35% for gastropubs, 26–32% for fine dining — are trade benchmarks rather than surveyed figures, and the right target depends on the concept, check average, and the financial model. To back-solve a menu price from a target food cost, use: Price = Dish Cost ÷ Target Food Cost %. A dish costing £2.40 at a 30% target requires a net selling price of £8.00. The VAT-inclusive menu price would then be £8.00 × 1.20 = £9.60.
Conclusion: Keep Your Food Cost Formula Reliable
The food cost percentage formula stays simple: COGS divided by net-of-VAT food sales, multiplied by 100. COGS comes from opening stock plus purchases minus closing stock. At recipe level, plate cost percentage is total dish cost divided by net selling price, multiplied by 100.
Most UK operators run into trouble on the inputs, such as using gross sales instead of net, skipping opening stock, or letting ingredient prices drift from the last invoice. Correcting those inputs produces a number that matches benchmarks, tracks cleanly across periods, and supports action before problems compound.
Jelly automates the invoices, stock, and dish costing behind the formula, so the number stays current, accurate, and ready when you need it.
Get a Personal Walkthrough of Jelly
