| Tip |
|---|
To see holidays and time off in the Ginsu report you must check the appropriate box on the parameters tab. |
| Tip | ||
|---|---|---|
| ||
The Topic of the Day: Utilization webinar is a great resource to learn about managing and measuring resource utilization with Projector. |
The Ginsu report enables customized utilization reporting in two flavors:
...
The utilization fields are explained in the table below:
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 | Normal Working Hours - Holiday Hours - Timeoff Hours | |
Utilized Hours | 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 | 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 | Utilized Hours / Utilization Basis Hours, shown as a percentage. Aggregates to higher levels by summing Utilized Hours and Utilization Basis Hours separately, then then dividing. | |
Net Available Hours | 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 | Net Available Hours / Working Hours, shown as a percentage | |
Resource Equivalents | Utilized Hours / Utilization Basis Hours, shown as a fraction. Aggregates to higher levels by summing. |
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>>".