Actual overtime cost fields

Description    The Actual Overtime Cost fields show costs incurred for overtime work already performed on tasks by assigned resources.

Data Type     Currency

Actual Overtime Cost (task field)

Entry Type    Calculated

How Calculated    When a task is first created, the Actual Overtime Cost field contains $0. If any actual overtime work is reported by assigned resources for the task, Microsoft Office Project calculates the actual overtime cost. The Actual Overtime Cost field is calculated by multiplying the value in the assigned resource's Overtime Rate field by the number of overtime hours reported.

Actual Overtime Cost = Overtime Rate * Actual Overtime Work

Best Uses    Add the Actual Overtime Cost field to a task view to review the resulting overtime expense of a task based on actual overtime work and the overtime rates of the assigned resources. You might find this useful while the task is in progress to see if you're staying within your budget for overtime. You can also use this information after the task is completed to help you plan costs and staffing for future projects.

Example    You're tracking costs on the "Conduct client meetings" task, which has planned overtime for Jamie and Chris. Jamie's overtime rate is $30 per hour, and the overtime rate for Chris is $25 per hour. So far, Jamie has reported 3 hours of overtime, and Chris has reported 4 hours of overtime. Project calculates that the actual overtime cost for this task so far is $190.

Actual Overtime Cost (resource field)

Entry Type    Calculated

How Calculated    When a resource is first added, the Actual Overtime Cost field contains $0. If any actual overtime work is reported by the assigned resource for any task, Microsoft Office Project calculates the actual overtime cost. The Actual Overtime Cost field is calculated by multiplying the value in the assigned resource's Overtime Rate field by the number of overtime hours reported.

Actual Overtime Cost = Overtime Rate * Actual Overtime Work

Best Uses    Add the Actual Overtime Cost field to a resource view to review the resulting overtime expense of a particular resource. You might find this useful during the course of the project to see if you're staying within your budget for overtime. You can also use this information after the project is completed to help you plan costs and staffing for future projects.

Example    You're tracking costs for Jamie, who has an overtime rate of $30 per hour. So far, Jamie has reported 10 hours of overtime. Project calculates that the actual overtime cost for Jamie so far is $300.

Actual Overtime Cost (assignment field)

Entry Type    Calculated or entered

How Calculated    When an assignment is first made, the Actual Overtime Cost field contains $0. If any actual overtime work is reported by the resource assigned to the task, Microsoft Office Project calculates the actual overtime cost. The Actual Overtime Cost field is calculated by multiplying the value in the assigned resource's Overtime Rate field by the number of overtime hours reported.

Actual Overtime Cost = Overtime Rate * Actual Overtime Work

Best Uses    Add the Actual Overtime Cost field to the sheet portion of the Task Usage or Resource Usage view to see the resulting overtime expense of a task based on actual overtime work and the overtime rates of the assigned resources. You can review this field while a task is in progress to see if you're staying within your budget for overtime. You can also find this information useful after the task is completed to help you plan costs and staffing for future projects.

Example    You're tracking costs on a resource assignment for a task that has planned overtime. The assigned resource has an overtime rate of $30 per hour. So far, the resource has reported six hours of overtime. Microsoft Office Project calculates that the actual overtime cost so far is $180.