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.

Overall Weightage by Cost

3 replies [Last post]
Jithin Kambhikanam
User offline. Last seen 20 weeks 2 days ago. Offline

Hello Everyone,

Need Help.

I saw a schedule in which the Progress is weighed by Cost.

Each activity under each WBS has a cost. So everytime it is updated the WBS shows the % Planned and % Actual.

Overall it shows % Completed based on Cost.

So how can it be set up ?

Regards

Jithin

Replies

Zoltan Palffy
User offline. Last seen 21 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

yes it will roll up 

Jithin Kambhikanam
User offline. Last seen 20 weeks 2 days ago. Offline

Thanks Zoltan,

 

So by this each WBS would have its own weightage and overall WBS would show the total progress Planned and Actual ?

 

Regards

Jithin

Zoltan Palffy
User offline. Last seen 21 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

1st go to the PROJECTS directory 

make sure that your project is open 

click on the reources tab and at the bottom make sure that resources can be assigned to teh same activity more than once is NOT checked

go to activites now go to Resources and on the rigth select add

create an new resource call it lumpsum make sure that calculate cost from units is NOT checked

filter for all of the activites thet you want cost on 

select all activities

right click

assign resource select LUMP sum

select file export and export the resource and cost to excel

populate cost values in excel for each actviity 

save file 

import back into p6

view show on bottom resource useage profile 

done