Earned Value Calculation

5-1 Earned Value Calculation
1.
PV-BCWS=$3607.14
EV-BCWP=$3593.34 (.98 x 3666.67) CPI x AC
AC-ACWP=$3666.67 (3593.34/.98) EV/CPI
2.
SV= -13.8 (3593.34 – 3607.14) EV – PV
CV=73.33 (3593.34 – 3666.67) EV – AC
SPI=1.0 (3593.34/3607.14) EV/PV
CPI=.98 (3593.34/3666.67) EV/AC
3.
According to these calculations, the schedule variance is running late and the cost variance did not run over. The SPI is 1.0 which means that it is running on schedule. The CPI is .98 which is over budget by .02%. I don’t feel that the project is too far off schedule which they should be able to celebrate.

Calculations:
6/7=86% complete
Budget
101000/4mth=25250
25250/7 tasks=3607.14 each task
Actual
88000/4mth=22000
22000/6 tasks=3666.67 each task
If 7th task was done
91666.67/4=22916.67
22916.67/3273.81 each task if complete 10% under budget

5-2 Earned Value Calculation

Activity Budget % Complete BCWP BCWS ACWP Cost Variance Schedule Variance CPI SPI
A $1,600.00 100% $1,600.00 $1,600.00 $1,800.00 -$200.00 $0.00 0.8888889 1
B $4,000.00 100% $4,000.00 $4,000.00 $4,500.00 -$500.00 $0.00 0.8888889 1
C $14,050.00 90% $12,645.00 $14,050.00 $13,500.00 -$1,035.00 -$1,405.00 0.9366667 0.9
D $5,800.00 10% $580.00 $2,900.00 $500.00 $80.00 -$2,320.00 1.16 0.2
E $12,000.00 0% $0.00 $2,400.00 $0.00 $0.00 -$2,400.00 0 0
F $5,200.00 0% $0.00 $0.00 $0.00 $0.00 $0.00 0 0
G $3,900.00 0% $0.00 $0.00 $0.00 $0.00 $0.00 0 0
Total $46,550.00 $18,825.00 $24,950.00 $20,300.00 ($1,655.00) ($6,125.00) 0.93 0.75

According to the SPI of a value of .75 it implies that we are under schedule at this time. The CPI of .93 implies that we are over budget. The schedule variance is negative $6125 which means the project is running behind. As of right now the project is over it's