Catering Costing Spreadsheet Template: Price, Quote and Track Every Event

You got the enquiry: 80 guests, buffet dinner, a Saturday in a venue 30 miles away. The client wants a number by Friday. You know roughly what the chicken costs, you have a feel for what the last similar job charged, and you will probably land somewhere in the right range. The problem is “probably”. A catering costing spreadsheet replaces the gut-feel number with a quote built from the bottom up, so you know the margin on the job before the client signs, not after the last server clocks out.

This guide shows the four cost buckets every catering quote needs, walks through a complete worked example with real arithmetic, gives you a copy-ready layout to build in Excel or Google Sheets, and explains why the old “food cost times three” shortcut quietly loses money on staffed events.

All figures below are fictional worked examples with clearly stated assumptions. Use your own supplier prices, wage rates and local tax rules.

Why caterers misprice events

When an event loses money, the instinct is to blame the food: the beef went up, the client added a course. In practice food is usually the most visible cost and the easiest to estimate. The costs that wreck margins are the ones nobody writes down:

A catering costing spreadsheet makes each of these a line you have to fill in. If a line is blank, you see it is blank.

The four cost buckets in every catering quote

1. Food

Food cost for an event is built from cost per portion, not from a grocery receipt. Each dish has a recipe; each recipe has ingredients; each ingredient has a pack price and pack size. From that you get a batch cost, divide by the portions the batch yields, and add a waste allowance for trim and spoilage. That is the dish’s true cost per portion.

Then you add overage: extra food on top of one portion per guest, because buffets and family-style service always go through more. The step-by-step method, with a full recipe worked out, is in our guide on how to calculate food cost per portion for a catering menu.

2. Labor

Every person, every paid hour. For each role, record prep hours, on-site hours, travel hours and load-out hours separately, then multiply by the rate and add a payroll burden percentage for employer taxes and insurance. Caterers who quote labor from on-site hours alone routinely miss a large share of the real cost. Our catering labor cost guide shows a 120-guest plated wedding where the hidden hours were worth more than $1,600.

3. Rentals and disposables

Linens, serveware, china, glassware, tables, heat lamps, plus disposable plates, napkins and containers. Only charge for the shortfall: what the event needs minus what you already own. Decide line by line whether you recharge the client at cost or with a markup.

4. Travel

Mileage for every vehicle, tolls and parking. Keep the mileage rate as an input cell so you can update it once and every quote follows.

Worked example: an 80-guest buffet dinner

Here is a full quote built the bottom-up way. Every assumption is labelled.

The event: 80 guests, buffet dinner, venue 30 miles away (60 miles round trip), two vehicles.

Food

The menu has six components. True cost per portion (after waste) for each:

Dish True cost per portion
Lemon herb chicken thighs $3.10
Roasted vegetable pasta $1.45
Roast seasonal vegetables $0.95
Garden salad with dressing $0.70
Rolls and butter $0.45
Dessert bar (two items) $1.25
Total per guest $7.90

Assumption: a buffet needs 10% overage. So food per guest is $7.90 × 1.10 = $8.69, and food for 80 guests is $695.20.

Labor

Role People Hours each (prep + on-site + travel + load-out) Rate Wages
Chef 1 14 $30 $420.00
Servers 3 7 $20 $420.00
Prep cook 1 8 $18 $144.00
Total wages $984.00

Assumption: 15% payroll burden for employer taxes and insurance (set your own; it depends on your state, your insurer and whether staff are employees). Labor cost = $984.00 × 1.15 = $1,131.60.

Rentals and disposables

10 table linens at $14 each = $140. Premium disposable plates, cutlery and napkins at $1.10 per guest = $88. Chafing dishes are owned, so they cost nothing extra. Total $228.00.

Travel

60 miles round trip × 2 vehicles × an assumed $0.70 per mile = $84.00. (Use your own vehicle cost or the current IRS standard mileage rate.)

Total cost and price per head

Bucket Cost Share of the final price
Food $695.20 20.7%
Labor $1,131.60 33.7%
Rentals and disposables $228.00 6.8%
Travel $84.00 2.5%
Total cost $2,138.80 63.7%

Cost per head = $2,138.80 ÷ 80 = $26.74.

Now set the price. If your target gross margin is 35%, the price per head is cost per head ÷ (1 − 0.35):

$26.74 ÷ 0.65 = $41.14 per head

Round to $42 per head. Revenue before tax is $42 × 80 = $3,360. Gross profit is $3,360 − $2,138.80 = $1,221.20, a gross margin of 36.3%.

Look at the cost shares: labor is a third of the price, and more than one and a half times the food. That is normal for a staffed event, and it is exactly what a food-only pricing method misses.

What “food cost times three” would have quoted

The old rule says multiply food cost by three. Food per guest is $8.69, so the rule gives $26.07, call it $26 per head. Revenue: $26 × 80 = $2,080. Cost: $2,138.80. The event loses $58.80 before you have paid yourself anything for running the business.

The rule was built for restaurants, where the dining room, staff and rent are spread across thousands of covers. On a catering job those costs are concentrated on one day and one invoice. Use food-times-three as a smell test, never as the price.

Copy-ready layout: a minimum catering costing sheet

You can build a working version of this in one sheet. Set up these blocks:

Inputs (yellow cells) - Guest count - Service style (buffet, plated, family style, drop-off) - Overage % for that style - Payroll burden % - Mileage rate - Target gross margin % - Sales tax rate (if your state taxes catering)

Food block — one row per dish: Dish | True cost per portion. Total per guest = SUM of the column. Food cost = total per guest × (1 + overage %) × guest count.

Labor block — one row per role: Role | People | Prep hrs | On-site hrs | Travel hrs | Load-out hrs | Rate. Wages = People × (sum of hours) × Rate. Labor cost = SUM of wages × (1 + burden %).

Rentals block — Item | Needed | Owned | Shortfall = MAX(0, Needed − Owned) | Unit cost | Line cost = Shortfall × Unit cost.

Travel block — Vehicles × round-trip miles × mileage rate, plus tolls and parking.

Results - Total cost = food + labor + rentals + travel - Cost per head = total cost ÷ guests - Price per head = cost per head ÷ (1 − target margin), rounded up - Gross margin = (revenue − cost) ÷ revenue - A check cell: =IF(margin < target, “THIN MARGIN”, “OK”)

That last cell is the most valuable formula in the sheet. It catches the quote you were about to discount too far.

Service style changes everything

The same menu costs very different amounts depending on how it is served. A plated dinner uses less food than a buffet but needs far more servers and more rented china. A drop-off has almost no labor at all. If you quote every style off the same per-head number, some of your jobs are subsidising the others. We ran one 100-guest menu through all four styles in buffet vs plated vs family style catering: cost per person compared, and the price per head needed to hold a 35% margin ranged from under $20 to over $51.

From quote to booked event: what else to track

Pricing is the first job. Once an event books, the same workbook should carry it through to the final payment:

Most margin leaks happen between the quote and the invoice. We list the common ones in catering quote mistakes that wipe out your profit margin.

Build it yourself or start with the finished workbook

Everything above can be built in a few evenings if you are comfortable with SUMIF, lookups and data validation. If you would rather start with it working, the Catering & Private Chef Event Costing workbook has 16 linked tabs and 15,839 formulas already connected. You enter pack costs once on the Ingredients tab; Recipe Lines and Menu Items turn them into batch cost, cost per portion, waste-adjusted true cost and food cost percentage for every dish; Quote Lines pull the true cost the moment you pick a dish; Staffing counts prep, travel and load-out hours and adds payroll burden; Rentals charges only the shortfall against what you own; and the Events tab returns client total, gross profit, margin, cost per head and price per head with deposit and final headcount dates. A dashboard runs 28 checks, including THIN MARGIN and OVER CAPACITY flags. Change one pack price and every dish, quote and margin in the file moves with it.

More in this series

General information only, not tax, legal or accounting advice. Example figures are fictional.

Frequently Asked Questions

What should a catering costing spreadsheet include?

Four cost buckets for every event: food (built from recipe costs per portion, plus overage), labor (every paid hour including prep, travel and load-out, plus employer payroll costs), rentals and disposables, and travel. It should total them, divide by guest count to give cost per head, and compare that with the price per head you plan to quote, so you see the gross margin before you send anything.

How do I price a catering event per person?

Add up the full cost of the event, divide by the guest count to get cost per head, then divide cost per head by one minus your target gross margin. For example, a cost of $26.74 per head at a 35% target margin gives $26.74 / 0.65 = $41.14, which you might round to $42 per person before tax.

Is the food cost times three rule good enough for catering?

It is a quick sanity check, not a pricing method. It ignores labor, rentals and travel, which on staffed events often cost more than the food. In the worked example in this guide, pricing at three times food cost would have produced a $58.80 loss on an 80-guest buffet.

Can I run a catering business from Excel or Google Sheets?

Yes. A well-built workbook can hold your ingredient prices, recipe costs, menu, quotes, staffing, rentals, payments and calendar in linked tabs, so a change to one ingredient price flows through every dish and every quote. Many small caterers and private chefs work this way instead of paying for catering software.

See the Real Margin on the Event Before the Client Signs

The Catering & Private Chef Event Costing, Menu Pricing and Quote Builder — 16 linked tabs, 15,839 working formulas and 28 data checks built around one job: knowing what an event really costs before you send the quote. Ingredients priced once from pack cost and pack size; Recipe Lines and Menu Items returning batch cost, cost per portion, a waste-adjusted true cost, margin and food cost percentage for every dish; Quote Lines that pull the true cost per portion the moment you pick a dish; Staffing that counts prep, travel and load-out hours, not just service, and adds payroll burden; Rentals and Equipment that charges only the shortfall against what you own; an Events tab returning client total, gross profit, margin, cost per head and price per head with deposit, balance and final-headcount dates; a Prep Timeline that moves with the event date; Payments and Clients; and a Dashboard with THIN MARGIN and OVER CAPACITY flags. Sample events pre-filled. Works in Excel and Google Sheets, no macros and no add-ons.

View on Etsy — $18.99