[Project Title]
Earned Value Analysis Report
Prepared By: [Manager's Name]
Date: [Report Date] 1
[42]
0.9 Planned Value (PV)
For Period: Earned Value (EV)
0.8
0.7 Actual Cost (AC)
Summary:
[Use this space to write a brief summary or to record 0.6
specific observations or notes] 0.5
0.4
0.3
0.2
0.1 Period
0
1 2 3 4 5 6 7 8 9 10 11 12
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
1.1 Task 1 0
1.2 Task 2 0
1.3 Task 3 0
1.4 Task 4 0
1.5 Task 5 0
1.6 Task 6 0
0
0
0
0
0
0
Insert new rows above this one
Total Budgeted Cost 0 0 0 0 0 0 0 0 0 0 0 0 0
Cumulative Planned Value (PV) 0 0 0 0 0 0 0 0 0 0 0 0
Actual Cost and Earned Value
Cumulative Actual Cost (AC) 0 0 0 0 0 0 0 0 0 0 0 0
Cumulative Earned Value (EV) 0 0 0 0 0 0 0 0 0 0 0 0
Project Performance Metrics
Cost Variance (CV = EV - AC) 0 0 0 0 0 0 0 0 0 0 0 0
Schedule Variance (SV = EV - PV) 0 0 0 0 0 0 0 0 0 0 0 0
Cost Performance Index (CPI = EV/AC) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Schedule Performance Index (SPI = EV/PV) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Estimated Cost at Completion (EAC) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #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.