ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[Project Title]
[Company Name / Logo]
2
Earned Value Analysis Report
3
4
Prepared By:
[Manager's Name]
5
Date:[Report Date]
6
[42]
7
For Period:Week 7
8
9
Summary:
10
[Use this space to write a brief summary or to record specific observations or notes]
11
12
13
14
15
16
17
18
19
20
Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS)
21
WBSTask NameTBC123456789101112
← You can change the labels for the periods (e.g. Week 1/2/3, Jan/Feb/Mar, etc.)
22
1,1Task 1350010005002000
← Enter or edit values in the light-blue cells.
23
1,2Task 242005008009002000
24
1,3Task 3450070020001000800
25
1,4Task 4330020060010001500
26
1,5Task 530007005001000800
27
1,6Task 667007002000100020001000
28
0
29
0
30
0
31
0
32
0
33
0
34
Insert new rows above this one
← To add more tasks, insert rows above this one. You can or delete this row after you are done adding tasks.
35
Total Budgeted Cost25200100010003700350047002800100015002000100020001000
36
Cumulative Planned Value (PV)
10002000570092001390016700177001920021200222002420025200
37
38
Actual Cost and Earned Value
39
Cumulative Actual Cost (AC)
800195045506550108001360014500
← Enter the Actual Costs as calculated from the AC worksheet.
40
Cumulative Earned Value (EV)
52528005885782097251517020770
← Enter the Earned Value as calculated from the EV worksheet.
41
42
Project Performance Metrics
43
Cost Variance (CV = EV - AC)
-27585013351270-107515706270 - - - - -
44
Schedule Variance (SV = EV - PV)
-475800185-1380-4175-15303070 - - - - -
45
Cost Performance Index (CPI = EV/AC)
0,661,441,291,190,901,121,43 - - - - -
46
Schedule Performance Index (SPI = EV/PV)
0,531,401,030,850,700,911,17 - - - - -
47
Estimated Cost at Completion (EAC)
38400175501948321107279862259217593 - - - - -
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100