Scribd
Upload
2K views14 pages

MS PIPE Reconciliation - Format

This document contains a reconciliation statement for the Chitradurga Drip Irrigation Project - Package III MS Pipeline from inception until June 25th 2022. It shows the total receipts, issues, DPR quantity, paid quantity, quantity laid, and variances for 15 different pipe sizes. The total receipt quantity is 76576.27 Rmt, the total issues quantity is 25726.16 Rmt, and the physical stock available is 51084 Rmt, leaving a quantity variance of 25492.27 Rmt. It also includes a daily log of pipeline laying for 1314 mm diameter pipes with details of pipe number, length, scheme, branch and dates from June 1st to 25th 2022 total

Uploaded by

Nagothu Nikhil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2K views14 pages

MS PIPE Reconciliation - Format

This document contains a reconciliation statement for the Chitradurga Drip Irrigation Project - Package III MS Pipeline from inception until June 25th 2022. It shows the total receipts, issues, DPR quantity, paid quantity, quantity laid, and variances for 15 different pipe sizes. The total receipt quantity is 76576.27 Rmt, the total issues quantity is 25726.16 Rmt, and the physical stock available is 51084 Rmt, leaving a quantity variance of 25492.27 Rmt. It also includes a daily log of pipeline laying for 1314 mm diameter pipes with details of pipe number, length, scheme, branch and dates from June 1st to 25th 2022 total

Uploaded by

Nagothu Nikhil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

NCC LIMITED

Name of the Project : CHITRADURGA DRIP IRRIGATION PROJECT - PACKAGE III


RECONCILIATION STATEMENT
MS PIPELINE
Duration : Upto 25th June 2022

Client Physical Stock to Actual Physical Quantity Variance


Certified Cummula be Available Stock Available

Thcikness
Latest
Sl. Dia / Size UoM Revised Total Reciepts Total Issues DPR Qty tive S/C Work in Remarks
No BOQ as on Date as on Date Paid Qty Progress [Link]
DPR vs DPR vs S/C Client vs Theoritical vs
Qty Laid as on Date Total Total Client S/C
Actual
1 2 3 4 5 6 7 8 9 10 11= (a+b+c) 12=(d+e+f) 13=(8-9) 14=(8-10) 15=(9-10) 16=(11-12)

1 910 900 5 Rmt 11454.13 3358.31 11454.13 8100.00 0.00 0.00 0.00 3354.13
2 1010 1000 5 Rmt 5112.57 1458.60 5112.57 3648.00 0.00 0.00 0.00 1464.57
3 1112 1100 6 Rmt 10910.24 4323.20 10910.24 6588.00 0.00 0.00 0.00 4322.24
4 1212 1200 6 Rmt 3414.57 1978.22 3414.57 1440.00 0.00 0.00 0.00 1974.57
5 1314 1300 7 Rmt 7561.36 5953.45 7561.36 1836.00 0.00 0.00 0.00 5725.36
6 1414 1400 7 Rmt 4508.39 2591.15 4508.39 1920.00 0.00 0.00 0.00 2588.39
7 1516 1500 8 Rmt 3616.57 2267.20 3616.57 1344.00 0.00 0.00 0.00 2272.57
8 1616 1600 8 Rmt 1080.07 177.26 1080.07 900.00 0.00 0.00 0.00 180.07
9 1718 1700 9 Rmt 2354.40 0.00 2354.40 2352.00 0.00 0.00 0.00 2.40
10 1818 1800 9 Rmt 2942.30 222.07 2942.30 2724.00 0.00 0.00 0.00 218.30
11 2020 2000 10 Rmt 8354.43 1348.86 8354.43 7008.00 0.00 0.00 0.00 1346.43
12 2222 2200 11 Rmt 7180.69 931.56 7180.69 6252.00 0.00 0.00 0.00 928.69
13 2324 2300 12 Rmt 4775.96 1116.28 4775.96 3660.00 0.00 0.00 0.00 1115.96
14 2428 2400 14 Rmt 1506.45 0.00 1506.45 1512.00 0.00 0.00 0.00 -5.55
15 2430 2400 15 Rmt 1804.14 0.00 1804.14 1800.00 0.00 0.00 0.00 4.14

Total Rmt 0 76576.27 25726.16 0 0 0 0 76576.27 51084 0 0 0 25492.27


NCC LIMITE
NAME OF PROJECT :
SR No. DATE PIPE DIA SCHEME BRANCH NO PIPE No. LENGTH MTR
NAME
1 1/Jun/21 1314 PS-4 BR-2 19A000642 11.950
2 1/Jun/21 1314 PS-4 BR-2 19B008580 11.760
3 1/Jun/21 1314 PS-4 BR-2 19A000579 11.970
4 2/Jun/21 1314 PS-4 BR-2 19A000645 11.980
5 2/Jun/21 1314 PS-4 BR-2 19B008675 11.800
6 2/Jun/21 1314 PS-4 BR-2 19B008629 11.800
7 3/Jun/21 1314 PS-4 BR-2 19A000805 11.990
8 4/Jun/21 1314 PS-4 BR-2 19A000594 11.980
9 4/Jun/21 1314 PS-4 BR-2 19A000851 11.980
10 4/Jun/21 1314 PS-4 BR-2 19A000654 11.980
11 5/Jun/21 1314 PS-4 BR-2 19A000629 11.980
12 5/Jun/21 1314 PS-4 BR-2 19A000879 12.000
13 5/Jun/21 1314 PS-4 BR-2 19A000783 11.960
14 6/Jun/21 1314 PS-4 BR-2 19A000912 11.700
15 7/Jun/21 1314 PS-4 BR-2 19A000799 11.970
16 7/Jun/21 1314 PS-4 BR-2 19A000896 12.000
17 7/Jun/21 1314 PS-4 BR-2 19A000914 11.700
18 9/Jun/21 1314 PS-4 BR-2 19A000907 11.700
19 9/Jun/21 1314 PS-4 BR-2 19A000835 11.980
20 10/Jun/21 1314 PS-4 BR-2 19A000743 11.950
21 11/Jun/21 1314 PS-4 BR-2 19A000628 11.970
22 11/Jun/21 1314 PS-4 BR-2 19A000901 11.750
23 11/Jun/21 1314 PS-4 BR-2 19A000729 12.000
24 12/Jun/21 1314 PS-4 BR-2 19A000840 12.000
25 13/Jun/21 1314 PS-4 BR-2 19A000784 11.940
26 14/Jun/21 1314 PS-4 BR-2 19A000675 11.990
27 15/Jun/21 1314 PS-4 BR-2 19A000746 11.960
28 15/Jun/21 1314 PS-4 BR-2 19A000798 11.970
29 16/Jun/21 1314 PS-4 BR-2 19A000649 11.980
30 16/Jun/21 1314 PS-4 BR-2 19A000724 11.970
31 17/Jun/21 1314 PS-4 BR-2 19A000591 11.970
32 17/Jun/21 1314 PS-4 BR-2 19A000657 11.990
33 17/Jun/21 1314 PS-4 BR-2 19A000756 11.960
34 18/Jun/21 1314 PS-4 BR-2 19A000876 11.990
35 18/Jun/21 1314 PS-4 BR-2 19B008586 11.800
36 19/Jun/21 1314 PS-4 BR-2 19A000811 11.960
37 19/Jun/21 1314 PS-4 BR-2 19A000846 7.500
38 23/Jun/21 1314 PS-4 BR-2 19A000909 4.690
39 23/Jun/21 1314 PS-4 BR-2 19A000846 4.490
40 23/Jun/21 1314 PS-4 BR-2 19A000909 7.000
41 25/Jun/21 1314 PS-4 BR-2 19A004646 11.880
42 25/Jun/21 1314 PS-4 BR-2 19A000577 12.000
43 25/Jun/21 1314 PS-4 BR-2 19A000733 12.000
44 25/Jun/21 1314 PS-4 BR-2 19A000892 11.990
45 25/Jun/21 1314 PS-4 BR-2 19A004611 11.900
46
47
48
49
50
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

512.780
NCC LIMITED
NAME OF PROJECT :- CBC P3
CUMULATIVE CHAINAG NO.
JOINT NO LOCATION NAME OF THE AGENCY
LENGTH MTR FROM TO
11.950 1382.000 1393.950 K-01/J-33 Nagjhiri MA PATEL
23.710 1393.950 1405.710 K-01/J-34 Nagjhiri MA PATEL
35.680 1405.710 1417.680 K-01/J-35 Nagjhiri MA PATEL
47.660 1417.680 1429.660 K-01/J-36 Nagjhiri MA PATEL
59.460 1429.660 1441.460 K-01/J-37 Nagjhiri MA PATEL
71.260 1441.460 1453.260 K-01/J-38 Nagjhiri MA PATEL
83.250 1453.260 1465.250 K-01/J-39 Nagjhiri MA PATEL
95.230 1465.250 1477.230 K-01/J-40 Nagjhiri MA PATEL
107.210 1477.230 1489.210 K-01/J-41 Nagjhiri MA PATEL
119.190 1489.210 1501.190 K-01/J-42 Nagjhiri MA PATEL
131.170 1501.190 1513.170 K-01/J-43 Nagjhiri MA PATEL
143.170 1513.170 1525.170 K-01/J-44 Nagjhiri MA PATEL
155.130 1525.170 1537.130 K-01/J-45 Nagjhiri MA PATEL
166.830 1537.130 1548.830 K-01/J-46 Nagjhiri MA PATEL
178.800 1548.830 1560.800 K-01/J-47 Nagjhiri MA PATEL
190.800 1560.800 1572.800 K-01/J-48 Nagjhiri MA PATEL
202.500 1572.800 1584.500 K-01/J-49 Nagjhiri MA PATEL
214.200 1584.500 1596.200 K-01/J-50 Nagjhiri MA PATEL
226.180 1596.200 1608.180 K-01/J-51 Nagjhiri MA PATEL
238.130 1608.180 1620.130 K-01/J-52 Nagjhiri MA PATEL
250.100 1620.130 1632.100 K-01/J-53 Nagjhiri MA PATEL
261.850 1632.100 1643.850 K-01/J-54 Nagjhiri MA PATEL
273.850 1643.850 1655.850 K-01/J-55 Nagjhiri MA PATEL
285.850 1655.850 1667.850 K-01/J-56 Nagjhiri MA PATEL
297.790 MA PATEL
309.780 MA PATEL
321.740 MA PATEL
333.710 MA PATEL
345.690 MA PATEL
357.660 MA PATEL
369.630 MA PATEL
381.620 MA PATEL
393.580 MA PATEL
405.570 MA PATEL
417.370 MA PATEL
429.330 MA PATEL
436.830 MA PATEL
441.520 MA PATEL
446.010 MA PATEL
453.010 MA PATEL
464.890 MA PATEL
476.890 MA PATEL
488.890 MA PATEL
500.880 MA PATEL
512.780 MA PATEL
REMARKS
NCC LIMITED
Name of the Project : CHITRADURGA DRIP IRRIGATION PROJECT - PACKAGE III
RECONCILIATION STATEMENT
MS PIPELINE
Duration : Upto 25th JUNE 2022

PHYSICAL Actual Variance as on Date


Total ISSUED as Total RETURN Total NET Total DPR Qty Total PAID STOCK to be PHYSICAL
Sl. No Name of the Agency UoM Qty as on ISSUED Qty as Qty as on available as STOCK Remarks
on Date as on Date
Date on Date Date on Date available as Phy. Stock
(Theoritical) on Date DPR vs PAID Theoritical vs
Actual
1 2 3 4 5 6=(4-5) 7 8 9=(6-7) 10 11=(7-8) 12=(9-10) 13

1 ANWAR KHAN PATHAN Rmt 427.09 0.00 427.09 0.00 0.00 427.09 0.00 0.00 427.09
2 BHOLAY YADAV CONSTRUCTION Rmt 767.76 0.00 767.76 0.00 0.00 767.76 0.00 0.00 767.76
3 BIJI MAITHI Rmt 2467.51 0.00 2467.51 0.00 0.00 2467.51 0.00 0.00 2467.51
4 BLUE BIRD CONSTRUCTION Rmt 486.87 0.00 486.87 0.00 0.00 486.87 0.00 0.00 486.87
5 FARAZ ENTP Rmt 3688.46 0.00 3688.46 0.00 0.00 3688.46 0.00 0.00 3688.46
6 IQUBAL CONSTRUCTION Rmt 2218.51 0.00 2218.51 0.00 0.00 2218.51 0.00 0.00 2218.51
7 KV RAM STONE CRUSHER Rmt 1116.28 0.00 1116.28 0.00 0.00 1116.28 0.00 0.00 1116.28
8 MA PATEL Rmt 740.33 0.00 740.33 512.78 0.00 227.55 228.00 512.78 -0.45
9 MKCS Rmt 956.43 0.00 956.43 0.00 0.00 956.43 0.00 0.00 956.43
10 MOHAN PRATAP SINGH Rmt 918.08 0.00 918.08 0.00 0.00 918.08 0.00 0.00 918.08
11 NEELANJANA ASSOCIATE Rmt 1794.13 0.00 1794.13 0.00 0.00 1794.13 0.00 0.00 1794.13
12 RAJSHREE DRILLING & BLASTING Rmt 1581.95 0.00 1581.95 0.00 0.00 1581.95 0.00 0.00 1581.95
13 RAM SRI ENGINEERS & CONTRACTORS Rmt 565.56 0.00 565.56 0.00 0.00 565.56 0.00 0.00 565.56
14 ROYAL ASSOCIATE Rmt 2353.54 0.00 2353.54 0.00 0.00 2353.54 0.00 0.00 2353.54
15 SAI CONSTRUCTION Rmt 1667.16 0.00 1667.16 0.00 0.00 1667.16 0.00 0.00 1667.16
16 SHIV SHAKTI CONSTRUCTION Rmt 2387.97 0.00 2387.97 0.00 0.00 2387.97 0.00 0.00 2387.97
17 SPN EARTH MOVERS Rmt 1179.05 0.00 1179.05 0.00 0.00 1179.05 0.00 0.00 1179.05
18 SUFIYAN CONSTRUCTION Rmt 409.48 0.00 409.48 0.00 0.00 409.48 0.00 0.00 409.48
19 STORE Rmt 0.00 0.00 0.00 0.00 0.00 0.00 50856.00 0.00 -50856.00

Rmt 25726.16 0.00 25726.16 512.78 0.00 25213.38 51084.00 512.78 -25870.62
NCC LIMITED
CBC P3
UPTO DATE RECEIVED QUANTITY
MS PIPE
6/25/2022

RECV QTY IN ISSUE QTY IN PRESENT STOCK


[Link]. DESCRIPTION OF MATERIAL Dia MTR MTR QTY IN MTR REMARKS

1 MS PIPE(15mm thick X 2430mm Outer Dia) 2430 1804.14 0 1804.14


2 MS PIPE(14mm thick X 2428mm Outer Dia) 2428 1506.45 0 1506.45
3 MS PIPE(12mm thick X 2324mm Outer Dia) 2324 4775.96 1116.28 3659.68
4 MS PIPE(11mm thick X 2222mm Outer Dia) 2222 7180.69 931.56 6249.13
5 MS PIPE(10mm thick X 2020mm Outer Dia) 2020 8354.43 1348.86 7005.57
6 MS PIPE(09mm thick X 1818mm Outer Dia) 1818 2942.3 222.07 2720.23
7 MS PIPE(09mm thick X 1718mm Outer Dia) 1718 2354.4 0 2354.4
8 MS PIPE(08mm thick X 1516mm Outer Dia) 1516 3616.57 2267.2 1349.37
9 MS PIPE(08mm thick X 1616mm Outer Dia) 1616 1080.07 177.26 902.81
10 MS PIPE(07mm thick X 1414mm Outer Dia) 1414 4508.39 2591.15 1917.24
11 MS PIPE(07mm thick X 1314mm Outer Dia) 1314 7561.36 5953.45 1607.91
12 MS PIPE(06mm thick X 1112mm Outer Dia) 1112 10910.24 4323.2 6587.04
13 MS PIPE(06mm thick X 1212mm Outer Dia) 1212 3414.57 1978.22 1436.35
14 MS PIPE(05mm thick X 1010mm Outer Dia) 1010 5112.57 1458.6 3653.97
15 MS PIPE(05mm thick X 910mm Outer Dia) 910 11454.13 3358.31 8095.82

TOTAL 76576.27 25726.16 50850.11


GVPR ENGINERS LIMITED
BBMLIS-MP
CONTRACTOR WISE MS PIPE ISSUE DETAILS
[Link]. CONTRACTOR NAME 2430 2428 2324 2222 2020 1818 1718 1516 1616 1414 1314 1112
1 RAM SRI ENGINEERS & CONTRACTORS - - - - - - - 565.56 - - - -
2 NEELANJANA ASSOCIATE - - - - - - - - - - - 213.56
3 MOHAN PRATAP SINGH - - - - - - - - - - 579.58 -
4 BIJI MAITHI - - - - - - - - - - - -
5 IQUBAL CONSTRUCTION - - - - - - - - - - 773.71 -
6 ANWAR KHAN PATHAN - - - 35.21 391.88 - - - - - - -
7 FARAZ ENTP - - - - - - - - - - 2,618.21 106.50
8 MKCS - - - - - - - - - - - 956.43
9 SAI CONSTRUCTION - - - - - - - - - 627.08 1,040.08 -
10 RAJSHREE DRILLING & BLASTING - - - - - - - - - - - 1,581.95
11 SHIV SHAKTI CONSTRUCTION - - - - - - - 342.65 177.26 969.52 - 898.54
12 ROYAL ASSOCIATE - - - - - - - 1,358.99 - 994.55 - -
13 SUFIYAN CONSTRUCTION - - - 409.48 - - - - - - - -
14 BHOLAY YADAV CONSTRUCTION - - - - - - - - - - 201.54 566.22
15 BLUE BIRD CONSTRUCTION - - - 486.87 - - - - - - - -
16 KV RAM STONE CRUSHER - - 1,116.28 - - - - - - - - -
17 SPN EARTH MOVERS - - - - 956.98 222.07 - - - - - -
18 MA PATEL - - - - - - - - - - 740.33 -
TOTAL - - 1,116.28 931.56 1,348.86 222.07 - 2,267.20 177.26 2,591.15 5,953.45 4,323.20
GVPR ENGINERS LIMITED
BBMLIS-MP
CONTRACTOR WISE MS PIPE ISSUE DETAILS
1212 1010 910 [Link]
- - - 565.56
- 694.50 886.07 1,794.13
- - 338.50 918.08
- 764.10 1,703.41 2,467.51
1,014.47 - 430.33 2,218.51
- - - 427.09
963.75 - - 3,688.46
- - - 956.43
- - - 1,667.16
- - - 1,581.95
- - - 2,387.97
- - - 2,353.54
- - - 409.48
- - - 767.76
- - - 486.87
- - - 1,116.28
- - - 1,179.05
- - - 740.33
1,978.22 1,458.60 3,358.31 25,726.16
SL NO DATE MS PIPE DIA PIPE SL NO INDENT NO MIN GATE PASS NO LENGTH IN MTR CONTRACTOR NAME VEHICLE NO LOADING POINT UN LOADING POINT REMARKS
NCC LIMITED
Name of the Project : CHITRADURGA DRIP IRRIGATION PROJECT - PACKAGE III
ACTUAL AVAILABLE PHYSICAL STOCK STATEMENT
MS PIPELINE
Duration : Upto 25th June 2022

Name of the Length of


Site / Description Dia / Pressure Total Length Name of the Agency
Sl. No Date Scheme / Stock UOM Quantity Each Location Latitude Longitude Photo Remarks
Store of Materials Size Rating (RMT) (Working / Worked)
Yard (RMT)

1 6/26/2021 PS-4 Site MS PIPE 1314 No's 17 12 204.00 Sirali 21.956219 76.049626 MA PATEL

2 6/26/2021 PS-4 Site MS PIPE 1314 No's 2 12 24.00 Sirali 21.887032 75.957117 MA PATEL

Amankhedi,
3 6/26/2021 Stock Yard Store MS PIPE 2430 No's 150 12 1800.00 Goradiya, STORE
Shangivi

Amankhedi,
4 6/26/2021 Stock Yard Store MS PIPE 2428 No's 126 12 1512.00 Goradiya, STORE
Shangivi

Amankhedi,
5 6/26/2021 Stock Yard Store MS PIPE 2324 No's 305 12 3660.00 Goradiya, STORE
Shangivi

Amankhedi,
6 6/26/2021 Stock Yard Store MS PIPE 2222 No's 521 12 6252.00 Goradiya, STORE
Shangivi

Amankhedi,
7 6/26/2021 Stock Yard Store MS PIPE 2020 No's 584 12 7008.00 Goradiya, STORE
Shangivi

Amankhedi,
8 6/26/2021 Stock Yard Store MS PIPE 1818 No's 227 12 2724.00 Goradiya, STORE
Shangivi
Name of the Length of
Site / Description Dia / Pressure Total Length Name of the Agency
Sl. No Date Scheme / Stock UOM Quantity Each Location Latitude Longitude Photo Remarks
Store of Materials Size Rating (RMT) (Working / Worked)
Yard (RMT)
Amankhedi,
9 6/26/2021 Stock Yard Store MS PIPE 1718 No's 196 12 2352.00 Goradiya, STORE
Shangivi

Amankhedi,
10 6/26/2021 Stock Yard Store MS PIPE 1516 No's 112 12 1344.00 Goradiya, STORE
Shangivi

Amankhedi,
11 6/26/2021 Stock Yard Store MS PIPE 1616 No's 75 12 900.00 Goradiya, STORE
Shangivi

Amankhedi,
12 6/26/2021 Stock Yard Store MS PIPE 1414 No's 160 12 1920.00 Goradiya, STORE
Shangivi

Amankhedi,
13 6/26/2021 Stock Yard Store MS PIPE 1314 No's 134 12 1608.00 Goradiya, STORE
Shangivi

Amankhedi,
14 6/26/2021 Stock Yard Store MS PIPE 1112 No's 549 12 6588.00 Goradiya, STORE
Shangivi

Amankhedi,
15 6/26/2021 Stock Yard Store MS PIPE 1212 No's 120 12 1440.00 Goradiya, STORE
Shangivi

Amankhedi,
16 6/26/2021 Stock Yard Store MS PIPE 1010 No's 304 12 3648.00 Goradiya, STORE
Shangivi

Amankhedi,
17 6/26/2021 Stock Yard Store MS PIPE 910 No's 675 12 8100.00 Goradiya, STORE
Shangivi

4257 51,084.00

You might also like