Pricing Photo & Video Shoots: Day Rates, Crew Overtime, Kit Hire, Usage Licences & Job Wrap-Up

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Price Mara's creative days for a two-day campaign shoot: each day type at its share of the day rate, the total creative fee in one SUMPRODUCT, the full-day equivalents and what the job really earns per calendar day.
• Split each crew member's planned hours into time-and-a-half and double-time hours, price a full crew line with overtime, and compare it with the crew cost of a day that ends on time.
• Price kit hire with a rental house's three-day week, add the job's kit insurance, and book studio time in full and half-day blocks.
• Bill seven expense lines, add a handling markup only where the studio's policy allows it, and total the billed expenses and the markup earned with SUMPRODUCT.
• Look up territory and term factors, price each medium on its own, and then price the whole campaign as a package where every additional medium gets a discount.
• Price 36 retouched images in three tiers, turn a film and its cut-downs into edit hours including an extra revision round, and bill the editor in whole half-days.
• Add a contingency line on the cost-driven sections, calculate the estimate total with tax, measure the job's gross margin and chart what each section bills and costs.
• Compare actual costs with the estimate line by line, decide what is billable under Northlight's overage policy, calculate the final invoice and flag the overruns the studio had to absorb.