Hi,

I got this issue from my Blog Reader:

“OK. I am entering in hours in overtime work field as the instructions note but when I view the cost table, only the regular hours are calculated in the cost. This task is fixed duration for the entire month. The reason is that as overtime is added more volume is processed and the schedule does not change. We are measuring/planning resource cost per task for each month.How do I get a total cost for regular and overtime hours spent on this task?”

As far as I understand, overtime hours are added to Actual hours! Let me try! With MS PROJECT 2013.

Now I will add a new Resource:

I will assign Resource to the Task:

Now double click on the Task and:

Now let’ see the Cost Table:

Task has ! month duration = 20 days = 20 * 8 hours per day = 160 hours, and because it is all Standard time ($100/hour) = 160 * $100 = $1600!

Now the overtime!

Click anywhere at the bottom part of the screen, and then:

and here it is:

Now, let suppose that I enter 40 hours as Ovt. work:

¸

and I will get:

The Task is now splinted, but will end sooner! Why, because the Resource will work 1 month (e.g. 160 hours, but 40 of them will be overtime! So this 40 hours does not mean that the Resource will work 40 hours more! NO! It will work 160 hours!)

Let us see a Cost Table:

160 hours = 120 hours (Standard time) * $100 (Standard rate) + 40 hours (Over time) * $200 (Overtime rate) = $12000 + $8000 = $20.000. Everything is fine!

Well let’s suppose that I want that my Resource work 200 hours (160 Regular + 40 Overtime):

There is no splitting! Now, let us see Cost Table:

200 hours = 160 hours (Standard time) * $100 (Standard rate) + 40 hours (Over time) * $200 (Overtime rate) = $16000 + $8000 = $24.000. Everything is fine!

Now let’s put some Actual Via Resource Usage View:

The Cost Table:

10 hours = 8 hours (Standard time) * $100 (Standard rate) + 2 hours (Over time) * $200 (Overtime rate) = $800 + $400 = $1.200. Everything is fine!

Now I will put 8 hours instead of 10:

8 hours = 8 hours (Standard time) * $100 (Standard rate)  = $800. Everything is fine!

And finally, I will put 16 hours instead of 10:

Now Be Careful!!! Initially work was 10 hours for this Task (8 hours regular and 2 hours overtime) When I put 16 instead of 10 MS PROJECT will calculate:

16 hours = 14 hours (Standard time) * $100 (Standard rate) + 2 hours (Over time) * $200 (Overtime rate) = $1400 + $400 = $1.800. Everything is fine!

What if you want to put some actual overtime work instead (for example 8 hours of actual and 8 hours of overtime work)? Piece od cake:

and then I will put 16 hours of Actual Work and 8 hours of Actual Overtime work:

16 hours = 8 hours (Standard time) * $100 (Standard rate) + 8 hours (Over time) * $200 (Overtime rate) = $800 + $1.600 = $2.400. Everything is fine!

I wish you a Mary Christmas!

Regards!