TeamRally TeamRally
Join the waitlist
← All templates
Google Sheets

Free Event Cost Per Person Calculator (Google Sheets)

Calculate the true cost per employee for any company event — a free Google Sheets calculator with live headcount, plus-ones, and scenario columns.

Get the free template → Opens in Google Sheets · make your own copy

Event Cost Per Person Calculator (Free Google Sheets Template)

“What’s this costing us per head?” is the first question finance asks and the last one most planners can answer. This calculator keeps a live per-person number as headcount and costs move — including the plus-ones everyone forgets.

What’s inside

  • A live per-person rollup — total cost divided by actual expected attendees, not the invite list
  • Plus-one and no-show adjustment rows so the denominator reflects reality
  • Three scenario columns — lean, planned, and stretch — to negotiate with leadership using numbers
  • Category breakdown showing which line items move the per-head figure most

How to use it

  1. Make a copy, enter your invite count, expected RSVP rate, and plus-one estimate.
  2. Fill in category costs (or link them from the offsite budget template).
  3. Watch the per-person figure as you tweak. Use the scenario columns in your budget pitch.

Tips

  • Budget against confirmed RSVPs, not invites. A 75% show rate changes your number by a third.
  • Fixed costs (venue, AV) make small events expensive per head. Per-person costs drop fast with headcount — use that in your pitch.

Get the free template →

Related templates

Your per-person number is only as good as your RSVP data. TeamRally keeps the headcount live so the math reflects who’s actually coming — join the waitlist.