Culvert Rate analysis (www.theengineeringcommunity.org).xlsx

	A	B	E	F	G	H	I	J	K	L	M	N	O	P	R	S
1	ANALYSIS OF RATE FOR CONSTRUCTION OF 3 SPAN 10' EACH CULVERT 52' ROADWAY)
2
3											BASED ON MRS 1ST QTR. 2011
4	1	Excavation all type of soil for structures.
5		Abutment	2	x	52	x	10,5	x	8	=	8736,00	Cft
6		Pier	2	x	57,125	x	7,75	x	8	=	7083,50	Cft
7		Wing Wall	4	x	(8+1)	x	7	x	8	=	2016,00	Cft		9
8			4	x	(10+3.5)	x	6,5	x	8	=	2808,00	Cft		13,5
9			4	x	(14+7.75)	x	6,25	x	8	=	4350,00	Cft		21,75
10			4	x	(16+10.25)	x	5,75	x	8	=	4830,00	Cft		26,25
11			4	x	(20+14.75)	x	5,25	x	8	=	5838,00	Cft		34,75
12			4	x	(25.5+20.5)	x	5	x	8	=	7360,00	Cft		46
13
14		Toe Wall D/S	2	x	5	x	2,875	x	6	=	172,50	Cft
15			1	x	4,875	x	2,875	x	6	=	84,09	Cft
16		Toe Wall U/S	2	x	5	x	2,875	x	4	=	115,00	Cft
17			1	x	4,875	x	2,875	x	4	=	56,06	Cft
18									Total	=	43449,15	Cft			8537	-34912,15
19					@	Rs.2 996,95		Per %o Cft.					Rs.130 215
20	2	P/L brick ballast 1-1/2" to 2" guage (1:6:12) complete in all respect
21		Abutment	2	x	52	x	10,5	x	4	=	4368,00	Cft
22		Pier	1	x	57,125	x	7,75	x	4	=	1770,88	Cft
23		Wing Wall	4	x	(8+1)	x	7	x	4	=	1008,00	Cft		9
24			4	x	2	x	6,5	x	4	=	208,00	Cft
25			4	x	4	x	6,25	x	4	=	400,00	Cft
26			4	x	2	x	5,75	x	4	=	184,00	Cft		26,25
27			4	x	4	x	5,25	x	4	=	336,00	Cft		34,75
28			4	x	5,5	x	5	x	4	=	440,00	Cft		46
29
30		Toe Wall D/S	2	x	5	x	2,875	x	0,5	=	14,38	Cft
31			1	x	4,875	x	2,875	x	0,5	=	7,01	Cft
32		Toe Wall U/S	2	x	5	x	2,875	x	0,5	=	14,38	Cft
33			1	x	4,875	x	2,875	x	0,5	=	7,01	Cft
34									Total	=	8757,66	Cft			3271	-5486,66
35					@	Rs.6 577,95		Per %Cft.					Rs.576 074
36	3	1st class brick work in foundation and plinth in 1:4 cement sand mortar complete in all respect
37		Abutment
38		1st Step	2	x	52	x	8,625	x	1	=	897,00	Cft
39		2nd Step	2	x	52	x	8,25	x	1	=	858,00	Cft
40		3rd Step	2	x	52	x	7,875	x	1	=	819,00	Cft
41		4th Step	2	x	52	x	7,5	x	1	=	780,00	Cft
42		5th Step	2	x	52	x	7,125	x	1,5	=	1111,50	Cft
43		6th Step	2	x	52	x	6,75	x	0,5	=	351,00	Cft
44		7th Step	2	x	52	x	6,375	x	0,5	=	331,50	Cft
45		8th Step	2	x	52	x	6	x	0,5	=	312,00	Cft
46		9th Step	2	x	52	x	5,625	x	0,5	=	292,50	Cft
47		10Th Step	2	x	52	x	5,25	x	0,5	=	273,00	Cft
48		11th Step	2	x	52	x	4,875	x	0,5	=	253,50	Cft
49		12th Step	2	x	52	x	4,5	x	0,5	=	234,00	Cft
50		13th Step	2	x	52	x	4,125	x	0,5	=	214,50	Cft
51		14th Step	2	x	52	x	3,75	x	0,5	=	195,00	Cft
52		15th Step	2	x	52	x	3,375	x	0,5	=	175,50	Cft
53		16th Step	2	x	52	x	3	x	0,5	=	156,00	Cft
54		17th Step	2	x	52	x	2,625	x	0,5	=	136,50	Cft
55		18th Step	2	x	52	x	2,25	x	0,5	=	117,00	Cft
56		Pier
57		1st Step	2	x	56,125	x	6,75	x	0,25	=	189,42	Cft
58		2nd Step	2	x	55,75	x	6,375	x	0,25	=	177,70	Cft
59		3rd Step	2	x	55,375	x	6	x	0,25	=	166,13	Cft
60		4th Step	2	x	55	x	5,625	x	0,25	=	154,69	Cft
61		5th Step	2	x	54,625	x	5,25	x	0,25	=	143,39	Cft
62		6th Step	2	x	54,25	x	4,875	x	0,25	=	132,23	Cft
63		7th Step	2	x	53,875	x	4,5	x	0,25	=	121,22	Cft
64		8th Step	2	x	53,5	x	4,125	x	0,25	=	110,34	Cft
65		9th Step	2	x	53,125	x	3,75	x	0,25	=	99,61	Cft
66		10Th Step	2	x	52,75	x	3,375	x	0,25	=	89,02	Cft
67		11th Step	2	x	52,375	x	3	x	0,25	=	78,56	Cft
68		12th Step	2	x	52	x	2,625	x	9,25	=	2525,25	Cft
69		Wing Wall
70		Section at 6-6
71		1st Step	4	x	(8+2.5)/2	x	5,25	x	3	=	330,75	Cft		5,25
72		2nd Step	4	x	(8+3.5)/2	x	4,5	x	0,75	=	77,63	Cft		5,75
73		3rd Step	4	x	(8+4.25)/2	x	3,75	x	0,75	=	68,91	Cft		6,125
74		4th Step	4	x	(8+5)/2	x	3	x	0,75	=	58,50	Cft		6,5
75		5th Step	4	x	(8+5.375)/2	x	2,625	x	0,75	=	52,66	Cft		6,6875
76		6th Step	4	x	(8+5.75)/2	x	2,25	x	2,33	=	144,17	Cft		6,875
77		7th Step	4	x	(6+3.75)/2	x	2,25	x	0,75	=	32,91	Cft		4,875
78		8th Step	4	x	(4+1.75)/2	x	2,25	x	1,25	=	32,34	Cft		2,875
79		Section at 5-5
80		1st Step	4	x	2	x	4,5	x	3	=	108,00	Cft
81		2nd Step	4	x	2	x	3,75	x	0,75	=	22,50	Cft
82		3rd Step	4	x	2	x	3	x	0,75	=	18,00	Cft
83		4th Step	4	x	2	x	2,625	x	0,75	=	15,75	Cft
84		5th Step	4	x	2	x	2,25	x	2,33	=	41,94	Cft
85		Section at 4-4
86		1st Step	4	x	4	x	4,125	x	3	=	198,00	Cft
87		2nd Step	4	x	4	x	3,375	x	0,75	=	40,50	Cft
88		3rd Step	4	x	4	x	2,625	x	0,75	=	31,50	Cft
89		4th Step	4	x	4	x	2,25	x	1,58	=	56,88	Cft
90		5th Step	4	x	2	x	2,25	x	0,75	=	13,50	Cft
91		Section at 3-3
92		1st Step	4	x	2	x	3,375	x	3	=	81,00	Cft
93		2nd Step	4	x	2	x	2,625	x	0,75	=	15,75	Cft
94		3rd Step	4	x	2	x	2,25	x	1,58	=	28,44	Cft
95		Section at 2-2
96		1st Step	4	x	4	x	3	x	3	=	144,00	Cft
97		2nd Step	4	x	4	x	2,25	x	1,58	=	56,88	Cft		0,83
98		3rd Step	4	x	2	x	2,25	x	0,75	=	13,50	Cft
99		Section at 1-1
100		1st Step	4	x	5,5	x	2,625	x	3	=	173,25	Cft