/
/
See who is stretched and who has capacity in Harvest
For operations leads who want utilization and billable ratio per person, just by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Capacity questions end up in a spreadsheet
Finding who is overloaded means exporting hours, working out capacity for the period and dividing by hand. Then each outlier needs another look to see which projects they are on.
Without PopdockAI
- Export the team time report
- Calculate capacity and utilization in a spreadsheet
- Separate contractors by hand
- Look up assignments for each outlier
With PopdockAI
- Hours are compared with capacity for the period
- Contractors are reported separately
- Over and under-used people are flagged with assignments
- Rates are never shown
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Report utilization per person from `{period-start}` (default: first of this month) to `{period-end}` (default: today).
**Step 1: Hours**
Call `harvest-get-time-reports-team` with `period-start` and `period-end`. Use `total-hours`, `billable-hours` and `weekly-capacity`.
**Step 2: Compute**
* Capacity for the period = `weekly-capacity` x weeks in the period.
* Utilization = `total-hours` / capacity.
* Billable ratio = `billable-hours` / `total-hours`.
Report contractors separately.
**Step 3: Explain the extremes**
For the two highest and two lowest, call `harvest-get-project-user-assignments` with `user-name` and `active` true to show what they are assigned to.
**Step 4: Report**
Table sorted by utilization with flags: over 100 percent (burnout risk), under 60 percent (capacity available), billable ratio under 50 percent. End with who could take on more work.
**Rules & Guidelines:**
* This is a read-only job. Never call any Action tool (any tool whose name ends in create, update, delete, restart, stop or create-from-tracked-time).
* Never show cost rates or hourly rates.
**Validation:**
* If `weekly-capacity` is empty for a person, report hours only for them.Who it's for
One answer, three teams that use it
Operations managers
Spot burnout risk early
See who is logging more than their capacity for the period and what they are assigned to, so work can be moved in time.
Who in the team was over 100 percent utilization in Harvest last month?
Resource planners
Find room for new work
List people under 60 percent utilization with their current assignments, so new projects go to those with space.
Who has spare capacity in Harvest this month and what are they assigned to?
Department heads
Check the billable ratio
See who spends less than half their hours on billable work, with contractors reported on their own line.
Which people had a billable ratio below 50 percent this quarter in Harvest?
How it works
What PopdockAI does when you ask
You name the period. Your AI assistant reads the team hours and project assignments in Harvest, does the calculations and reports. Nothing is changed.
Ask
You give a period, or accept the first of this month to today.
Calculate
It compares logged and billable hours with capacity for the period, with contractors kept apart.
Explain
It looks up the assignments of the two highest and two lowest people.
Report
You get a table with flags and a note on who could take more work.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-time-reports-team
harvest-get-project-user-assignments
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Workload balance you can act on
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
