Hi,
I have interesting question form one of my Blog Readers:
“I have below query in Fixed Duration Task.
Step1: created a task “paint the wall” with duration as 10 days (work starts by a Monday). Task is fixed duration
Step2: created a resource “A” (100%) – (8hrs/day)
Step3: assigned this resource in this task.
Step4: In task usage, changed the timelines middle tier->months, bottom tier->weeks
Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped.
Now it shows 1st week, Resource works 20hrs, and over allocated in next week with 60hrs.
Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.`
I would like the MS project to calculate by itself and assign 40hrs for resource A and 20hrs to resource B.
Please guide on how to achieve this?”
I will show you how to do that in MS PROJECT 2016! I will follow steps from the question.
Step1: created a task “paint the wall” with duration as 10 days (work starts by a Monday). Task is fixed duration
As you can see, I make this Task Effort Driven, because I will have to split work between Resources.
Step2: created a resource “A” (100%) – (8hrs/day)
As you can see, I have another resource, Resource B, because I will need it for latter steps.
Step3: assigned this resource in this task.
Step4: In task usage, changed the timelines middle tier->months, bottom tier->weeks
and:
Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped
Now it shows 1st week, Resource works 20hrs, and over allocated in next week with 60hrs.
Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.`
I would like the MS project to calculate by itself and assign 40hrs for resource A and 20hrs to resource B
I will assign Resource B on the Task:
I will get:
As you can see, remaining work among those Resources is divided in 60/40 (36 hours for Resource A, and 24 hours for Resource B). So, Resource A is not over allocated any more, but it is not what we want. We want that Resource A should work 40 hour, and Resource B 20 hours for Task. So I will have to put those hours manually:
and I’ve got what I wanted.
So, no, this is not going to happens automatically, you should do it manually.
Hope this helps.
Regards!
Nenad Trajkovski 
Great explanation.. Thank you so much..
Dear Ninad
I have below query now, on msproject.
I have 2 resource initially planned to work for 160hrs (fixed work) for 2 weeks (duration=10 days, 8hrs work/day) to complete a task (fixed work).
Unfortunately, Due to some personal reason, 1st resource could work only for 15hrs in 1st week instead of 40hrs/week. Hence setting actual hrs=15hrs in week1 for 1st resource.
Due to this 25hr work left out, onboarded 1 more resource from 2nd week to complete this 25hr remaining work.
How to achieve this in msproject?
I am expecting below result.. (below also gives 160hrs fixed work)
For week1, A holds 15hrs, B holds 40hrs, C holds 0hr (As C starts only 2nd week)
For week2, A should hold same 40hr, B should hold same 40hr, C must hold 25hr
Please advice.
Long Live, Ninad T — Great Blog. Excellent explanation.. I love this SITE – Bookmarked.