You are here:

Overtime

The PPA Overtime dashboard allows a Resource Manager to understand the impact of resources working overtime across different projects and portfolios across different departments and geographical locations. The Resource Manager can also view the Overtime Cost, Capacity Overtime Cost, Overtime %, and Capacity Overtime % metrics for the selected departments and locations during the selected months.

Using this dashboard, the Resource Manager can answer the following questions:

Are the overtime hours high for resources associated with a specific role?
How are the different employee types such as Full Time Employees (FTE), contractors, Part Time Employees (PTE) etc. placed in terms of overtime? Do certain employee types clock in significantly more overtime as compared to others?
How can a Resource Manager analyze overtime from different perspectives? For instance, can a Resource Manager analyze overtime with respect to allocated hours or expected effort or with respect to a resource's capacity?
What are the costs incurred due to overtime logged by the resources?

This dashboard consists of the following sections:

Overtime by Emp. Type: This section displays a horizontal bar graph showing the Overtime % metric for various employment types. Using this section, the Resource Manager can determine if the resources logging high overtime hours belong to the same employment type.
Note: The data displayed in the remaining sections of the dashboard are based on the employment type selected in this section
Demand Vs Effort Variance by Role: This section displays a heat map that helps you analyze the planned effort against effort variance for various roles. This means, for a given role, the heat map displays the initial planned hours for a resource in comparison to the effort variance of the resource.
Resource Time Card: This section displays a grid showing the week-on-week effort variance for different resources. The resources listed in this grid are based on the roles selected in the Demand Vs Effort Variance by Role section.
Weekly Overtime Trend: This section displays a line graph showing the number of overtime hours logged by the resources selected in the Resource Time Card section. This information is filtered by the projects these resources have worked on, in a given week. This allows the Resource Manager to view the overtime trend of all selected resources across different projects.

Metrics Used:

Metric Name	Description	Formula	Expected Value
Overtime Cost	Cost of the overtime hours spent by resources using the per hour rate of resource	([Overtime Hours] * [Resource Per Hour Cost])	0 or >0, closer to 0 is ideal
Capacity Overtime Cost	Cost of the capacity overtime using per hour rate of resource	[Capacity Overtime (Hours)] * [Resource Per Hour Cost]	0 or >0, closer to 0 is ideal
Overtime %	The percentage of overtime clocked in by the resources of projects as compared to total hours allocated for the project	[Overtime Hours] / [Resource Allocated Hours]	0 or >0, closer to 0 is ideal
Capacity Overtime %	Percentage of overtime hours against total capacity of resource	([Capacity Overtime (Hours)] / [Capacity Hours])	0 or >0, closer to 0 is ideal
Effort Variance %	The percentage difference between actual and allocated efforts of a project.	Avg([Project Effort Variance %])	0 - 100%, closer to 0 is ideal
Effort Variance	The difference between the allocated and actual effort of a resource	([Resource Allocated Hours] - [Resource Actual Hours])	0, <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
Overtime Hours	The extra hours clocked in by a resource for a project. The 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