To see holidays and time off in the Ginsu report you must check the appropriate box on the parameters tab. |
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 Ginsu report enables customized utilization reporting in two flavors:
The Ginsu report, unlike the Utilization report, lets you see both the utilization and the projects, holidays, and time off that contribute to the utilization. By selecting which projects to include in the report you can control the numerator in the calculation. For example:
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>>".