Day rates per resources in Microsoft Project 2016

Hi, I have the question from my Blog reader: “After trying for weeks, I’m trawling the net for Microsoft Project, to find out how to add day rates per resource to the schedule. I can do this in SAP, but not every firm has it. These cost are variable and should change automatically if the duration increases, – lets say the dates get pushed out, and work takes place on a Saturday I should see a cost increase with out having to go through each activity one by one……
Have you work with this ?”

I will show you the solution using Microsoft Project 2016. first I’m going to create very simple Project, with one Task:

image

For this example I’m going to modify Standard Calendar in a way that every Saturday and Sunday will be working day:

image

Now I will create two Resources, John with $100 Standard rate, and Mary with $200 Standard rate:

image

Finally, I will assign John and Mary to the Task:

image

Let’s see the Cost Table:

image

and:

image

As you can see Total Cost is $12.000,00. John will work 5 days * 8 hours per day * $100 per hour = 40 hours * $100 = $4.000, and Mary will work 5 days * 8 hours per day * $200 per hour = 40 hours * $200 = $8.000. So John + Mary = $4.000 + $8.000 = $12.000

Now let’s say that John will be paid $150 per weekend and Mary will be paid $300. To do that I must do next:

image

and:

image

Now I will put 10 days in Duration for the Task:

SNAGHTML98abaaf

and again, let’s see the Cost Table:

image

As you can see Total Cost is $26.400,00. John will work 5 days * 8 hours per day * $100 per hour = 40 hours * $100 = $4.000, then on Saturday and Sunday he will work 2 days * 8 hours per day *  $150 = 16 hours * $150 = $2.400, and again from Monday to Wednesday he will work 3 days * 8 hours per day * $100 per hour = 24 hours * $100 = $2.400. So John will have $4.000 + $2.400 + $2.400 = $8.800
Mary will work 5 days * 8 hours per day * $200 per hour = 40 hours * $200 = $8.000, then on Saturday and Sunday she will work 2 days * 8 hours per day *  $300 = 16 hours * $300 = $4.800, and again from Monday to Wednesday she will work 3 days * 8 hours per day * $200 per hour = 24 hours * $200 = $4.800. So John will have $8.000 + $4.800 + $4.800 = $17.600. So John + Mary = $8.800 + $17.600 = $26.400

So this is solution! BUT! If you have those double rates for John and Mary for every weekend than you should put it manually, like I did for every weekend. there is no way to put so called “weekend” rates or something like that in MS Project. It is only date based.

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, MS PROJECT 2016, PMI, 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