Activity Name

BCWS

BCWP

ACWP

% Work Completed

% Work Scheduled to be Completed

BAC

 

 

A

$300

$300

$400

100%

100%

$300

 

 

B

$200

$200

$180

100%

100%

$200

 

 

C

$250

$250

$300

100%

100%

$250

 

 

D

$480

$240

$400

40%

80%

$600

 

 

E

$200

$160

$200

40%

50%

$400

 

 

Total

$1,430

$1,150

$1,480

 

 

$1,750

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SV

-$280

 

 

 

 

 

 

 

CV

-$330

 

 

 

 

 

 

 

CPI

0.777

 

 

 

 

 

 

 

SPI

0.804

 

 

 

 

 

 

 

ETC

$772

 

 

 

 

 

 

 

EAC

$2,252

 

 

 

 

 

 

 

VAC

-$502

 

 

 

 

 

 

 

CR

0.625

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

BCWS = Budgeted Cost of Work Scheduled

 

 

 

 

 

BCWP = BCWS * % of work completed

 

 

 

 

 

ACWP = Actual Cost of Work Performed

 

 

 

 

 

SV = BCWP - BCWS

 

 

 

 

 

 

CV = BCWP - ACWP

 

 

 

 

 

 

CPI = BCWP/ACWP

 

 

 

 

 

 

 

SPI = BCWP/BCWS

 

 

 

 

 

 

 

ETC = (BAC - BCWP)/CPI

 

 

 

 

 

 

EAC = ETC + ACWP

 

 

 

 

 

 

 

VAC = EAC - ETC

 

 

 

 

 

 

 

CR = CPI * SPI