Capacity Matrix Template: The One Spreadsheet Creative Ops Managers Open Every Monday

Editor's note: The numbers here — available hours, utilization bands, the rules of thumb — are working estimates typical for in-house teams and creative agencies as of early 2026. Your actuals will vary. Track them and the matrix gets sharper.

On a lot of creative teams the capacity plan lives in one person’s head, and it’s wrong in the same way every week. The lead carries a confident picture of who’s free and who’s buried, then hands a rush job to the one designer who turns out to be three deadlines deep, while a copywriter mentally filed as “busy” sits with a clear afternoon. The mental model isn’t lazy — it’s just stale by Tuesday.

What finally fixes it usually isn’t a resource management platform. It’s a single spreadsheet, one tab, opened every Monday before the week’s planning and refreshed in about fifteen minutes. That spreadsheet is the capacity matrix, and this article is the template for building your own.

The matrix is deliberately small. One row per team member, one column per week, a number in each cell, and a thin band of color that tells you at a glance who is fine, who is full, and who is one rush job from dropping a deadline. It is not a project management tool, it is not time tracking, and it is not a Gantt chart. It is the one surface that answers the question a creative ops manager gets asked on a Monday: can we take this on, and if so, who?

What a Capacity Plan Actually Answers#

A capacity plan is not a forecast of everything. It answers four questions, and if your matrix answers these, it is doing its job — anything more is gold-plating. First: does each team member have room for what’s already committed this week? Second: where is the next bottleneck, and is it a person or a skill? Third: if a new project lands, who can absorb it without slipping a deadline? Fourth, and the one most teams skip: who is quietly over the line and heading toward burnout?

Notice what’s missing. The capacity plan does not tell you how long the work will take — that’s a timeline estimate, a separate discipline. It does not tell you what each person did with their hours; that’s time tracking, and most creative teams don’t need it. Capacity planning is the process of matching committed workload against available hours, week by week, so you can allocate new work to people with the right skills and the room to do it. Keep the scope that tight and the spreadsheet stays a fifteen-minute Monday habit instead of a second job.

The discipline matters more as the team grows. At eight people a lead can hold the roster in their head; somewhere past a dozen the mental model breaks, and resource management stops being intuition and starts being a surface you share. The creative operations manager owns that surface — or the head of creative carries it on a dotted line until they hire one.

The Anatomy of the Capacity Matrix#

Here is the layout. Each row is one team member; the columns split into two halves — a fixed left block that rarely changes, and a rolling set of week columns on the right that you refresh every Monday. The example below shows one person’s row across the fixed block plus the current week.

The left block is the part you set once and adjust quarterly. Role and skills matter because capacity is never just a headcount — you can have spare hours and still be blocked because the spare hours belong to a copywriter and the work needs a motion designer. Available hours is the honest weekly number after meetings, admin, and the standing internal work are subtracted; in the teams we work with that usually lands around 30 to 32 of a nominal 40 — yours may run lower — never the full 40. The rolling week columns carry the live numbers: allocated hours against that available number, the resulting utilization percentage, and a one-word status the color band makes readable across the whole grid in a single glance.

Two design choices keep this usable. Hold available hours below the nominal 40 — planning against 40 is how you book people to 110% without noticing. And cap the week columns at four to six; nobody can plan creative work twelve weeks out with any honesty, so a rolling six-week horizon is the most a good capacity plan should ever pretend to know.

How to Fill It In, Step by Step#

Building the matrix the first time takes an hour. Refreshing it after that takes fifteen minutes a week. Work through it in order.

• 1. List the team, one row each. Everyone who does billable or project creative work — designers, copywriters, motion, the producer. Leave out anyone whose time you don’t allocate to projects.
• 2. Set each person’s available hours. Start from their weekly contracted hours, then subtract standing meetings, admin, and recurring internal work. The number you’re left with is the real capacity you can allocate against. Be honest here; an inflated available number poisons every utilization figure downstream.
• 3. Tag role and skills. One or two skill tags per person is enough to spot a skill bottleneck later — “design + motion,” “copy,” “design + web.” You’re not building a competency matrix, just enough to tell whose spare hours can actually take the work.
• 4. Allocate committed work into the current week. Walk the live project list and write each person’s committed hours for the week into the cell. Use rough estimates — whole or half-days, not minutes. This is where a quick time-tracking glance or last quarter’s historical data helps you calibrate, if you have it.
• 5. Let utilization and status compute. Utilization is allocated divided by available — =Allocated/Available in the cell. Drive the status off it with a nested IF — =IF(Util>1,"Red",IF(Util>0.85,"Amber","Green")) — so the whole team’s state reads off the color without any arithmetic in your head.
• 6. Roll it forward every Monday. Delete the past week, add a new week column on the right, and re-allocate. Fifteen minutes at the start of the week. That cadence is the entire workflow.

Resist the urge to make it heavier. A creative ops manager who adds per-task hour estimates, billable-percentage targets, and a utilization dashboard usually discovers two months later that nobody updates it — the maintenance cost outran the value. The matrix earns its keep precisely because it is cheap to keep current. When you’re standing up creative ops from scratch, the capacity matrix is one of the first artifacts worth building, exactly because it’s this light.

Reading the Matrix: Overload, Bottlenecks, Burnout#

The point of the color bands is that the read is instant. Run your eye down the current-week column and the matrix surfaces three of those four answers at a glance — overload, bottlenecks, and burnout — before you’ve thought about any of them. Take the example grid above: one glance says Maya is over the line at 119% and Priya is maxed at 100%, and the only real slack is Leo’s — but it’s motion-only, so a stray web edit still has to land on Tom at 81%.

Overload shows up as a wall of red. A single red cell is a bad week for one person; two or three reds clustered in the same week is a planning problem you caused, not a personal one. When you see overload, the question isn’t “can they push through” — it’s which deadline moves, which deliverable drops, or who else can take a piece of it. The matrix turns “everyone’s slammed” into a specific, negotiable list.

Bottlenecks hide in the skill tags, not the hours. A common false read is a team that looks half-empty on hours but is jammed solid, because the only person who can do the work that’s queued is at 130% and everyone else is the wrong skill. Cross-reference the red cells against role and skills and the bottleneck stands out: usually one senior person or one scarce skill, and the fix is either redistributing within that skill, buying a freelancer, or moving the deadline. It’s a read pure headcount math can miss.

Burnout is the pattern across weeks, not the spike. One red week is a sprint; the same person amber-to-red for four weeks running is a burnout signal, and it’s invisible in any single-week view. The capacity matrix is one of the few tools that makes sustained overload legible, because the weeks sit side by side. When you spot a person carrying a red streak, treat it as a leading indicator and intervene before it becomes a resignation. Balancing workloads isn’t only about hitting deadlines — it’s one of the lowest-cost ways to catch workload risk before it turns into a resignation.

A working rule on the bands: green runs up to about 85% utilization, amber from there to roughly 100%, and red above 100%. Those thresholds are deliberately conservative, because a creative who is planned to exactly 100% has no room for the inevitable rush job, the sick day, or the round of feedback that lands late. Plan to leave slack and the team can absorb the surprises that creative work always produces. Treat the bands as starting defaults, not gospel — once you’ve watched a couple of months of real delivery, nudge them toward your team’s actual ceiling.

From Spreadsheet to System: When to Graduate#

The spreadsheet is the right tool for a long time — longer than most vendors will tell you. For a team between eight and forty people, a single well-kept tab beats most resource management tools, because it costs nothing to change and everyone can read it. Don’t let a sales pitch convince you the matrix is beneath you; it isn’t, until it genuinely is.

You’ve outgrown the spreadsheet when three specific frictions show up at once. The first is multi-tab sprawl — one tab per team, project allocations living somewhere else, and the numbers no longer reconciling between them. The second is staleness: the matrix is only true the moment you finish editing it, and the manual roll-forward can’t keep pace with how fast the project list churns. The third is the audience problem — the leads, the producer, and the people whose hours you’re allocating all need to see the same live picture, and emailing a screenshot of a spreadsheet stops scaling.

At that point a purpose-built management tool earns its cost, turning the matrix into a shared, live surface that pulls allocations straight from the project list. The two purpose-built resource schedulers come first, then the project tools that bolt a resourcing view onto boards you already keep:

The graduation isn’t a rebuild; it’s a port. Everything you learned filling in the spreadsheet — honest available hours, conservative utilization bands, the skill-tag bottleneck read — carries straight across. The tool changes; the discipline doesn’t. Teams that buy the tool before they’ve learned the discipline on a spreadsheet just get an expensive, equally-stale dashboard.

Whichever surface holds it, the capacity matrix is the same Monday habit it always was: open the tab, refresh the week, and read the colors, then allocate the new work to the person with both the room and the right skills. Keep it light and keep it honest, and it will answer the only question that matters on a Monday morning — can we take this on, and who.

Viacheslav Shuranov

Co-Founder at YetOnePro

Entrepreneur and software engineer with 20+ years building products that matter. From payment systems to telemedicine to media encoding, Viacheslav has led technical teams as CTO and Tech Lead across multiple startups. He co-founded YetOnePro to solve the creative workflow problems he encountered firsthand.

Contact author

If you want to leave feedback, suggest an addition, or report something outdated — reach out.

Related Articles

Guide11 min read

How Long Should a Creative Project Take? (A Working Estimate Guide)

Guide10 min read

The Creative Operations Manager: Role, Responsibilities, and Day-in-the-Life