Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2012, 01:37 PM
ketanco ketanco is offline Calculating earned value Windows 7 64bit Calculating earned value Office 2007
Expert
Calculating earned value
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-10-2012, 02:54 PM
JulieS JulieS is offline Calculating earned value Windows 7 64bit Calculating earned value Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 08-13-2012, 05:17 AM
ketanco ketanco is offline Calculating earned value Windows 7 64bit Calculating earned value Office 2007
Expert
Calculating earned value
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

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....
Reply With Quote
  #4  
Old 08-13-2012, 09:06 AM
JulieS JulieS is offline Calculating earned value Windows 7 64bit Calculating earned value Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Profits? MarkL Project 1 06-12-2012 07:19 AM
Calculating earned value calculating duration ketanco Project 5 12-15-2011 07:15 PM
Calculating earned value Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM
Calculating earned value 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft