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.
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. |
Time Off Hours | The number of time off hours. |
Capacity | A person's total available hours. |
Overtime | The number of hours a person is scheduled/has logged above their Capacity. |
Remaining Availability | Capacity - Total Hours |
Billable Utilization (%) | The percentage of a person's capacity that is scheduled/logged as Billable Hours.
Billable Hours / Capacity * 100 |
Total Utilization (%) | The percentage of a person's capacity that is scheduled/logged on both billable and non-billable hours.
Total Hours / Capacity * 100 |
Non-billable Utilization (%) | The percentage of a person's capacity that is scheduled/logged on non-billable hours.
Billable 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. |
Example
Click on the images to enlarge
Romeo has been scheduled to work on the Model Z User Interface project in February as a developer. He normally works 8h per day.
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