(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.
Dear members;
I have a question regarding estimation of activity duration by using productivty rates;
as i understand the formula for Duration = work quantity/(production rate X resource usage)
Now; i have a activity say Plaster works with quantity 2000 sqm
Daily output for full crew = 90 sqmCrew structures =0.125 Foreman1.000 Plasterer1.000 Common Laborer0.500 Mixer 0.17 m31.000 Tools Set1.000 Scafolding set So How can i Calculate the activity duration of plaster works using above daily output and Crew structures. Thanks in advance!!!!
Printer-friendly version
Send to friend
We all know that estimating the duration of an activity is far more complex than simply dealing with 'canned' production rates, therefore the inherent complexity shall be considered in order to get good enough models. Because P6 and MSP lack the capacity to create such models many of us prefer to use more functional software.
Impact of variable but predictable working conditions such as the change of season shall be considered in any model. The following is a sample schedule where activity duration is determined by the season. While the crew is the same the productivity is reduced during the winter as well as the work hours. Attempting such adjustments using manual methods in large resource leveled projects is not a practical approach when the computer can do it.
Fortunately creating such models is easier than getting reliable estimates of production rates.
Patrick, in any case people and norms estimate resource/crew productivity and this is the basis for estimating activity duration when volume of work is known. For some activities duration does not depend on assigned resources.
If certain activity type meets many times in the project model and the same crew does them all it is reasonable to estimate duration of activities of this type basing on the same estimates of crew productivity.
If risk simulation and management is applied then it is necessary to estimate optimistic, most likely and pessimistic values of resource/crew productivity and composition, volumes of work, activity and resource calendars, and a lot more.
Estimating the duration of an activity is far more complex than simply dealing with 'canned' production rates! For a discussion on the subject see: http://www.mosaicprojects.com.au/WhitePapers/WP1052_Time_Estimating.pdf
Unfortunately P6 does not have activity volume and resource assignment productivity fields and does not do calculations that you need.
It is a pity that you are not able to select and to use the software that better fits to your requirements.
Dear Members;
I am working in Saudi Arabia and here we are using p6 for scheduling, in p6 we dont have the option to add quantities and productivites, so that the program can calculate the duration.
Mainly we are supposed to enter the duration of activities by calculating manually (in excel)in terms of work quantities and productivities of the crew.
Is there any other method can be use for p6 to automatic calculation of duration as in spider project??
Dear Members;
I am working in Saudi Arabia and here we are using p6 for scheduling, in p6 we dont have the option to add quantities and productivites, so that the program can calculate the duration.
Mainly we are supposed to enter the duration of activities by calculating manually (in excel)in terms of work quantities and productivities of the crew.
Is there any other method can be use for p6 to automatic calculation of duration as in spider project??
The following schedule is what you will get if you fix the resource quantities with an availability of 9 Resources A and 9 resources B. It will be inefficient and will yield the resources idle for too long.
The following schedule is what you will get if you allow the model to automatically adjust resource quantity and activity duration taking in consideration the relationship with production rates. The schedule duration will be substantially reduced and idle resource time will be reduced and perhaps eliminated.
So easy to implement that all is required is to specify resource productivity, minimal quantity and mark quantity as variable, the computer algorithm will do the math for you.
Vladimir,
The driving resource approach we use frequently with variable quantities as for the activity be scheduled to start as soon as a minimal amount of the required resources are available and to increase the quantity as soon as there are more available. Anyway this is how even a rookie PM will react in the field if the plan is not good enough to consider these scenarios. No PM is to delay the start of such activity because out of 10 planned resources only 9 are available.
Of course there are many occasions in which it is easier to use the driving resource approach, but not always this represents crew behavior when composition changes. The same resource might still be driving but the relationship to crew production rate as a whole might not be linear and this shall be considered by the model when this might happens and is predictable.
When crew productivity is not in linear relation to a specific/driving resource quantity we use a multi-resource to represent the crew, then by using Skills on the multi-resource the best available crew along with its adjusted production rate will be automatically selected.
All makes sense, all is easy and transparent.
Best Regards,
Rafael
Rafael,
when crew productivity is defined it is expected that crew productivity was calculated for current crew composition.
But yes, crew composition does matter and that is why we suggest to assign productivity not to the crew but to driving resources belonging to the crew. In this case crew productivity is the sum of productivities of its resources and will change together with the changes in crew composition.
Spider Project is an advanced project management software that is used everywhere in Russia and in 34 other countries.
It is the only PM software that works with activity volumes and resource productivity and so automates calculations you are looking for.
Spider Project is an integrated software that includes everything project planner may need - scheduling, budgeting, advanced resource management, risk simulation, portfolio management, etc.
Demo version of Spider Project with 40 activities per project restriction may be downloaded from www.spiderproject,com. You may also look at Spider Project forum here at Planning Planet.
Regards,
Vladimir
Thanks Mr. Vladimer!!!!
What I understand from your answer is we dont need to consider the crew structure, just quantity/daily output.
What is spider project can you give me more detail as iam new to planning.
Siddiq,
if activity volume is 2000sqm and crew does 90sqm per day then the job will take 2000/90=22.2 days.
You set productivity for the whole crew. Another approach - to set productivity for the leading resource of the crew that defines the productivity of the whole crew. If this resource or the crew works on activity part time (for example 50% of work day) then resource/crew productivity is lower (45sqm per day in our case) and activity duration will become longer (44.5 days in our example).
This is the way activity duration is calculated in Spider Project when you enter activity volume and assigned resource/crew productivity.
Email: PPadmin@planningplanet.com
Replies