You are here:

Resource Level

The PPAResource Level dashboard allows Resource Managers to monitor the utilization, performance, effort variance, and other aspects of selected resources during selected months. This dashboard helps the Resource Manager to determine if each resource is being utilized optimally by comparing factors such as the resource's net available capacity, project utilization and overtime hours logged by the resource.

This dashboard consists of the following sections:

Effort Variance by Project: This section displays a combination of a line graph and a vertical bar graph showing the project-wise breakup of Resource Allocated Hours and Allocation Gap % metrics. The vertical bar for each project represents the resource allocated hours for the project whereas the line graph at the top of the bar represents the shortage in allocated hours as compared to the actual hours spent by the resource on the project.
Utilization Trend: This section displays two line graphs representing the Project Utilization % and Capacity Utilization % respectively. These metrics indicate the percentage utilization of a resource with respect to the allocated hours and their overall capacity respectively. This provides the Resource manager an insight into how effectively the resources are being utilized.
Allocation Trend: This section displays two line graphs representing the Project Allocation % and Resource Allocation % respectively. These metrics indicate the percentage time allocation of a resource for projects and percentage time allocation of a resource compared to the overall capacity respectively. This provides the Resource manager an insight into how effectively their resources are being allocated.
Net Available Capacity Trend: This section displays a week-on-week trend showing the net available capacity of resources. This allows the Resource Manager to identify periods of high resource availability and plan for better resource utilization in the future.
Overtime Trend: This section displays a line graph showing the week-on-week trend of number of overtime hours logged by selected resources. This allows the Resource Manager to identify periods of low resource availability and plan for better resource allocation in the future.
Resource Details: This section displays a table consisting of information about the selected resources such as the employment type, resource's primary role, primary skill, and other skills.
Resource Performance: This section displays a table with information about the performance of the selected resources such as the Project Utilization %, Capacity Utilization %, Resource Actual Hours, and Resource Allocated Hours, and the Average hourly rate.

Metrics Used:

Metric Name	Description	Formula	Expected Values
Allocation Gap %	Percentage of hours where resources are falling short and unable to meet their allocated hours	(([Resource Allocated Hours] - [Resource Actual Hours]) / [Resource Allocated Hours])	0 or >0, closer to 0 is ideal
Resource Actual Hours	Amount of actual project work logged by the resource using timesheets	Sum (Resource Actual Hours)	0 or >0, greater than 0 is ideal
Resource Allocated Hours	Total number of hours allocated by resource manager to projects	Sum (Resource Allocated Hours)	0 or >0
Project Allocation %	The percentage of hours that are allocated to projects as compared to total planned hours	[Resource Allocated Hours] / [Resource Planned Effort (Hours)]	0 or >0, closer to 100% is ideal
Project Utilization %	Percentage of actual hours logged by a resource as compared to their allocated hours	([Resource Actual Hours] / [Resource Allocated Hours])	0 or >0, closer to 100% is ideal
Resource Allocation %	Percentage of allocation done to a resource as per his capacity	[Resource Allocated Hours] / [Capacity Hours]	0 or >0, closer to 100% is ideal
Capacity Utilization %	Time spent by resource on project compared to its total capacity	[Resource Actual Hours] / [Capacity Hours]	0 or >0, closer to 100% is ideal
Net Available Capacity	Available capacity of resource after removing all engagements	[Capacity Hours] - [Resource Planned Effort (Hours)]	0 or >0, greater than 0 is ideal
Avg Hourly Rate	The average rate of work per hour for the project	[Project Actual Cost] / [Project Actual Effort (Hours)]	0 or >0
Resource Allocated Cost	The cost associated to the allocated resource. The resource can be allocated either at the task or project level.	Sum (Resource Allocated Cost)	0 or >0
Resource Actual Cost	The actual cost of all the resources associated with all the tasks within a project	[Resource Actual Hours] * [Resource Per Hour Cost]	0 or >0
No. of Allocated Projects	Same as No. of Projects. Indicates the total number of projects	Count([No. of Projects])	0 or >0
Overtime Hours	The extra hours clocked in by a resource for a project. Number of hours spent by a resource beyond the allocated time is considered to be overtime hours	IF(([Resource Actual Hours] > [Resource Allocated Hours]), THEN ([Resource Actual Hours] - [Resource Allocated Hours]), ELSE 0)	0 or >0, closer to 0 is ideal