I will explain how can you enter up pay rates for a resource to apply at different times in MS PROJECT 2010
Suppose that you have a Resource with name Mary. Mary is working on your project, and se has 300$ / day. From 23.06.2011 she will has +50% more (e.g 450$/ day)
First I will add two tasks and I will link them:
Now I will add Mary as Resource:
I have left Standard Rate $300/day.
Now I will add two pay rates for Mary. I will now +50%per day for Mary from 23.06.2011:
After I click OK I will get:
Now, I will assign Mary to the TASK 1:
You can see $7.200 in the Cost field. TASK 1 has 3 days duration, and Mary’s pay rate is $300/hour –> 3 days X 8 hours/day X $300 = $7.200
Now, I will assign Mary to the TASK 2:
You can see $16.800 in the Cost field. TASK 1 has 5 days duration, and Mary’s pay rate is $300/hour at 22.06.2011 and $450 from 23.06.2011 –> 1 day X 8 hours/day X $300 = $2.400 (22.06.2011) + 4 days X 8 hours/day X $450 (from 23.06.2011) = 14.400. $2.400 + $14.400 = $16.800
Now, I will choose the Cost Table:
and I will get:
If I delete row from pay rate:
I will get in Cost Table:
Why? TASK 1 has 3 day duration, and TASK 2 has 5 day duration = 8 days. 8 days X 8 hours / day X $300 / hour = 19.200.
Be very careful when you are adding or deleting pay rate for resurces.
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)!
Hi Nenad Trajkovski,
This is very good and informative article,can you please let me know which table/view does this different pay rate get stored ,in case if it is required to use for reporting purpose.
In the Cost Rate Table, but you can not see it directly. you can write a VB Macro to get those data!
You can’t get this directly. You can write a VB Macro for The Cost rate Table!
first I would like to say thanks for your above post, after that I would like to share one question with you which I have in mind, it is also something about cost calculation that’s why I am asking here:
How to set up different pay rate units such as ($/m, $/m2, $/m3, $/ton and so) … and that’s it. you know in most construction projects like building, roads, tunnel, canal even dam constructions cost of much of items such as excavation, drainage and so will calculated based on different pay rates as indicated above. for example if I want to setup cost of “excavation” task how I suppose to do that, if I have to setup unit pay rate of this task in resource sheets ? so which kind of resource I suppose to assign (work, material or cost resource) and how I use different pay rate ? or if I suppose to setup this kind of cost in different place, where is that place ?
with thanks and respect …
I’ll write a Blog post about your problem next week!
OH, its great … I will appreciate that.