My problem is actually the calculation of earned value when using a resource curve (Linear, triangular etc.) on a specific activity.
The way it calculates the earned value when a resource curve is allocated to an activity, is as follows:
Actual Duration = Data Date - Actual Start
Actual Duration
Percent of duration = ---------------------------
Actual + Remaining Duration
Resource Percentage = Percent of duration applied to curve.
On the curve: X-axis = Percent of duration
Y-axis = Resource Percentage
On a linear curve: Percent of duration = Resource Percentage
The problem is the following:
If an activity gets delayed, the actual duration increases, but the remaining duration remains the same.
The longer an activity gets delayed the remaining duration will become more insignificant.
Your percent of duration will become closer to 100% as time marches on.
This will be compounded by a curve tapering off at the end.
It has happened to a collegue of mine who used resource curves to get a better resource loading on activities. We were over progressing by 2%. Luckily we did not have many delayed activities and were still on schedule after we fixed the problem.
I would not want to see what would happen if a project is behind schedule and you have to fix this.
I see planners using using resource curves to "fix" planning issues.
I dont really understand your problem. However, I will have a guess that your possibly need to look at your cost & Resource setting (Accounting Rules). I dont have a problem when using EVM in P3, on both activity and resource level. I can accurately plot the EV curve according to the actual resource loading. Please check your Setting especially in the
Remaining Cost = Budgeted Cost -/+ Actual Cost
The only point I find P3 is not very good is the report printing do not have EV in their resource curve. It is only printable in Layout View. Other than EV is running ok.
In addition, if you have a target programme (Baseline) You need to also be careful with BQ/BC and CAC/QAC. They need to match.
IMHO, the software is only a tool, and we are the Driver.
Enjoy planning and hopefully this time around it works for you.
Ive actually got a problem with the calculation. It does not use the resource % complete. It uses Remaining Duration over Actual Duration (Data date - Actual Start).
If an activity with a resource curve is 20% complete and delayed for a long time, it can show an earned value up to 90% (depends on OD).
Thus, the longer you delay the activity, the more it progresses.
It does not make sense to me. It is also very dangerous if you us it and dont know exactly how it works.
Regards,
Erik
Member for
21 years 1 month
Member for21 years2 months
Submitted by Jaco Stadler on Sat, 2004-10-23 09:06
Please confirm when you do a progress update do you update at the resource level or at activity level. Are you using Remaining Duration or % Complete.
I have found if I apply % complete at resource level I dont have a problem with earned Value. If you use it at Activity level you seem to have a problem but it does make sence since Earned Value is based on Resources not activitys planned.
Member for
22 years 6 monthsRE: Resource Curves
Hi Alex,
In the previous calculation, (Percent of duration) equals (Actual Duration) divided by (Actual + Remaining Duration).
It does not help if you change any settings in the autocost rules.
For more info see P3 knowledge base ID : 200181143955
Regards,
Erik
Member for
22 years 6 monthsRE: Resource Curves
Hi Alex,
My problem is actually the calculation of earned value when using a resource curve (Linear, triangular etc.) on a specific activity.
The way it calculates the earned value when a resource curve is allocated to an activity, is as follows:
Actual Duration = Data Date - Actual Start
Actual Duration
Percent of duration = ---------------------------
Actual + Remaining Duration
Resource Percentage = Percent of duration applied to curve.
On the curve: X-axis = Percent of duration
Y-axis = Resource Percentage
On a linear curve: Percent of duration = Resource Percentage
The problem is the following:
If an activity gets delayed, the actual duration increases, but the remaining duration remains the same.
The longer an activity gets delayed the remaining duration will become more insignificant.
Your percent of duration will become closer to 100% as time marches on.
This will be compounded by a curve tapering off at the end.
It has happened to a collegue of mine who used resource curves to get a better resource loading on activities. We were over progressing by 2%. Luckily we did not have many delayed activities and were still on schedule after we fixed the problem.
I would not want to see what would happen if a project is behind schedule and you have to fix this.
I see planners using using resource curves to "fix" planning issues.
IT IS DANGEROUS!!!!!!!
Member for
22 years 8 monthsRE: Resource Curves
Erik
I dont really understand your problem. However, I will have a guess that your possibly need to look at your cost & Resource setting (Accounting Rules). I dont have a problem when using EVM in P3, on both activity and resource level. I can accurately plot the EV curve according to the actual resource loading. Please check your Setting especially in the
Remaining Cost = Budgeted Cost -/+ Actual Cost
The only point I find P3 is not very good is the report printing do not have EV in their resource curve. It is only printable in Layout View. Other than EV is running ok.
In addition, if you have a target programme (Baseline) You need to also be careful with BQ/BC and CAC/QAC. They need to match.
IMHO, the software is only a tool, and we are the Driver.
Enjoy planning and hopefully this time around it works for you.
Alex
Member for
22 years 6 monthsRE: Resource Curves
Thanks Jaco
Ive actually got a problem with the calculation. It does not use the resource % complete. It uses Remaining Duration over Actual Duration (Data date - Actual Start).
If an activity with a resource curve is 20% complete and delayed for a long time, it can show an earned value up to 90% (depends on OD).
Thus, the longer you delay the activity, the more it progresses.
It does not make sense to me. It is also very dangerous if you us it and dont know exactly how it works.
Regards,
Erik
Member for
21 years 1 monthRE: Resource Curves
Hi Eric
Please confirm when you do a progress update do you update at the resource level or at activity level. Are you using Remaining Duration or % Complete.
I have found if I apply % complete at resource level I dont have a problem with earned Value. If you use it at Activity level you seem to have a problem but it does make sence since Earned Value is based on Resources not activitys planned.
I hope this assist
Cheers