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