Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    EVM-Calculation Template

    Uploaded by

    Pavethra
    This 14-day project is under budget and ahead of schedule. The project has a positive cost variance of $50, indicating it is under budget. It has a schedule variance of $0, indicating it is on schedule. The cost performance index of 1.02 and schedule performance index of 1 also show the project is under budget and on schedule.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    EVM-Calculation Template

    Uploaded by

    Pavethra
    17 views5 pages
    This 14-day project is under budget and ahead of schedule. The project has a positive cost variance of $50, indicating it is under budget. It has a schedule variance of $0, indicating it is on schedule. The cost performance index of 1.02 and schedule performance index of 1 also show the project is under budget and on schedule.

    Original Description:

    Original Title

    EVM-Calculation template

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This 14-day project is under budget and ahead of schedule. The project has a positive cost variance of $50, indicating it is under budget. It has a schedule variance of $0, indicating it is on schedule. The cost performance index of 1.02 and schedule performance index of 1 also show the project is under budget and on schedule.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    17 views5 pages

    EVM-Calculation Template

    Uploaded by

    Pavethra
    This 14-day project is under budget and ahead of schedule. The project has a positive cost variance of $50, indicating it is under budget. It has a schedule variance of $0, indicating it is on schedule. The cost performance index of 1.02 and schedule performance index of 1 also show the project is under budget and on schedule.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Test Project [Company Name / Logo]

    Earned Value Analysis Report

    Prepared By: [Manager's Name]


    Date: [Report Date] $3,000
    [42]
    Planned Value (PV)
    For Period: 14 Days $2,500 Earned Value (EV)
    Actual Cost (AC)
    Summary: $2,000
    [Use this space to write a brief summary or to record specific
    observations or notes] $1,500
    This project is under budget and
    $1,000 ahead of schedule.
    $500
    Period
    $0
    1 2 3 4 5 6 7 8 9 10 11 12 13 14

    Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS)


    WBS Task Name TBC 1 2 3 4 5 6 7 8 9 10 11 12 13 14
    Task 1 600 0 0 400 0 0 0 0 0 0 200 0 0 0 0
    Task 2 500 0 0 200 0 0 0 0 0 0 0 0 300 0 0
    Task 3 500 0 0 300 0 0 0 0 0 0 0 0 0 200 0
    Task 4 500 0 0 0 0 100 100 100 100 100 0 0 0 0 0
    Task 5 150 0 0 0 0 0 0 0 0 150 0 0 0 0 0
    Task 6 200 0 0 0 0 0 0 0 0 0 0 200 0 0 0
    Task 7 50 0 0 0 0 0 0 0 0 0 0 0 0 50 0
    0
    0
    0
    0
    0
    Insert new rows above this one
    Total Budgeted Cost 2500 0 0 900 0 100 100 100 100 250 200 200 300 250 0
    Cumulative Planned Value (PV) 0 0 900 900 1000 1100 1200 1300 1550 1750 1950 2250 2500 2500

    Actual Cost and Earned Value


    Cumulative Actual Cost (AC) 0 0 850 850 950 1050 1175 1275 1500 1600 1900 2200 2450 2450
    Cumulative Earned Value (EV) 0 0 540 540 815 970 1150

    Project Performance Metrics


    Cost Variance (CV = EV - AC) 0 0 -310 -310 -135 -80 -25 -1275 -1500 -1600 -2450 -2450
    Schedule Variance (SV = EV - PV) 0 0 -360 -360 -185 -130 -50 -1300 -1550 -1750 -2500 -2500
    Cost Performance Index (CPI = EV/AC) #DIV/0! #DIV/0! 0.64 0.64 0.86 0.92 0.98 0.00 0.00 0.00 0.00 0.00
    Schedule Performance Index (SPI = EV/PV) #DIV/0! #DIV/0! 0.60 0.60 0.82 0.88 0.96 0.00 0.00 0.00 0.00 0.00
    Estimated Cost at Completion (EAC) #DIV/0! #DIV/0! 3935 3935 2914 2706 2554 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
    This worksheet is used to help calculate the Earned Value (EV) or Budgeted Cost of Work Performed (BCWP).
    Use this worksheet to help calculate the Actual Cost (AC) of Work Performed (ACWP) by entering the costs incurred each period.
    Earned Value and its use in Cost Control.

    BCWS ACWP BCWP


    Work Package %Progress
    Planned Value Actual Cost Earned Value
    1 $600.00 $650.00 100% $600.00
    2 $500.00 $440.00 100% $500.00
    3 $500.00 $460.00 100% $500.00
    4 $500.00 $500.00 100% $500.00
    5 $150.00 $150.00 100% $150.00
    6 $200.00 $200.00 100% $200.00
    7 $50.00 $50.00 100% $50.00
    8 $0.00 0% $0.00
    9 $0.00 0% $0.00
    10 $0.00 0% $0.00
    BAC $2,500.00 $2,450.00 $2,500.00
    ACWP : Actual Cost of Work Performed

    BCWP : Budgeted cost of Work Performed


    BAC : Budget At Completion

    BAC $2,500.00
    PV $2,500.00
    AC $2,450.00
    EV $2,500.00
    In this example,
    the project is
    Cost Variance (CV = EV - AC) $50.00 over budget and
    behind schedule
    Cost Performance Index (CPI = EV/AC) 1.02
    Schedule Variance (SV = EV - PV) $0.00
    Schedule Performance Index (SPI = EV/PV) 1.00

    You might also like