# Earned Value Calculator (Excel) by hedongchenchen

VIEWS: 21 PAGES: 4

• pg 1
```									                                                                Definitions

Metric           Abbrev.                        Description                                          Formula/Value
Budget at Completion          BAC Baseline cost for 100% of project.                                                 N/A
Actual Cost of Work
Performed                    ACWP Total costs actually incurred so far.                                                N/A
Budgeted Cost of Work             Amount of budget earned so far based on physical work
Performed                    BCWP accomplished, without reference to actual costs.                                     N/A
Budgeted Cost of Work             The budget for the physical work scheduled to be completed by
Scheduled                    BCWS the end of the time period.                                                          N/A
Budgeted Cost of Work
Measure of cost overrun. The difference between the budget for       Performed–Actual Cost of Work
Cost Variance                  CV    the work actually done so far and the actual costs so far.              Performed BCWP/ACWP
Cost efficiency ratio. A CPI of 1.00 means that the costs so far   Budgeted Cost of Work Performed/
are exactly the same as the budget for work actually done so        Actual Cost of Work Performed
Cost Performance Index         CPI   far.                                                                        BCWP/ACWP
Budgeted Cost of Work
Measure of schedule slippage. The difference between the           Performed–Budgeted Cost of Work
budget for the work actually done so far and the budgeted cost                 Sceduled
Schedule Variance              SV    of work scheduled.                                                          BCWP–BCWS
The schedule efficiency ratio. An SPI of 1.0 means that the
Schedule Performance Index     SPI   project is exactly on schedule.                                               BCWP/BCWS
Estimate at Completion–Actual Cost
Work Performed
Estimate to Completion        ETC    The expected additional cost to complete.                                      EAC–ACWP
Budget at Completion/Cost
Performance Index
Estimate at Completion        EAC    Expected total cost based on the current cost efficiency ratio.                 BAC/CPI
Budget at Completion–Estimate at
Completion
Variance at Completion        VAC    Estimated cost overrun at the end of project.                                   BAC–EAC
(Cost Performance Index+Schedule
Performance Index)/2
Status                               Average of CPI & SPI.                                                          (CPI+SPI)/2
GREEN = On track                                                                  >1.0
YELLOW = Slightly behind schedule or budget                                       >0.85
RED = Needs immediate attention                                                   >0.65
BLACK = Killed or Restore                                                         <0.65

Page 1 of 4
Analysis

Project Earned Value Analysis
<ProjectName>
EVA Review Dates >>>>>>>>>>>>>                 Jan         Feb         Mar           Apr              May          Jun           Jul          Aug          Sep          Oct
Budget at Completion (BAC)                  N1,230,000 N1,320,000 N1,320,000 N1,320,000 N1,500,000 N1,500,000 N1,500,000 N1,500,000 N1,500,000 N1,500,000
BCWP - Budgeted Cost of Work Performed       N100,000     N300,000    N400,000      N550,000        N850,000     N900,000 N1,200,000 N1,300,000 N1,450,000 N1,300,000
ACWP - Actual Cost of Work Performed         N100,000     N250,000    N400,000      N700,000        N900,000 N1,100,000 N1,300,000 N1,400,000 N1,600,000 N1,700,000
BCWS - Budgeted Cost of Work Scheduled       N100,000     N300,000    N425,000      N700,000        N900,000 N925,000 N1,300,000 N1,600,000 N1,450,000 N1,500,000
Cost Variance (CV)                                   N0    N50,000           N0    -N150,000         -N50,000    -N200,000     -N100,000     -N100,000   -N150,000    -N400,000
CV %                                                 0%       17%            0%            -27%           -6%        -22%              -8%        -8%        -10%         -31%
Schedule Variance (SV)                               N0          N0   -N25,000     -N150,000         -N50,000     -N25,000     -N100,000     -N300,000           N0   -N200,000
SV %                                                 0%          0%       -6%              -21%           -6%            -3%           -8%       -19%            0%       -13%
Cost Performance Index (CPI)                     1.00        1.20        1.00              0.79          0.94        0.82          0.92          0.93        0.91         0.76
Schedule Performance Index (SPI)                 1.00        1.00        0.94              0.79          0.94        0.97          0.92          0.81        1.00         0.87
Estimate to Completion (ETC)                N1,130,000    N850,000    N920,000      N980,000        N688,235     N733,333      N325,000      N215,385     N55,172     N261,538
Estimate at Completion (EAC)                N1,230,000 N1,100,000 N1,320,000 N1,680,000 N1,588,235 N1,833,333 N1,625,000 N1,615,385 N1,655,172 N1,961,538
Variance at Completion (VAC)                        N0 N220,000           N0 -N360,000   -N88,235 -N333,333 -N125,000 -N115,385 -N155,172 -N461,538
Status based on Average Performance Index    GREEN        GREEN       YELLOW         RED           YELLOW        YELLOW        YELLOW        YELLOW      YELLOW         RED

Status Update                                                                                     New
baseline set

Page 2 of 4
Performance Graphs

Earned Value Analysis

N1,800,000
N1,600,000
N1,400,000
N1,200,000
N1,000,000
N800,000
N600,000
N400,000
N200,000
N0
Jan    Feb      Mar      Apr       May        Jun     Jul      Aug      Sep      Oct
Period

Budget at Completion (BAC)
ACWP - Actual Cost of Work Performed
BCWP - Budgeted Cost of Work Performed

Performance Index

1.30
1.20
1.10
1.00
Efficiency

0.90
0.80
0.70
0.60
0.50
Jan     Feb    Mar       Apr        May       Jun      Jul      Aug      Sep       Oct
Period

Cost Performance Index (CPI)          Schedule Performance Index (SPI)

Page 3 of 4
Performance Graphs

Variance Analysis

N300,000
N200,000
N100,000
N0
Jan      Feb       Mar      Apr       May         Jun     Jul      Aug         Sep      Oct
-N100,000
-N200,000
-N300,000
-N400,000
-N500,000

Period

Cost Variance (CV)         Schedule Variance (SV)          Variance at Completion (VAC)

Estimate at Completion
2100
2000
1900
1800
1700
1600
1500
1400
1300
1200
1100
1000
Jan      Feb        Mar     Apr       May        Jun      Jul      Aug      Sep       Oct
Period

Budget at Completion (BAC)                Estimate at Completion (EAC)

Page 4 of 4

```
To top