#1
|
|||
|
|||
Calculating earned value
Hello,
How do you calculate the earned value of the activities? Here is what I did before the job started months ago: I had entered the total costs of activities, so I have a lump sum cost for activities. I then went to task usage tab and I have the costs and cumulative cost rows displayed against dates there so I was able to see the planned and cumulative planned values. I even pasted the dates and values as two rows into excel and made a nice S-Curve… But how about actual earned values versus the dates now, based on the current progress? We are in the middle of the job now and there are finished activities, there are activities between 0-100 % and there are activities has not started yet. They asked me for instance to give the earned value in July, based on progress (as I said, lump sum costs for activities were already entered before) Does the task usage column distribute costs against current start and finish dates (i.e. start and finish columns)? If so, the distribution I made months ago before job started and when I saved my baseline has gone now and what I am seeing is the earned value? Is that the case? (because I see costs vs current start and finish dates now by default I believe) Note: I never updated any costs or entered actual costs. All I am after is to calculate the earned values, not actuals. Thanks in advance and sorry for the long question |
#2
|
|||
|
|||
In order to calculate earned value you must have the following:
1. Tasks with costed resources assigned. 2. A baseline saved. 3. Progress recorded. How did you enter costs? Through Fixed Costs? Have you saved a baseline? You should be able to view the Earned Value table applied to the Task Usage view or the regular Gantt chart view. Earned value is calculated as of the status date. So, you set your status date, update your tasks and Earned Value data is calculated for you. You should also be able to add the Earned value table to the timescaled portion. |
#3
|
|||
|
|||
yes i entered fixed costs only
and yes i saved a baseline but ity only calculates against the original baseline, but not the other baselines i might have saved such as baseline 1 2 3 4 etc... correct? because BCWP, which is in other words EV, I saw only one of it, which made me think it is only taking the original baseline into account but not the others.... |
#4
|
|||
|
|||
Earned value is calculated, by default, against the Baseline. You can change which baseline earned value is calculated from through Tools > Options, Calculation tab - earned value button. However, you cannot use different baselines for different tasks.
I hope this helps. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating Profits? | MarkL | Project | 1 | 06-12-2012 07:19 AM |
calculating duration | ketanco | Project | 5 | 12-15-2011 07:15 PM |
Calculating dates | Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |
How to apply budget for earned value analysis | ttorneby | Project | 2 | 06-03-2010 04:52 PM |
Good commission to be earned for writing some office questions | iqnetsys | Office | 0 | 02-23-2009 05:22 AM |