How is BCWP calculated?

[verossa]

Morning All

I am looking at my MS Project > Task View > Earned Value Table and I have the following information

BCWS: £360
BCWP: £2,915.2
ACWP: £430
SV: -£684.7
CV: -£1394.7
EAC: £590
BAC: £400
VAC: -£190

This is sample to test the EVA in MS Project - it only has one 10 day task. I have deliberately created a variance between the 'actual work' and baseline schedules to view the effects. However, I confused (as usual). Isn't there a formula for calculating BCWP

Any information would be appreciated :-

TIA - Vers

 

[Gérard Ducouret]

Hello Vers,
That means you realised only 80,9% on the work to be done, but you spent
1,47 times the budget for that.

That not a good job Vers ! I hope you'll work better than that in the future
;-)

Gérard Ducouret

Morning All,

I am looking at my MS Project > Task View > Earned Value Table and I have the following information:

BCWS: £3600
BCWP: £2,915.25
ACWP: £4300
SV: -£684.75
CV: -£1394.75
EAC: £5900
BAC: £4000
VAC: -£1900

This is sample to test the EVA in MS Project - it only has one 10 day

task. I have deliberately created a variance between the 'actual work' and
baseline schedules to view the effects. However, I confused (as usual).
Isn't there a formula for calculating BCWP.

 

[verossa]

Hi Gerrard

Hope you're well my friend. Fortunately, this was a test to see how EVA works. Can you explain how you derived this understanding. And do you know how MSP calculates BSWP

Thanks for responding :-
Vers

 

[Rob Schneider]

Vers,

If you take a quick look in Project's Help File, Tab: Index, you'll see
lots of information about this field, including how it is computed.
There is also detailed information about Earned Value computation.

Hope this is useful to you. Let us know.

rms

 

[Gérard Ducouret]

Hello Verossa,
In the Project Help, make a search on "Earned value fields"
Hope this helps,
Have a good week-end !

Gérard Ducouret

Hi Rob,

Hope you're well.

I always try and view the help files before posting, but I cannot find any

information in the help file about how this field is computed other than
descriptions. I cannot find any formula's or Earned Value computations.

I'd appreciate any directions you can provide for the help files - I'm

obviously not looking in the right place.

 

[Rob Schneider]

In additoin to Gérard's advice, simply pick the tab:index, and type in
BCWP and you'll find the info for that field, and "earned value" for the
Earned Value info. It's there.

Hope this is useful to you. Let us know.

rms

 

[verossa]

Thanks for replying guys...

I've seen this help files but I don't understand how this translates into
the BCWP figures when either in the earned value view or the exported excel
data.

I'll post a more specific question

Thanks again,
Vers

 

[Steve House]

Imagine a 2 week (80 hour) task assigned to a resource who is paid $10 per
hour. At the end of Friday in the first week the resource reports that he
has done 32 man-hours of work on the task. He should have done 40 man-hours
by that time but he booked off ill on Tuesday. OK, so we are at the halfway
mark. We should have done (ie, scheduled) 40 hours but we actually only did
32 hours. The Budgeted Cost of Work Scheduled at this point is 40*10 or
$400. The Budgeted Cost of Work Performed is 32*10 or $320. The Actual
Cost of Work Performed is 32*10 or $320. We're running late but on budget
for cost so we'll likely finish on budget but a day late. Second variation:
As before our resource booked off ill on Tuesday but we replaced him with
another resource that one day so we've been able to do a total of 40 hours
of work by this point as we'd planned. Unfortunately, the replacement gets
$15 per hour, not $10. So, Friday at 5pm we should have done 40 hours of
work and we did, with 32 being done by resource 1 and 8 by resource 2. Our
Budgeted Cost of Work Scheduled is still 40*10 or $400. Our Budgeted Cost
of Work Performed is 40*10 or $400, the original baseline cost estimate.
Our Actual Cost of Work Performed is 32*10 plus 8*15, or $440. We're on
time but running over-budget. In both cases out BAC, Budget At Completion is
the original saved baseline estimate, $800. Our EAC, Estimate At Completion
depends on whether we think resource 1 will be at work next week or is
likely to call in sick again thus requring that we fall back on resource 2
once again and will be either $840 or $1040.