How to Build a Capacity Dashboard That Protects Your Creative Team
“Can we squeeze in one more project?”
Every creative leader has heard this question. Usually from a stakeholder. Often on a Friday afternoon. Always with a delivery date that’s already too close.
The answer is almost always yes — because the alternative is saying no without data, which feels political and risky.
So the team takes on the project. Existing work slips. Quality compresses. Someone burns out. The pattern repeats.
There’s a better answer than yes-by-default. It requires one tool: a capacity dashboard.
Why Most Creative Teams Don’t Have One
Capacity planning is treated as a finance function or PM nice-to-have. In creative teams, it’s neither owned nor measured. The result: creative leaders “know” the team is overloaded but can’t prove it — and stakeholders see only what ships, not what’s queued.
This information asymmetry is what gets creative teams overcommitted. Fixing it doesn’t require enterprise software. It requires a Google Sheet and three columns.
The Three-Column Capacity Dashboard
Column 1: Available Hours
Total available creative hours this week. Calculated as:
(Number of team members) × (40 hours) − PTO − standing meetings − admin time
For a team of 8, this typically lands around 240–260 working hours per week after meetings and admin.
Column 2: Committed Hours
Total estimated hours required by all active and queued projects. This requires each project to have an estimated hour budget at intake — which is why this dashboard depends on having a real brief template.
Column 3: Utilization Status
Calculated as Committed ÷ Available, displayed as a status:
GREEN (Under 80%): Capacity exists. New work can be accepted.
YELLOW (80–95%): Selective intake only. New work requires deprioritization.
RED (Above 95%): Closed to new work. Existing commitments at risk.
That’s the entire dashboard. Three columns, one calculation, three status colors.
Why 80% Is the Real Threshold
The instinct is to run at 95–100% utilization — “maximize productivity.” This is the single most common mistake in creative resource planning.
Above 85% utilization, three things happen: quality compresses (creatives lose time for craft), urgency response disappears (no buffer for real urgent requests), and burnout accelerates (sustained high utilization is the leading indicator of attrition).
Healthy creative teams target 75–85% utilization. The remaining 15–25% is buffer for urgent requests, learning, internal initiatives, and the unaccounted complexity that always shows up in creative work.
This isn’t “underusing” the team. It’s the actual sustainable rate of creative output.
The Weekly Cadence
The dashboard becomes useful when it’s embedded in a weekly rhythm:
Monday morning: PM updates the dashboard with current capacity status.
Monday 1:1 with CD: Brief 15-minute review. If yellow or red, decide what gets deprioritized.
Friday close: Log actuals. Did estimates hold? This data improves estimation accuracy over time.
After 8–12 weeks, the dashboard becomes a powerful planning instrument. Estimation tightens. Patterns emerge. Stakeholders learn to plan around real capacity.
How This Changes the Stakeholder Conversation
When a stakeholder asks “Can we squeeze in one more project?”, the answer becomes:
“We’re currently at 92% utilization — yellow status. To take on this project, we’ll need to deprioritize one of these three current commitments. Which would you like us to delay?”
This is a different conversation. It’s not “no.” It’s “yes, with explicit tradeoffs.” Most stakeholders, faced with a real tradeoff, will deprioritize their own “urgent” request because they didn’t realize what it was displacing.
The work that survives this filter is the work that should survive.
How This Protects Your Team
Beyond operational benefits, the dashboard makes burnout structural instead of personal.
Without one, when the team is overloaded, the narrative becomes “the team can’t handle the work.” With one, the narrative becomes “the demand exceeds available capacity — here’s the data, here’s the gap, here’s what we need.”
The first narrative leads to performance reviews and attrition. The second leads to budget conversations and headcount decisions.
Take the StoryOps AI Friction Index. The Planning & Capacity dimension scores how visible your team’s capacity actually is to leadership — and what it’s costing you. Free, 2 minutes.
Start This Week
You can build version 1 of this dashboard in 90 minutes. A simple Google Sheet. Three columns. Weekly update. Share it with your team and your VP.
The first time you walk into a stakeholder meeting and say “We’re at red status this week” — with data behind it — the conversation changes permanently.
Capacity visibility is the cheapest, fastest, highest-leverage intervention available to most creative leaders. Build it before you need it.