Interpreting BCWP Caculation: Part II

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: verossa (verossa_at_hotmailnospam.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 13:51:01 +0100

Here is my MS Excel project information - the status date was set to
21/05/04

10/5/04 [DAY 1]
ACWP £20.00
BCWP £80.00
BCWS £80.00

11/5/04 [DAY 2]
ACWP £20.00
BCWP £160.00
BCWS £160.00

12/5/04 [DAY 3]
ACWP £40.00
BCWP £240.00
BCWS £240.00

13/5/04 [DAY 4]
ACWP £80.00
BCWP £320.00
BCWS £320.00

14/5/04 [DAY 5]
ACWP £140.00
BCWP £400.00
BCWS £400.00

17/5/04 [DAY 6]
ACWP £280.00
BCWP £480.00
BCWS £480.00

18/5/04 [DAY 7]
ACWP £440.00
BCWP £560.00
BCWS £560.00

19/5/04 [DAY 8]
ACWP £760.00
BCWP £640.00
BCWS £640.00

20/5/04 [DAY 9]
ACWP £1,080.00
BCWP £720.00
BCWS £720.00

21/5/04 [DAY 10]
ACWP £1,080.00
BCWP £720.00
BCWS £800.00

Task 1 Earned Value Analysis as per Task Usage View
BCWS: £800.00
BCWP: £720.00
ACWP: £1,080.00
SV: £80.00
CV: -£360.00
EAC: £1,080.00
BAC: £800.00
WAC: -£280.00

Resource: Verossa
BCWS: £800.00
BCWP: £800.00
ACWP: £1,080.00
SV: £0.00
CV: -£280.00
EAC: £1,080.00
BAC: £800.00
WAC: -£280.00

Question:

1) On the 10/5/04 and 11/5/04. The actual work lower than BCWS but why is
the BCWP the same as BCWS? Likewise, 19/5/04 and 20/5/04 the actual work is
much higher than the baseline. So I assumed this would reflect the BCWP.

2) How do I interpret the EVA information in Task Usage View? Are there any
help online resource, or can anyone provide any tips / hints.

3) The help file states: "Microsoft Project calculates BCWP. The amount of
work complete is multiplied by the assignment's timephased baseline cost."
Can any explain how the calculation works - as it seems to always be the
same as BCWS, and there I do not see the significance of BCWP. The help
files also states: "percentage of the budget that should have been spent for
a given percentage of work performed on a task." But when the given
percentage of work performed is greater or less than the budgeted /
baseline - I see no difference?

Finally, thanks to everyone who has assisted me and taken time out to answer
my many questions.

Have a good day,
Verossa

Relevant Pages

  • Re: Earned Value Field Categories
    ... I'm not sure you would ever roll up the assignment to the specific resource, ... between ACWP BCWP and BCWS. ...
    (microsoft.public.project)
  • Re: Earned Value Field Categories
    ... If the project is performed exactly as planned then there is no difference between ACWP BCWP and BCWS. ... Resource fields do not make much sense in determining Earned value. ...
    (microsoft.public.project)
  • Re: Earned Value Field Categories
    ... look at Fields Reference via Help it gives me six Field Categories for BCWS, ... six for BCWP and six for ACWP. ... to different views (Gantt, Resource, Task etc.), I’m actually at a loss to ...
    (microsoft.public.project)
  • Earned Value Field Categories
    ... noticed there are six field categories for BCWS, ... updating the BCWP and actual work plus remaining work updating the ACWP. ...
    (microsoft.public.project)
  • Re: Earned Value Calculation
    ... You have some major problems with your calculations ... the estimated work in the BCWS must come from the Baseline Work ... BCWP is not rate*estimated work*%complete nor is the formula for ACWP ...
    (microsoft.public.project)