clearing-and-grading-job-costing-template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	CLEARING AND GRADING JOB COSTING
2
3	PROJECT AND CONTRACT INFORMATION
4	Project Name						Project Number			Project Status
5
6	Customer						Contract Number			Subcontract Number
7
8	Project Manager				Superintendent				Reporting Date
9
10	Original Estimate				Revised Budget				Revised Contract
11
12
13	FINANCIAL SUMMARY
14		Committed Cost		Actual Cost		Forecast Final Cost		Budget Remaining		Earned Revenue		Forecast Profit
15		$220,000.00		$310,000.00		$830,000.00		$450,000.00		$494,000.00		$495,000.00
16
17
18		Gross Margin		Cost Performance Index		Labor Productivity		Equipment Utilization		Trucking Cost / Load		Cost / Bank CY
19		37.4%		159.4%		0.00		0.6%		$0.17		$0.37
20
21
22
23
24
25	COST BY CATEGORY

26	Cost Category	Budget	Committed	Actual	Forecast	Variance	% Complete	Unit Cost	Work Area	Phase	Status	Notes
27
28
29
30
31
32
33
34
35
36
37
38
39
40	PRODUCTION AND UNIT-COST SUMMARY
41	Metric	Actual Quantity	Unit	Labor Hours	Equipment Hours	Truck Loads	Actual Cost	Unit Cost	Budget Unit Cost	Variance	Trend	Notes
42
43
44
45
46
47
48
49
50
51
52
53
54	COMMITMENTS, PURCHASE ORDERS, AND CHANGE ORDERS
55	Purchase Orders and Vendor Commitments
56
57
58
59	Change Orders and Revenue Exposure
60
61
62
63
64
65
66	FORECAST, PROFITABILITY, AND PERFORMANCE
67	Forecast Assumptions and Cost Trends
68
69
70
71	Risks, Opportunities, and Corrective Actions
72
73
74
75
76
77
78	INTERNAL NOTES AND APPROVAL
79	Internal Notes
80
81
82
83	Prepared / Reviewed / Approved
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100