How to apply different pay rates for Material Resources in MS PROJECT 2013?

 

Hi,

again, my Blog reader has a problem:

Hi dear
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

OK! I’ll do it in MS PROJECT 2013!

First thing first.

I will add two Tasks in MS PROJECT 2013:

image

Now I will add Concrete as Material Resource in My Project:

image

Now let’s say that this $1 is price per m3, and price per ton is $10 (just for example!)

I will put this $10 here:

image

Now suppose that for Task 1 I want to assign 10 m3 of Concrete, and for Task 2, 20 tons of concrete.

First for Task 1:

image

I will do the same thing for the Task 2 (with 20 in Units Field, and if I look at the Cost Table I’ll see:

image

Now, I need to change pay rate for Task 2. I will go to Resource Usage View:

image

Let’s look at the Cost Table again:

image

You can see that for Task 1 there is 10 m3 of Concrete with 1$ Price, and that makes Total Cost = 10*1=$10. For the Task 2 there is 20 tons of Concrete with 10$ Price, and that makes Total Cost = 20 * 20 = $20!

Piece of cake.

 

Regards!

I

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, Microsoft Project 2013, MS PROJECT 2010, PMI, PRoject Management and tagged , , , . Bookmark the permalink.

4 Responses to How to apply different pay rates for Material Resources in MS PROJECT 2013?

  1. Jame says:

    This was helpful and easy to follow. Thank you

  2. Steve Golubov says:

    Steve Golubov,
    Just discovered your blog today, wonderful. All the best and happy easter

  3. Hieu Ho Trung says:

    It is wonderful!

  4. Eric Gagné says:

    Just discover your blog today and wanted to thank you for your time and the good information.

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