Units field in Resource assignment – MS PROJECT 2016

Hi,

I’ve got a question from one of my Blog readers: “Max units field in Assign Resources are always in %? I want to use QTY instead of %, like we have 10 cranes available, and how many cranes are needed per task instead of using %.”

I will explain this with MS PROJECT 2016.

First of all, you have two choices when assign resources to the Tasks: to use % (percentage), or to use Decimals.  To clarify this, and what decimals means, I will create a simple Project with only one Task:

image

Now, let’s say that we have 10 Cranes, which are going to be charged per hour, so they will be concerned as worked resource. Let’s say that we have 10 Workers, and they will also be charged per hour. Now, suppose that we need Gasoline, as a Material resource, but it depends on working hours, e.g. we need, for example, 10 liters of Gasoline per hour. And last, we need 500 bricks, no matter how long will the Task take to finish.

Before I create those resources I will change setup for assignment units from Percentage to Decimal:

image

and then:

image

and finally:

image

Now I will create Resources:

image

As you can see, Max. Units are now in Decimal, instead in Percentages (e.g. 10 instead of 1000%).

Now I will assign 500% or 5 Cranes, 500% or 5 Workers, 10 liters of Gasoline per hour, and 500 Bricks:

image

As you can see, Costs are:

  • for Bricks are fixed (500 * $5= $2500)
  • for Crane are not fixed (5 days * 8 hours per day * $500 per hour * 5 Cranes = $100.000)
  • for Gasoline 5 days * 8 hours per day * $10 per hour = $4.000)
  • for Workers are not fixed (5 days * 8 hours per day * $100 per hour * 5 Workers = $20.000)

So, yes you can put Decimals instead of percentage, and you will get same results.

Hope this helps!

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