Measuring Utilization - Variance 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)

You cannot see holidays and time off in the Variance report.

The Variance report is similar to the GInsu report in that by selecting which projects to include in the report you can control the numerator in the calculation. For example:

  • To compute billable utilization use the parameters tab to include billable engagements only
  • To compute utilization based on projects with a UDF of a specific value, run the report and filter the pivot table based on the UDF value

 Use it instead of Ginsu when you want to see reported utilization (that is, utilization based on history) compared to utilization based on booking for the same time period.

The utilization fields are explained in the table below. There is only one Normal Working Hours field, as its value is not dependent on reported or booked hours. Each of the other utlization-type fields can vary. For example, any field dependent on time off may vary if the time off reported is not equal to the time off scheduled. Note the there is currently never a difference between reported and booked holiday time, as holiday time is inferred based on the holiday schedule and is never reported.

Field

Description

Normal Working Hours

Hours that the 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.

Working Hours, Booked, Reported, and Variance

Normal Working Hours - Holiday Hours - Timeoff Hours

Utilized Hours, Booked, Reported, and Variance

Hours worked on projects. It does not include holiday or timeoff hours. Therefore to exclude the hours from a project (e.g., one that is non-billable) you must exclude that project from the report.

Utilization Basis Hours, Booked, Reported, and Variance 

The denominator for the utilization calculation, as determined by the RDC basis (e.g., Normal Working Hours, Normal Working Hours - Holiday Hours, or Normal Working Hours - Holiday Hours - Timeoff Hours).

Utilization, Booked, Reported, and Variance 

Working Hours / Utilization Basis Hours, shown as a percentage

Net Available Hours, Booked, Reported, and Variance 

Working Hours - Total Hours. If the number is positive then the resource has hours available for other projects. If negative then the resource is overallocated. The total net available hours for a period greater than a day may be positive even if the resource is overallocated on some days. Or may be negative even if the resource is available on some days.

Net Available Hours Percent, Booked, Reported, and Variance 

Net Available Hours / Working Hours, shown as a percentage


Utilization is a property of a resource, not of a project. So all of the above fields, except for Utilized Hours are defined for each resource, but not for the projects worked on by the resource. When the report shows data for a project the normal working hours, working hours, utilization basis hours, etc. will be zero. Only the total for the resource will contain the utlization percentage. You will also see a special utilization row with Hours Type = "U" (U = Utilization) that contains the resource-based data, such as Normal Working Hours. The project code for these rows will be marked with "<<Utilization>>".