Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2012, 06:08 AM
ketanco ketanco is offline earned value not calculating Windows 7 64bit earned value not calculating Office 2007
Expert
earned value not calculating
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default earned value not calculating

hello,
in my schedule i have tasks which i assigned fixed costs. in the task usage view, the cost and cumulative cost are showing, between the corresponding start and finish dates.



1-BCWP and BCWS rows are not showing anything though. (although I also have a baseline). i checked both the current start and finish dates interval and the basleine start and finish dates interval but no BCWS and BCWP is visible. Why?

2-lets say I wanted to know the EV for last month, July. If it showed BCWP, I would simply add the values of BCWP for the interval of July 1- July 31 right?

3-BCWP would add up to fixed cost and would show between current start and finish dates of that activity correct?

4-BCWS would also add up to fixed cost but it would show between basline start and finish of that activity correct?
Reply With Quote
  #2  
Old 08-14-2012, 09:39 AM
JulieS JulieS is offline earned value not calculating Windows 7 64bit earned value not calculating Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

1-BCWP and BCWS rows are not showing anything though. (although I also have a baseline). i checked both the current start and finish dates interval and the basleine start and finish dates interval but no BCWS and BCWP is visible. Why?

What is your status date? BCWP and BCWS are dependent upon the status date. Are the tasks scheduled before the status date?

2-lets say I wanted to know the EV for last month, July. If it showed BCWP, I would simply add the values of BCWP for the interval of July 1- July 31 right?

No - it is not necessarily additive. BCWP is based upon % complete (or Physical % complete) * time phased baseline cost.

3-BCWP would add up to fixed cost and would show between current start and finish dates of that activity correct?
No - see above.

4-BCWS would also add up to fixed cost but it would show between basline start and finish of that activity correct?
As of the status date.
Reply With Quote
  #3  
Old 08-16-2012, 10:42 AM
ketanco ketanco is offline earned value not calculating Windows 7 64bit earned value not calculating Office 2007
Expert
earned value not calculating
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
1-BCWP and BCWS rows are not showing anything though. (although I also have a baseline). i checked both the current start and finish dates interval and the basleine start and finish dates interval but no BCWS and BCWP is visible. Why?

What is your status date? BCWP and BCWS are dependent upon the status date. Are the tasks scheduled before the status date?

2-lets say I wanted to know the EV for last month, July. If it showed BCWP, I would simply add the values of BCWP for the interval of July 1- July 31 right?

No - it is not necessarily additive. BCWP is based upon % complete (or Physical % complete) * time phased baseline cost.

3-BCWP would add up to fixed cost and would show between current start and finish dates of that activity correct?
No - see above.

4-BCWS would also add up to fixed cost but it would show between basline start and finish of that activity correct?
As of the status date.
1-my status date is august 8th. these tasks start way before the status date of august 8th and continue through that date. they finish around end of august. i saved baseline again on a test file and it worked.

2-i meant the completed portion of those tasks. if I wanted to EV for july, I would take the "completed portion" of those tasks that took place in July and add them correct? or, is it a cumulative amount, so the amount shown say on July 25 would include the amount in July 24 plus that day?

3-again, i meant when it is complete. so when the task is complete, in that instant BCWP would be equal to the fixed cost i had assigned in the beginning when saving baseline correct?

4-did not understand your answer to this one. BCWS or in other words PV, is totally dependent on baseline, isnt that so? so what is the relevancy of status date here?
Reply With Quote
  #4  
Old 08-16-2012, 02:13 PM
JulieS JulieS is offline earned value not calculating Windows 7 64bit earned value not calculating Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

2-i meant the completed portion of those tasks. if I wanted to EV for july, I would take the "completed portion" of those tasks that took place in July and add them correct? or, is it a cumulative amount, so the amount shown say on July 25 would include the amount in July 24 plus that day?

I'm afraid I don't understand your question. The earned value (BCWP) is only calculated on the work that is actually performed. You can see earned value data in a timescaled view to see what the earned value was as of a certain date and status date.

3-again, i meant when it is complete. so when the task is complete, in that instant BCWP would be equal to the fixed cost i had assigned in the beginning when saving baseline correct?

Only if the work was completed as originally scheduled. If you finished the task before the original finish, then the BCWP could be greater than the BCWS and you would show a positive schedule variance when the status date = task finish date.

If you took longer to complete the work then the schedule variance would be negative.

4-did not understand your answer to this one. BCWS or in other words PV, is totally dependent on baseline, isnt that so? so what is the relevancy of status date here?

No. All earned value data is as of the status date. If you have a task scheduled for the future and the status date is today, the BCWS will show zero - there is no work for that task scheduled for today. BCWP is also as of status date and tracking.

To illustrate, create a simple, one-task project. Project start date was last Monday August 13, 2012. Task duration is 5 days. Assign $50 fixed cost. Save the baseline.
Set your status date to August 10, 2012 and you will see zero BCWS. The tasks is not scheduled to start until August 13.

Set your status date to August 13, 2012. You will see BCWS = $10. You were scheduled to spend $10 per day for 5 days so your current BCWS is $10.00. Mark the task 15% complete. The BCWP = $7.50. By the end of the first day, you should be 20% complete but you are only 15%. You've only earned $7.50 instead of the $10 you should have earned by the end of the first day.

Set your status date to August 14, 2012. You will see BCWS = $20.00 and until you update the % complete the BCWP = $7.50. Update the % complete to 50% - Project is going to assume you have actually worked through mid-day on Wednesday. Set the Actual Duration to 2 days and remaining duration to 2 days. The finish date of the task moves in and now you BCWS = $20 but the BCWP = $25.00. You are currently ahead of schedule - you've accomplished 50% of the work in less than the original 2.5 days.

If all you do is mark % complete -- Project will assume everything went according to schedule and BCWP and BCWS and ACWP will be equal.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
earned value not calculating Calculating earned value ketanco Project 3 08-13-2012 09:06 AM
Calculating Profits? MarkL Project 1 06-12-2012 07:19 AM
earned value not calculating Calculating age at date jamierbooth Excel 2 02-22-2011 03:35 AM
earned value not calculating 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 01:29 AM.


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