Convert available production hours into a bounded concept slate
Media budget cannot buy a concept the production team has no time to finish. A reproducible illustrative example with editable inputs and explicit limits.
Media budget cannot buy a concept the production team has no time to finish. This worksheet estimates capacity after reserving hours for existing commitments. It exposes the time constraint before a plan is described as a high-volume creative programme.
Define the calculation before using it
Subtract committed hours from genuinely available team hours, divide by hours per completed concept and round downward. The completion definition should include agreed review and export work. A rough concept and a traffic-ready asset are different deliverables; mixing them makes a capacity estimate look more generous than reality.
Work through the synthetic example
With 320 hours available, 80 committed elsewhere and forty hours per completed concept, capacity is six concepts. If review rework doubles the requirement, capacity halves without a headcount change. The sensitivity view lets a producer demonstrate that effect without inventing an industry productivity benchmark.
| Output | Worked-example result |
|---|---|
| Available concept hours | 240.0000 |
| Whole concept capacity | 6.0000 |
Use the artifact and preserve its assumptions
Open the editable calculator to change the inputs and inspect the sensitivity view. The CSV records synthetic inputs and expected outputs; the JSON fixture keeps the equations available for reproduction. These calculations have been checked against the stated example. No measured campaign data is included.
The sensitivity rows vary only perConcept by 20% below and above the entered value. They are scenarios, not confidence limits or a forecast distribution. A row outside the model’s constraints is labelled rather than turned into a plausible-looking result. Save the chosen inputs with the decision so another reader can distinguish a changed assumption from a changed formula.
Evidence and limits
Google distinguishes average daily budgets from campaign total budgets. This planning worksheet does not itself set a platform limit; verify the campaign’s actual budget mechanism before translating a plan into account settings. See Budgets overview, especially “Average daily budgets and spending limits; Other types of budgets”.
This model ignores dependencies, skill specialisation and variable revisions. Confirm the critical path and named availability before turning arithmetic capacity into a delivery promise.
Background: A Creative Brief Template That Playable Teams Actually Use and Playable ad file size budgets by network. These existing articles provide context; the present calculation does not verify every archived claim.
