Question 2.
You are asked to undertake a project that consists of four activities: A-B-C-D. Activity A is worth $40,000, is complete and actually cost $40,000. Activity B is worth $20,000, is 50% complete and has actually cost $15,000 so far. Activity C is worth $1,000, is 75% complete and has actually cost $950 so far. Finally, Activity D is worth $3,000, is 25% complete and has actually cost $1,200 so far. What is the current status of this project?
Use the information and formulas provided to calculate the following:
a) Total planned value of the scheduled work [2 marks]
b) Total earned value for the project [2 marks]
c) Total actual cost of the work performed [2 marks]
d) Cost Variance [1 mark]
e) Schedule Variance [1 mark]
f) Cost Performance Index (CPI) [2 marks]
g) Schedule Performance Index (SPI) [2 marks]
h) Budget at Completion (BAC) [1 mark]
i) Estimate at Completion (EAC) [2 marks]
j) Estimate to Complete (ETC) [1 mark]
k) Is the project on time and on budget? Please, justify your answer by using the appropriate indicators [4 marks]
Calculations must be shown
Formulas:
CV = EV - AC = BCWP - ACWP
SV = EV - PV = BCWP - BCWS
CPI = EV/AC = BCWP/ACWP
SPI = EV/PV = BCWP/BCWS
EAC = BAC/CPI = BAC/(BCWP/ACWP)
ETC = EAC - AC = EAC - ACWP