Productivity and Resource assignment..
In the Open Standard
Thomas ChuaMember for 18 years 6 months
- Created
- 2
- 4
0
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.
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.
2 replies
Oldest first- 0Vladimir Liberzon ·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. - 0Bo Johnsen ·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
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?