MS Project increasing duration
MS Project increasing duration
(OP)
Hi,
I know this is an age-old problem/bug/feature of MS Project, but can someone please tell me why allocating resource to a task line in project INCREASES its duration unless the resource is added at 100% utilisation?
I have a task with effort of 54 days. I have two resources assigned, one at 68% and another at 26%. I believe, and my calculator agrees with me, that this is the equivalent of 94% utilisation. So why does MSProj tell me that the task will take 123 days?
I've fiddled with all the 'task type', 'effort-driven' options, and nothing makes any difference.
How do I make Project behave? Or, what am I misunderstanding and what do I have to do to get the result I'm expecting?
Thanks
I know this is an age-old problem/bug/feature of MS Project, but can someone please tell me why allocating resource to a task line in project INCREASES its duration unless the resource is added at 100% utilisation?
I have a task with effort of 54 days. I have two resources assigned, one at 68% and another at 26%. I believe, and my calculator agrees with me, that this is the equivalent of 94% utilisation. So why does MSProj tell me that the task will take 123 days?
I've fiddled with all the 'task type', 'effort-driven' options, and nothing makes any difference.
How do I make Project behave? Or, what am I misunderstanding and what do I have to do to get the result I'm expecting?
Thanks
RE: MS Project increasing duration
RE: MS Project increasing duration
Can anybody recommend an alternative tool that can provide this basic functionality?
Thanks
RE: MS Project increasing duration
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: MS Project increasing duration
I want to know how long a given task will take, if I know how much effort's involved and I know what resources I have.
As an example, I know, from various estimating techniques, that developing Widget X takes 200 person-days of effort. I know that I have lots of other tasks to do and I know that I have a team of, say, 6. What I need to do (and this seems like bread and butter to me, so I'm stunned that Project can't handle it), is say that George can work on this for 50% of his time, and Fred can work on it for 20% of his time. HOW LONG WILL IT TAKE?
Project seems unable to answer this; it seems to think that if two people work on a project, they'll each do 50% of the work, regardless of their %utilisation. Therefore, in the example above, the task will take as long as it takes Fred to do his half of the job at 1 day a week. That's not real-world, and it's not useful.
I'm sure Project is great for saying, "Fred's going to go and support Widget X on-site for 3 months, how much will it cost and how does it affect the other, duration-based tasks I've got?" - but it's crap for estimating how long a job will take for a given effort and resource (unless the resource is 100% utilised on the task).
As far as I can see, the only solution is to export the information into Excel, do some processing there to arrive at a task duration (basic maths, no reason why Project shouldn't be able to do it), then import it back into Project. Then, if anything changes, go and do it again... and again... and again. And this means that for effort-driven scheduling, the only thing that Project is actually any good at is displaying these calculations as a Gantt.
So I need something that can support effort-driven planning!
RE: MS Project increasing duration
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: MS Project increasing duration
Here's an example of why Project doesn't work:
1. Create two tasks
2. On the first task, set the resources to "Me[50%], him[25%]"
3. Set the work to 5 days
4. On the second task, set the work to 5 days
5. Set the resources to "Me[50%], him[50%]"
The task information is identical for both, yet the durations are different. The one set up using your method is correct (effort / total utilisation (50 + 25 = 75%)). But don't get smug
6. Now, change the utilisation for both resources, on both tasks, to 50%.
Now the one set up using your method has an incorrect duration, whereas the one set up "properly" (to my way of thinking) is correct. But it's only correct by coincidence, because the utilisation for each resource happens to be the same. This is because Project divides the work by the number of resources, not the proportional utilisation of all the resources.
How can this be workable?
RE: MS Project increasing duration
The story goes: Working in a Manufacturing Engineering function doing project work, The Boss beats me up for missing all my schedules. As an experiment, I record my time for 3 weeks and realize I am only 40% efficient (too many meetings, etc.)
Solution: I make my project task list and schedule as if I was 100% efficient. I place lots of milestones and deadlines to anchor my tasks and provide "pivot points". I put in sufficient detail to drive it and account for the majority of activities. Then I return to my tasks and put my 40% resource allocation to it. Poof, MSP changes all the durations and the project begins to act like reality.
I start hitting all my schedules. I explain this to The Boss, he starts doing his job and reduces the amount of silly meetings and lets his team actually do work. Everybody wins. Eventually my efficiency increases and I start putting that into my project plans. Continuous immprovement.
Conclusion: the working business world is too dynamic to capture all the details and ineffiencies into MSP. You would spend weeks developing a project plan to do this. I've NEVER had the luxury of absolutely 100% perfect predictive task durations. I suppose they do exist somewhere, but I've never seen them. Everything is only your best guess, and MSP can be used effectively as a Prediction Tool. Some people create big fat task lists with lack of detail and then manage it day-to-day to fit in the their published deadlines. I choose a different approach. Put in a lot of detail (task lists provide daily to-do lists without thinking). But I realize I can never capture everything, and that conditions actually do change as time progresses (an amazing concept).
Then the truth is that most people only use MSP to create pretty pictures that get shown to Management at the Kickoff Meeting, then never again.
I set the expectations to Management / Customers that the prediction accuracy of the project is 100%-90% for a few weeks from the current date. Then the prediction accuracy rapidly falls off after that. Constantly updating and managing the project keeps managers informed and happy that there actually IS a plan, it is being worked, and provides a reasonable level of predictive accuracy. Besides, they have never met a schedule, either.
For projects that absolutely can't slip behind schedule, then there is a lot of fat built into it for recovery. This allows 100% success rate of hitting the milestones. But it's a very inefficient use of resources.
TygerDawg
Blue Technik LLC
Virtuoso Robotics Engineering
www.bluetechnik.com
RE: MS Project increasing duration
Which is why I'm desperate to find a tool that will accurately calculate and portray effort-driven, utilisation-flexible Gantts.
RE: MS Project increasing duration
Then, again, I've been wrong about many things
TygerDawg
Blue Technik LLC
Virtuoso Robotics Engineering
www.bluetechnik.com
RE: MS Project increasing duration
I've decided the only real solution is to copy-and-paste into Excel, parse the resources column and calculate the duration correctly, then type it back into Project.
RE: MS Project increasing duration
Correct me if I am wrong
xx
RE: MS Project increasing duration
I found a tool called OpenProj which does this adequately - unfortunately it has other shortcomings which means I can't use that either.
RE: MS Project increasing duration
RE: MS Project increasing duration
Don't consider this an "age old problem" consider this as it is how the software works.
RE: MS Project increasing duration
To recap, if you assign two resources, MSP splits the hours 50/50 regardless of the utilization factors of resources, rather than dividing the resources according to the utilizations. So, start with 100 hrs of work, if A is at 1% availability and B is at 99% availability, A still gets 50% of hours, jacking the duration out to 625 days.
The more correct distribution is to assign A 1 hr, and b 99 hrs, resulting in 12.5 day duration
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: MS Project increasing duration