Film Production KPI Dashboard Example

Film Production Performance Dashboard

Day 9 of a 26-day shoot. The production report lands after wrap: 2 5/8 pages shot against 4 3/8 scheduled, a rain delay on the only exterior, and the crew went an hour past the budgeted day. Nobody on set calls it a crisis. It's one day. But the schedule has no room for three more like it, and the cost report won't say so until Friday.

Los Angeles production has been shrinking, but independent features are picking up. FilmLA counted 19,694 on-location shoot days in Greater Los Angeles in 2025, 16.1% fewer than in 2024. Features picked up early this year: 687 feature shoot days in Q1 2026, up 52.3% on Q1 2025, with most of that activity from independent films and 21.8% from projects in California's expanded tax credit program. An independent film has no studio balance sheet behind it, so an overage comes out of the producers' own margin.

The money behind those films is watched closely. A completion guarantor typically wants the call sheets and daily production reports every day, and cost reports weekly, and uses them to judge where the film is heading. The figures a bond company reads are the ones the producers should be reading first.

This example follows an invented independent production company in Los Angeles through two features made over the same two years. The company, the films and every monthly figure are modeled, not taken from a customer. One target in the table below has a published benchmark behind it, from the Bureau of Labor Statistics. The rest are starting points.

What is a Film Production KPI Dashboard?

Overview

A film production KPI dashboard shows whether each production is shooting the pages it planned, spending what it budgeted and hitting its post dates, and what that does to the return before anyone has sold the film.

It follows a production in the order the money goes out. During the shoot, the 2nd AD's production report gives the first four numbers: shooting days completed, pages shot per shooting day, shooting days behind schedule, and days lost to weather or to a location that fell through. Payroll adds crew overtime, the hours worked past the day the budget paid for. A recordable incident rate covers the people doing the work.

Then the accountant's numbers. Budget variance compares cost to date with budget to date on the weekly cost report. Contingency remaining shows how much of the reserve the completion guarantor insisted on is still unspent.

After wrap, milestones on time tracks editor's cut, picture lock, the mix and delivery against the dates the financing assumed. Projected ROI sits over all of it, because every extra day and every late delivery comes out of the margin on a deal that was priced before the camera rolled.

Who benefits from this dashboard?

1. Producer: Projected ROI and contingency remaining are what the financiers will ask about. Seeing them move during the shoot means the producer calls the financiers before they call the producer.
2. Line Producer and UPM: Pages per day against the scheduled rate, days behind and overtime show whether to cut a scene, add a unit or ask for another day, while there's still a choice.
3. 1st AD: The schedule is theirs. Days lost and pages per day show whether the problem was the weather, the locations or a schedule that asked for more than the crew could shoot.
4. Production Accountant: Budget variance and contingency drawn are the cost report in two lines, which makes the weekly report to the bond company easier to explain.
5. Post Supervisor: Milestones on time shows how much of a late wrap the post schedule can absorb before the delivery date moves.

Read pages shot per shooting day against the rate your schedule assumed, not against your last film. 3.3 pages is a solid day on a schedule built at 3.2. On a schedule built at 4.4 it puts you more than a day behind every week.

Dashboard Example Overview

The example company has a staff of nine in Los Angeles and makes one or two features a year on budgets of $3 to 6 million, hiring crews of 45 to 70 for each film. It reports ten KPIs monthly across whatever it has in prep, shooting or post:

• Shooting Days Completed: Principal photography days shot in the month. It's context, not a target, and it reads zero in the months with no shooting, which is most of them. The next three KPIs read zero in those months too, by design. With no shooting there's nothing to measure, so read them only for the months a film is in principal photography, and don't count a zero as a missed target.
• Pages Shot per Shooting Day: Script pages shot, counted in eighths, divided by shooting days. The first sign a schedule was too ambitious.
• Shooting Days Behind Schedule: At month end, shooting days used minus the days the locked schedule gave to the pages shot so far. The schedule figure a bond company follows most closely.
• Days Lost to Weather and Locations: Scheduled days lost to rain, snow or a location falling through, with no cover set to move to.
• Crew Overtime Rate: Crew hours past the budgeted day (12 hours shooting, 10 in prep and post) divided by all crew hours. Overtime inside the budgeted day is already paid for, so it isn't counted.
• Crew Recordable Incident Rate: OSHA recordable incidents over the trailing 12 months, times 200,000, divided by crew hours in the same 12 months.
• Budget Variance: Cost to date minus budget to date, divided by budget to date, from the weekly cost report. Contingency is kept out of the budget figure.
• Contingency Remaining: The share of the contingency not yet drawn. This company holds 10% of each film's budget.
• Milestones on Time: Prep, shoot and post milestones met on or before the date locked at greenlight, divided by milestones due that month.
• Projected Film ROI: Contracted and documented revenue minus estimated final cost, divided by estimated final cost, across both films.

In October 2024, after its previous feature finished five days over, the company changed how it plans. Schedules would assume no more than 3.8 pages a day. Every film would get eight weeks of paid prep, with locations locked by week six. And every exterior day would have a cover set. The first film planned under those rules was a contained thriller: 94 pages, 25 days, shooting in Los Angeles County with a $3.6 million budget.

It shot as planned. In February 2025 the crew completed 20 days at 3.7 pages a day and finished the month 0.3 days behind. A rain day went to the cover set, so days lost stayed at zero. The last five days, in March, ran at 4.0 pages a day and the film wrapped on day 25. Overtime was the one blemish: 4.7% of crew hours in February, then 6.0% in March, over the 5% target, because the final week was all night exteriors.

Post mostly held too. Milestones on time dropped to 75% in July 2025 when the music was delivered late, and an overage on a music license pulled contingency remaining down to 73.6%. By August, with only the delivery left, the thriller sat 0.3% under budget to date. It was delivered in September 2025, on the date the financing assumed.

The second film, a period drama, broke the rules. A streamer licensed it in June 2025 for a fixed fee, with delivery due June 30, 2026, and projected ROI across the two films slipped from 19.8% in May to 18.5% in June, because the drama's margin was thinner from the start. Financing closed late, so prep started late, and the lead actor was only available from early November. The company accepted five weeks of prep and a 26-day schedule for a 114-page script: 4.4 pages a day, in upstate New York, in November, with no cover sets. Milestones on time fell to 66.7% in August, September and October, and budget variance was already 3.0% over in October because two late location deals cost more than budgeted.

November 2025 showed exactly why the rules existed. The crew shot 18 days at 3.3 pages a day. Two rain days and a location that pulled out cost three days, and by month end the drama was 4.5 days behind. Overtime reached 11.9% of crew hours as the 1st AD tried to make up pages. Budget variance hit 11.7%, contingency remaining fell to 44.2%, and projected ROI dropped to 14.9%.

December finished it. Pace improved to 3.7 pages a day once scenes were combined, but snow and ice took two more days and the film wrapped on day 33, seven shooting days over schedule. Overtime ran at 14.6%, contingency was gone, and budget variance reached 15.5%. A grip slipped on ice during a night exterior, the company's first recordable incident in over a year, which put the rolling incident rate at 2.4 against the BLS figure of 1.1.

The late wrap ran straight into post. Milestones on time read 0% in January and March 2026 and 50% in February and from April to June, and the June 30 delivery date was missed. The streamer agreed a new date in July, which was met. The drama finished 13.1% over budget, about $680,000 on $5.2 million, so the $520,000 contingency covered most of it and the producers' deferred fees covered the rest. The incident rate kept climbing, to 3.6 by September 2026, with no new incident. The hours behind the rate fell once the crews went home.

Projected ROI across the two films fell to 10.9% in January 2026. The thriller's sale to a US distributor in February lifted it to 13.8%, and it ended September 2026 at 13.2%, against 19.4% when the board started. Same company, same ten KPIs. The difference was settled in prep, before anyone shot a frame.

List of Film Production KPIs

Only the incident rate has a published US benchmark, from the Bureau of Labor Statistics. The rest are marked starting point: replace them with your own figures after a couple of productions.

Why Film Production Dashboards Matter

On a film, the numbers that matter are produced by different people on different schedules. The 2nd AD files the production report every night. Payroll runs weekly. The accountant's cost report lands on Friday, and the financiers see a summary once a month. A schedule that's quietly failing shows up in the first of those days before it reaches the last.

On a shoot, almost every fix is paid for somewhere else on the board. Pages per day can go up if the crew works past the budgeted day, which shows up as overtime and, on a long night exterior, as risk. Days behind can be bought back by spending contingency on a second unit. Prep can be cut to make an actor's window, and the cost shows up months later as days lost and missed post dates. On the drama, the overtime and the short prep were both chosen, and each looked reasonable on the day.

The return is where they all land. On a fixed license fee there's no upside to absorb an overrun, so the seven extra days on the drama came straight off the margin. The thriller's sale was what pulled projected ROI back above 13%. That's a reason to watch the board across both films. One film going well can hide another going badly, and you only see it if each is tracked on its own. For the same schedule and budget tension on a building site, see the construction project dashboard example.

Before you sign off the next shooting schedule, divide the script's pages by the shooting days and put the answer next to the pages per day your last three films actually shot. If the new number is higher than all three, you've found next year's overage in prep, when it's still cheap to fix.