The Anatomy of a Weekly Cost Report
The Weekly Cost Report is the single most important financial management tool during the principal photography of a film. Prepared by the production accountant and their team, this comprehensive report provides a snapshot of the film’s financial health. It is typically a detailed spreadsheet organized by the same line items and account codes found in the official production budget.
For each line item (e.g., ‘Director of Photography,’ ‘Camera Package Rental,’ ‘Location Fees’), the report presents several key columns of data:
| Column | Description |
|---|---|
| Budget | The original amount allocated for that specific line item. |
| Week’s Cost | The actual amount spent and committed for that item in the current week. |
| Cost to Date (CTD) | The cumulative total spent on that item from the start of production up to the current week. |
| Estimated Cost to Complete (ETC) | The production accountant’s professional forecast of the additional funds required to fulfill that line item through the end of the production. |
| Estimated Final Cost (EFC) | The sum of the Cost to Date and the Estimated Cost to Complete (CTD + ETC). This is the projected final cost for the line item. |
| Variance (Over/Under) | The difference between the Budgeted amount and the Estimated Final Cost. A positive number indicates a projected cost savings, while a negative number (often in parentheses) signals a budget overage. |
Its Role in Production Management
This report is not merely a historical record of spending; it is a proactive management tool. Producers and the Unit Production Manager (UPM) scrutinize the Weekly Cost Report to monitor financial performance and make immediate strategic decisions. If the report reveals a significant overage in the ‘Overtime’ category for the camera department, for example, the producers can instantly investigate the cause with the Assistant Director and UPM. They might discover that shooting days are running long due to technical issues or inefficient setups and can then implement changes to bring the schedule—and therefore the budget—back on track.
The ‘Estimated Cost to Complete’ (ETC) column is particularly critical. It requires the production accountant to be in constant communication with every department head to accurately forecast future spending. This forward-looking aspect allows the production team to anticipate financial problems before they become unmanageable. The report effectively serves as an early warning system for the entire production.
Distribution and Confidentiality
Due to its sensitive financial nature, the Weekly Cost Report has a very limited and controlled distribution. It is typically delivered at the end of each shooting week to a select group of key stakeholders. This includes:
- The lead Producers
- The Unit Production Manager (UPM)
- The studio or financier executives overseeing the project
- The completion bond company, if one is in place
The report allows the financiers to maintain oversight and ensure their investment is being managed responsibly. For the completion bond company—which guarantees that the film will be finished on time and on budget—the weekly report is an essential instrument for assessing their risk. A pattern of consistent overages will trigger close scrutiny and potential intervention from the bond company to protect their investment.