People Explorer Report

Important KPIs for your people grouped by weekly, monthly and quarterly periods

Shannon Toe avatar
Written by Shannon Toe
Updated this week

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.
โ€‹
Runn calculates Capacity from a person's contracted hours minus any Time Off 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

Did this answer your question?