Overtime cost fields

The Overtime Cost field shows the total overtime cost for a task, for a resource on all assigned tasks, or for a resource assignment. Overtime cost includes actual overtime costs already incurred by the resource in addition to any planned overtime costs on remaining work.

There are several categories of Overtime Cost fields.

Data Type    Currency

Overtime Cost (task field)

Entry Type    Calculated

How Calculated    When a task is first created, the Overtime Cost field contains the same value as the Remaining Overtime Cost field, which is the planned overtime for the task. As actual overtime work is reported, Microsoft Office Project calculates the remaining overtime work and remaining overtime cost and adds this to the actual overtime cost to maintain a continually updated Overtime Cost field.

Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost

Best Uses    Add the Overtime Cost field to a task sheet to review the running total overtime costs for tasks, combining actual and remaining overtime costs on an ongoing basis.

Example    You have planned 10 hours of overtime on a task for one resource with an overtime rate of $30 per hour. So far, the resource has reported four hours of overtime for $120 of actual overtime cost. The remaining overtime cost is $180. Adding actual overtime cost and remaining overtime cost together, the total overtime cost is $300.

Remarks    The overtime cost calculation is based on the overtime rates and the amount of overtime work assigned to each resource on the task.

Overtime Cost (resource field)

Entry Type    Calculated

How Calculated    When a resource is first added, the Overtime Cost field contains the same value as the Remaining Overtime Cost field, which is the planned overtime for the resource. As actual overtime work is reported, Microsoft Office Project calculates the remaining overtime work and remaining overtime cost and adds this to the actual overtime cost to maintain a continually updated Overtime Cost field for the resource.

Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost

Best Uses    Add the Overtime Cost field to a resource sheet to review running total overtime costs for resources, combining actual and remaining overtime costs on an ongoing basis.

Example    You had planned 15 hours of overtime on various tasks for a resource with an overtime rate of $30 per hour. So far the resource has reported five hours of overtime for $150 of actual overtime cost. The remaining overtime cost is $300. Adding actual overtime cost and remaining overtime cost together, the total overtime cost is $450.

Remarks    The overtime cost calculation is based on the Overtime Rate field for a resource and the amount of overtime work assigned to the resource.

Overtime Cost (assignment field)

Entry Type    Calculated

How Calculated    When an assignment is first made, the Overtime Cost field contains the same value as the Remaining Overtime Cost field, which is the planned overtime for the assignment. As actual overtime work is reported, Microsoft Office Project calculates the remaining overtime work and remaining overtime cost and adds this to the actual overtime cost to continually update the Overtime Cost field.

Overtime Cost = Actual Overtime Cost + Remaining Overtime Cost

Best Uses    Add the Overtime Cost field to the sheet portion of the Task Usage or Resource Usage view to display the running total overtime cost for the assignment, combining actual and remaining overtime costs on an ongoing basis.

Example    You had planned 10 hours of overtime on an assignment for a resource with a rate of $30 per hour. So far the resource has reported four hours of overtime for $120 of actual overtime cost. The remaining overtime cost is $180. Adding actual overtime cost and remaining overtime cost together, the total overtime cost is $300.

Remarks    The overtime cost calculation is based on the Overtime Rate field for the resource and the amount of overtime work assigned to the resource for the task.