Overtime, Costs, and Fixed Duration in MS PROJECT 2013

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.

image

Now I will add a new Resource:

image

I will assign Resource to the Task:

image

Now double click on the Task and:

image

Now let’ see the Cost Table:

image

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!

image

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

image 

 

and here it is:

image

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

image ¸

and I will get:

image

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:

image

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):

image

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

image

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:

image

The Cost Table:

image

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:

image

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

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

image

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:

image

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

image

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!

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 2013, PRoject Management and tagged , , . Bookmark the permalink.

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