Earned Value Calculations

kjc28's version from 2017-01-31 01:55

Summary

Earned Value Formulas

Abbreviations

BACBudget - Sum of Budgeted Costs (no Formula)
ACActual Costs (no Formula)
PVPlanned Value
EVEarned Value
SVSchedule Variance
CVCost Variance
SPISchedule Performance Index
CPICost Performance Index
EACEstimate AT Completion
ETCEstimate TO Completion
VACVariance AT Completion
TCPITo Complete Performance Index

Formulas

BAC (Budget)NONE
PV or BCWS"%Time(Planned) Completed" * BAC
EV or BCWP"%Units(Actual) Completed" * BAC
AC or ACWPNONE
CVEV - AC
SVEV - PV
CPIEV / AC
SPIEV / PV
EACBAC / CPI
ETCEAC - AC
VACBAC - EAC
TCPI(BAC - EV) / (BAC - AC)

Abbreviations what they mean

BACTotal BUDGET (\$) for the project
PV or BCWSValue (\$) How much in COST should have been completed by this point in time
EV or BCWPValue (\$) How much in COST actually performed by this point in time
AC or ACWPTotal (\$) actually spent by this point in time
CVVariance (Subtract) - Difference between what we expected to spend (\$) and what we actually spent (\$) for the work completed
SVVariance (Subtract) - Difference between where we planned to be and where we are (in time).
CPIHow Efficient (\$) we spend money (>=1 is good <1 bad) ie 1.50 would mean for every dollar spent we achieved \$1.50 worth of work
SPIHow Efficient (time) we are to this point (>=1 is good <1 bad) ie 1.50 means for every hour worked we have completed 1.5 hours of work
EACTotal cost AT completion (at our current rate of spending what will we spend by the end of the project)
ETCHow much more will we spend by the end the project at our current rate of spending (EAC).
VACDifference from budgeted will we actually spend (Budget - EAC). <0 (BAD) overspending budget & >0 (GOOD) under budget
TCPIPerformance that must be achieved in order to meet finacial goals (<1 BAD & >1 GOOD)

.