You are here:

Resource Alignment

The PPA Resource Alignment dashboard allows Project Managers and Portfolio Managers to view and monitor the allocation and utilization of resources across various projects. It displays the details of the resources who were allocated to the projects and their performance in terms of number of projects worked on and effort variance. It also displays the weekly trends of utilization, overtime, actual effort and effort variance across projects providing a clear picture of how well aligned the allocated resources are with the expectations of the Project Manager.

This dashboard consists of the following sections:

Project Distribution:This section displays a bubble chart juxtaposing the Project Utilization % and Project Allocation % of the selected resource(s) across projects.
Utilization & Overtime Weekly Trend: This section displays a week-on-week trend of Overtime hours and Project Utilization % over the years selected using the timeline at the top.
Actual Hours & Effort Variance Weekly Trend: This section displays a week-on-week trend of Resource Actual Hours and Effort Variance over the years selected using the timeline at the top.
Resource Details: This section displays a grid with details about all selected resources such as Employment type, primary role, tenure, number of projects that the resource is working on, Resource Allocated hours, Overtime Hours, and Effort Variance.
Project Details: This section displays a grid with details about projects within all selected portfolios such as Resource Planned Effort, Resource Allocated and Actual Hours, Effort Variance, Timecard Non-compliance %, Project Utilization %, Resource Planned Effort Cost, and Resource Actual Cost.

Metrics Used:

Metric Name	Description	Formula	Expected Values
No. of Projects	Total number of projects	Count ([No. of Projects])	0 or >0
Project Allocation %	The percentage of hours that are allocated to projects as compared to the 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
Missed Project Credit	The cost incurred in the event of an allocated resource not working on a project	([Resource Actual Hours] - [Resource Planned Effort (Hours)]) * [Avg Hourly Rate]	0, >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 Planned Effort (Hours)]) THEN ([Resource Actual Hours] - [Resource Planned Effort (Hours)]) ELSE 0)	0 or >0, closer to 0 is ideal
Timecard Non-Compliance %	The percentage of actual time spent by a resource which is less than the allocated hours for projects	1 - ([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
Effort Variance	The effort difference between the allocated and actual effort of a resource	([Resource Allocated Hours] - [Resource Actual Hours])	0, <0, or >0
Resource Allocated Hours	Total number of hours allocated by resource manager to projects	Sum (Resource Allocated Hours)	0 or >0
Resource Planned Effort (Hours)	The hours planned for a resource for a task or project	Sum [Resource Planned Effort (Hours)]	0 or >0
Resource Planned Effort Cost	The planned cost for a resource for a task or project	Sum [Resource Planned Effort 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