this is my last post for this year. I will show you what is happening when you change Units in Assign Resource field in MS PROJECT 2013!
First, I’m going to create new Project with only one Task:
and I will create one Resource:
This mean that John can work only 100% of his capacity per day (8 hours per day in my example) or otherwise he will be over allocated.
Now I’m going to assign John to the Task:
Let’s see Resource Usage View:
As you can see John will work 40 hours (8 hours per day from Monday to Friday)
Now suppose that I change my mind in a way that I do not want John to work 100% but only 50% for this Task.
I will get this:
If I use firs option: “Change the duration but keep the amount of work the same” I’ll get:
Let’s see Resource Usage View again:
As you can see for the Task John need 40 hours to complete it. But he will work only 50% per day (4 hours), and it will take 10 days instead of 5 days.
If I choose another option: “Change the amount of work but keep the duration the same” I’ll get:
You can see that Duration remains the same. But, let’s look at the Resource Usage View again:
As you can see Duration is 5 days, but because John has to work 50% (4 hours per day) he need only 20 hours (5 days * 4 hours per day) for entire work to be done.
To conclude if you increase or decrease Units field in Assign Resource window you must now why are you doing it. and there are only two reasons. You want to change duration for the Task, or hours.
Dear Blog readers,
I wish you a wonderful New Year 2015. I will keep write a Post per week, and answer all your questions as soon as I can.
Glad to find your site and I thought of requesting your assistance ! It would be great, if you clarify my queries on below !
I have a question on below issue ! Hope I will get assistance on how to get the desired result !
In Below Scenario, i am trying to face a situation which i could not solve !
Need to create a task “Paint the wall”.
I would expect this task to be completed by 24 hours.
I would expect the Start Date to be Jan 7, 2015 (Wednesday)
I have 3 resources with below constraints.
A (with max unit = 50%). i.e., A can work only 4 hours daily
B (with max unit = 50%). i.e., B can work only 4 hours daily
C (with max unit = 25%). i.e., C can work only 2 hours daily
Also, C cannot work on Jan 8 and Jan 9. (in general, C is not available on Thursday and Fridays always)
I would like to implement the above in Project 2013, such that, resources are effectively utilized such that, we can complete this task (“paint the wall”) with less number of days !
If I assign Resource A alone, I would expect the work (24hours) to be completed in 6 working days (Jan 14th) (note: Resource A works 4 hours daily. Hence 24 hours work will be completed in 6 working days)
If I assign Resource A, B and C, I would expect the work (24 hours) to be completed by Jan 9th.
On Jan 7th, 2015 – i expected all 3 resources work. Hence total hours is 4+4+2 = 10 hrs
On Jan 8th, 2015 – Since resource3 can’t work, Resource1 and Resoure2 will work 4+4 = 8 hrs
On Jan 9th, 2015 – Since resource3 can’t work, Resource1 and Resoure2 will work 3+3 = 6 hrs
Requesting your assistance on how the above can be done in ms project 2013. As I could not get the expected result of above case !!
In general, I am expecting ms project to calculate smartly, when I add/remove resources on this task. (like, if I have 6 resources (100%) assigned, I would expect 24 hrs work to be completed on same day itself – Jan 7th itself. Similarly, if have 6 resources (50%) assigned, I would expect 24 hours to be completed in 2 days ie., work to be completed by Jan 8th itself).
Hope I have explained my query clearly
Read my latest Blog Post it is all about your Problem!
Mind Blowing — to see https://ntrajkovski.com/2015/01/07/duration-units-work-and-schedule-in-ms-project-2013-how-are-they-linked-and-some-tips-and-tricks/#comment-13104
Very sad that, i just didnt noticed this reply till date (Nov 2016 🙂 ).. I had posted my query in youtube (https://www.youtube.com/watch?v=P9fhXiejG7I) as well 🙂 to ask for help.
Now i got it. You are Genius..
Will keep visiting your site !
Thanks Nenad for the great help !
Compliments of the season to you Nenad, Thanks for the post. It was quite informative. Still looking forward to your response on the S curve illustration using MS Project.
Compliments of the season Nenad,
Thanks for the post. quite informing. Still looking forward to your response of S curve illustration with MS Project.