Effective Resourcing Management in Ms Project 2013 – A Case Study (Help needed)
In Below Scenario, i am trying to faced a situation which i could not solve ! Need assistance from you all !
Step1:
I have created a task “Paint the wall” and expecting this work to be completed in 24 hrs.
TaskName: Paint the wall
Work: 24 hrs
Task Mode: Auto Schedule.
Start Date: Jan 7, 2015 (wednesday)
Step2:
Here, i have added 3 resources
Resource1 (with max unit = 50%)
Resource2 (with max unit = 50%)
Resource3 (with max unit = 25%)
By this, i expect, Resource1 to work only 4 hrs per day. Resource2 to work only 4 hrs per day. Resource3 to work only 2 hrs per day.
Step3:
In Project Calendar, i have added non-working days for Resource 3 as Jan 8 and Jan 9.
Step4:
I assigned all 3 resources against the task “Paint the wall”, but i found that, resources efforts didn’t came as expected !
i got resource1 with 9.6hrs, resource2 with 9.6hr, resource with 4.8hr and task end date as Jan 13th 2015 !!
Expectation:
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 cant work, Resource1 and Resoure2 will work 4+4 = 8 hrs
On Jan 9th, 2015 – Since resource3 cant work, Resource1 and Resoure2 will work 3+3 = 6 hrs
So i would expect the work to be showing as completed by Jan 9th. But it shows project will complete by Jan 13th only ! I expect project should complete by Jan 9th itself, with resource 1 using 4+4+3 = 11 hrs, resources2 also using 11 hrs and resource 3 using 2 hours only ! But i am not getting this result.
Please assist. I am using microsoft project 2013 software.
Kumar
|