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
| Field | Why it matters |
|---|---|
| Role and department | Rates are set by role. A camera op and an A1 rarely share one. |
| Start and end date | The number of days is what multiplies everything else. |
| Day rate | The person's usual rate, or the rate agreed for this show if it differs. |
| Per diem | The daily allowance when the crew member works away from home. Zero for local crew. |
| Travel budget | Flights, trains or mileage for this booking, kept out of the daily figures. |
| The milestone it depends on | Load-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:
- The days change and the cost does not. Someone moves the tech rehearsal a day earlier in the schedule and forgets the roster tab.
- 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.
- 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:
| Role | Days | Day rate | Per diem | Cost |
|---|---|---|---|---|
| Technical director | 3 | $900 | $75 | $2,925 |
| A1 (audio) | 3 | $750 | $75 | $2,475 |
| Camera operator ×2 | 2 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?.