Skip to main content

Guide

How to track crew per diem and day rates for an event

Track crew cost per booking, not per spreadsheet row. Each booking needs its days, its day rate and its per diem, so that when a call date moves the cost moves with it.

By Pedro van Tol, founder of ShowOps.AI and an executive producer for 15 years

To track crew per diem and day rates for an event, record them on each crew booking, not in a separate sheet: every booking needs its dates, its day rate and its per diem, and crew cost is the day rate plus per diem for each day booked, plus travel. When the cost lives on the booking, a moved call date changes the cost in the same step instead of in a second tab someone has to remember.

Most budget surprises on a show are not big. They are one extra day for four people, a per diem nobody added for a travel day, or a rate that changed between the estimate and the booking. The fix is a structure where those numbers cannot drift apart.

What to record for every crew booking

FieldWhy it matters
Role and departmentRates are set by role. A camera op and an A1 rarely share one.
Start and end dateThe number of days is what multiplies everything else.
Day rateThe person's usual rate, or the rate agreed for this show if it differs.
Per diemThe daily allowance when the crew member works away from home. Zero for local crew.
Travel budgetFlights, trains or mileage for this booking, kept out of the daily figures.
The milestone it depends onLoad-in, tech rehearsal, show day. If the milestone moves, you know which bookings move with it.

The formula, and where it goes wrong

Crew cost for one booking = (day rate + per diem) × days booked + travel.

That line is simple. It goes wrong in three places:

  1. The days change and the cost does not. Someone moves the tech rehearsal a day earlier in the schedule and forgets the roster tab.
  2. The rate is copied, not referenced. A rate changes on the crew list, and twelve rows in last month's copy of the budget still carry the old one.
  3. Per diem is folded into the rate. Then nobody can see what the show spent on per diem, and changing it means editing every rate.

A worked example (illustrative)

The figures below are made up for the example and do not come from any customer.

A two-day corporate general session with one travel-in crew of four:

RoleDaysDay ratePer diemCost
Technical director3$900$75$2,925
A1 (audio)3$750$75$2,475
Camera operator ×22 each$650$75$2,900
Total before travel$8,300

Now the client asks for a rehearsal the day before. The technical director and the A1 each gain a day: (900 + 75) + (750 + 75) = $1,800 more, before anyone has changed the budget. In a spreadsheet that number appears when someone thinks to look. On a booking-based roster it appears when the date moves.

How ShowOps.AI handles it

  • Each crew member has a default day rate and per diem. A booking on a show can override either one for that show, and carries its own travel budget.
  • Crew bookings can be anchored to timeline milestones, so the roster knows which milestone each booking depends on.
  • When a producer confirms a change to the timeline, ShowOps.AI reports which crew bookings move and the change in staffing cost, day rates and per diem included, along with the budget lines linked to those bookings. The crew date changes become one suggestion that a producer approves or rejects, and an approved change can be undone. This step is switched on for each organization during setup.
  • The calculation uses no AI.

What it does not do: it has no time tracking or payroll, and it does not re-staff the show for you. Only bookings anchored to a milestone are priced when the timeline changes, so anchor the ones that depend on a date.

For rosters, rates and certifications, see Staffing. If your crew cost lives in a spreadsheet today, read When does an event production spreadsheet stop working?.

Frequently asked questions

What is a day rate for event crew?
A day rate is the flat amount a crew member is paid for one working day on a show, agreed before the booking. It usually covers a set number of hours, and overtime or a sixth or seventh day is paid on top according to the deal or the agreement that applies.
Is per diem part of the day rate?
No. Per diem is a separate daily allowance for meals and incidentals when crew work away from home. Keep it in its own column so you can change it without touching the rate, and so the budget shows labor and per diem apart.
Does per diem apply to travel days?
That depends on your deal and the client contract, and teams handle it differently. Decide it once per show, write it down, and apply it the same way to every booking.
How does ShowOps.AI calculate crew cost?
Each roster booking carries its dates, a day rate and a per diem, either from the crew member's defaults or overridden for that booking, plus any travel budget. Crew cost adds day rate and per diem for each day booked, plus travel.
What happens to per diem when the show date moves?
In ShowOps.AI, confirming a timeline change produces a report of the crew bookings that move and the staffing cost change, with day rates and per diem included. A producer approves or rejects it, and an approved change can be undone. This approval step is switched on for each organization during setup.

See it in your production

Talk to the team

We are happy to walk through how ShowOps.AI fits your productions, your tools, and your data requirements.