Earned Value

H

Helge

Hello

I running a Earned value analyze based on phisical % complete and cost and
have got calculated BCWP-values on the project based on my status at 30.01.08.

Is it possible to distribute the remaining cost(Baseline cost - BCWP) on the
activities from status date to the end of the activities?

Helge Svee
 
A

Andrew

I think that this formula, set up as a Task Cost field would do it:

([Baseline Cost]-[BCWP])/(ProjDateDiff([Status Date],[Finish])/480)

Although I am not sure what value that equation will provide.

However, you can't really make that timephased data natively in MS Project.
If you want to depict it in a timephased fashion on a chart, you would have
to export your data to Excel, then get clever with the formulas in Excel. It
wouldn't be that much work I think.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simulate a project performance with earned value analysis 0
Earned Value Cost Indicator View/Sheet 2
Earned value (BCWP) showing as zero in chart 0
A good way to calculate Earned Value with Cost Resources? 4
earned value cost indicator tables 3
Actual Cost vs % Complete using Earned Value 6
timephased remaining value in project 1
Forcing Earned Values 12

Top