How to track Actual overtime work in MS PROJECT 2010

 

Hi,

I received a question from one of my Blog reader:

“After calculating the costing for work and overtime work, I baselined the task and then did tried to do the actuals in the task usage sheet. I did this to check the actual cost and actual overtime cost. I was able to enter the actual work (hrs) for each day and was not able to do actual overtime work (hrs). Would you be able to assist as how to feed the actual overtime work in the task usage sheet.”

There is the way to put actual overtime work, but it is not an easy one.

First let me setup an example. I will add two Tasks in ma Project:

image

Now I will add two Resources to My Project:

image

and I will assign those Resources to my Tasks:

image

Now I am going to put some overtime hours:

image

I will click on the lower part of the screen and then I will get a new buttons in the Format Tag of the Ribbon:

image

and I will get:

image

For Task 1 I will put 16 hours in the Work Field, and 8 hours in the Overtime Work field. It means that it will have 1 day Duration, and 16 hours of total work:

image

For Task 2 I will put 32 hours in the Work Field, and 16 hours in the Overtime Work field. It means that it will have 2 days Duration, and 32 hours of total work:

image

I will apply the Cost Table and I will get:

image

Task 1 will have 8 hours regular work, and 8 hours overtime work. 8 hours * $100 (regular rate) + 8 hours * $150 (overtime rate) = $800 + $1.200 = $2.000.

Task 2 will have 16hours regular work, and 16 hours overtime work. 16 hours * $200 (regular rate) + 16 hours * $300 (overtime rate) = $3.200 + $4.800 = $8.000.

Now I will save the Baseline:

image

and I will get:

image

Now I will apply the Task usage View:

image

and I will get:

image

OK! Now, suppose that Actual work for Task 1 was 20 hours instead 16 hours, and for Task 2 was 18 hours per day instead 16 hours:

image

For Resource 1 (assigned to Task 1) you can see that Actual work is 20 hours instead of 16, but overtime work remains the same:

image

For Resource 2 (assigned to Task 2) you can see that Actual work is 36 hours instead of 32, but overtime work remains the same:

image

I will apply the Cost Table again:

image

Task 1  have 12 hours regular work, and 8 hours overtime work. 12 hours * $100 (regular rate) + 8 hours * $150 (overtime rate) = $1.200 + $1.200 = $2.400.

Task 2 will have 20 hours regular work, and 16 hours overtime work. 20 hours * $200 (regular rate) + 16 hours * $300 (overtime rate) = $4.000 + $4.800 = $8.800.

As you can see when you put Actual work it is considered as regular work.

But what if, for example, 20 hours spent at Task 1 was 8 hours of regular time, and overtime was not 8, but 12 hours?

image

Now, Task 1 have 8 hours regular work, and 12 hours overtime work. 8 hours * $100 (regular rate) + 12 hours * $150 (overtime rate) = $800 + $1.800 = $2.600.

An what is, for example. 36 hours spent at Task 2 was 16 hours of regular time, and overtime was not 20, but 16 hours?

image

Now, Task 2 have 16 hours regular work, and 20 hours overtime work. 16 hours * $200 (regular rate) + 20 hours * $300 (overtime rate) = $3.200 + $6.000 = $9.200.

Finally, let’s look at Work Table:

image

You can see, that I have added two more fields Overtime Work, and Actual Overtime Work.

OK! The conclusion! In the Task Usage View, you can’t put actual overtime work. You can do it in Task Form, as I mentioned before.

 

Regards,

Advertisements

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management and tagged , , , , , . Bookmark the permalink.

One Response to How to track Actual overtime work in MS PROJECT 2010

  1. dijeesh says:

    this is really helpful..thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s