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.

Weightings

6 replies [Last post]
Barry Fullarton
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 6 Jan 2009
Posts: 44
Groups: None
I hope guys can help me

I am wanting to weight my WBS or other level

I am trying to weight these phase , so that i can measure project physical progress , doesnt any one know how this can be achieved?

Replies

Deepak Astagimath
User offline. Last seen 6 years 2 weeks ago. Offline
Joined: 5 Aug 2006
Posts: 11
Groups: None

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.

1181
duration_weight.jpg

I would like to know similar/same option in P6.

Rodel Marasigan
User offline. Last seen 7 weeks 8 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
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.
Barry Fullarton
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 6 Jan 2009
Posts: 44
Groups: None
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
Rodel Marasigan
User offline. Last seen 7 weeks 8 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
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.
Waseem Saber
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 1 Dec 2004
Posts: 63
Groups: None
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
Rodel Marasigan
User offline. Last seen 7 weeks 8 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
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.