Construction Budget Vs Actual Template.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Construction Budget vs Actual Template
2	Fill in blue cells at kickoff. Update Actual Cost as work is completed. Variance calculates automatically. Positive variance = favorable.
3	Project Name				Project No.			Contractor
4	Contract Value				Date			Project Manager
5
6	Cost Code	Description	Phase / Category	Estimated ($)	Actual ($)	Variance ($)	Variance (%)	Date Incurred	Invoice Status	Notes

7	LABOR
8	L-101	Project Manager	Management	$38,000.00	$36,500.00	$1,500.00	3.9%	2026-01-31	Paid	On track -- PM hours within plan.
9	L-102	Foreman	Supervision	$52,000.00	$53,800.00	($1,800.00)	-3.5%	2026-02-28	Paid	Ran ~35 hrs over due to scope clarifications at rough-in.
10	L-103	Journeyman Electrician	Rough-In	$44,000.00	$44,000.00	-	-	2026-02-28	Paid
11	L-104	Apprentice (2 workers)	Rough-In	$28,000.00	$27,200.00	$800.00	2.9%	2026-02-28	Paid
12	L-105	Overtime Premium	Various	$5,000.00	$6,400.00	($1,400.00)	-28.0%	2026-03-15	Paid	Compressed schedule in weeks 6-8 drove OT.
13	Labor Subtotal			$167,000.00	$167,900.00	($900.00)	-0.5%
14
15	MATERIALS
16	M-201	Electrical Panel (200A main)	Procurement	$8,500.00	$8,750.00	($250.00)	-2.9%	2026-01-20	Paid	Supplier price increase after bid lock.
17	M-202	Wire and Cable	Rough-In	$12,000.00	$11,640.00	$360.00	3.0%	2026-01-31	Paid
18	M-203	Conduit and Fittings	Rough-In	$5,400.00	$5,900.00	($500.00)	-9.3%	2026-02-10	Paid	Additional hangers required per GC RFI-007.
19	M-204	Devices and Covers	Trim-Out	$3,200.00	$3,200.00	-	-	2026-02-15	Paid
20	M-205	Lighting Fixtures	Trim-Out	$9,800.00	$9,420.00	$380.00	3.9%	2026-02-28	Paid	Owner substitution saved $380.
21	M-206	Fire Alarm Devices	Rough-In	$4,200.00	-	$4,200.00	100.0%		Not Yet Billed	Scope TBD pending GC coordination.
22	Materials Subtotal			$43,100.00	$38,910.00	$4,190.00	9.7%
23
24	EQUIPMENT AND TOOLS
25	E-301	Scissor Lift Rental (4 weeks)	Various	$3,200.00	$3,200.00	-	-	2026-02-01	Paid
26	E-302	Cable Puller and Tugger	Rough-In	$800.00	$800.00	-	-	2026-01-31	Paid
27	E-303	Conduit Bender Rental	Rough-In	$400.00	$480.00	($80.00)	-20.0%	2026-02-12	Paid	Extended 2 extra days.
28	E-304	Small Tools Allowance	Various	$1,200.00	$1,050.00	$150.00	12.5%	2026-03-01	Paid
29	Equipment and Tools Subtotal			$5,600.00	$5,530.00	$70.00	1.3%
30
31	SUBCONTRACTED WORK
32	S-401	Low-Voltage Cabling Subcontractor	Various	$6,500.00	$6,500.00	-	-	2026-02-20	Paid
33	S-402	Fire Suppression Tie-In	Rough-In	$2,800.00	$2,800.00	-	-	2026-02-25	Paid
34	S-403	Commissioning and Testing	Commissioning	$3,500.00	-	$3,500.00	100.0%		Pending	Scheduled for project closeout week.
35	Subcontracted Work Subtotal			$12,800.00	$9,300.00	$3,500.00	27.3%
36
37	PERMITS, FEES, AND OVERHEAD
38	O-501	Electrical Permit	Pre-Construction	$1,200.00	$1,200.00	-	-	2026-01-10	Paid
39	O-502	Inspection Fees	Pre-Construction	$400.00	$400.00	-	-	2026-01-15	Paid
40	O-503	Insurance (project rider)	Pre-Construction	$1,800.00	$1,800.00	-	-	2026-01-10	Paid
41	O-504	General Overhead (5%)	Various	$3,000.00	$3,000.00	-	-	2026-01-10	Paid
42	Permits, Fees, and Overhead Subtotal			$6,400.00	$6,400.00	-	-
43
44	CHANGE ORDERS
45	CO-001	Add circuits to server room	Rough-In	$4,800.00	$4,800.00	-	-	2026-03-05	Paid	Approved CO per GC RFI-###.
46	CO-002	EV charger rough-in (3 stalls)	Rough-In	$2,200.00	-	$2,200.00	100.0%		Pending	Owner-approved; install scheduled week 12.
47	CO-003	Emergency generator transfer switch	Rough-In	$6,500.00	-	$6,500.00	100.0%		Disputed	Under negotiation -- await written approval.
48	Change Orders Subtotal			$13,500.00	$4,800.00	$8,700.00	64.4%
49
50	PROJECT TOTAL			$248,400.00	$232,840.00	$15,560.00	6.3%
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