How is Overtime Work booked in PWA Timesheet

[Subhendra]

Hi Guys,

I am not able to figure out how to actual overtime work
is booked via Timesheet functionality of Project Web
Access in Project Server 2002. I need to make this
available urgently. Eventhough I can include the Actual
Overtime Work field in the Timesheet by adding this field
in the Published fields list but this field comes as read
only field.

Besides how is overtime cost calculated. For example each
resource has a standard rate & overtime rate which we
have created by adding the rate values in 2 diff. tables
for each resource. Do I need to create a custom cost
field to calculate cost for each task ???

Pl. help

Subhendra

 

[Dale Howard]

Subhendra --

If you are using the timesheet for the entry of actuals in PWA, you don't
need to add the Actual Overtime Work column to the task sheet on the left.
What you need to do is to add the Actual Overtime Work row of information to
the timesheet itself. To do this, click the View Options tab at the top of
the Tasks page, then select the "Show overtime work" option. This cells in
this new row of information should be formatted in white, indicating that
the values can be changed.

The cost for actual overtime work is calculated as the Actual Overtime Work
multiplied by the Overtime Rate for the rate table currently specified on
the assignment. For example, I have a resource who has an Overtime Rate of
$75/hr. on Rate Table A, and an Overtime Rate of $100/hr. on Rate Table B.
The resource performed 10 hours of Actual Overtime Work on an assignment in
which Rate Table B is specified, then the cost for the actual overtime work
would be 10 hrs. x $100/hr. = $1,000. If you want a Rate Table other than
Rate Table A, you MUST specify this, because Cost Rate Table A is the
default for every assignment.

To specify which Rate Table is used for calculating costs, open the project
in Microsoft Project 2002, then apply the Task Usage view. The assignments
for each task are the resource names which are indented and italicized below
each task. To change the Rate Table for any assignment, double-click the
assignment, and in the Assignment Information dialog box, change the Cost
Rate Table setting to the appropriate value, and then click OK. To quickly
change the Cost Rate Table for multiple assignments, you can temporarily
insert the Cost Rate Table column in the Task Usage or Resource Usage view.

To see the Actual Overtime Work entered by your team members, you can add
this row in the Task Usage or Resource Usage views in Microsoft Project
2002. To do so, right-click in the timephased grid (yellow/white
timesheet), then click Detail Styles. In the Detail Styles dialog box,
select Actual Overtime Work on the left and copy it to the right, then click
OK. Hope this information helps.

 

[Dale Howard]

Kevin --

Your answer is not correct. Entering actual work hours in only the Actual
Work field will not calculate overtime work or overtime costs, regardless of
hour many hours are specified for a typical work day. In order for actual
overtime costs to be calculated correctly, the hours that constitute
overtime work MUST be entered in the Actual Overtime Work field. Consider
the following example:

Resource A
Standard Rate = $50/hour
Overtime Rate = $75/hour

Resource A works 10 hours of Actual Work each day for 5 days during the work
week, when a working day is defined as 8 hours in the project Options dialog
box. Are you saying that Microsoft Project will automatically determine the
overtime work hours when it calculates the cost for this task, and bill
those overtime hours at the higher Overtime Rate? If so, the cost for this
task should be $2,750 (($50/hr. x 40 hours) + ($75/hr. x 10 hours))? Plug
the 10 hours of Actual Work each day into Microsoft Project and you will
quickly discover that the Actual Cost for this task will be only $2,500
($50/hr. x 50 hours).

When you plug 8 hours of Actual Work and 2 hours of Actual Overtime Work
each day for 5 days, you will see that Microsoft Project calculates the
Total Cost of this task correctly at $2,750, just as we would expect.
Microsoft Project does not factor in actual overtime costs as a part of the
total cost of a task unless the overtime hours are SPECIFICALLY entered in
the Actual Overtime Work field. Hope this helps.