ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Project Forecast Template
4
Track planned vs actual time and cost - and forecast where you will land at project end.
5
6
To download an Excel file, go to File —> Download —> Microsoft Excel
7
What this template doesEAC explained
8
Combines a time forecast and a cost forecast in one workbook.EAC = Estimate at Completion. The projected final value if current performance continues.
9
Shows plan vs actual to date, and calculates EAC (Estimate at Completion) - what the final cost and duration will be if current trends continue.Time EAC = Actual weeks elapsed / % complete. If you are 4 weeks in and 30% done: EAC = 4/0.3 = 13.3 weeks total.
10
Gives an early warning when you are tracking over budget or over time - before it is too late to act.Cost EAC = Actual spend / % complete. If you spent $30k and are 40% done: EAC = $30k/0.4 = $75k total.
11
EAC > Budget = you are tracking over. The earlier you see this, the more options you have.
12
13
Schedule Performance Index (SPI)How to update it
14
SPI = % Complete / % Elapsed Time. SPI < 1 means you are behind schedule.1. Time Forecast: update Actual Weeks and % Complete monthly.
15
SPI 1.0 = on track. SPI 0.8 = 20% behind. SPI > 1 = ahead.2. Cost Forecast: update Actual Spend monthly. EAC and SPI recalculate automatically.
16
Use SPI to spot schedule drift early - before it hits the critical path.3. Dashboard: reads from both sheets - no manual entry needed here.
17
4. Archive a copy of the forecast each month so you can see how estimates evolved.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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