Written by: JJ Tan, Founder, Jelly
Key Food Costing Takeaways for UK Caterers
- Rising supplier prices and 3.1% fresh food inflation squeeze UK caterers, so accurate food costing now directly protects margin.
- A structured four-tab template calculates ingredient costs, recipe margins, event pricing, and flags weak dishes against the 28–35% UK benchmark.
- Common spreadsheet mistakes, such as outdated prices, skipped yield calculations, and missing waste buffers, can quietly remove several points of gross margin.
- As operations grow, spreadsheets demand 10–20 hours of manual updates each month and create blind spots in pricing decisions.
- Ready to replace manual spreadsheets with live, automated margins? See how Jelly automates your food costing in a 15-minute walkthrough.
Food Costing Basics for Caterers
Food costing calculates the exact ingredient cost of every dish or event menu, expresses it as a percentage of the selling price, and uses that figure to set prices that protect gross margin. A £15 main course with £5 in ingredients carries a 33% food cost, which means one third of every pound of revenue goes straight back to the supplier.
| Formula | Calculation | UK Benchmark |
|---|---|---|
| Usable Unit Cost | Package Cost ÷ (Package Size × Yield %) | — |
| Ingredient Cost | Quantity Used × Usable Unit Cost | — |
| Total Recipe Cost | Sum of all Ingredient Costs | — |
| Cost Per Serving | Total Recipe Cost ÷ Number of Portions | — |
| Suggested Price | Cost Per Serving ÷ Target Food Cost % | 28–35% of revenue |
Download Your Free Food Costing Template for Caterers
The template below uses four tabs that work together to hit the UK benchmark food cost of 28–35% of revenue. Make a copy in Google Sheets and adapt it to your supplier prices and event formats.
→ Click here to copy the free Google Sheets food costing template for caterers
- Tab 1 – Ingredient Master: Stores every ingredient, supplier, pack size, pack cost, yield percentage, and usable unit cost in one place.
- Tab 2 – Recipe Costing: Builds any dish by pulling ingredients from Tab 1, then calculates total recipe cost, cost per portion, and food cost percentage automatically.
- Tab 3 – Event Calculator: Uses guest count and menu selection to output total food cost, per-head cost, and a suggested event price at your chosen margin.
- Tab 4 – Margin Matrix: Summarises every recipe’s food cost percentage and GP, colour-coded against the 28–35% target so weak dishes stand out immediately.
Ready to replace the template with live, invoice-driven margins? Chat with the Jelly team about your operation and see the system in action.
How the Food Costing Template Works in Excel
The same four-tab structure works in both Google Sheets and Microsoft Excel, using identical logic and formulas. Here is how each tab functions with real formulas.
Tab 1 – Ingredient Master
| Column | Input / Formula | Example |
|---|---|---|
| Pack Cost (£) | Manual entry from invoice | £14.00 |
| Pack Size (kg) | Manual entry | 5 kg |
| Yield % | Manual entry | 80% |
| Usable Unit Cost (£/kg) | =Pack Cost ÷ (Pack Size × Yield %) | £3.50/kg |
Tab 2 – Recipe Costing
| Column | Input / Formula | Example |
|---|---|---|
| Quantity Used (kg) | Manual entry | 0.2 kg |
| Usable Unit Cost | VLOOKUP from Tab 1 | £3.50 |
| Ingredient Line Cost | =Quantity × Usable Unit Cost | £0.70 |
| Total Recipe Cost | =SUM of all line costs | £4.20 |
| Cost Per Portion | =Total Recipe Cost ÷ Portions | £1.40 |
Tab 3 – Event Calculator multiplies Cost Per Portion by confirmed guest count, adds a 10–15% waste buffer, and divides by the target food cost percentage to produce a minimum event price. Tab 4 – Margin Matrix uses conditional formatting to flag any recipe above 35% food cost in red and below 28% in green.
Step-by-Step: Create Your Own Food Cost Spreadsheet
The formula tables above show the mechanics. Now use these steps to populate your template with real data and build a working food cost spreadsheet from scratch.
- Capture every ingredient from your latest invoices. Unit cost equals purchase price divided by purchase quantity. Use the most recent invoice price, not last season’s rate card.
- Apply yield percentages to every protein and produce item. Applying yield factors across a full catering menu raises raw ingredient cost per person. A chicken breast bought at £6/kg with 70% usable yield has an edible-portion cost of £8.57/kg.
- Include every component. Total recipe cost must include sauce, garnish, sides, and packaging. Omitting minor items such as oil, salt, and herbs understates costs across every dish.
- Calculate cost per portion. Divide total recipe cost by the number of saleable servings, not the planned yield.
- Set your suggested price. Divide cost per portion by your target food cost percentage, which typically targets the 28–35% benchmark.
- Add a waste buffer. A 10–15% waste buffer on top of yield-adjusted costs produces a realistic true food cost per person.
- Recalculate whenever prices shift. Recipe costs should be recalculated at least quarterly, or whenever a major ingredient price changes by 5–10%.
How the Template Prevents Common Catering Mistakes
The four-tab template is designed to block the most frequent causes of margin erosion in UK catering operations. Each mistake below maps to a control in the Ingredient Master, Recipe Costing, Event Calculator, or Margin Matrix.
| Mistake | Impact | Source |
|---|---|---|
| Using outdated ingredient prices from last year’s rate card | Systematic underpricing across every quote | MyJucas |
| Skipping yield calculations on proteins | Raises true ingredient cost per person | FoodCosting.app |
| Omitting labour, travel, and overhead from per-head pricing | A £48.90 quote against a true cost of £77.84 before margin | ProChefDesk |
| No wastage buffer or minimum guest-count clause | Spreads overhead too thin; quietly turns small events unprofitable | MyJucas |
| Not updating ingredient prices as supplier costs rise | A restaurant with £500k revenue loses £25,000 annually when food cost drifts from 30% to 35% | KitchenNmbrs |
| Discounting the final quote without reducing scope | Fixed and variable costs unchanged, revenue reduced | FoodCostTools |
Recipes often contain outdated costs after a supplier price change when using spreadsheets. The template above reduces this risk, although it still relies on manual price updates whenever a new invoice arrives.
Costing a 50-Person Event on a Tight Budget
Catering for 50 guests on a tight budget starts with disciplined costing before a single ingredient is ordered. The worked example below uses a buffet format, which typically targets 28–35% food cost.
| Cost Line | Per Head (£) | Total for 50 (£) |
|---|---|---|
| Yield-adjusted food cost | £5.50 | £275 |
| 10% waste buffer | £0.55 | £27.50 |
| Packaging and disposables | £0.80 | £40 |
| True food cost per head | £6.85 | £342.50 |
| Suggested price at 32% food cost | £21.41 | £1,070 |
Use a simple sequence to keep costs down without sacrificing margin. Start with ingredient selection and menu design, then protect your margin structurally, and finally sanity-check against the market.
- Choose seasonal vegetables, because vegetable prices change weekly, and abundant produce reduces both cost and waste.
- Pair those vegetables with batch-cooked proteins such as pulled pork or roasted chicken thighs, which carry higher usable yield than bone-in cuts and scale well for larger guest counts.
- Set a confirmed minimum guest count in the contract, since guest-count changes without a guaranteed minimum spread overhead too thin.
- Cost every sub-recipe separately so sauces, dressings, and dips each carry their own unit cost before being loaded into the event calculator.
- Outside London, mid-range buffet catering typically runs £10–£35 per person, so use that range as a market-rate check rather than a starting point for your quote.
When Food Costing Spreadsheets Stop Scaling
The 50-person catering example above shows the template working as designed, but only under stable prices and a single event format. In practice, that stability rarely lasts. A spreadsheet is adequate for a single site, a short menu, and stable supplier prices. Beyond that scale, the required manual updates are typically not performed. Spreadsheet-based price tracking typically fails after approximately one or two weeks, and outdated data is worse than no data because it creates a false sense of control.
The operational consequences compound quickly.
- Supplier price drift of a few percent on a large monthly food spend can cost thousands of pounds per month.
- Missing 2–5 percentage points of food cost accuracy on £50,000 per month in revenue equals £1,000–£2,500 in lost monthly profit.
- Suppliers modify prices periodically, with meat and fish fluctuating more frequently than dry goods.
| Capability | Static Spreadsheet | Jelly (Invoice-Driven) |
|---|---|---|
| Ingredient price updates | Manual, after each invoice | Automatic on every invoice scan |
| Dish margin visibility | Recalculated manually | Live, with a red or green flag per dish |
| Supplier price alerts | None | Instant Price Alert per line item |
| Admin time per month | 10–20 hours | Reduced by 10–20 hours |
| Gross margin impact | Baseline | Positive impact from live pricing |
Jelly ingests every invoice by photo or email, scans every line item, and updates ingredient costs across every recipe instantly. When a supplier raises the price of chicken breast, every dish containing it reflects the new cost before the next event is quoted. The Price Alert feature flags every increase and decrease, giving chefs the hard data needed to negotiate credits or switch suppliers. What previously took 28 minutes to cost a single menu item now takes 3 minutes.
Operators who move to automated systems react faster to price changes, make stronger buying decisions, and keep tighter control over menus and margins.
Want to see how Jelly replaces your food costing template with live, automated margins? Get a personalised demo built around your menu and supplier setup.
Conclusion: From Food Costing Template to Automation
A structured food costing template for caterers with an Ingredient Master, Recipe Costing tab, Event Calculator, and Margin Matrix delivers immediate control over food cost percentages and event pricing. It removes guesswork, enforces yield calculations, and keeps your pricing aligned with the 28–35% range established earlier.
The template’s limitation matches every spreadsheet’s limitation, because it stays only as accurate as the last manual update. As supplier count grows, event volume increases, and price volatility accelerates, the gap between what the spreadsheet shows and what the business is actually spending widens quietly. By the time the month-end report arrives, the margin has already gone.
Jelly closes that gap permanently. Invoices are scanned automatically, ingredient costs update in real time, and every dish margin stays live without manual entry. Operators using Jelly see improvements in gross margin alongside a sharp reduction in admin time.
Download the template, use it to build discipline around food costing, and then move to automation once manual updates become unsustainable. Show us your current template and we will demonstrate the automated alternative.
Frequently Asked Questions
What is a good food cost percentage for a UK catering business?
Most profitable UK catering operations target a food cost of 28–35% of revenue, though the right figure depends on event format. These food cost targets sit alongside labour, typically 25–35% of revenue, and overheads at 10–20%, which leaves a healthy catering business with a net profit margin of 15–25%. The key is to calculate food cost per dish and per event format rather than as a single blended figure across the whole business, because one low-margin event type can hide the true profitability of another.
How often should caterers update their food cost spreadsheet?
Recipe costs should be recalculated whenever a major ingredient price changes by 5–10%, and at minimum once per quarter. In practice, UK supplier prices change far more frequently, with meat and fish fluctuating monthly, vegetables weekly, and dry goods quarterly. Suppliers modify prices periodically, and during inflationary periods food prices can rise quickly. A spreadsheet updated monthly already works with stale data for most of that month. The practical solution is to update ingredient prices on the day each invoice arrives, which is why automated invoice scanning, as provided by Jelly, removes the manual burden entirely and keeps every dish cost current without additional admin.
What is the difference between theoretical and actual food cost for caterers?
Theoretical food cost is the cost calculated from exact recipe adherence with zero waste, which is the number your spreadsheet or costing template produces. Actual food cost is measured through real inventory movements, using beginning inventory plus purchases minus ending inventory, divided by sales. The gap between the two comes from over-portioning at the pass, unrecorded waste or spoilage, yield losses not captured in the recipe, receiving errors where items were invoiced but not delivered, and untracked consumption such as staff meals and tasting portions. Industry data suggests kitchens typically aim for a gap under 2-3% between theoretical and actual food cost, with 3-5% indicating issues needing attention. Tracking this variance consistently gives one of the most reliable signals of kitchen discipline, and closing it often delivers the largest margin gains.
Why do catering spreadsheets become unreliable as the business grows?
Spreadsheets store a static ingredient price entered at a point in time, so the moment a supplier raises a price and no one updates the file, every recipe using that ingredient becomes under-costed. As supplier count grows, this problem multiplies, and a busy period of four to six weeks is typically enough for a spreadsheet price file to go stale across multiple ingredients simultaneously. Additional failure points include formula errors that silently invalidate cost data across an entire menu, the absence of yield tracking, which means trim and cooking losses are not reflected in usable unit costs, and the inability to combine recipe costs with sales data to identify which dishes inflate overall food cost.
Multi-site operations face a further complication, because the same dish costs different amounts at different locations when each site buys at its own supplier prices, and a single shared spreadsheet cannot reflect that accurately.
How does Jelly replace a food costing template for caterers?
Jelly automates the entire workflow that a food costing template handles manually. Every supplier invoice is captured by photo or email and scanned line by line, including quantity, SKU, price, and tax, without manual data entry. Those prices flow directly into recipe costs, so every dish margin updates the moment a new invoice arrives. The Price Alert feature flags every ingredient price increase or decrease on the day it appears, giving chefs and managers the data needed to negotiate credits, switch suppliers, or adjust menu pricing before the event is quoted.
The Flash Report provides a daily, weekly, or monthly view of gross profit margin by combining invoice costs with sales data from integrated POS systems including Square, Lightspeed, EPOS Now, and Toast. Operators typically save 10–20 hours of admin per month and see improvements in gross margin with no per-user fees.