Estimation in hours and Resource Assignments with Fixed work Tasks in MS Project 2019

Hi,

very often Tasks are estimated by effort, not duration. And Tasks are fixed work type. Now the question is: “How many hours will each resource spend at the Task?”

I will show that in MS PROJECT 2019.¸

Let’s say that I have a Project with one Task which need effort 24 hour (I will show that in Task Usage View):

image

and that we have four Resources:

image

John is available 100%, Mary 50%, Peter 75%, and Paula 20% to work per day. So John can work max. 8 hours per day, Mary 4 hours, Peter 6 hours, and Paula 2 hours.

Now I will assign them to the Task:

image

So, Duration is 3 days, and each Resource will work 6 hours in Total. Let me explain the calculation:

  • Since total work is 24 hours, and we have four Resources, each Resource will have to work 24 hours / 4 Resources = 6 hours
  • John is 100% assigned. So according to formula Work = Duration * Units he will work 6 hours at first day, and he is done
  • Mary is 50% assigned. So according to formula Work = Duration * Units she will work 4 hours at first day, and remining 2 hours at second day
  • Peter is 75% assigned. So according to formula Work = Duration * Units he will work 6 hours at first day, and he is done
  • Paula is 25% assigned. So according to formula Work = Duration * Units she will work 2 hours at first day, 2 hours at second day, and remining 2 hours at third day.

No, suppose that only John and Paula will work on Task:

image

So, Duration is 6 days, and each Resource will work 12 hours in Total. Let me explain the calculation:

  • Since total work is 24 hours, and we have two Resources, each Resource will have to work 24 hours / 2 Resources = 12 hours
  • John is 100% assigned. So according to formula Work = Duration * Units he will work 8 hours at first day, and remaining 4 hours at second day
  • Paula is 25% assigned. So according to formula Work = Duration * Units she will work 2 hours each day, and it will take her 6 days to fulfill those 12 hours.

This might seem complicated, but once you got it, you will see it is not!

Hope this helps.

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 MS PROJECT 2019 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 )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s