Progress Variance. Help me pls !

Unless there is a value in terms of cost, hours or deliverables etc assigned to activities and progress of these is measured then it is not possible to give a percentage variance except as a function of the durations of activities.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au

Thanks Harris for your response. You are right that progress variance is calculated based on duration if there is no costs assigned. I’m sure MsP plot their zig zag progress line using this method. But my problem is still same how to show such percent variance if the progress calculated based on duration.

Thanks in advance.

regards

You could try a couple of options
1. Enter a dummy cost for the software for each activity which will calculate the BCWS. This could be using the Fixed Cost column. Then use a Custom column to calculate the Planned % Complete. The cost could be the same as the original duration if you are looking for Planned % Complete based on Duration, or you could enter some more realistic values.
2. Use a Custom Column to calculate the % Complete based on the Early Start, Early Finish and Status Date.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au

Thanks alot Harris, it’s good idea. I will assign budget by using formula : Duration X Unit Price. Unit Price is $1. Then I’ll get BCWS and BCWP in $. For the percent BCWS or BCWP just dividing them with the Budgetted Cost of each task then the delta of both percentage is the % variance.

Thank you very much.

Kind Regards,
RH

If I have understand correctly your question, you can have percent completion value on project duration provide you have already enter actual data,
For an overall view, go to Project>Project Information Statistics

Yes you’re right Ioannis. There is an overall progress information in the Statistic based on duration too. But I need progress variance per activities based on duration.

Regards,
RH

Plsease try the formulas as shown below; may be what you would expect

Nunber 1
(Days of workload should have completed as per status date, measured on Baseline data

Nunber 1
IIf([% Complete]>0;IIf([% Complete]<100;([Baseline Duration])/480-((ProjDateDiff([Status Date];[Baseline Finish];"standard"))/480);0);0)

Number 5 (Per Task % delay) (only for active tasks)
IIf([Number1]<>0;(([Number1]/[Baseline Duration])*480*100)-[% Complete];0)

Ioannis,

The numerical 480 in your formula, what does it denote?

Rohit