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.

Productivity and Resource assignment..

2 replies [Last post]
Tue, 2008-12-16 09:08
Thomas Chua
User offline. Last seen 14 years 16 weeks ago. Offline
Joined: 23 Mar 2008
Posts: 5
Groups: Civil Engineering, GPC Malaysia
i am rather new to ms project. have a few questions here. when i hv created the wbs, i give them a period each. then i assign the resources to them. when, for a specific task, i assign more resources, the time changed, it reduced. Nothing wrong with that as more resources means less time. however, each activities r of different productivity. and the time that i hv entered is based on the no. of people for that job and the amount of time required by that amount of people.

Say welding a section of plate, i put 2 welders and total required time is say 2 hours. what should i do then? i can’t seem to find a place to input productivity for each activity in MSP. please advise, thanks.
Top

Replies

Wed, 2008-12-17 05:06
#1
Bo Johnsen
User offline. Last seen 8 years 24 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
Well, MS Project does work with productivities to a certain degree, but you have to do a bit of customized fields before it works in a simple way, so admitted it is maybe not as clever carried out as in SpiderProject (not that I know it) and in other planning software that have this features.

Anyway, in MS Project you can introduce e.g. a Number1 column containing your quantities, Number2 contains your resource productivities and Duration1 the product of Number1 and Number2. Duration1 maybe need some touching up with INT()functions and a factor depending of what unit (hours, days, etc.) you calculate in. Then copy by paste special / paste links from Duration1 into Duration.

Now all durations will change when you change quantities and resource productivities and actvities will move acoording to their links.

You could also introduce a Number3 column containing your buffer/contingency/safety time for each activity, e.g. 5% extra for time to this activity and 10% to this activity, before calculating Duration1 and pasting links into Duration.

Regards,

Bo

Top
Tue, 2008-12-16 10:03
#2
Vladimir Liberzon
User offline. Last seen 2 weeks 1 day ago. Offline
Joined: 5 Feb 2001
Posts: 2750
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)
MS Project does not work with productivities.
I recommend to look at Spider Project http://www.spiderproject.ru/demo_e.php
In Spider Project you can define the quantities of work to be done (work volumes) and assigned resource productivities. The rest will be done by the software.
You can also create the database of resource productivities on typical assignments and use this database in your projects. In this case it will not be necessary to enter resource productivities for the repeated types of work.
Top