ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[Project Name]
2
Use this sheet to track the Planned Value (PV)
3
Use this sheet for the Earned Value Management (EVM) Calculations
4
5
6
Prepared By:[PM Name]
7
Date:[Today's Date]
8
For Period:[Start Date - End Date]
9
10
Belnded hourly rate$100.00
11
12
13
14
15
16
17
18
19
20
21
22
Planned Value
*Fill this table out with a month by mohty projected cost per line item
23
WBSTask NameHoursBudgetMonth 1Month 2Month 3Month 4Month 5Month 6Month 6Month 8Month 9Month 10Month 11Month 12
24
Task 1$0.00
25
Task 2$0.00
26
$0.00
27
$0.00
28
$0.00
29
$0.00
30
$0.00
31
$0.00
32
$0.00
33
$0.00
34
$0.00
35
$0.00
36
$0.00
37
$0.00
38
$0.00
39
$0.00
40
$0.00
41
$0.00
42
$0.00
43
$0.00
44
45
Total Budgeted Cost$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
46
Cumulative Planned Value (PV)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
47
48
Actual Cost and Earned Value
Month 1Month 2Month 3Month 4Month 5Month 6Month 6Month 8Month 9Month 10Month 11Month 12
49
Cumulative Actual Cost (AC)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
50
Cumulative Earned Value (EV)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
51
52
Project Performance Metrics
53
Cost Variance (CV = EV - AC)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
54
Schedule Variance (SV = EV - PV)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
55
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!
56
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!
57
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!
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