welding-job-costing-template.xlsx

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