Production Reports and Hot Costs
for Line Producers and UPMs
The call sheet says what should happen. The production report says what did. G-Casper Pro keeps both on the same show, so the PR Back's in and out times turn into hours, overtime and meal penalties the same evening, priced at the deal in your Globals.
Money figures need the Producer plan. On the AD plan the hours and counts still show.
The Daily Numbers, Worked Out
Every figure below comes from times someone typed on the PR Back. When a time is missing, the report says so.
PR Front and PR Back
The Front carries scenes in shot order, pages, setups, key times, film and cast. The Back records each crew member's IN, meal and OUT by department, and works out hours net of the meal.
Production reports overviewStatus, flags and locking
Total Production shows every day that has passed as a small page, with chips for what each one still owes. One person holds a day's report at a time, and a finished day can be locked.
Report status and lockingHot Costs: Overview, Detail, All Days
Overview is the daily hot cost sheet with budgeted against actual. Detail costs each person by department. All Days rolls the shoot up to date, with an Excel export of the daily report.
Hot costs reportsYour overtime bands
Globals holds the scheduled day and where each overtime band starts, with crew and drivers apart. Overtime is measured past the scheduled day, and hours past it print red on the PR Back.
Production financeMeal penalties, escalating
The MPV cell reads a/b: penalties on the first meal and the second. Hot Costs prices them at your production's rates, penalty by penalty.
Meal penaltiesCrew pay beside the DOOD
Each week gets a payment status, Waiting, Auth, Paid or Error, with Total Paid and Total LTP counting what the crew is still owed.
Crew DOOD payment trackerBurn rate before the day
An estimate of what each shoot day costs: crew and cast rates, extras, breakdown items and base camp overhead. Read it by day or by scene, with the peak day called out.
Burn rateWhat one more hour costs
The Overtime Cost Estimator on the Producer Dashboard sizes today's day from the call sheet and shows what one to four hours past the scheduled day would add.
Producer DashboardFrom the PR Back to the Bottom Line
PR Back
Click an OUT cell and type the real wrap. Hours show in decimal or hours and minutes. Days with rows still missing an OUT say so in Total Production.
Hot Costs, All Days
The whole shoot on one sheet: hours worked, overtime past the scheduled day, overtime cost, meal penalties and a table per day. A day with missing OUT times links straight to its PR Back.
Hours are IN to OUT net of meals, as the PR Back counts them. Scheduled is the budgeted day from Globals (12h crew, 14h drivers) for every row with times in; Overtime is every hour past it, row by row. OT cost is what those hours cost at each person's hourly (their own, the one their day rate implies, or the burn rate fallback) minus the scheduled day; rows with no rate contribute hours but no money. Meal penalties escalate per meal at the Globals rates.
Burn Rate
The assumptions sit in a strip at the top, including the fallback rate for anyone without one, so the rate behind every figure is in view.
Total estimated burn
$124,670
Across 5 shoot days
Average per shoot day
$24,934
Peak day
Day 5
$33,280
| Day # | Scenes | Date | Location(s) | Crew | Cast | Extras | Items | Total burn | vs peak |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1213 | Sep 14 | Safehouse | 16 $9,150 | 3 $3,400 | 0 $0 | 5 $1,120 | $18,190 | |
| 2 | 45 | Sep 15 | Marina, Parking Lot | 22 $11,880 | 4 $4,649 | 24 $4,800 | 7 $3,560 | $31,889 | |
| 3 | 21 | Sep 16 | Elevator | 15 $8,750 | 2 $2,117 | 0 $0 | 2 $1,030 | $16,257 | |
| 4 | 30 | Sep 17 | Rooftop | 21 $11,340 | 4 $4,234 | 12 $2,400 | 5 $1,120 | $25,054 | |
| 5 | 3133 | Sep 18 | Boardroom, Dockyard | 19 $10,450 | 4 $4,200 | 40 $8,000 | 6 $2,590 | $33,280 | |
On-Set Daily ATL & BTL Combined ATL (Cast): $18,600BTL (Crew + Extras + Items): $76,190Combined: $124,670 | |||||||||
Questions
Where do the hot cost numbers come from?
From the IN, meal and OUT times on the PR Back, the MPV cell and the overtime bands in Globals. A person with no hourly rate is costed at the hourly their day rate implies, or at the Burn Rate fallback if neither is set.
Can an AD see the money?
Only if they are on the Producer tier of the show. With an AD grant, rate, cost and budget cells are blank while hours, counts and days remain.
What if a crew member wraps after midnight?
Hours run from IN to OUT across midnight, net of the meal. A 2:00 AM wrap is read as the next morning.
Numbers the Office Can Use
G-Casper Pro is in private beta. Join the waitlist and get your first production days free when access opens.