Sample.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Estimate of Materials and Cost of Construction
3
4				Date:	6/6/2018						Summary	Amount
5				Project:	BUILDING CONSTRUCTION						Subtotal	$ 1,368,240
6				Project Location:							Profit/Overhead	$ 424,154
7											Total	$ 1,792,394
8
9	ITEM #	REF. SHEET	DETAIL	CSI SECT	DESCRIPTION	QTY.	WASTAGE	QTY WITH WASTAGE	UNIT	UNIT LABOR COST	UNIT MATERIAL COST	ITEM COST	TRADE COST
10
11				DIV-03	CONCRETE								$ 1,368,240
12
13					CONCRETE FOOTINGS
14	1	S2.1a, S2.1b	1/ S2.3		Reinf. Concrete footing	182	5%	191	CY	$ 570.0	$ 180.0	$ 143,098
15	2	S2.1a, S2.1b	1A/ S2.3		Reinf. Concrete footing	1	5%	1	CY	$ 570.0	$ 180.0	$ 552
16	3	S2.1a, S2.1b	2/ S2.3		Reinf. Concrete footing	11	5%	12	CY	$ 570.0	$ 180.0	$ 8,905
17	4	S2.1a, S2.1b	3/ S2.3		Reinf. Concrete footing	17	5%	18	CY	$ 570.0	$ 180.0	$ 13,169
18	5	S2.1a	4/ S2.3		Reinf. Concrete footing	30	5%	31	CY	$ 570.0	$ 180.0	$ 23,360
19	6	S2.1a	5/ S2.3		Reinf. Concrete footing	58	5%	61	CY	$ 570.0	$ 180.0	$ 45,790
20	7	S2.1b	7/ S2.3		Reinf. Concrete footing	6	5%	7	CY	$ 570.0	$ 180.0	$ 4,938
21	8	S2.1b	8/ S2.3		Reinf. Concrete footing Note: No section detail is provided. Assumed same as for 7/ S2.3	2	5%	2	CY	$ 570.0	$ 180.0	$ 1,535
22	9	S2.1b	9/ S2.3		Reinf. Concrete footing	32	5%	34	CY	$ 570.0	$ 180.0	$ 25,394
23	10	S2.1b	10/ S2.3		Reinf. Concrete footing	2	5%	2	CY	$ 570.0	$ 180.0	$ 1,645
24	11	S2.1b	11/ S2.3		Reinf. Concrete footing	11	5%	12	CY	$ 570.0	$ 180.0	$ 8,948
25	12	S2.1b	12/ S2.3		Reinf. Concrete footing	30	5%	32	CY	$ 570.0	$ 180.0	$ 23,766
26	13	S2.1b			Reinf. Concrete footing (at bottom left of S2.1b) Note: No specific detail is provided. Depth is considered as 3'H	33	5%	34	CY	$ 570.0	$ 180.0	$ 25,813
27
28	14	S2.1a S2.1b	Footing Schedule		(3'x3'x1') Reinforced concrete footing (F3.0) - 16 EA	5	5%	6	CY	$ 570.0	$ 180.0	$ 4,200
29	15				(3'6"x3'6"x1') Reinforced concrete footing (F3.5) - 12 EA	5	5%	6	CY	$ 570.0	$ 180.0	$ 4,288
30	16				(4'3"x4'3"x1'2") Reinforced concrete footing (F4.25) - 2 EA	2	5%	2	CY	$ 570.0	$ 180.0	$ 1,233
31	17				(4'6"x4'6"x1'2") Reinforced concrete footing (F4.5) - 2 EA	2	5%	2	CY	$ 570.0	$ 180.0	$ 1,382
32	18				(5'x5'x1'4") Reinforced concrete footing (F5.0) - 16 EA	20	5%	21	CY	$ 570.0	$ 180.0	$ 15,517
33	19				(6'x6'x1'6") Reinforced concrete footing (F6.0) - 18 EA	36	5%	38	CY	$ 570.0	$ 180.0	$ 28,350
34	20				(6'3"x6'3"x1'6") Reinforced concrete footing (F6.25) - 5 EA	11	5%	11	CY	$ 570.0	$ 180.0	$ 8,545
35	21				(6'6"x6'6"x1'6") Reinforced concrete footing (F6.5) - 3 EA	7	5%	7	CY	$ 570.0	$ 180.0	$ 5,545
36	22				(7'x7'x1'8") Reinforced concrete footing (F7.0) - 2 EA	6	5%	6	CY	$ 570.0	$ 180.0	$ 4,773
37	23				(7'x7'x1'8") Reinforced concrete footing (F7.0A) - 2 EA	6	5%	6	CY	$ 570.0	$ 180.0	$ 4,773
38
39					CONCRETE SLABS
40	24	S2.1b	11/ S2.3		(1'2" thk.) Reinf. concrete slab under elevator pit	15	5%	15	CY	$ 505.0	$ 165.0	$ 10,243
41	25	S2.1b	S2.3		(5" thk.) Basement reinf. concrete slab on grade	62	5%	65	CY	$ 440.0	$ 150.0	$ 38,523
42	26	S2.1a, S2.1b	S2.3		(5" thk.) First floor Reinf. concrete slab on grade	409	5%	430	CY	$ 440.0	$ 150.0	$ 253,433
43	27	S2.1b			(18" thk.) Reinf. Concrete slab on grade (at bottom left of S2.1b)	45	5%	47	CY	$ 440.0	$ 150.0	$ 27,588
44	28	S3.2a, S3.2b	S4.2, A8.22		(Approx. 3-1/2" thk.) Ecospan concrete slab on metal deck at second floor	327	5%	344	CY	$ 400.0	$ 130.0	$ 182,169
45	29	S3.3a, S3.3b	S4.2, A8.22		(Approx. 3-1/2" thk.) Ecospan concrete slab on metal deck at third floor	283	5%	297	CY	$ 400.0	$ 130.0	$ 157,227
46	30	S3.4a, S3.4b	S4.2, A8.22		(Approx. 3-1/2" thk.) Ecospan concrete slab on metal deck at roof	283	5%	297	CY	$ 400.0	$ 130.0	$ 157,227
47
48
49					CONCRETE WALLS
50	31	S2.1b	7/ S2.3		(1'2" thk.) Reinf. concrete walls Note: 12' H wall height is taken in basement	27	5%	28	CY	$ 570.0	$ 180.0	$ 21,035
51	32	S2.1b	9/ S2.3		(12" thk.) Reinf. Concrete walls Note: 12' H wall height is taken in basement	98	5%	103	CY	$ 570.0	$ 180.0	$ 77,000
52	33	S2.1b	10/ S2.3		(1'6" thk.) Reinf. Concrete walls Note: 12' H wall height is taken in basement	10	5%	10	CY	$ 570.0	$ 180.0	$ 7,823
53	34	S2.1b	11/ S2.3		(12" thk.) Reinf. Concrete walls Note: Elevator wall is taken as 5'H in basement	14	5%	15	CY	$ 570.0	$ 180.0	$ 11,185
54	35	S2.1b			(12" thk.) Reinf. Concrete foundation walls (at bottom left of S2.1b) Note: No specific detail is provided. Height is considered as 5'H	10	5%	11	CY	$ 570.0	$ 180.0	$ 7,948
55
56					CONCRETE PIERS
57	36	S2.1a, S2.1b	Pier Schedule		(18"x18") Reinf. concrete pier (P1) - 35 EA Note: (3'6"H) Pier is taken from elevations	10	5%	11	CY	$ 570.0	$ 180.0	$ 8,039
58	37	S2.1a, S2.1b	Pier Schedule		(16"x16") Reinf. CMU pier (P2) - 10 EA Note: (5'H) Pier is taken from elevations	4	5%	4	CY	$ 570.0	$ 180.0	$ 3,281
59
60				DIV-05	METALS								$ -
61
62					STEEL REINFORCEMENT
63
64		S2.1a S2.1b	1/ S2.3		Reinf. Concrete footing
65	38				#5 Continuous bars (8 EA)	8,160	5%	8,568	LF			$ -
66	39				#5 bar @ 12" O.C. (5 EA)	13,586	5%	14,266	LF			$ -
67
68		S2.1a S2.1b	1A/ S2.3		Reinf. Concrete footing
69	40				#5 Continuous bars (8 EA)	31	5%	33	LF			$ -
70	41				#5 bar @ 12" O.C. (5 EA @ each section)	130	5%	137	LF			$ -
71
72		S2.1a S2.1b	2/ S2.3		Reinf. Concrete footing
73	42				#5 Continuous bars (8 EA)	546	5%	574	LF			$ -
74	43				#5 bar @ 12" O.C. (5 EA @ each section)	3,934	5%	4,131	LF			$ -
75
76		S2.1a S2.1b	3/ S2.3		Reinf. Concrete footing
77	44				#5 Continuous bars (9 EA)	819	5%	860	LF			$ -
78	45				#5 bar @ 12" O.C. (6 EA @ each section)	1,638	5%	1,720	LF			$ -
79
80		S2.1a S2.1b	4/ S2.3		Reinf. Concrete footing
81	46				#5 Continuous bars (3 EA)	795	5%	835	LF			$ -
82	47				#4 bar @ 16" O.C. (6 EA @ each section)	1,177	5%	1,235	LF			$ -
83
84		S2.1a S2.1b	5/ S2.3		Reinf. Concrete footing
85	48				#5 Continuous bars (10 EA)	5,250	5%	5,513	LF			$ -
86	49				#4 bar @ 16" O.C.(1 EA @ each section)	3,780	5%	3,969	LF			$ -
87	50				#5 bar @ 12" O.C. (1 EA @ each section)	4,629	5%	4,860	LF			$ -
88
89		S2.1a S2.1b	7/ S2.3		Reinf. Concrete footing
90	51				#5 Continuous bars (3 EA)	154	5%	162	LF			$ -
91	52				#5 bar @ 12" O.C.(1 EA @ each section)	453	5%	475	LF			$ -
92
93		S2.1a S2.1b	8/ S2.3		Reinf. Concrete footing -
94	53				#5 Continuous bars (3 EA)	48	5%	50	LF			$ -
95	54				#5 bar @ 12" O.C.(1 EA @ each section)	141	5%	148	LF			$ -
96					Note: No specific detail is provided. Considered same as 7/ S2.3
97
98		S2.1a S2.1b	9/ S2.3		Reinf. Concrete footing
99	55				#5 Continuous bars (3 EA)	800	5%	840	LF			$ -
100	56				#5 bar @ 12" O.C.(1 EA @ each section)	2,396	5%	2,516	LF			$ -