Enterprise DNA
Guide Intermediate Omni Ops

How to Calculate Agency Team Utilization

Learn how to calculate agency team utilization with scheduled work, time records, and leave data, then use capacity gaps to plan assignments.

Sam McKay |
How to Calculate Agency Team Utilization

Why utilization gets misread at agencies

An agency can look fully booked while some people are waiting for work and others are covering late client requests. That usually happens because leaders are looking at one version of capacity, not the whole picture.

A project plan shows assignments. A time system shows hours already recorded. A leave calendar shows when people are unavailable. If those sources aren’t compared, a “free” designer might already be committed to revisions, while a strategist who appears busy may have hours reserved for internal work that can move.

For owners, partners, and GMs, this isn’t just a staffing question. It affects delivery dates, project margins, hiring decisions, and how much work the agency can accept. It’s also difficult to judge account profitability when the hours spent on reporting, revisions, and client requests aren’t visible. If that’s a related issue, start with how to calculate agency client profitability.

The practical answer is to calculate utilization using three kinds of data:

  • Scheduled work: What people are expected to deliver, by person and by week.
  • Time records: What they actually spent time on, including client work, internal work, admin, and rework.
  • Leave data: When they’re unavailable because of holiday, sick leave, or other planned time away.

Together, these sources help you see both what has happened and what’s coming. You can then assign work based on realistic capacity, not a spreadsheet that only records project hours.

Calculate capacity before utilization

Start with the working hours available for each person in the period you’re planning. Weekly calculations are useful for staffing and scheduling. Monthly calculations help with reporting and comparing trends.

A simple baseline looks like this:

Available hours = contracted working hours − public holidays − planned leave

For example, if a full-time employee has a 40-hour working week and one day of annual leave, their available capacity that week is 32 hours. If they work part time, use their contracted hours rather than applying a full-time assumption.

Then separate available hours from target billable hours. Not every hour should be client work. Internal meetings, training, sales support, and operational duties are part of running an agency. Decide what proportion of available hours each role is expected to spend on client delivery, and make that target explicit.

For instance, an agency might set different targets for a designer, an account manager, and a delivery lead. Those targets should reflect how each role works, not a single figure applied to everyone. An account manager who spends time on client communication, planning, and internal coordination may reasonably have a different billable target from a specialist producing deliverables.

The important thing is to keep the definition consistent. If one month’s utilization includes client meetings and another month’s calculation excludes them, the trend won’t tell you much.

Choose a utilization formula that answers a real question

There are several useful utilization measures. Name them clearly so people don’t mistake one for another.

Actual billable utilization measures billable time recorded against available working hours:

Billable hours recorded ÷ available hours × 100

If someone had 32 available hours and recorded 24 billable hours, actual billable utilization is 75%.

Scheduled utilization compares planned client delivery hours with available hours:

Scheduled client hours ÷ available hours × 100

This is a forward-looking view. It shows whether a person has work planned, but it doesn’t prove the work was completed or recorded accurately.

Target utilization compares actual billable hours with the billable hours expected for that person or role:

Billable hours recorded ÷ target billable hours × 100

This helps you see performance against a role-specific expectation. It can also show why a team member’s overall utilization percentage looks low when they’ve had substantial internal responsibilities or leave.

Keep scheduled utilization and actual billable utilization separate. If the two are combined into one number, you lose the difference between a future commitment and work that has already happened.

Combine schedules, time records, and leave

A useful utilization view needs a shared time period, a consistent person or role identifier, and a common way to classify hours. You don’t need perfect systems to begin, but you do need to know where each field comes from.

1. Get scheduled work into hours

Project schedules often contain tasks, dates, and owners without reliable effort estimates. A task that runs across five days isn’t necessarily 40 hours of work. Ask project leads to record expected hours by person and week, especially for work that’s already approved.

Separate client delivery from tentative work. A signed project with confirmed deadlines should carry more weight than a proposal that may not proceed. Mark estimates as provisional rather than treating them as committed capacity.

2. Use time records as the actuals

Time records should distinguish client delivery, client communication, internal work, and rework. This doesn’t mean asking staff to track every minute. It means having enough detail to understand where capacity goes.

Account managers can spend a substantial share of their week preparing monthly reports, building decks, and sending status updates. The time spent on reporting and related communications varies by agency and account model. If all those hours are recorded as general admin, leadership may miss how much account margin that work consumes.

The same applies to creative production. If a campaign requires multiple rounds of unplanned edits, time records need to show that rework rather than burying it inside a general project code. That’s how you distinguish an underused team member from a team member whose hours are being spent on work the estimate didn’t include.

3. Subtract leave before comparing hours

Import approved leave and public holidays before calculating capacity. If leave is entered after the schedule is built, a person can appear underbooked even when they’re unavailable for several days.

When calculating future capacity, include known leave for the planning window. For past utilization, use the leave that actually took place. Keep sick leave and other unplanned absences visible, but don’t treat them as a performance issue.

4. Check planned work against actual time

At the end of each week, compare scheduled client hours with time recorded. A large gap can have several causes: the schedule wasn’t updated, the work took longer than estimated, time wasn’t entered, or the person was redirected to another priority.

Don’t assume every gap is a staffing problem. Investigate the reason, then improve the schedule, estimate, or time code that caused the mismatch. For a deeper look at measurement choices, see this guide to tracking creative agency utilization rates.

Turn the numbers into assignment decisions

A utilization report is useful only if it changes what you do next. Use the combined view to answer four questions:

  1. Who has capacity soon? Look at scheduled hours after approved leave, then check current assignments and deadlines.
  2. Who is overloaded? Flag people whose scheduled client work exceeds their realistic available hours or whose recent actual hours repeatedly run beyond the plan.
  3. Which work can move? Separate fixed client deadlines from internal tasks or work that can be rescheduled.
  4. What should be assigned next? Match the new task to skills, account context, and delivery dates, not just the lowest utilization percentage.

Suppose a campaign needs 12 hours of design work next week. One designer has 20 scheduled hours in a 32-hour week, but their timesheets show that similar campaign work regularly runs over estimate. Another has 24 scheduled hours and a stronger fit for the brief. A simple capacity ranking might point to the first designer. A useful assignment decision considers both their schedule and the difference between planned and actual effort.

This is also where a shared view helps account leads. They can see whether a request fits within the agreed scope, whether an existing task needs to shift, or whether the agency should quote additional work. It’s safer than promising a deadline based on a team member’s reported availability alone.

If you want to compare approaches to the underlying data, read about software for tracking agency team utilization rates. If the manual weekly report is the bottleneck, this guide covers automating agency utilization reporting.

What an agent can do from end to end

An agent for utilization planning should do more than summarize hours. It should collect the inputs, flag data problems, calculate capacity, and prepare recommendations for a person to review.

A practical workflow could look like this:

  1. Collect the latest inputs. The agent reads approved schedules, time records, leave calendars, and role or skill information from connected systems.
  2. Match records. It checks that people, projects, dates, and hour categories line up. Unmatched names or missing time entries are flagged rather than silently ignored.
  3. Calculate capacity. For each person and planning week, it subtracts leave from contracted hours, then compares scheduled work with available capacity and role targets.
  4. Find exceptions. It highlights possible overloads, unexplained gaps between planned and recorded hours, and assignments that depend on tentative work.
  5. Draft next steps. It can prepare a list of assignments to review, questions for project leads, and a short explanation of why each item was flagged.
  6. Ask for human approval. A delivery lead or operations owner checks the inputs and recommendations before changing a schedule or committing to a client date.
  7. Record the decision. The approved assignment and any changed estimate go back into the system, creating a record for the next planning cycle.

The agent shouldn’t decide that a person is “underperforming” because their utilization falls below a target. It should surface the relevant details, such as leave, internal responsibilities, missing time records, or a project that is waiting on client feedback. People who manage delivery should make the final call.

A utilization workflow can sit alongside other agency operations. Agents can help with reporting, content production, and account health tasks, while utilization data helps leaders review how capacity is being used.

For a view of the broader offer, see Omni for marketing and creative agencies.

Connect utilization to the money

Utilization is not the same as profitability. A team can meet its utilization target and still lose margin if project estimates are too low, the mix of work is poor, or delivery requires repeated unplanned revisions.

The numbers become useful when you connect them to project economics. For each account or project, compare planned hours with actual hours by role. Then check whether the work was in scope and whether the time produced billable value. That helps distinguish a genuine capacity gap from a pricing or delivery problem.

For agencies in this vertical, operational leakage can add up over time. The actual amount depends on team size, account mix, and how much work is delayed, repeated, or delivered without being reflected in scope. Treat this as a prompt to examine your own records, not a prediction of what your agency will recover.

An underused specialist may point to weak forecasting or a sales pipeline that isn’t being translated into assignments. An overloaded account manager may indicate that reporting work is eating time that could support more accounts. If reporting takes a substantial share of AM time, review whether those hours are captured accurately and whether report preparation can be reduced. Adding headcount before understanding the work may increase costs without fixing the underlying workflow.

If you want to map these issues to your own systems and workflow, book a 60-min Omni Audit.

A practical weekly review

A weekly review doesn’t need a lengthy presentation. Keep it focused on exceptions and decisions.

Start with the next two to four weeks. For each person, compare available hours after leave with scheduled client work. Mark confirmed work separately from tentative assignments. Then review last week’s planned hours against actual time records.

Bring only the exceptions to the discussion:

  • People with assignments above available capacity.
  • People with no confirmed work in an upcoming week.
  • Projects where actual hours repeatedly exceed the estimate.
  • Time records that are missing or classified too broadly.
  • Work that can move, needs a scope conversation, or needs another owner.

Assign someone to resolve each exception and set a date for the next check. If a team member looks free because they’re doing internal work, decide whether that work should continue. If an account is taking more time than planned, agree whether to change the process, revise the scope, or revisit the fee.

This process also helps avoid treating utilization as a target to maximize at all costs. A schedule with no room for client changes, internal collaboration, or recovery time is fragile. The aim is to make commitments that the team can deliver, while keeping enough visibility to spot capacity that can be used productively.

What the Omni Audit gives you

The Omni Audit is a working session for mapping the manual work, systems, and handoffs behind a specific agency operation. It can help you identify practical next steps for the workflow.

For team utilization, that may mean finding out whether your data can support a reliable weekly capacity view, or first fixing inconsistent time categories and leave records. The point is to identify a useful first step based on your agency’s actual process, rather than assuming new software will solve a data or ownership problem.

See the AI audit for marketing and creative agencies to understand the fit. When you’re ready to map the work, book your 60-min Omni Audit.