Resource rates and Billing rates in MS PROJECT 2016

Hi!

I always get a question like this:

I need to charge an hourly rate per project.  My hourly rate is $100.00 per hour. I have an employee work for me.  Their rate is $20.00 per hour. I need to track both.
How do I do this in Project 2016? “

You can do it, in a limited way. I will show you how, using MS PROJECT 2016, and I will explain why you can not get what you obviously want!

First I will create Single Project with one Task:

image

And I will create Two Resources, John and Mary, with $20 as a standard rate:

image

Now I will make two Resource Custom fields:

image

and then:

image

Now I will create second Custom field, on the same way:

image

Notice, that I am using formula, where Billing amount is Billing Rate (Cost1) multiplied by work and divided by 60, and then rounded at two decimal places. The reason why am I dividing work with 60 is because work is expressed in minutes in formula, so if I want to get it in Hours I should divide it!

No I am going to show Billing rate in Resource sheet, and I will put $100 per John and Mary:

image

I will now assign John and Mary to both Tasks:

image

and I will now switch to Resource Usage View, and I will show the Billing Amount field:

image

As you can see for both John and Mary, Cost is $800 (40 hours * $20), and Billing Amount is $4000 (40 hours * $100).

BUT! If you look at the Task Usage View you can not get this new field (Billing amount), Because it is Resource based. That means that you can not compare two rates (regular and billing), for the Tasks. And that is no such a thing like default Billing rate for each resource.

It can be annoying, but before you think in that way remember that Microsoft Project is tool with which you manage your Project, and that means that you are tracing your Costs (Planned, Actual, etc.), not your revenue. Microsoft Project is not for billing purposes. You should use ERP (MBS NAV, SAP or other).

Hope I helped with a little bit more understanding of that!

Regards!

Advertisement

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

Connecting to %s