How do you calculate the last 2 lines? How did you get those figures?
Thanks for the help.
Problem: A project has a budget of £10M and schedule for 10 months. It is assumed that the total budget will be spent equally each month until the 10th month is reached. After 2 months the project manager finds that only 5% of the work is finished and a total of £1M spent.
Solution:
PV = £2M
EV = £10M * 0.05 = £0.5M
AV = £1M
CV = EV-AC = 0.5-1 = -0.5M
CV% = 100 * (CV/EV) = 100*(-0.5/0.5) = -100% overrun
SV = EV-PV = 0.5-2 = -1.5 months
SV% = 100 * (SV/PV) = 100*(-1.5/2) = -75% behind
CPI = EV/AC = 0.5/1 = 0.5
SPI = EV/PV = 0.5/2 = 0.25
EAC = BAC/CPI = 10/0.5 = £20M
ETC = (BAC-EV) / CPI = (10-0.5)/0.5 = £19M
Time to compete = (10-0.5)/0.25 = 38 Months
This project will take TOTAL £20M (19+1) and 40 (38+2) Months to complete.