structure BOQ for mam.xlsx

	A	B	C	D	E	F	G	H	I
1
2
3
4		Total Civil Phase 1			rate	amount
5		Cement OPC	1325.418439	bags	850	1126605.673
6		Cement PPC	1038.040923	bags	760	788911.1016
7		Sand (Khasro)	4729.941159	cu.ft	56.66666667	268029.999
8		Sand (double washed)	983.8306642	cu.ft	63.33333333	62309.2754
9		Aggregate	6880.232734	cu.ft	76.66666667	527484.5096
10		Brick	89937.06399	No.	15	1349055.96
11		Rebar	32005.76642	kgs	118	3776680.438
12
13			Total civil cost			7899076.957
14			plumbing materials		0.03	236972.3087
15			electric wires		0.03	236972.3087
16			labour cost		0.25	1974769.239
17			company overhead		0.07	552935.387
18			contengency		0.05	394953.8478
19
20
21			Grand Total			11295680.05
22
23
24
25
26	SN	Description	No.	Length	Breadth	Height	Quantity	Unit	Remarks
27	1	Site Clearance	0				0.00	ft^2	Lumpsum
28
29	2	Earthwork
30	2.1	Excavation
31	2.1.1	Footing (F1)	6	8	8	6	2,304.00	ft^3	6" extra on both sides
32	2.1.2	Footing (F2)	3	7	7	7	1,029.00	ft^3
33	2.1.3	Footing (F3)	3	6	6	7	756.00	ft^3
34		FOR TIE BEAM WALL ALL ROUND	3	38	2	5	1,140.00	ft^3
35			4	27	2	5	1,080.00	ft^3
36							6,309.00	ft^3
37
38
39
40
41							6,309.00
42	3	1 Layer brick soling of second class
43		Below Footing
44	3.1.1	Footing (F1)	6	8	8		384.00
45		Footing(F2)	3	7	7		147.00
46		Footing(F3)	3	6	6		108.00
47		Footing(F4)	0	0	0		0.00
48	3.1.2	For tie beam wall all round	3	38	2		228.00
49			4	27	2		216.00
50							1,083.00
51
52
53
54
55
56	3.1.4	Ground floor brick soling befor PCC
57		all round	38	27			1,026.00
58
59							2,109.00	ft^2
60	3.2	Sand Filling above Brick Soling of atleast half inch
61	3.2.1	Footing (F1)	6	8	8		384.00	ft^2
62		Footing(F2)	3	7	7		147.00	ft^2
63		Footing(F3)	3	6	6		108.00	ft^2
64		Footing(F4)	0	0	0		0.00	ft^2
65								ft^2
66	3.2.2	For tie beam wall all round	3	38	2		228.00
67			4	27	2		216.00
68							1,083.00	ft^2
69
70
71
72
73
74	3.2.3	Ground floor Sand Filling above brick befor PCC
75		all round	38	27			1,026.00
76							1,026.00
77							2,109.00	ft^2
78	4	75mm ThickP.C.C (1:2:4)
79	4.1	Footing (F1)	6	8	8	0.33	126.72
80	4.2	Footing(F2)	3	7	7	0.33	48.51	ft^3
81		Footing(F3)	3	6	6	0.33	35.64	ft^3
82		Footing(F4)	0	0	0	0.33	0.00
83
84	4.3	For tie beam wall all round	3	40	2	0.33	79.20
85			4	27	2	0.33	71.28
86							361.35
87
88
89
90
91
92	4.5	Ground floor PCC
93		all round	38	27		0.33	338.58
94							338.58
95							699.93	ft^3
96								ft^3
97	5	Concrete for RCC work of minimum strenght M20 1:1.5:3
98	5.1	Footing
99	5.1.1	Footing (F1)	6	8	8	1.75	672.00
100		Footing (F2)	3	7	7	1.75	257.25	ft^3