The People Explorer report shows important KPIs for your people grouped by weekly, monthly, and quarterly periods.
IMPORTANT
Read more about how Runn accounts for scheduled vs. actual hours, placeholders, tentative projects, and overtime in the Reports Guide.
Tentative projects are excluded from this report.
Scheduled time off is included in the utilization calculation.
For utilization metrics, the Totals row on this report gives the average utilization rate across all people (100% + 50% = 75%), not the utilization rate for the entire business (i.e. it is not total hours / total capacity).
For all other metrics, the Totals row on this report gives you the sum across all people.
If a person is archived and there are no scheduled/actual hours associated with them, they will not show up in the People Report.
People Explorer Metrics
All metrics on the People Explorer Report are rounded to the nearest whole number.
Billable Hours | The number of hours that are scheduled or logged on billable assignments. |
Non-billable Hours | The number of hours that are scheduled or logged on non-billable assignments or projects. |
Total Hours | The sum of Billable Hours and Non-billable Hours. |
Contracted Capacity | The number of hours as stated in the person's contract. |
Time Off Hours | The number of time off hours. |
Effective Capacity | A person's total available hours. |
Overtime | The number of hours a person is scheduled/has logged above their Effective Capacity. |
Remaining Availability | Effective Capacity - Total Hours |
Billable Utilization (%) | The percentage of a person's effective capacity that is scheduled/logged as Billable Hours.
Billable Hours / Capacity * 100 |
Total Utilization (%)
| The percentage of a person's effective capacity that is scheduled/logged on both billable and non-billable hours.
Total Hours / Capacity * 100 |
Revenue ($) | The revenue a person is expected to earn on projects. |
Project Costs ($) | The labor costs you are expected to incur from a person doing assigned work on a project |
Business Costs ($) | The fixed costs of a person, based on their hourly cost-to-business. |
Detailed Toggle
When the detailed toggle is on, you can view the calculation for Billable Utilization and Total Utilization, per project.
Billable Utilization % (per project) | Billable Hours for project / Effective Capacity |
Total Utilization % (per project) | Total Hours for project / Effective Capacity |
Example
Click on the images to enlarge
Romeo is scheduled to work as a developer on the Model Z User Interface project in February. His contract states that he works 8 hours per day (Contracted Capacity).
The project has a developer rate of $150 and Romeo's cost to the business is $70.
Billable hours = (8h * 7 days) + (10h * 2 days) = 76 hours
Non-billable hours = 8h * 2 days = 16 hours
Total hours = 76h + 16h = 92 hours
Time off hours = 8h * 4 days = 32 hours
Capacity = (8h * 20 days) - 32h = 128 hours
Overtime = 92h - 128h = 0 hours overtime
Remaining availability = 128h - 92h = 36 hours
Billable utilization = 76h / 128h * 100 = 59%
Total utilization = 92h / 128h * 100 = 72%
Revenue ($) = $150 * 76h = $11,400
Project Costs ($) = $70 * 92h = $6,440