In P3 we have an option of seeing the percent complete as the Duration asweight factor when coputing the percent complete, where in the total sum of Ori Dur and Total sum of Rem Dur are used as weight factor to compute % complete. I have attached a screen shot from P3. formula p3 uses as (OD-RD)/OD. In this each activity duration is considered as weighting factor.
In P6 you cannot weight your WBS/Activities without cost otherwise your summary band will always have zero %. I recommend using man-hour as cost by setting Price/Unit on resources say $1.00/unit. Alternatively, remove effective date, max unit/time and Price/unit by deleting the data under resource-> Unit & Price tab. The under Project Window-> Calculation tab = enter 1.00 as a default Price/Unit for activities without resource or role Price/Units. This automatically compute your hr or unit = budgeted cost.
Waseem is correct that Top Down Estimation is another way to weight and spread the cost to WBS and Activities using resource. You need to apply this for each WBS to have accurate distribution and should have only one resource define for each WBS otherwise you need to compute how many units for each resource to arrive on the expected weightings. Also be aware that using top down estimation will possible over allocate your resource max unit/time that prevent user to level the resource.
did you ever tried Top Down Estimate, i think this would be helpful to allocated cost with 90-95% accuracy, i would rather recommed using the top down estimate to spread the cost for the project, the top down estimate works on the weighted Original Duration, say you have 10 activities, each with 10 days duration, thus each activity would we 10% weighted duration and the cost spreading could be done using this weighting.
if you have any further query, send me an email i will forward you the file with the steps.
P6 use cost to weight WBS and or activities. There a lot of ways of doing it and the best practice is to use budget cost against its WBS and Activities with equivalent Cost Account which is very useful especially for Earned Value Management.
For this exercise if you wanted to weight your WBS/Activities using your own parameter like what you mentioned on the other post.
Example (just for this exercise) say $1000.00
Design -> 10% = $100
Procurement -> 15% = $150
Project Management -> 20% = $200
Construction -> 55% = $550
Total ->100% = $1000
The general idea is to know the value of each WBS that equivalent to the Budgeted Cost At Completion (BAC) that need to distribute for each activity.
On the other thread I mention on how to weight activities using duration if BAC is not available using 3 different options.
For this exercise I would like to use resource loading instead of expenses and or activity status fields.
1) First create a resource for each WBS so BAC allocated cost can easily distribute with max unit/time = 1 (i.e. Labor)
Ex: Design, Procurement, PM and Construction
2) Assign resource by highlighting all activities per WBS (i.e. Design WBS) then right click -> Assign-> Resources then double click Design Resource
3) Repeat until all WBS activities have their own resources
4) Show the Budgeted Labor Unit column by right click on the activity area window and select column->Unit-> Budgeted Labor Units
5) On each WBS summary band will have a total number of units based on duration. (i.e. Design = 200 labor units) Use the WBS total unit to get the rates of each resource assigned. (e.g. Design = $100/200 hr or unit = $0.50)
6) Select Enterprise-> Resources and enter the rate per each resource based on the derived rates per resource.
7) Show the Budgeted Labor Cost column by right click on the activity area window and select column->Cost-> Budgeted Labor Cost
8) Check the main summary band if equivalent to $1000.00 and each WBS cost = allocated cost.
9) If everything is fine and according to what expected… CONGRATULATION!!! You weighted your WBS and Activities successfully.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
In P3 we have an option of seeing the percent complete as the Duration asweight factor when coputing the percent complete, where in the total sum of Ori Dur and Total sum of Rem Dur are used as weight factor to compute % complete. I have attached a screen shot from P3. formula p3 uses as (OD-RD)/OD. In this each activity duration is considered as weighting factor.
[[wysiwyg_imageupload:1181:]]
I would like to know similar/same option in P6.
Barry,
In P6 you cannot weight your WBS/Activities without cost otherwise your summary band will always have zero %. I recommend using man-hour as cost by setting Price/Unit on resources say $1.00/unit. Alternatively, remove effective date, max unit/time and Price/unit by deleting the data under resource-> Unit & Price tab. The under Project Window-> Calculation tab = enter 1.00 as a default Price/Unit for activities without resource or role Price/Units. This automatically compute your hr or unit = budgeted cost.
Guys I appreciate the answers here
However we don’t load costs into our programs here, don’t ask me why?
So I need to "fix" the phases into those percentages, so that when we measure physical progress it measure it against that phase,
We have back ups measure the manhours,
Even if we load hours, I need to ensure that these phases are locked ? at these percentages ?
Who can help
Hi Barry,
Waseem is correct that Top Down Estimation is another way to weight and spread the cost to WBS and Activities using resource. You need to apply this for each WBS to have accurate distribution and should have only one resource define for each WBS otherwise you need to compute how many units for each resource to arrive on the expected weightings. Also be aware that using top down estimation will possible over allocate your resource max unit/time that prevent user to level the resource.
Hi Barry,
did you ever tried Top Down Estimate, i think this would be helpful to allocated cost with 90-95% accuracy, i would rather recommed using the top down estimate to spread the cost for the project, the top down estimate works on the weighted Original Duration, say you have 10 activities, each with 10 days duration, thus each activity would we 10% weighted duration and the cost spreading could be done using this weighting.
if you have any further query, send me an email i will forward you the file with the steps.
cheers
W.Saber
Hi Barry,
P6 use cost to weight WBS and or activities. There a lot of ways of doing it and the best practice is to use budget cost against its WBS and Activities with equivalent Cost Account which is very useful especially for Earned Value Management.
For this exercise if you wanted to weight your WBS/Activities using your own parameter like what you mentioned on the other post.
Example (just for this exercise) say $1000.00
Design -> 10% = $100
Procurement -> 15% = $150
Project Management -> 20% = $200
Construction -> 55% = $550
Total ->100% = $1000
The general idea is to know the value of each WBS that equivalent to the Budgeted Cost At Completion (BAC) that need to distribute for each activity.
On the other thread I mention on how to weight activities using duration if BAC is not available using 3 different options.
For this exercise I would like to use resource loading instead of expenses and or activity status fields.
1) First create a resource for each WBS so BAC allocated cost can easily distribute with max unit/time = 1 (i.e. Labor)
Ex: Design, Procurement, PM and Construction
2) Assign resource by highlighting all activities per WBS (i.e. Design WBS) then right click -> Assign-> Resources then double click Design Resource
3) Repeat until all WBS activities have their own resources
4) Show the Budgeted Labor Unit column by right click on the activity area window and select column->Unit-> Budgeted Labor Units
5) On each WBS summary band will have a total number of units based on duration. (i.e. Design = 200 labor units) Use the WBS total unit to get the rates of each resource assigned. (e.g. Design = $100/200 hr or unit = $0.50)
6) Select Enterprise-> Resources and enter the rate per each resource based on the derived rates per resource.
7) Show the Budgeted Labor Cost column by right click on the activity area window and select column->Cost-> Budgeted Labor Cost
8) Check the main summary band if equivalent to $1000.00 and each WBS cost = allocated cost.
9) If everything is fine and according to what expected… CONGRATULATION!!! You weighted your WBS and Activities successfully.