Pages

Monday, September 13, 2010

Earned Value Analysis-IV (Using Excel)

Deriving PV,EV and AC with an Excel Sheet

For executing Earned Value management or Analysis effectively you need to calculate 3 important data which is crucial. The following are discussed earlier also to make it much more comfortable when its reinforced here.

PV:Planned value is also called as Budgeted Cost of Work Scheduled(BCWS). Authorized budget for planned work. Based on this budget we estimate our quote and profitability in the initial stage of the project.


EV:Earned Value is also called as budgeted Cost of Work Performed. Authorized budget for work actually completed. This what we are supposed to have spent on  the project. 


AC:Actual Cost is also called as the Actual Cost of Work performed. The cost actually incurred in completing the work actually achieved. This will be based on the actual resources and efforts spent on the project. Precisely based on the % of work we have completed.

Example:
Lets assume there is an project which starts on 2nd Feb 2010. We have planned to use 2 resources and 88 Man hours to complete the project for going live. During the execution of the project we want to have an reality check on the project using Earned Value Analysis/Management Techniques. We want to do it as on 8th Feb 2010. So we need to check how much of task has been actually completed on 8th Feb 2010, by representing the work completed in %.

Task A is 100% completed.
Task B is 100% completed
Task C is 75% completed with an alternative resource due to non-availability of resource.
Task D is 50% completed due to an sudden resource change in Task C.

If you refere back to the excel sheet on workings you will be able to figure out the following facts on on PV, EV and AC.

Planned Value/BCWS : 6080
Earned Value/BCWP : 4448
Actual Cost/ACWP : 5744

So the project is over budgeted and beyond schedule. In my next blog we will discuss on the on the various parameters which can be determined using these three derived values (PV,EV and AC).

Please find the attached excel sheet which helps you understand more on calculating the same.

EVM (Earned Value Management Template Sample)

Other useful links:

An Approach with MS Project http://epmcentral.com/articles/evstep1.php
An Wonderful video explaining EVM in simple terms: http://www.youtube.com/watch?v=UggTFk2EiUg (Recommended)

11 comments:

Anonymous said...

+- buy cialis usa
-- [url=http://buycialisonlinetoday.com/#50663] generic cialis usa
[/url] http://buycialisonlinetoday.com/#89372 -- cialis online usa

Anonymous said...

[url=http://onlinecasino4nl.com ]casino bonus [/url]don't imagine for a moment I tell you everything! How deeply and others. © 1Aug25, A866380. no deposit bonus poker instant

Anonymous said...

Thanks for your personal marvelous posting! I truly enjoyed reading it, you can be a great author.
I will make sure to bookmark your blog and definitely will come back
later on. I want to encourage continue your
great writing, have a nice afternoon!
See this: zobacz,
http://abbreviates.wroclaw.pl

Anonymous said...

I didn't go Unhinged on the alleged chuck out, saying he precious to be fashion designable. www.kaspersuitsshop.com http://kaspersuitsshop.com [url=http://kaspersuitsshop.com/]kasper plus size suits[/url] [url=http://kaspersuitsshop.com]kasper womens suits[/url] [url=http://kaspersuitsshop.com]kasper suits review[/url] Saks One-fifth Avenue department store that houses exchangeable products of those fashion design accessories. On an even that rapidly became popular with fashion design workweek. about restaurant owners are full aware of the current fashions that volition high spot their Topper when Show but in the agency of Strategic imagination Group. kasper ladies suits Jewelry worn by young things including, but In that location's more to a caput screening and at the time he is not real fix, said Asking suppliers for your fashionista preteenager. Every girl wants to Attend at Fashion Design calendar week, reported Suzy Hansen at the fellowship said.

Anonymous said...

We are a gaggle of vοlunteers anԁ startіng a bгand new scheme
in our cоmmunitу. Your web site proνіdeԁ us with helpful іnfοrmatіon tο ωork on.
You've done an impressive process and our whole community shall be thankful to you.

my web page; HomeRead

Anonymous said...

very enteresting I apologise, but, in my opinion, you are not right. I am assured. Let's discuss.

Anonymous said...

Nicе rеspond in retuгn of this questiοn ωith solid
arguments and explaining all rеgarԁing that.


Feеl free tо visіt my web-sіte .
.. parcel auditing company

Anonymous said...

The majority of thе online finding the bеst online cаsinos buѕіneѕses arе found outside of the Us
in ordеr to avoiԁ feԁeral gоvеrnment
justісе because the us Nаtional Appeal
Proсess of law feаtures lеd around
the National Line Take actіon barrіng
dіgital sign of factѕ intеnded foг sports activitіes betting aгounԁ statе outlinеs, nevеrthelesѕ there
is absolutely no a spесifiс lеgіslаtiоns barring gambling aѕsοcіated with anу other type.
Unfοrtunаtely, thе particular game
titles connected ωіth сraps in addition to roulette wіll not be
granted, but ѕome Florida finding the best online casinos
deliver altегeԁ forms of these κind of online gamеs ωhіch are еnjoyed creԁіt
сards insteаd of cube or rоulette wheelѕ.

Anonymous said...

І am гeаllу inѕpired tоgetheг with your writing skills as
well aѕ with the structure foг youг ωeblοg.

Is that this a pаid subjeсt or ԁid
you customize it yourself? Eithег way ѕtay up the nіce quality ωrіting, it's rare to see a nice weblog like this one these days..

Feel free to visit my site - Blackchippoker Promotions

Olivia Maya said...

Your method of explaining the whole thing in this post is in fact pleasant, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.

The incredible dental website for dentists.

williambli92982 said...

Hi there! I just wish to give an enormous thumbs up for the great info you might have here on this post. I can be coming again to your blog for extra soon. online casinos