Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Overallocation/Fixed Work Query

13 replies [Last post]
Mon, 2010-03-01 17:51
Neil Gartland
User offline. Last seen 14 years 7 weeks ago. Offline
Joined: 1 Mar 2010
Posts: 7
Groups: None
I have 3 tasks in a project each consisting of 20h work, set to be fixed work scheduled over a 5 day duration starting and finishing at the same time. All three tasks are allocated to the same resource, so MS Project allocates 50% of the user’s time to each task by default. The means that the resource is 150% allocated.

Is there any way to automatically resolve this resource over allocation in this case by MS Project reducing the % allocation to 33% and extending the duration of the task.
Any help would be really appreciated
Top

Replies

Tue, 2010-03-02 14:45
#1
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Neil,
it is possible but not with Microsoft Project.
Best Regards,
Vladimir
Top
Tue, 2010-03-02 13:25
#2
Neil Gartland
User offline. Last seen 14 years 7 weeks ago. Offline
Joined: 1 Mar 2010
Posts: 7
Groups: None
Many thanks for all your comments and responses, Alexandre is correct if there are 3 tasks the effort would be levelled equally between the tasks i.e. 3- 33%, 4 - 25%, 5 - 20% etc

I did not think this was possible as there are too many variables and potential solutions but I very much appreciate all of you taking the time to assist me with this

Many thanks

Neil
Top
Tue, 2010-03-02 12:38
#3
Rafael Davila
User offline. Last seen 36 min 3 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Vladimir,

Spider is another thing, Spider is my software of choice. If Neil want to do what you are saying then MS Project cannot do it. I missunderstood his question "by MS Project reducing the % allocation", is also about adjusting resource assignments automatically.

Any excuse to get better at Spider as well as MS Project is good. I will take a look at it in detail as I knew of this option in Spider Project but not in MS Project. It is also good to know what your software can do and what cannot do, comparison of functionalities is part of what makes this place great.

I will check it with a 100% initial workload and minimal 33% at some activities and minimal 50% at other activities to see what happens. I assume/expect the algorithm will be looking for allocations that will yield minimum project duration within these constraints.

Best regards,
Rafael
Top
Tue, 2010-03-02 11:44
#4
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Rafael,
Neil wanted MS Project to adjust resource assignments automatically. It is too hard to find and correct the problems manually in the real projects.
You can try this in Spider Project:
Create 3 activities, assign the same resource, check variable resource workload check box in the assignment dialog, set resource workload 50% and minimal resource workload 33% (to avoid 1% workload that you mentioned) for all assignments.
Set resource productivities as 1 unit/per hour, select activity types Productivity.
In the levelling options uncheck Minimize parallel activities and look at the result.
Then compare with the schedule created with Minimize parallel activities box checked.
Best Regards,
Vladimir
Top
Tue, 2010-03-02 11:16
#5
Rafael Davila
User offline. Last seen 36 min 3 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Why not a hundred tasks at 1%?

Only Neil’s can answer. I understood he just wanted to set the activity to automatically change durations as he changed percent assigment, in this way he would be able to try several scenarios when changing % assigments, at times resource leveling might delay an activity at times might not.

He still can assign another 33% of the resource to another activity. Resource leveling will tell you if delaying resource or not as demand might be shifted by logic.

Rafael
Top
Tue, 2010-03-02 10:27
#6
Rafael Davila
User offline. Last seen 36 min 3 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
http://rapidshare.com/files/357880202/Units__.mpp

Just change the resource unit % and the duration will change. Then after resource leveling resource overallocation will be solved as requested.

Percentages will not be reassigned automatically, this you must decide. Would it make sense a 1% assigment if the software wishes to do so?
Top
Tue, 2010-03-02 09:59
#7
Rafael Davila
User offline. Last seen 36 min 3 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
33% resource

Also at the Resource Leveling dialog box: Level only within available slack (Prevents the finish date of your project from being delayed.) Make sure it is unchecked, otherwise over allocation might occur if assigned other 33% to a fourth activity.
Top
Tue, 2010-03-02 05:48
#8
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Hi Neil,
MS Project cannot do this and you will get different assumptions why.
If you need this and other advanced resource management functions look at Spider Project.
Best Regards,
Vladimir
Top
Tue, 2010-03-02 03:42
#9
Neil Gartland
User offline. Last seen 14 years 7 weeks ago. Offline
Joined: 1 Mar 2010
Posts: 7
Groups: None
I am well aware of the range of possible/feasible solutions, the reason for my query is to see if anyone creative has found a simple way of addressing this situation that I may be missing, surely the point of forums such as these??
Top
Mon, 2010-03-01 21:50
#10
Trevor Rabey
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
There are many different solutions to the over-allocation, all of which are feasible, so how can MSP know which one you prefer?

You cannot expect MSP to make all of the decisions and assumptions that the human can make, and gets paid to make.
Top