Resource Utilization & Capacity Planner
An automated daily workflow pulls time entries and task assignments from your existing tools, calculates each team member's utilisation rate, and posts a capacity heatmap to Slack or a dashboard. People above 90% get flagged for burnout risk. People below 60% get flagged as available for new projects.
The Problem with Flying Blind on Capacity
You know your team is busy. But busy and productive aren't the same thing. And "busy" tells you nothing about who's three weeks from handing in their resignation because they've been running at 95% utilisation since February.
The numbers paint a clear picture. The target utilisation sweet spot sits between 65% and 75%. Push above that and burnout follows. Drop below 50% to 60% and you're not covering costs. Context switching and poor time management alone waste up to 40% of productive capacity. Meanwhile, 40% of finance leaders don't trust their own labour cost data.
Most agencies and consultancies track utilisation the same way: someone exports time entries once a week, drops them into a spreadsheet, runs formulas, and presents the results at the next team meeting. By then the data is already stale. The person who was drowning last Tuesday is now behind on two more projects. The person who had nothing to do last Wednesday still has nothing to do.
It's always reactive. You discover burnout after someone snaps. You discover underutilisation after payroll has already gone out. And staffing decisions get made on gut feel rather than arithmetic.
How It Works
The automation runs once a day, every morning before your team starts work. It pulls data from the tools you already use, calculates utilisation, and delivers a visual summary to wherever your team communicates. Here's the sequence.
1. Scheduled daily trigger
An n8n or Make workflow fires at a set time each morning (typically 7:00 AM). No manual action required. It runs before anyone opens their laptop.
2. Pull time entries from your tracking tool
The workflow connects to your time tracking platform (such as Harvest, Toggl, or Clockify) and pulls each team member's logged hours for the previous day. It categorises entries as billable or nonbillable based on project tags you've already set up.
3. Pull task assignments and estimates
In parallel, the workflow queries your project management tool (such as Asana, ClickUp, or Monday.com) for each person's assigned tasks and estimated hours. This gives you the forward looking picture: not just what happened yesterday, but what's coming this week.
4. Calculate utilisation rates
For each team member, the workflow divides billable hours by available hours (accounting for part time schedules, leave, and public holidays). It calculates a rolling weekly rate and a trailing four week trend. Senior staff get different target thresholds than junior team members, because a director at 40% billable utilisation is doing their job, not slacking off.
5. Generate capacity heatmap
The results feed into a colour coded heatmap, either in Notion, Looker Studio, or a shared Google Sheet. Green for healthy utilisation (65% to 75%). Amber for trending outside range. Red for burnout risk or serious underutilisation.
6. Flag at risk team members
Anyone above 90% utilisation triggers a burnout alert. Anyone below 60% triggers an availability flag for business development. If someone's trend has been climbing or falling steadily over four weeks, that gets called out separately as a drift warning.
7. Post to Slack and notify leadership
A formatted summary lands in your team's Slack channel each morning. A separate weekly digest goes to leadership with team level utilisation, capacity availability for new pitches, and any persistent flags that haven't been addressed.
Why Spreadsheets and Intuition Stop Working
At five or six people, a founder can hold team capacity in their head. They know Sarah's swamped because she mentioned it at standup. They know James seems quiet because he hasn't asked for help in a while. Intuition works when you can see everyone.
At ten people it starts to crack. At fifteen it's gone entirely.
The spreadsheet approach fills the gap for a while. Someone (usually the ops manager or a senior PM) spends two to three hours each Friday pulling reports, cleaning data, fixing formula errors, and building a summary. That summary arrives at Monday's meeting, based on data that's already three to five days old. And nobody looks at it again until the following Monday.
A design lead ran at 93% utilisation for six consecutive weeks. The weekly spreadsheet showed it every time. But by the time it appeared in the Monday meeting, the conversation had moved on to new project kick offs. She resigned on a Wednesday. Replacing her cost the agency four months and roughly 150% of her annual salary.
The problem isn't that the data didn't exist. It's that the data arrived too late, in the wrong format, without enough urgency attached. An automated daily alert with a burnout flag lands in the channel where decisions actually happen. It's hard to ignore a red indicator next to someone's name at 8 AM on a Tuesday.
What Changes When Capacity Data Is Live
Something interesting happens when utilisation data updates every morning instead of every week. Staffing decisions stop being arguments and start being arithmetic.
When a new project comes in, you don't need to ask around or guess who has bandwidth. You open the heatmap. Two people in the green zone with the right skill set. You assign the work in ten minutes instead of two days of back and forth.
When a client asks if you can take on an extra sprint, you don't promise and hope. You check the capacity forecast, see that your development team is at 82% for the next two weeks, and either push back the timeline or bring in a contractor. The decision is grounded.
And when someone's utilisation creeps past 85% for three weeks running, you catch it before they start updating their LinkedIn profile. That early warning is worth more than any retention bonus you could offer after the fact.
The Business Impact
Take a 12 person professional services firm billing at $180 per hour. If your average utilisation sits at 58% instead of the 68% target, each team member is leaving roughly eight billable hours per week on the table. That's $1,440 per person per week. Across 12 people, that's $17,280 per week, or just under $900,000 per year in unrealised revenue.
You won't capture all of that. Some of it is genuine downtime, training, or admin. But if automated capacity visibility helps you recover even a quarter of those lost hours, that's $225,000 in additional annual revenue. For a system that costs a few thousand dollars to build and a few hundred per year to maintain.
Then factor in the retention side. Replacing a burned out employee costs 50% to 200% of their annual salary. Catching one burnout case early and redistributing their workload before they quit pays for the entire automation several times over.
- Daily utilisation visibility replaces weekly spreadsheet reports, saving two to three hours of ops time per week
- Burnout flags at 90% utilisation catch overwork weeks before it leads to resignations
- Availability flags at 60% make underutilised team members visible to business development within 24 hours
- Capacity forecasting enables confident commitments on new project timelines
- Role specific thresholds prevent false alarms for senior staff with lower billable targets
- Trailing trend analysis surfaces slow utilisation drift that weekly snapshots miss entirely
Frequently Asked Questions
Does this work if my team doesn't track time consistently?
The automation works with whatever time data you have. But it also exposes gaps. When someone sees their utilisation sitting at 20% because they forgot to log three days, they tend to fix their habits fast. The visibility itself improves tracking compliance, which is one of the more useful side effects.
Can it handle different utilisation targets for different roles?
Yes. Junior staff might have a target of 70% to 80%, while senior partners might sit at 30% to 40% (reflecting the strategic, nonbillable nature of their work). The automation applies role specific thresholds so a partner at 35% billable isn't flagged alongside a junior designer at the same number.
Won't my team feel like they're being monitored?
Frame it as protection, not surveillance. The burnout alerts exist to stop people being overloaded. The availability flags exist to make sure quiet periods get filled with interesting work, not just left to fester. When teams see the heatmap catching problems early and distributing work fairly, resistance drops quickly.
What time tracking and PM tools does this integrate with?
Any tool with an API. Common setups include Harvest, Toggl, or Clockify for time tracking paired with Asana, ClickUp, or Monday.com for task assignments. The dashboard can live in Notion, Looker Studio, or Google Sheets. The orchestration layer (n8n or Make) connects to all of them.
Do we really need this if we're a small team?
At five or more billable team members, the maths starts to justify it. One person underutilised for a single month at $150 per hour represents roughly $12,000 in missed revenue. One person burning out and quitting costs $50,000 to $150,000 to replace. The automation costs a fraction of either scenario.
Can it forecast future capacity, not just report on the past?
Yes. By pulling task assignments and estimated hours from your PM tool, the system calculates forward looking capacity for each team member. You can see who's booked solid next week and who has room before you commit to a new project or pitch.
How long does this take to set up?
Most implementations take one to two weeks, including connecting your time tracking and PM tools, configuring role specific thresholds, and building the dashboard. The workflow itself runs unattended after that. Book your free audit and we'll map out exactly which tools to connect and what your capacity heatmap should look like.
Sources
- ClickTime: Utilization Dashboard and Billable Hours
- Ravetree: How to Improve Resource Utilization in Your Agency
- Mosaic: Best Practices for Forecasting Billable Hours in Agencies
- Flowace: Agency Utilization Rate Calculator
- TimeTackle: Resource Capacity Planning Tools
- Alto Accounting: Agency Profitability Guide
Automations we’ve already built
Thirty days after onboarding begins, an automated workflow surveys your client, pulls milestone data from your project tools, generates an AI written retrospective, and flags anyone who needs a recovery call. Every onboarding teaches the next one.
When a new client lands in your practice management software, this automation generates a tailored engagement letter with the right services, fees, and deadlines, sends it for electronic signature, then builds the client folder and kicks off your onboarding checklist. No chasing. No waiting.
A project manager fills out a short form after a discovery call. Within minutes, AI drafts a full Statement of Work into your branded template, routes it through Slack for internal approval, and sends it to the client for signature.
When a project closes in your PM tool, this automation collects every contract, deliverable, and sign off from across your systems, organises them into a standardised archive folder, and generates a summary PDF. No manual cleanup required.
When a contact is tagged in your CRM as needing an NDA, the agreement is generated from a template with their details prefilled, sent for signature, and tracked automatically. Overdue NDAs trigger reminders so nothing slips through.
Automatically converts raw meeting notes or recordings into structured, branded board minutes with tracked resolutions and action items, so your admin staff can stop spending full days on documentation that nobody reads until it's too late.
Capture scope changes on site, generate costed PDFs, route them through internal approval and client e signature, and log everything automatically. No verbal agreements, no lost paperwork, no payment disputes.
When a new contract lands in your cloud folder, an AI agent extracts the text, checks every clause against a risk framework, and sends your team a structured memo flagging the problems that actually matter. Preliminary review drops from hours to minutes.
When a new contractor lands in your HR system or Airtable base, this automation generates a complete document bundle, sends it as a single signing package through PandaDoc, and updates your records the moment everything is signed.
When a deal hits the proposal stage in your CRM, this automation pulls the client name, scope, pricing, and line items, then merges everything into a branded template. The finished PDF lands back on the deal record and in the prospect's inbox without anyone touching a document.
When every party signs a document in DocuSign or PandaDoc, this automation downloads the completed PDF, renames it to your filing convention, stores it in the right client folder, and notifies the account manager. No manual downloading, no misfiled contracts.
A scheduled workflow scans your contracts database daily, flags renewals at 30, 14, and 7 day intervals, and sends tiered alerts to account managers and leadership so nothing expires unnoticed.
When a new client is created in your CRM, this automation builds their billing profile, generates the first invoice, sets up recurring payments, and sends a secure link to collect their payment method. No manual data entry between systems, no forgotten first invoices.
When a project is marked complete in your project management tool, this automation pulls billable hours and rates, generates a branded PDF invoice, and emails it to the client with payment instructions. A copy lands in the client folder without anyone lifting a finger.
When a new patient books an appointment, this automation sends digital intake forms, collects consent and insurance details, converts everything to PDF, files it in the patient folder, and notifies your front desk. No clipboards. No data entry.
An AI agent that turns your meeting recordings into structured summaries, assigned action items, and tracked tasks across Slack, Asana, and Notion. No more post meeting admin, no more forgotten decisions.
An automated workflow pulls client KPIs from your data sources on the first business day of each month, populates branded report templates, converts them to PDF, and emails every client their personalised report before your team starts work.
Automatically classify incoming contracts by type, route each one to the right reviewer, and track every document through the review pipeline so nothing stalls in someone's inbox.
When a new B2B client submits their intake form, this automation reads every team member's role and sends each person the exact onboarding content they need. Billing contacts get payment setup. Project sponsors get the timeline. Day to day operators get tool access and kickoff details. Every stakeholder's progress is tracked independently until all are ready.
When a new client record lands in your CRM with a signed engagement letter, a prefilled contract is automatically generated and sent for e signature. No copying, no delays, no forgotten clauses.
When a prospect opens your proposal, this automation logs the view in your CRM, pings the assigned salesperson on Slack, and sends a templated follow up email if the document stays unsigned after 48 hours.
When a real estate agent fills out a short form with property details and buyer information, the automation generates a complete contract of sale, attaches the correct disclosure forms, and sends the full package to DocuSign with the right signing order.
Automatically converts approved quotes into signed service contracts with warranty terms, payment schedules, and scope definitions. No manual paperwork, no verbal agreements, no disputes three months later.
When a vendor sends a contract, AI extracts payment terms, liability caps, termination clauses and auto renewal dates into a structured row. Your procurement team can then compare every vendor agreement side by side, spotting bad deals before anyone signs.
Not ready to talk yet? Start here.
Everything we've learned building 300+ automations for small businesses, in one practical guide. Written for business owners, not engineers.
- Where your team's hours are actually disappearing
- The five automations worth setting up first and why
- How to calculate what manual work is actually costing you
- A step by step checklist to get your first automation live this week
Completely free.