You are asked to undertake a project that consists of four activities: A-B-C-D. Activity A is worth
Question:
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 Dis 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
b) Total earned value for the project
c) Total actual cost of the work performed
d) Cost Variance
e) Schedule Variance
f) Cost Performance Index (CPI)
g) Schedule Performance Index (SPI)
h) Budget at Completion (BAC)
i) Estimate at Completion (EAC).
j) Estimate to Complete (ETC)
k) is the project on time and on budget?
Please, justify your answer by using the appropriate indicators.
Calculations must be shown Formulas
CV = EV - AC = BCWP - ACWP;
SV = EV - PV = BCWP - BCWS;
CPI = EVIAC = BCWP/ ACWP;
SPI = EV/PV = BCWP/BCWS;
EAC = BAC/CPI = BAC/(BCWP/ACWP);
ETC = EAC-AC = EAC - ACWP
Foundations of Financial Management
ISBN: 978-1259194078
15th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen