How to Price Catering: A Cost-per-Person Sheet With AI

To work out catering cost per person, add food (with wastage), labour for prep and service, equipment hire, consumables, transport and a share of overhead, divide by guests, then add your margin to the total cost rather than the food cost. In the 60-guest example below, cost is $37.72 a head and the price $47.16.

Most pricing guides tell you to triple your food cost. That rule can hide a loss, because a buffet for 60 and a plated dinner for 60 have similar food costs but very different labour. A sheet built from your real costs shows you which jobs earn money. AI helps with the dull parts: structuring the sheet, writing formulas, spotting what you forgot and checking the sums. The numbers below are illustrative, so replace each one with your own invoices and wage rates.

Follow me on Instagram@sagnikteaches

The seven lines every catering price must cover

1. Ingredients per head, by course, with a wastage allowance.
2. Prep labour in the kitchen before the event.
3. Event labour: chef, cooks, servers, setup and clear-down.
4. Equipment and hire: crockery, glassware, linen, warmers, tables.
5. Consumables: napkins, foil, gas, cleaning supplies.
6. Transport and loading, including your own time.
7. Overhead share: kitchen rent, insurance, software, admin, a share of unpaid time such as quoting.

Margin then goes on top of the total of all seven. It is easy to add margin to the food cost only and call it profit, when the real profit has been eaten by labour you did not count.

Connect on LinkedInSagnik Bhattacharya

The 60-guest worked example

An illustration: a catering company is quoting a buffet lunch for 60 guests: a starter, a main with two sides, a dessert and non-alcoholic drinks with bread. Each figure comes from a supplier invoice or a recipe costing; here they are invented round numbers.

Subscribe on YouTube@sagnikteaches

Step 1: food cost per head

For 60 guests, food comes to $14.04 x 60 = $842.40. The 8% allowance covers trimming, spillage and the extra portions you always cook for; adjust it from your past events.

Step 2: labour, with a staff ratio

The ratio is your biggest judgement. My starting assumption for a buffet is one server per 20 guests, so three servers for 60; for plated service you would want more, and for drop-off catering none. Set the ratio from what actually happens at your events.

The hours include travel and setup. A common error is to cost only the hours at the venue; prep, loading and cleaning the van are real hours too. Your own pay belongs in this sheet at a sensible rate, even if you take profit as drawings.

Step 3: equipment, consumables and transport

• Crockery, cutlery and glassware hire: 60 x $1.80 = $108
• Linen: $90
• Chafing dishes and warmers: $60
• Equipment total: $258
• Consumables (napkins, foil, gas, cleaning): $45
• Transport (fuel and van share): $40

Step 4: overhead, total cost and price

Food                      $842.40
Labour                    $872.30
Equipment hire            $258.00
Consumables                $45.00
Transport                  $40.00
Direct cost             $2,057.70
Overhead share, 10%       $205.77
TOTAL COST              $2,263.47      ($37.72 per head)

Target profit margin: 20% of the selling price
Price = cost / (1 - 0.20) = $2,263.47 / 0.80 = $2,829.34
Per head: $2,829.34 / 60 = $47.16 (quote $47.20)
Profit at that price: $2,829.34 - $2,263.47 = $565.87
Food cost as % of price: 29.8%

Notice two things. First, a 20% margin on price needs a 25% markup on cost, not 20%. Mixing the two under-prices every job you quote. Second, food is only 29.8% of the price here, and labour is nearly as large as food. That is why a blanket "triple the food" rule drifts wrong whenever a job needs more hands.

What happens when the headcount changes

Many fixed lines do not shrink with guests. Re-running the sheet for 50 guests, keeping the same three servers and the same prep and chef hours, and scaling food and hire:

Food (50 x $14.04)            $702.00
Labour (unchanged)            $872.30
Equipment (50/60 of $258)     $215.00
Consumables and transport      $85.00
Direct cost                 $1,874.30
Overhead 10%                  $187.43
Total cost                  $2,061.73
Price at 20% margin         $2,577.16  ($51.54 per head)

Ten fewer guests cut the total price by about $252 but raise the per-head price by $4.38, about 9%. If a client says "we might drop to 50", you now know to restate the per-head price, not to keep $47.20. Put a minimum charge in your terms, for example the price for 50 guests, and a date by which final numbers are due.

Building the sheet with AI

You can do all this in a spreadsheet by hand, but an assistant gets you to a clean template quickly. The best use is to have it set out the structure and write formulas, then to check the result against your hand calculation above.

A prompt that produces the layout

I run a small catering company. Build me a spreadsheet layout for pricing
an event by cost per person. Sheets: Inputs (guest count, wastage %, wage
rates, overhead %, target margin %), Menu (course, cost per head), Labour
(role, hours, rate), Hire (item, unit cost, quantity), Summary (each cost
line, total, price using margin on price not markup on cost, price per
head). Give me the exact formulas for each cell in plain text, using cell
references, so I can paste them. Include a check cell that proves
price - cost = margin % of price.

A good answer gives you cell-by-cell formulas such as =Inputs!B2*Menu!D8. Paste them into Google Sheets or Excel. If you want to go further with AI inside the sheet, the tutorials on Google Sheets AI prompts and the recipe scaling and shopping list tutorial cover that.

A prompt that finds what you forgot

Here is my cost sheet for a buffet lunch for 60 guests: [paste the lines
with no client details]. List up to ten costs a caterer commonly forgets
to include for an event like this (for example parking, waste disposal,
spare portions, staff meals, breakages, payment fees, insurance for the
event). For each, say whether it is missing from my sheet. Do not invent
prices; leave them blank for me to fill in.

This usually returns things such as staff meals, card fees on the deposit, breakages and a late-night overtime allowance. Add the ones that apply to you, with your own figures. Treat the list as a prompt for thought, not as a verified list of your costs.

Checking the AI's maths

Assistants sometimes get the totals wrong, or round quietly. Before you send any quote, run three checks. First, the "known answer" test: feed the sheet this tutorial's inputs and confirm it returns $2,829.34. Second, the reverse test: take the price, subtract the cost, divide by the price, and check it equals your target margin. Third, change one input (add a server) and confirm the total moves by the amount you expect, here $80 x 1.10 x 1.10 / 0.80 = about $121 on the price. If any check fails, find the formula, not the answer. The same discipline applies to any spreadsheet an assistant builds for you.

Where the cost data comes from

Every figure above should trace to something. Ingredient costs come from your supplier invoices divided by usable portions; recipe costing sheets turn those into a cost per head. Wage rates come from your payroll, with on-costs. Hire prices come from the hire company's list. Overhead comes from last year's accounts divided by the number of events or billable days. An illustrative mistake: a caterer costs chicken thighs at the bulk case price, forgetting 20% bone and trim loss, and finds on the third event that the main costs $1.10 more per head than the sheet said. The fix is to cost the cooked, edible portion: purchase cost divided by yield.

A yield sum you can copy

Chicken thighs, bone-in:  $6.00 per kg
Edible yield after bone and cook loss: 65%
Cost per kg of edible meat: $6.00 / 0.65 = $9.23
Portion: 150 g edible = $1.38 per head

The same approach works for vegetables (peeling loss), fish and rice (which gains weight when cooked). Keep the yields in your Inputs sheet and update them when you change supplier.

Turning the cost sheet into a price list

Once the sheet gives you a reliable cost per head for each menu, build three tiers rather than quoting from scratch every time. A simple structure: a basic buffet, a standard buffet with an extra course, and a plated option, each priced from the sheet for a stated minimum guest number. Add rules for what moves the price: guests under the minimum, venues with no kitchen, evening events with overtime, dietary menus needing separate preparation. The proposal template tutorial shows how to present those packages, and catering quote software shows what to buy when quoting volumes grow.

Three jobs, three different shapes

Drop-off lunches for an office need almost no service labour, so food and packaging dominate and the sheet's labour block shrinks. A wedding for 120 with plated service has a heavy staff ratio, higher hire and a long prep, so labour and equipment may exceed food. A canapé reception is the odd one: food cost per head looks low, but prep hours per head are high, so pricing by food cost misses it entirely. Running these three through the same sheet shows quickly that one rule of thumb cannot work for all of them, and why per-head prices should come from your own numbers.

Choosing the staff ratio by service style

Labour is where quotes go wrong, because the ratio of staff to guests changes with how the food reaches the table. These are starting assumptions to test against your own events, not rules. Write yours into the Inputs sheet so the Labour sheet reads from it.

Do not forget that servers are paid for setup and clear-down, not just the meal. A five-hour shift for a two-hour meal is realistic once you count arrival, setting up, service and packing away. Venues with stairs or a long carry add time, and an extra pair of hands for the first hour is cheaper than a late start.

Own the equipment or hire it

The sheet's hire block is also where you decide whether to buy. An illustrative sum: you hire crockery, cutlery and glassware at $1.80 a head for about 20 events a year of 60 guests. That is $108 x 20 = $2,160 a year. A full set of your own for 60 might cost $900 to buy, plus a dishwasher run, storage space and breakages. If buying saves $2,160 and costs about $900 once plus roughly $300 a year in washing, replacement and storage, it pays back inside the first year. If you run only five events a year, hire costs $540 and buying makes no sense. Put the annual event count and the hire-or-own figures on the sheet, and let it make the decision for you.

A caution: when you own equipment, charge for it. Add a "use of equipment" line to each job at roughly what hire would cost, so the purchase pays back and a replacement fund builds up.

Dietary menus and allergens change the cost

Vegetarian, vegan, gluten-free and allergen-free meals are not free to add. They often mean separate ingredients, separate preparation space, labelled containers and sometimes a dedicated cook. Cost them as their own menu lines rather than assuming they cost the same as the standard dish. Ask the client for the number of each dietary need by a set date, and price a small surcharge or a separate per-head rate where it is justified.

AI can help to label and list allergens across a menu, but it must never be the last check: allergen information needs to come from your ingredient labels and your own process, signed off by you. The menu cycle tutorial with costs and allergens goes further on tracking this.

Payment terms and what they cost you

Deposits and payment fees belong in the price, not in hope. If you take a deposit by card, the processor takes a fee on every payment; if you invoice, late payment costs you in chasing time. Add a small line to the overhead percentage that covers payment fees, and write your terms into the quote: deposit amount, balance due date, minimum numbers, what happens if guests drop. An illustrative sum: if card fees average 2% on a $2,830 job, that is about $57, which comes straight off the $566 profit unless it is in the cost. Two percent sounds small; it takes a tenth of the profit.

When the client says it is too much

You have three honest levers that keep your margin intact, and each has a cost you can read off the sheet.

1. Change the menu. Replace a $5.60 main with a $4.20 one and food falls by $1.40 x 1.08 x 60, about $91, which lowers the price by roughly $125 once overhead and margin follow it.
2. Change the service. Drop from three servers to two with a self-service setup. That removes about $80 of servers, $121 in price after on-costs, overhead and margin.
3. Change the number or the extras. Remove the dessert course, hire less glassware, or ask the client to collect.

What you should not do is discount the price and keep the menu. A price cut of $300 on a quote with a $566 profit leaves $266, and a surprise cost on the day can turn it into a loss. Show the client the options and let them choose; the sheet turns each into a number in a minute. Offering three options at three prices also tends to start the conversation about which to pick rather than whether to hire you.

Reviewing the event afterwards

A pricing sheet improves only when you feed it what actually happened. After each event, spend ten minutes recording planned against actual figures. An illustrative review entry for the 60-guest job: planned prep 14 hours, actual 17; planned food $842, actual $905 because the main needed more portions than expected; planned hire $258, actual $258; servers planned at 5 hours each, actual 6 because of a late start. The overrun is about $175 once you add up the extra prep, food and server time with on-costs, close to a third of the planned $566 profit. The fix goes into the Inputs sheet: wastage from 8% to 12% for this menu, prep hours from 14 to 16, and a standard setup buffer of an hour.

You can paste your planned and actual lines into an assistant and ask for the biggest variances and likely causes. Leave out client names and addresses. A prompt such as "Here are planned and actual costs for five events; which cost lines are consistently under-estimated and by what percentage?" will give you a ranked list to check. Use it as a pointer and confirm each finding in your own records before changing a rate. After five or six events, the sheet's inputs are yours rather than guesses, and your quotes will be right more often. That is the point of building the sheet properly, not as a one-off but as a record that gets better every time you use it.

Seven leaks that eat a catering margin

• Costing food at menu portions and forgetting that you cook extra.
• Leaving out prep and clean-up hours.
• Adding margin to food cost instead of total cost.
• No allowance for card or invoice-payment fees.
• Quoting a per-head price without a minimum number or a final-numbers date.
• Using last year's supplier prices.
• Forgetting extras clients add after the quote: late changes, extra tables, a dietary menu.

Review every quote after the event by comparing planned and actual hours and food spend. Two or three events of data will tell you whether your wastage allowance and staff ratio are right. If you would like help building the sheet around your own costs, that is what my AI implementation consultation covers.

Catering pricing questions answered

What food cost percentage should a caterer aim for?

There is no single right figure; it depends on menu, labour and how much equipment you hire. Many caterers watch food cost as a share of the selling price, but the better test is whether the whole quote covers food, labour, hire, overhead and your margin. Work it out from your own costs, as in the sheet here.

Should I price per person or as a flat package?

Per person suits events with a firm headcount and a set menu, because it scales when numbers change. Flat packages suit small, simple jobs. Either way, build the sum bottom-up from costs first, then choose how to present the price, and state a minimum guest number.

Can I trust AI to do the arithmetic?

Not unchecked. Assistants can build the sheet and write the formulas well, but they sometimes slip on sums or silently round. Ask for formulas you can see, test them on a case you can do by hand, and keep a calculator check on the final total before you send any quote.

How do I price for a lower number of guests?

Fixed costs such as lead chef time, transport and hire minimums do not shrink in proportion, so the cost per person rises as numbers fall. The worked example here shows 50 guests costing noticeably more per head than 60. Set a minimum charge or minimum guest count in your terms.

Further reads

• Catering Event Checklist: Build the Run Sheet From One Brief With AI — Build the run sheet from the same brief you priced.
• Wedding Catering Proposals: Tastings, Quotes and Follow-Ups With AI — Wedding quotes, tastings and follow-ups.
• Corporate Catering Proposals: Win Office Contracts With AI Outreach — Win office contracts with outreach and follow-ups.
• How Caterers Use AI to Quote Events and Plan Menus — The wider picture of AI in quoting and menu planning.
• Catering Software for Small Business: Free Options and AI Extras — Free catering software options and the AI extras worth having.
• Can AI Write a Catering Tender Response? What to Keep Confidential — Pricing a tender response without exposing confidential figures.
• AI for Delis: Daily Specials, Platter Orders and Allergen Labels — One deli, four weeks: specials built from the chiller, a platter order form that prices itself, and allergen labels a person signs off.
• How Much to Charge as an Event Planner: Flat Fee vs Percentage — Flat fee, percentage or hybrid: two worked quotes, a corporate launch and a private weekend, built from your own hourly cost with an AI fee model.
• Florist Wedding Quote Template: Price Stems, Labour and Hire With AI — A worked wedding quote in a sheet: stems, waste, labour hours, hire items and delivery, plus the ChatGPT prompts that build it.
• Food Truck Booking Software: Screen Private-Event Requests With AI — Seven answers to collect from every private-event enquiry, three AI prompts to screen and quote them, and when booking software earns its fee.
• Food Truck Food Cost: Use ChatGPT Before Paying for Software — A ChatGPT-built food cost sheet for a food truck, one burger costed to the cent, and the break-even sum for paid costing software.
• Food Truck Pricing: Set Menu Prices After Fees, Fuel and Pitch Costs — One Saturday market worked through with numbers: overhead per service day, cost per portion and the menu prices that clear a 12% margin.
• How Much to Charge as a DJ: Wedding, Party and Corporate Packages — A cost-based package table for DJ owners: whole-gig hours, kit wear per gig, travel, an overtime rate, and a quote calculator built with AI.
• How to Price a Wedding Venue: Peak Dates, Midweek and Minimum Spend — A worked price grid for a 120-guest venue: four date tiers, food-and-drink minimums, a midweek discount test and three yearly scenarios modelled with AI.
• Recipe Costing Spreadsheet for Restaurants: Build It With ChatGPT — Five tabs, one salmon dish costed line by line, and a ten-minute weekly step that updates every plate cost when an invoice changes.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: the worked example uses illustrative costs, not market prices; check your own supplier invoices and wage rates.