How to apply budget for earned value analysis

T

ttorneby

I'm having huge problems finishing a plan I'm working on. Maybe someone
here has some clever ideas.

To take it from the beginning: This is a part of some school work, and I
have a number of tasks, and for each of the tasks I have details on what
the budget is, and the planned duration. At a specific point in time I
have details on the completion rate of each task, as well as the money
spent, and the actual duration. From these figures, I want MS Project to
calculate figures such as BCWS, ACWP, BCWP, EAC, SPI and CPI.

My problem is that I have not found a place to enter the budget cost for
each task, without having to assign resources and all this. I've only
found two coloums containing the word "budget", but neither of them
allows me to enter values. Is there not a simple way to do this?

Also, it seems like "actual duration" and "% work completed follow each
other. F.ex. on a specific task, 13 out of 16 weeks are spent, but the
work is only 75% completed. MS Project doesn't seem to accept this.

I've attached a screeshot of what I'm working on, in case it might be at
help.

Any help on this matter is highly appreciated!


+-------------------------------------------------------------------+
|Filename: screenshot.png |
|Download: http://forums.techarena.in/attachment.php?attachmentid=11002|
+-------------------------------------------------------------------+
 
S

Steve House

The "budget" Project refers to when calculating EV is the timephased
baseline cost data.

You are also confusing "% Complete" with "% Work Complete" - they are in
fact two entirely different and separate metrics. "% Complete" refers
strictly to duration, the passage of time, and carries no information about
how much work has been done nor how much deliverable has been completed. It
is impossible that at the end of 13 weeks into a 16 week duration task for
the "% Complete" be 75%. Assuming that no scheduled work time has been
missed, at the end of Week 13 into a 16 week task, the % complete is 13/16
or 81.25% by definition; it can be nothing else. If by "75% Complete" you
mean as much deliverable has not been achieved by the end of Week 13 as you
had expected, you need to revise the estimated total duration upward from
the original 16 weeks. If you are 75% complete after working for 13 weeks,
the total duration needs to be 17.33 weeks. The "% Work Complete" MIGHT be
81.25%, if the work contour is flat, but it could also be some wildly
different number from that if it is contoured.
 

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

Top