Blog Post Image

Whirlwind Bike Earned Value Question

Paul Naybour Paul Naybour

Published: 2nd December 2013

Whirlwind Bike Earned Value Question         
Planned cost (BCWS) week 6  194,000 Planned Duration  12 periods
Work Package Dur BAC %complete EV Actual Cost
Start-up and mobilisation 1            5,000 100%         5,000                  5,000
Design frame 2          60,000 95%      57,000               57,000
Design wheels 1          10,000 100%      10,000               12,000
Design the ancillaries 1          10,000 100%      10,000               15,000
Build the frame 4          60,000 0%                –    
Build the wheels 2          20,000 70%      14,000               14,000
Build the ancillaries 1          20,000 90%      18,000               17,000
Integrate the bike 2          40,000 0%                –    
Test the bike 2          20,000 0%                –    
Launch the bike 1            5,000 0%                –    
Project Management  12          48,000 50%      24,000               22,000
Total         298,000      138,000             142,000
           
CPI = EV / AC 0.97        
SPI = EV / PC                 0.71        
SV= EV – PC –          56,000        
CV = EV – AC –            4,000        
           
Actual completion = planned duration / SPI               16.87        
           
EAC = BAC/ CPI          306,638        
  1. Student says:

    Adelle Well spotted I think its a rounding error on CPI. CPI is 0.971830985915493 so EAC is 306.6376811594203….excel……

  2. Student says:

    Hi – I’m a bit stuck and wonder if anyone can help please.

    If the BAC is 298,000 and the CPI is 0.97, shouldn’t that give a EAC of 307,261? Not 306,638

  3. Student says:

    Hi Paul,

    Fully understand how you arrived at your cals but the question then asks to draw the cost curves for EV and AC, How do you do this?

    Many thanks

  4. Paul says:

    @epicday all you can do is plot the three points you have calculated and join with straght lines. So you have zero for all three at the start, AP and EV at week 6 and then the EAC and forcast actual completion.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.