Earned Value Calculator (Excel) by hedongchenchen

VIEWS: 21 PAGES: 4

									                                                                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