Can anyone offer advice?
I am for the first time dipping my toe into the murky waters of Earned Value Analysis. My aim is to produce an Earned Value Chart from a P3 (V3.1) project programme. My problems are as follows:
1 I want to calculate the percent complete as a function of resource hours spent and revised estimate of hours remaining. I have set up a global change to calculate this, but the problem arises where an activity has more than one resource. The global change formula only takes account of one of the resources (though if these values are displayed in a column, the sum of all resources on that activity are given). (I cannot use the Resource ‘Percent Complete’ as produced by P3, as this is derived as a function of the original budget value, not the revised current value)
2 My Target plan contains some wild card resources. When these resources are re-named in the current plan, the planned value for that activity becomes zero. The current plan has lost the link to the original resource in the target. Do I need to go back and update the Target, each time a resource is allocated in the current plan?
3 What is the best method of producing an Earned Value Chart from the data produced in P3. Ideally showing all the relevant data (BCWS, ACWP, BCWP, cost and schedule variances, estimated cost at completion etc).
4 We are considering upgrading our planning software from P3 to P3V5 (Enterprise). Is the EVA facility much improved?
Replies