fire-protection-job-costing-template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Fire Protection Job Cost Summary
2
3	Project Information
4	Project Name				Project Number			Customer
5	General Contractor				Project Manager			Estimator
6	Project Address							Contract Date			Project Start Date
7								Project Completion Date
8
9	Project Financial Summary
10	Original Contract Value			Original Estimated Cost	-		Actual Cost to Date	-		Projected Final Cost	-
11	Approved Change Orders			Approved Cost-Budget Changes	-		Committed Cost	-		Budget Variance	-
12	Revised Contract Value	-		Revised Cost Budget	-		Estimated Cost to Complete	-		Projected Gross Profit	-
13										Projected Gross Margin
14	Forecast note:	Projected Final Cost follows the approved definition: Actual Cost + Estimated Cost to Complete. Enter ETC so it reflects remaining expected cost without duplicating amounts already recorded as actual.
15	Detailed Cost-Code Summary
16	Cost Code	Cost Category	Cost Description	Original Budget	Budget Changes	Revised Budget	Actual Cost	Committed Cost	Remaining Budget	Estimated Cost to Complete	Projected Final Cost	Projected Variance	Notes

17
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	Project Totals			-	-	-	-	-	-	-	-	-
68
69	Periodic Cost Review
70	Review Date	Status	Revised Contract Value	Revised Cost Budget	Actual Cost	Committed Cost	ETC	Projected Final Cost	Projected Variance	Projected Gross Profit	Projected Gross Margin	Reviewed By	Notes
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85	Project Closeout Notes
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100