|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 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%||–|
|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|
4 Comments Leave a comment
Adelle Well spotted I think its a rounding error on CPI. CPI is 0.971830985915493 so EAC is 306.6376811594203….excel……
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
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?
@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.