## Help with calculations

This forum is for members to share and gain knowledge of Project Management. Got a question about project management? Need help with a problem? Wish to offer tips and advice? Post here.
falcios
New Member
Posts: 1
Joined: Fri 02 Aug 2013 11:40 am
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.