Measuring Utilization - Utilization Report

The Utilization report is about whole resources. This makes it possible to understand resource utilization across your entire organization. For example if your resources are over/under allocated or the type/number of hours worked.

Ginsu Report

If you want more granularity to analyze your resources by specific projects, roles, or task codes then you need to use the Ginsu report (with one exception: you can filter out projects with low likelihood.) Along this same vein, the utilization report will give you generalized holiday time and time off, but if you wish to see specifics you will need to use the Ginsu report.

Additional Resources

The Topic of the Day: Utilization webinar is a great resource to learn about managing and measuring resource utilization with Projector. (go to 14:21)


The Utilization report computes utilization based on a range of engagement types and enables comparison of utilization rates in the same report. All utilization computations use the same denominator, as determined by the RDC basis and the utilization calculation method. They vary in terms of the numerator. There are a large number of predefined utilization metrics available, however most can be divided into the following broad categories. A more detailed chart can be found at the bottom of this article.

Hours

The actual number of hours devoted to a utilization category, such as hours worked, billable hours worked or available hours to work.

Percent

A percentage of a resource's utilization based on how your installation is set to measure RDC. See Measuring Utilization to read about Projector's RDC settings and how they affect utilization measurements.

Full Time Equivalent (FTE)

The most precise way to compare resource supply and demand is to use hours, as hours always represent the same amount of time. However, a user may prefer to think in terms of people, not hours. Therefore Projector enables reporting based on FTEs (full-time equivalents). The formula used is

  • (Hours / FTE-Hours) = FTE.
  • FTE-Hours are the difference between the resource's location's normal working hours and the holiday hours. For example:
    • If a resource is scheduled to work 32 hours in a week that has no holidays then the demand for that resource is 0.8 FTEs, and the supply is 1 FTE.
    • If a resource is scheduled to work 32 hours in a week that has one 8-hours holiday then the demand and supply are both 1 FTE.

Whenever resource demand is specified in Projector there is always a resource location specified, so the number of hours in an FTE is never ambiguous.

Vacation hours are not considered in the computation of FTEs because resources in the same location will have different vacation schedules, which would make it difficult to compare supply and demand using FTEs.

Subtracting holidays is somewhat problematic when resourcing from locations with different holiday schedules, but that is the nature of using the FTE metric.

The computation of an FTE is dependent on the Major and Minor timescale set on the column fields tab of the utilization report. For example, if you report supply and demand by week then 1 FTE is 1 resource working all FTE hours that week – one person-week. If you run a report for an entire year and break the report into monthly time buckets then a person who is available to work all year will appear as 1 FTE each month, and 12 FTEs (12 person-months) for the entire year.

Headcount

A headcount of one is calculated for each resource available to work in the specified time period. Therefore a resource that is active for only one day carries the same headcount as a resource that is active an entire month. If you want to understand capacity at a more granular level then it makes more sense to use an hours or FTE utilization report.

The headcount is calculated in a similar way as FTE's. If you run a report for an entire year and break the report into monthly time buckets then a person who is available to work all year will appear as a headcount of 1 each month, and a headcount of 12 for the entire year.

When reporting below the resource level (e.g., title, cost center, location) then headcount is 1 for each unique record at that level. For example, assume that the report includes both resource display name and resource title. Fred was promoted from a Consultant to a Senior Consultant in the middle of a reporting time bucket. The report will have one row for Fred as a Consultant and one row for Fred as a Senior Consultant. The headcount will be 1 for each row. This treatment allows you to count the number of Consultants and the number of Senior Consultants. But if you want to count only the number of resources then you must run the report without including the resource title.

Utilization Report Data Fields

When choosing the data fields for a report you can hover over the field to see a more detailed description.

Variable data Fields

Description

Engagement Types

For each engagement type specified under Administration -> Job accounting a data field will automatically be created. The following are default engagement types defined by Projector and may or may not be included in your installation.

FP

Billable (Fixed Price)

NTE

Billable (Not to Exceed)

T&M

Billable (Time and Materials)

G&A

General and Administrative

Pitch

Sales Pitch

Training

Training

Permanent Data Fields

Description

Available

Working Hours - Total Hours. Always zero for historical time. Hours are not available to you if they have already passed.

Billable Type

Hours on billable engagements

Billing Adjusted Rate

Billing rate after adjustments

Billing Adjusted Revenue

Revenue based on billing adjusted rate

Productive

Hours on productive engagements

Chargeable

Time is chargeable if its associated system revenue is non-zero

Contract Rate

Negotiated rate

Contract Revenue

Revenue that would be earned based on Contract Rate

Headcount

See specific details on this page

Holiday

Time off based on resource location

Missing

Working time - Total time. For projected time this is always zero. You cannot miss time if it has not happened yet.

Net Available

Working time - Total time. If the number is positive then the resource has available hours to work on other projects. If negative the resource is overallocated. These hours are spread over the measured time period so even if a resource is overallocated on some days, if they are underallocated on other days the net results could be available.

Non-Billable Type

Time on nonbillable engagements

Normal

Time including holiday and time off. This is the number of hours a resource normally works each day of the week. This is determined by the resource's location work schedule, but can be overridden for each resource.

Overallocated

Total Hours - Working Hours. Always zero for historical time because hours in the past are no longer allocated, they are worked.

Overtime

A salaried w/ overtime employee exceeds Normal time

RDC Basis

Number of hours resource is paid in this time period

Resource Direct Cost

RDC Basis Hours times RDC

Resource Direct Rate

RDC / Utilization Basis Hours

Resource Margin

Resource Project / System Revenue

Resource Profit

System Revenue - RDC

Resource ROI

Resource Project / RDC

Standard Rate

Billing rate based on resource cost center

Standard Revenue

Revenue that would be generated if engagement is billed at the standard rate

System Rate

Actual or projected billing rate after billing and revenue adjustments

System Revenue

Actual or project revenue after billing and revenue adjustments

Timeoff

Paid + Unpaid time off work

Total

Billable Time + Nonbillable Time

Utilization Basis

Determined by the RDC Basis. See Measuring Utilization

Working

Normal Working time - Holiday time - Timeoff time