Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
249x Filetype XLSX File size 0.33 MB Source: jjmup.org
VSAIPPL - SMC JV
Implementation of various rural water supply projects comprising of tube well/ Intake Well, WTP, rising / pressure mains, CWRs, Overhead Tanks,
Distribution pipe networks, individual house connections, public stand posts, Retrofitting etc. located in the State of Uttar Pradesh (NIYAMTABAD &
SAKALDIHA Group of Villages - CHANDAULI DISTRICT)
ABSTRACT OF BILLS & PAYMENTS
RA BILL NO. 03
DATE : 21st Dec'21
Agreement No:- 116 / ED / 2021-22 / II; DATED : 27-08-2021
Sr. Description Cumulative Upto Previous (Rs.) This Bill
No. (Rs.) (Rs.)
1 GROSS BILL VALUE 25 76 51 928.09 22 96 95 921.97 2 79 56 006.12 A
3 ADD GST @ 12.0%
aADDITION OF CGST @ 6.0% ON SL NO -1 1 54 59 115.32 1 37 81 755.32 16 77 360.00
bADDITION OF SGST @ 6.0% ON SL NO-1 1 54 59 115.32 1 37 81 755.32 16 77 360.00
TOTAL GST ( a+b) 3 09 18 230.64 2 75 63 510.64 33 54 720.00 B
TOTAL VALUE (INCL. GST) 28 85 70 158.73 25 72 59 432.61 3 13 10 726.12 C=A+B
4 DEDUCTIONS
aINCOME TAX DEDUCTION @ 2 % ON SL NO-1 (A) 51 53 038.00 45 93 918.00 5 59 120.00
bLABOUR CESS @ 1.0 % ON SL NO -1 (A) 25 76 519.00 22 96 959.00 2 79 560.00
cTDS on CGST @ 1.0 % ON SL NO-1 (A) 25 76 519.00 22 96 959.00 2 79 560.00
dTDS on SGST @ 1.0 % ON SL NO-1 (A) 25 76 519.00 22 96 959.00 2 79 560.00
TOTAL DEDUCTIONS ( a+b+c+d+e) 1 28 82 595.00 1 14 84 795.00 13 97 800.00 D
5 NET PAYABLE VALUE 27 56 87 563.73 24 57 74 637.61 2 99 12 926.12 C-D
Encl: Attached Abstract along with required documents / certificates
Implementation of various rural water supply projects comprising of tube well/ Intake Well, WTP, rising / pressure mains, CWRs, Overhead Tanks, Distribution pipe networks, individual house connections, public stand posts,
Name of Project Retrofitting etc. located in the State of Uttar Pradesh (NIYAMTABAD & SAKALDIHA Group of Villages - CHANDAULI DISTRICT)
Client State Water and Sanitation Mission (SWSM) , Government of Uttar Pradesh
VSAIPPL- SMC JV Date 21st Dec'21
Contractor
Agreement No. 116 / ED / 2021-22 / II
02 Bill Period 28th Oct'21 to 18th Dec'21
RA Bill No.
ACCOUNT OF WORK DONE OR SUPPLIES MADE
Sr. No. Item Description % Payment U0M Total Boq Qty Quantity Rate (Rs.) Part Rate Previous Bill Qty Previous Bill This Bill This Bill Amount Cumulative Cumulative Remarks
Schedule (Rs.) Amount Quantity Quantity Amount
1 2 3 4 5 6 7 8 9 10 11 12 13 14
1.00 SURVEY
1.01 All the works including Hydrological survey, topographical survey, Design charges LS 80 23558823.53 - 23558824
including preparation and 1%of ECV
approval of DPR
Drilling of Borehole for Tubewell construction by DC/RC/DTH Rig Machine including -
transportaion,
2.00 erection, dismantling of Rig and assosiated T&P complete in all respect including
required all material labour etc.
2.01 Transportation, Installation Dismantling of Rig machine and logging of bore hole Job 105 156378 0.00 - -
2.02 Tube well construction ‐ - -
2.03 DC/RC Drilling up to 100Mtr. ‐ - -
2.04 400 MMØ Mtr. 2,195.78 - -
2.05 450 MMØ Mtr. 3785 2,458.39 0.00 - -
2.06 500 MMØ Mtr. 4440 2,721.00 0.00 - -
2.07 600 MMØ Mtr. 3,246.22 - -
2.08 DC/RC Drilling from 101 Mtr. To 200 Mtr.Deep ‐ - -
2.09 450 MMØ Mtr. 1100 2,778.52 0.00 - -
2.10 500 MMØ Mtr. 3,038.00 -
2.11 600 MMØ Mtr. 3,556.96 -
2.12 DC/RC Drilling from 201 Mtr. To 300 Mtr.Deep ‐ -
2.13 450 MMØ Mtr. 3,163.42 -
2.14 500 MMØ Mtr. 3,368.00 -
2.15 600 MMØ Mtr. 3,777.16 -
2.16 DC/RC Drilling from 301 Mtr. To 400 Mtr.Deep & above ‐ -
2.17 450 MMØ Mtr. 3,708.29 -
2.18 500 MMØ Mtr. 3,912.87 -
2.19 600 MMØ Mtr. 4,322.04 -
2.20 DTH Drilling upto 200.0 Mtr.Deep -
2.21 200/165 MMØ (in over burden/Hard Rock) Mtr. 1,250 -
2.22 Development / Flushing of tubewell Hr. 2,900 -
3.00 Tubwell Assembly: -
3.01 MSERW plain pipe,As per IS 4270 -
3.02 100 MMØ Mtr. 928 -
3.03 150 MMØ 70% Mtr. 7193 7193 1,900 1,330 7,193 9,566,690 7193 9566690
3.04 200 MMØ 70% Mtr. 4440 4440 2,550 1,785 4,440 7,925,400 4440 7925400
3.05 300 MMØ 70% Mtr. 2160 2160 3,800 2,660 2,160 5,745,600 2160 5745600
3.06 MSERW Pipe slotted pipe as per IS 8110 ‐ - -
3.07 100 MMØ Mtr. 1,367 - -
3.08 150 MMØ 70% Mtr. 1683 1683 2,800 1,960 1,683 3,298,680 1683 3298680
3.09 200 MMØ 70% Mtr. 180 180 3,834 2,684 180 483,059 180 483059
3.10 300 MMØ Mtr. 5,189 -
3.11 MS fittings such as clamp, bail plug, reducer, well cap, girder & support structure LS 32,295 -
3.12 MS fittings such as ring & centre guide RM 471.68 -
Sr. No. Item Description % Payment U0M Total Boq Qty Quantity Rate (Rs.) Part Rate Previous Bill Qty Previous Bill This Bill This Bill Amount Cumulative Cumulative Remarks
Schedule (Rs.) Amount Quantity Quantity Amount
1 2 3 4 5 6 7 8 9 10 11 12 13 14
4.00 Lowering of above assembly with welding of parts complete in all respect with all ‐ -
required material, T&P,
labour, etc.
4.01 Lowering up to 100 Mtr. Deep ‐ -
4.02 100 MMØ MSERW Plane/Slotted Pipe Mtr. 177.82 -
4.03 150 MMØ MSERW Plane/Slotted Pipe Mtr. 386 -
4.04 200 MMØ MSERW Plane/Slotted Pipe Mtr. 390 -
4.05 300 MMØ MSERW Plain/Slotted Pipe Mtr. 490 -
4.06 Lowering from 101 Mtr. To 200 Mtr. Deep Mtr. ‐ -
4.07 150 MMØ MSERW Plane/Slotted Pipe Mtr. 443.00 -
4.08 200 MMØ MSERW Plane/Slotted Pipe Mtr. 590.80 -
4.09 300 MMØ MSERW Plane/Slotted Pipe Mtr. 882.41 -
4.10 Lowring from 201 Mtr. To 300 Mtr. Deep Mtr. ‐ -
4.11 150 MMØ MSERW Plane/Slotted Pipe Mtr. 570.35 -
4.12 200 MMØ MSERW Plane/Slotted Pipe Mtr. 679.64 -
4.13 300 MMØ MSERW Plane/Slotted Pipe Mtr. 898.22 -
4.14 Lowring from 301 Mtr. To 400 Mtr. Deep & above Mtr. ‐ -
4.15 150 MMØ MSERW Plane/Slotted Pipe Mtr. 426.53 -
4.16 200 MMØ MSERW Plane/Slotted Pipe Mtr. 499.00 -
4.17 300 MMØ MSERW Plane/Slotted Pipe Mtr. 643.94 -
5.00 Supplying and unconsolidated packing of gravel with suitable size Cum 7,500 - -
6.00 Development of Tube well -
6.01 Tranportation, Installation Dismantling of 150 PSI Compressor Job 92,152.00 -
6.02 Charges for Development by 150 PSI Compressor per hour Hr. 2,639.51 -
6.03 Tranportation, Installation Dismantling of 250/400/600 PSI Compressor Job 92,152.00 -
6.04 Charges for Development by 250 PSI Compressor per hour Hr. 3,140.00 -
6.05 Charges for Development by 400 PSI Compressor per hour Hr. 3,271.85 -
6.06 Charges for Development by 600 PSI Compressor per hour Hr. 4,213.85 -
6.07 Tranportation, Installation Dismantling of 0.5 Cusec OP Unit Job 34,942.72 -
and Yield test, water test
6.08 Charges for Development of TW by 0.5 Cusec OP Unit Hr. 814.44 -
6.09 Tranportation, Installation Dismantling of 1/3 Cusec OP Unit Job 1,05,237.00 -
and Yield test, water test
6.10 Charges for Development of TW by 1 cusec OP Unit Hr. 994.43 -
6.11 Charges for Development of TW by 3 cusec OP Unit Hr. 1,196.00 -
6.12 Tranportation, Installation Dismantling of 2 Cusec OP Unit Job 89,317.00 -
and Yield test, water test
6.13 Charges for Development of TW by 2 cusec OP Unit Hr. 1,119.00 -
7.00 SITC of Pumping plant including pumps with motors starter, pannel, cable, complete ‐ -
in all respect with all
required material T&P labour etc.
7.01 1 HP Nos. 32,518.98 -
7.02 2 HP Nos. 35,843.14 -
7.03 3 HP Nos. 46,249.21 -
7.04 5 HP Nos. 65,037.95 -
7.05 7.5HP Nos. 2,28,500.00 -
7.06 10 HP Nos. 2,30,200.00 -
7.07 12.5 HP Nos. 2,38,800.00 -
7.08 15 HP Nos. 2,52,100.00 -
7.09 17.5 HP Nos. 2,76,504.56 -
7.10 20 HP Nos. 2,95,500.00 -
7.11 25 HP Nos. 3,34,043.48 -
7.12 30 HP Nos. 3,66,163.04 -
7.13 35 HP Nos. 3,93,723.70 -
7.14 40 HP Nos. 4,26,547.83 -
Sr. No. Item Description % Payment U0M Total Boq Qty Quantity Rate (Rs.) Part Rate Previous Bill Qty Previous Bill This Bill This Bill Amount Cumulative Cumulative Remarks
Schedule (Rs.) Amount Quantity Quantity Amount
1 2 3 4 5 6 7 8 9 10 11 12 13 14
7.15 Variation in HP due to change of site locations increased/decreased in per HP of the Rate/HP 30,467.00 -
proposed pumping
plants.
8.00 Pressure Transmitter Nos. 43,120.00 -
9.00 Electrically operated Sluice Valve PN 1.0 dia 100 mm Nos. 1,25,000.00 -
9.01 Electrically operated Sluice Valve PN 1.0 dia 150 mm Nos. 1,25,000.00 -
9.02 Electrically operated Sluice Valve PN 1.0 dia 200 mm Nos. 1,50,000.00 -
9.03 Check Valve PN 1.0 DPCV dia 100 mm Nos. 27,519.80 -
9.04 Check Valve PN 1.0 DPCV dia 150 mm Nos. 51,145.45 -
9.05 Check Valve PN 1.0 DPCV dia 200 mm Nos. 73,485.90 -
9.06 Dismantling Joint PN 1.0 dia 100 mm Nos. 3,923.92 -
9.07 Dismantling Joint PN 1.0 dia 150 mm Nos. 5,605.60 -
9.08 Dismantling Joint PN 1.0 dia 200 mm Nos. 7,367.36 -
9.09 SITC of Chain Pulley Blocks -
9.10 1 Tonne Nos. 46,305.00 -
9.11 2 Tonne Nos. 58,432.50 -
10.00 Turbidity & Chlorine analyzer Nos. 2,73,000.00 -
11.00 Providing and installation hydrostatic level sensor at all tubewell pumping system Nos. 1,26,000.00 -
including all accessories
etc. complete in all respect as per instructions of Engineer ‐in –charge.
12.00 Stabalizer ‐ -
12.01 2 KVA Nos. 12,777.78 -
12.02 5 KVA Nos. 25,555.56 -
12.03 7.5 KVA Nos. 44,722.22 -
12.04 10 KVA Nos. 1,27,777.78 -
12.05 15 KVA Nos. 1,66,111.11 -
12.06 20 KVA Nos. 1,91,666.67 -
12.07 25 KVA Nos. 2,04,444.44 -
12.08 30 KVA Nos. 2,30,000.00 -
12.09 40 KVA Nos. 2,81,111.11 -
12.10 50 KVA Nos. 3,19,444.44 -
12.11 60 KVA Nos. 3,45,000.00 -
13.00 SITC of Column pipe of MS pipe for connecting submersible pumps ‐ -
13.01 32 mm Dia size ‐ MS pipe Mtr. 500.00 -
13.02 40 mm dia size ‐ MS pipe Mtr. 666.67 -
13.03 50 mm dia size ‐ MS pipe Mtr. 921.00 -
13.04 65 mm Dia size ‐ MS pipe Mtr. 1,066.67 -
13.05 80 mm Dia size ‐ MS pipe Mtr. 1,400.00 -
13.06 100 mm Dia size ‐ MS pipe Mtr. 1,567.00 -
13.07 150 mm Dia size ‐ MS pipe Mtr. 2,167.00 -
Supply , Installation of chlorinating system with dosing pump 0‐6 LPH capacity with -
14.00 100 Litres(1w+1s) tanks,valves ,pipes with required acessories (Automatic Dosing JOB 1,12,000.00
System for chemical injection)
15.00 Fluoride Removal Plant: Supplying, installation, testing, commissioning of Fluoride LS 80,62,500.00 -
removal plant for required capacity including transportation and labour charges as
complete. (vendor have to select the technology based on capacity (Electrolytic‐de
fluoridation plant or media based system).
Rates for400 KLD/ 500 LPM
16.00 Iron Removal Plant: Supplying, installation, testing, commissioning of Iron removal LS 60,62,500.00 -
plant which includes
vessel, media, piping valves etc. for required capacity including transportation and
labour charges as complete.
Rates for400 KLD/ 500 LPM
no reviews yet
Please Login to review.
