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.

P6 Physical % Complete & Actual Cost

3 replies [Last post]
Tue, 2008-04-29 14:24
Benjamin Mora
User offline. Last seen 11 years 1 day ago. Offline
Joined: 19 Oct 2007
Posts: 66
Groups: None
I got a problem with P6. My company only uses cost loaded schedules with no true resource management involved. P6 calculates Actual Cost based either on the ratio of OD vs. RD or via manual input. I am trying to calculate Actual Cost based on Physical % Complete and not based on RD. Global changes are not working. I am sure some of you have run into this already.
Top

Replies

Fri, 2008-05-02 08:35
#1
Benjamin Mora
User offline. Last seen 11 years 1 day ago. Offline
Joined: 19 Oct 2007
Posts: 66
Groups: None
Thank you, Duy Huynh. I found a similar process, but yours looks easier. I will try it out.
Top
Fri, 2008-05-02 05:16
#2
Duy Huynh
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 24 Apr 2008
Posts: 22
Groups: None
Sorry, there was some mistake in the previous post. Primavera won’t understand that it need to multiply a percentage not a number. However I could not edit it, i post new then.
1. Add a user defined field called :"Actual cost of % Physical Complete" with data as "Cost"
Add one more user defined field called: "Physical % Complete Indicator" or anything, with data as "Number".
2. Add two global changes:
2.a: Physical % Complete Change to devide Physical % Complete to 100.
Delete anything in "If" box.
In "Then" box:
Parameter is Parameter/Value Operator Parameter/Value
Physical % Complete Indicator = Physical % Complete / 100
2.b: Actual cost change
"Actual cost of % Physical Complete" = Budgeted Total cost * Physical % Complete Indicator
Top
Fri, 2008-05-02 04:43
#3
Duy Huynh
User offline. Last seen 14 years 18 weeks ago. Offline
Joined: 24 Apr 2008
Posts: 22
Groups: None
Well I have a solution, I don’t know if it suit for your need. It is calculated based on the Budgeted Total Cost and %Physical complete.
1. Add a User Defined field (Enterprise>User Defined Fields)called: "Actual cost of % Physical" or anything u like.
2. Add a global change (Tool>Global Change) called: "Physical ToDate Cost" or anything u like.
3. Modify the above change:
- Select Subject area as Activities
- Delete any condition in "If" field
- In "Then" field:

Parameter is Parameter/Value Operator Parameter/Value
Actual cost of % Physical = Physical % Complete * Budgeted Total Cost.
Top