steel-erection-job-costing-template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	STEEL ERECTION JOB COSTING
2
3	JOB CONTROL
4	Job Number			Job Name				Status			Report Date
5
6											Forecast Update Date
7
8
9
10	CONTRACT / REVENUE
11	Customer / Owner / GC / CM						Contract / Subcontract / PO / Estimate
12
13
14
15
16
17
18
19
20
21
22	COST SUMMARY
23	Revised Subcontract			Projected Revenue			Current Budget			Actual Cost
24
25
26
27	Open Commitments			Cost To Complete			Projected Final Cost			Cost Variance
28
29
30
31	Projected GP			Projected Margin			Retainage			Remaining To Bill
32
33
34
35
36
37
38	STEEL PRODUCTION / PRODUCTIVITY
39	Sequence	Level	Member Type	Budget Tons	Actual Tons	Budget Pieces	Actual Pieces	Labor Hrs	Hrs/Ton	Hrs/Piece	Crane Hrs	Notes
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54	CRANE / EQUIPMENT / CONNECTIONS
55	Crane / Equipment / Connections / Deck
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70	CHANGE ORDERS / FORECAST
71	Change Orders / Forecast / Revenue
72
73
74
75
76
77
78
79
80
81
82
83
84	VARIANCE / CLOSEOUT REVIEW
85	Variance Explanation / Corrective Action / Closeout
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100