0% found this document useful (0 votes)
13 views27 pages

Excess Payment Statement to Contractor

Uploaded by

umrav
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
0% found this document useful (0 votes)
13 views27 pages

Excess Payment Statement to Contractor

Uploaded by

umrav
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

Statement showing excess payment to contractor under Price Variation

Name of work:-Construction of 12 units type-II, 8 unit type-III and 4 unit type-IV quarters for C&W staff at Hisar under ADEN/SSA.
Name of Agency- Dilbag Singh Contractor, Hisar

Tender opening Date Date of negotiation Original DOC Actual DOC Extension granted under Clause 17A Extension granted under Clause 17B

24.12.15 NA 17.02.17 16.08.17 18.02.17 to 17.06.17 18.06.17 to 16.08.17


Base month December-2015 indices (2004-05 Base) ▼ Base month January-2017 indices (2011-12 Base)▼ Percentage Component ▼

Labour Material Fuel Cement Labour Material Fuel Cement Labour Material Fuel
NA
277 182.90 188.00 175.30 112.60 93.10 105.90 30% 40% 15%
Quarter for Name of Formula for worked out Quarter wise Average index Amount of Updated Quarter Average index of Item wise amount of
Price component Price Variation payment of quarter PVC wise/item wise payment quarter for PVC Price Variation
Variation after Quarter Jan. 2017 after Jan.2017 payable/recoverable
=(4+6)
1 2 3 4 5 6 7 8 9
Labour
Ist Qtr 01/16 W x (LQ – LB) x LC 276.66 -600.70 NA NA
to 03/16 LB 100 1631323.18 -600.703842454829
Material
W x (MQ – MB) x MC 183.47 2033.58 NA NA
MB 100 2033.57946987422
Fuel
W x (FQ – FB) x FC 190.01 2616.19 NA NA
Cement FB 100 2616.1911636702
CV x (CQ – CB) / CB 343356.14 175.63 646.36 NA NA 646.363526525924
Steel SW x (SQ – SB) 0 0 0.00 0 0 0

Labour
Ist Qtr 01/17 W x (LQ – LB) x LC 4512026.38 274.333 -13032.75 NA NA
to 03/17 LB 100 -13032.7520095233
Material
W x (MQ – MB) x MC 185.467 25330.50 NA NA
MB 100 25330.5012957026
Fuel
W x (FQ – FB) x FC 202.900 53640.31 NA NA
Cement FB 100 53640.3136132979
CV x (CQ – CB) / CB 1043017.59 173.833 -8728.50 NA NA -8728.50430422141
Steel SW x (SQ – SB) 0 0 0.00 0 0 0

Labour
Ist Qtr 04/17 W x (LQ – LB) x LC 278.33 1802.70 NA NA
to 06/17 LB 100 1251496.92 1802.69772953066
Material
W x (MQ – MB) x MC 185.1 6021.42 1257518.34
MB 100 112.93 1474.17780258284
Ist Qtr 04/17
to 06/17

Fuel
W x (FQ – FB) x FC 201.2 13180.66 1264677.58
Cement FB 100 90.73 -4829.13941302526
CV x (CQ – CB) / CB 297848.24 174.2 -1868.98 295979.26 112.37 18074.5783033502
Steel SW x (SQ – SB) 0 0 0.00 0 0 0

Labour
Ist Qtr 07/17 W x (LQ – LB) x LC 285.000 30898.91 NA NA
to 09/17 LB 100 3566248.92 30898.9076101083
Material
W x (MQ – MB) x MC 185.100 17158.55 3583407.47
MB 100 114.533 24606.4889598607
Fuel
W x (FQ – FB) x FC 201.200 37559.43 3603808.35
FB 100 89.800 -19160.9573931995
Cement
CV x (CQ – CB) / CB 483805.23 174.200 -3035.86 480769.37
111.100 23607.1835597736
SW x (SQ – SB) 0 0.000 0.00 0 0
Steel 0

Labour
Ist Qtr 1017 W x (LQ – LB) x LC 287.000 17563.66 NA NA
to 12/17 LB 100 1621711.02 17563.6572563177
Material
W x (MQ – MB) x MC 185.100 7802.66 1629513.68
MB 100 115.900 19102.6469956306
Fuel
W x (FQ – FB) x FC 201.200 17079.72 1638790.74
FB 100 94.633 4047.68991648931
Cement
CV x (CQ – CB) / CB 166469.37 174.200 -1044.59 165424.78
110.133 6612.30501857502
SW x (SQ – SB) 0 0.000 0.00 0 0
Steel 0

185705.225258866

Total amount of PVC payable Rs.

Amount of PVC already paid Rs.


Overpayment of PVC to Contractor Rs.
Without Updatation
cost PVC

Without Updatation
cost PVC

For Updation cost


PVC
For Updation cost
PVC

For Updation cost


PVC

For Updation cost


PVC
Statement showing excess payment to contractor under Price Variation
Name of work:-Construction of 12 units type-II, 8 unit type-III and 4 unit type-IV quarters for C&W staff at Hisar under ADEN/SSA.
Name of Agency- Dilbag Singh Contractor, Hisar
Date of opening of tender Date of negotiation Original DOC Extension granted under Clause 17A Extension granted under
Clause 17B
21.06.16 Nil 18.05.17 up to 28.02.18 Nil
Actual DOC Base month (for Jue-2016) indices
28.02.18 Labour Material Fuel Cement
Base (2004-05) 277 182.90 188 175.3
Jan-2017 index(2004-05) - 201.20 174.20
185.10
Jan-2017 (2011-12 base)
277.00 112.60 93.10 105.90

Ist Quarter for PVC 07/2016 to 09/2016 Amount of PVC


0*(278.33-277)X30% = 0.00
Labour = 277
0*(183.57-182.90)X40% = 0.00
Material = 182.90
0*(185.2-188)X15% = 0.00
Fuel = 188
0*(177.77-175.30) = 0.00
Cement = 175.30
IInd Quarter for PVC 10/2017 to 12/2016
1631323.18*(276.66-277)X30% = -600.70
Labour = 277
1631323.18*(183.47-182.90)X40% = 2033.58
Material = 182.90
1631323.18*(190.01-188)X15% = 2616.19
Fuel = 188
343356.14*(175.63-175.30) = 646.36
Cement = 175.30
IIIrd Quarter for PVC 01/2017 to 03/2017
4512026.38*(274.33-277)X30% = -13047.41
Labour = 277
4512026.38*(185.50-182.90)X40% = 25656.14
Material = 182.90
4512026.38*(202.90-188)X15% = 53640.31
Fuel = 188
1043017.59*(173.80-175.30) = -8924.85
Cement = 175.30
IVth Quarter for PVC 04/2017 to 06/2017
1251496.92*(278.33-277)X30% = 1802.70 Updation of basic cost as per Jan.2017 indicies Revised Value of
Labour = work executed
277 with base year 2011-12
1257518.33*(112.93-112.6)X40% = 1474.18 1251496.92*(185.1-182.90)X40% = 6021.42 1257518.34
Material = 112.6 182.90
1264677.57*(90.73-93.1)X15% = -4829.14 1251496.92*(201.20-188)X15% = 13180.66 1264677.58
Fuel = 93.1 188
295979.25*(112.36-105.90) = 18055.01 297848.24*(174.2-175.30) = -1868.98 295979.26
Cement = 105.90 175.30
Vth Quarter for PVC 07/2017 to 09/2017
3566248.92*(285-277)X30% = 30898.91 Updation of basic cost as per Jan.2017 indicies Revised Value of
Labour = work executed
277 with base year 2011-12
3583406.77*(114.53-112.6)X40% = 24568.30 3566248.23*(185.1-182.90)X40% 17158.55 3583406.78
Material = 112.6 182.90
3603807.65*(89.8-93.1)X15% = -19160.96 3566248.23*(201.20-188)X15% 37559.42 3603807.65
Fuel = 93.1 188
295979.25*(111.1-105.90) = 23607.18 483805.23*(174.2-175.30) -3035.86 480769.37
Cement = 105.90 175.30
VIth Quarter for PVC 10/2017 to 12/2017
1621711.02*(287-277)X30% = 17563.66 Updation of basic cost as per Jan.2017 indicies Revised Value of
Labour = work executed
277 with base year 2011-12
1629513.67*(115.9-112.6)X40% = 19102.65 1621711.02*(185.1-182.90)X40% 7802.66 1629513.68
Material = 112.6 182.90
1638790.74*(94.63-93.1)X15% = 4039.77 1621711.02*(201.20-188)X15% 17079.72 1638790.74
Fuel = 93.1 188
165424.78*(110.13-105.90) = 6607.62 166469.37*(174.2-175.30) -1044.59 165424.78
Cement = 105.90 175.30
VIIth Quarter for PVC 01/2018 to 03/2018
9370468.16*(287.5-277)X30% = 106559.48 Updation of basic cost as per Jan.2017 indicies Revised Value of
Labour = work executed
277 with base year 2011-12
415552.97*(116.05-112.6)X40% = 5092.92 9370468.16*(185.1-182.90)X40% 45084.81 9415552.97
Material = 112.6 182.90
9469157.13*(98.15-93.1)X15% = 77044.97 9370468.16*(201.20-188)X15% 98688.97 9469157.13
Fuel = 93.1 188
407399.2*(112.2.1-105.90) = 24236.21 409971.76*(174.2-175.30) -2572.56 407399.20
Cement = 105.90 175.30
Total amount of PVC payable Rs. = 398683.07

Amount of PVC already paid Rs. = 661064.00

Overpayment of PVC to Contractor Rs. = 262380.93


SSA.

Quarter wise
payment

1631323.18

343356.14
4512026.38

1043017.59

1251496.92

297848.24

3566248.92

483805.23

1621711.02

166469.37
9370468.16

409971.76
Statement showing excess payment to contractor under Price Variation
Name of work:-Replacement of existing 44 no. units Type-I Type-II old dilapidated quarter with type-II quarters from mid section to nearest station
for Gangs under ADEN-I/HMH

Name of Agency- M/s Trimurti Construction, Bikaner


Date of opening of Date of negotiation Original DOC Extension granted under Clause Extension granted under Quarter wise
tender 17A Clause 17B payment
22.09.14 Not applicable 26.03.16 up to 31.05.17 Nil
Actual DOC Base month (for Sept.-2014) indices
30.05.17 Labour Material Fuel Cement
Base (2004-05) 253 185.00 213.40 172.7
Jan-2017 index(2004-05) - 185.10 201.20 174.20
Jan-2017 (2011-12 base)
274 112.60 93.1 105.9
Ist Quarter for PVC 10/2014 to 12/2014 Amount of PVC
0*(253-253)X30% = 0.00 0.00
Labour = 253
0*(181.20-185.00)X40% = 0.00
Material = 185.00
0*(201.83-213.40)X15% = 0.00
Fuel = 213.40
0*(171.13-172.70) = 0.00 0.00
Cement = 172.70
IInd Quarter for PVC 01/2015 to 03/2015
743657.16*(253.66-253)X30% = 2929.82
Labour = 253 3743657.16
743657.16*(176.33-185.00)X40% = -70178.39
Material = 185.00
743657.16*(186.1-213.40)X15% = -71838.22
Fuel = 213.40

628456.10*(174.47-172.70) = 6441.04
Cement = 172.70 628456.10
IIIrd Quarter for PVC 04/2015 to 06/2015
1328032.42*(258.33-253)X30% = 8393.37
Labour = 253 1328032.42
1328032.42(177.83-185.00)X40% = -20588.09
Material = 185.00
1328032.42*(190-213.40)X15% = -21843.46
Fuel = 213.40

258648.11*(173.73-172.70) = 1542.60
Cement = 172.70 258648.11
IVth Quarter for PVC 07/2015 to 09/2015
3183080.71*(264.33-253)X30% = 42764.00 3183080.71
Labour = 253
3183080.71*(176.87-185.00)X40% = -55953.40
Material = 185.00
3183080.71*(181.6-213.40)X15% = -71149.46
Fuel = 213.40

950830.37*(172.17-172.70) = -2918.01 950830.37


Cement = 172.70
Vth Quarter for PVC 10/2015 to 12/2015
0*(269.33-253)X30% = 0.00 0.00
Labour = 253
0*(177.07-185.00)X40% = 0.00
Material = 185.00
0*(177.1-213.40)X15% = 0.00
Fuel = 213.40

0*(174.13-172.70) = 0.00 0.00


Cement = 172.70
VIth Quarter for PVC 01/2016 to 03/2016
5198906.9*(268-253)X30% = 92470.68
Labour = 253 5198906.90
5198906.9*(174.93-185.00)X40% = -113195.66
Material = 185.00
5198906.9*(170.4-213.40)X15% = -157136.60
Fuel = 213.40

588928*(173.87-172.70) = 3989.84
Cement = 172.70 588928.00
VIIth Quarter for PVC 04/2016 to 06/2016
2355282.05*(274.33-253)X30% = 59570.95
Labour = 253 2355282.05
2355282.05*(180.30-185.00)X40% = -23934.76
Material = 185.00
2355282.05*(181.4-213.40)X15% = -52977.29
Fuel = 213.40

274471.85*(174.70-172.70) = 3178.60 274471.85


Cement = 172.70
VIIIth Quarter for PVC 07/2016 to 09/2016
3033892.14*(278.33-253)X30% = 91124.69 3033892.14
Labour = 253
3033892.14*(183.57-185.00)X40% = -9380.47
Material = 185.00
3033892.14*(185.2-213.40)X15% = -60137.60
Fuel = 213.40

219969.95*(177.77-172.70) = 6457.72 219969.95


Cement = 172.70
IXth Quarter for PVC 10/2016 to 12/2016
2260312.38*(276.66-253)X30% = 63413.82 2260312.38
Labour = 253
2260312.38*(183.47-185.00)X40% = -7477.36
Material = 185.00
2260312.38*(190.1-213.40)X15% = -37018.71
Fuel = 213.40

449939.09*(175.63-172.70) = 7633.59 449939.09


Cement = 172.70
Xth Quarter for PVC 01/2017 to 03/2017
4098464.18*(274.33-253)X30% = 103674.94
Labour = 253 4098464.18
4098464.18*(185.5-185.00)X40% = 4138.34
Material = 185.00
4098464.18*(202.90-213.40)X15% = -30248.74
Fuel = 213.40

642011.26*(173.80-172.70) = 4211.92
Cement = 172.70 642011.26
Xth Quarter for PVC 04/2017 to 06/2017 Updation of basic cost as per Jan.2017 indicies with Revised Value of
work executed
base year 2011-12
4514408.46*(278.33-253)X30% = 135592.85
Labour = 253 4514408.46
4515384.55*(112.93-112.6)X40% = 5293.35 4514408.46*(185.1-185)X40% = 976.09 4515384.55
Material = 112.6 185
4475695.4*(90.73-93.1)X15% = -17090.33 4514408.46*(201.20-213.40)X15% = -38713.06 4475695.40
93.1 213.40
Fuel =

722388.18*(112.367-105.90) = 44114.11 716167.85*(174.2-172.70) = 6220.33 722388.18


Cement = 105.90 172.70 716167.85

Total amount of PVC payable Rs. = -136130.31 -286563.482402464

Amount of PVC already paid Rs. = -127515.86 -127515.86

Overpayment of PVC to Contractor Rs. = 8614.45 159047.622402464


Statement showing excess payment to contractor under Price Variation

Name of work:-Replacement of existing 44 no. units Type-I Type-II old dilapidated quarter with type-II quarters from mid secti
ADEN-I/HMH
Name of Agency- M/s Trimurti Construction, Bikaner

Tender opening Date Date of negotiation Original DOC Actual DOC Extension granted under Clau

22.09.14 NA 26.03.16 30.05.17 27.03.16 to 31.05.17


Base month Sept.2016 indices (2004-05 Base) Base month January-2017 indices (2011-12 Base)
▼ ▼
Labour Material Fuel Cement Labour Material Fuel
NA
253 185.00 213.40 172.70 112.60 93.10
Quarter for Name of Formula for worked out Quarter wise Average index Amount of
Price component Price Variation payment of quarter PVC
Variation
under
considertion

1 2 3 4 5 6
Labour
IInd Qtr 1/15 W x (LQ – LB) x LC 253.667 2960.89
to 3/15 LB 100
Material
W x (MQ – MB) x MC 176.333 -70154.11
MB 100 3743657.2
Fuel
W x (FQ – FB) x FC 186.067 -71925.06
Cement FB 100
CV x (CQ – CB) / CB 628456.10 174.467 6430.12
Steel SW x (SQ – SB) 0 0 0.00

Labour
IIIrd Quarter W x (LQ – LB) x LC 258.333 8398.10
04/2015 to LB 100 1328032.4
Material
06/2015 W x (MQ – MB) x MC 177.833 -20579.48
MB 100
Fuel
W x (FQ – FB) x FC 189.967 -21874.26
Cement FB 100
CV x (CQ – CB) / CB 258648.11 173.733 1547.10
Steel SW x (SQ – SB) 0 0 0.00

Labour
IVth Quarter W x (LQ – LB) x LC 3183080.7 264.333 42775.32
07/2015 to LB 100
Material
09/2015 W x (MQ – MB) x MC 176.867 -55974.04
MB 100
Fuel
W x (FQ – FB) x FC 181.567 -71223.30
Cement FB 100
CV x (CQ – CB) / CB 950830.37 172.170 -2918.01
Steel SW x (SQ – SB) 0 0 0.00

Labour
VIth Quarter W x (LQ – LB) x LC ### 268.000 92470.68
01/2016 to LB 100
Material
03/2016 W x (MQ – MB) x MC 174.933 -113161.94
MB 100
VIth Quarter
01/2016 to
03/2016

Fuel
W x (FQ – FB) x FC 170.367 -157257.19
Cement FB 100
CV x (CQ – CB) / CB 588928.00 173.867 3979.61
Steel SW x (SQ – SB) 0 0 0.00

Labour
VIIth W x (LQ – LB) x LC ### 274.333 59579.33
04/2016 to LB 100
Material
06/2016 W x (MQ – MB) x MC 180.300 -23934.76
MB 100
Fuel
W x (FQ – FB) x FC 181.433 -52922.66
Cement FB 100
CV x (CQ – CB) / CB 274471.85 174.700 3178.60
Steel SW x (SQ – SB) 0 0 0.00

Labour
VIIIth W x (LQ – LB) x LC 3033892.1 278.330 91124.69
07/2016 to LB 100
Material
09/2016 W x (MQ – MB) x MC 183.567 -9400.15
MB 100
Fuel
W x (FQ – FB) x FC 185.200 -60137.60
Cement FB 100
CV x (CQ – CB) / CB 219969.95 177.767 6453.90

Steel SW x (SQ – SB) 0 0 0.00

Labour
IXth 10/2016 W x (LQ – LB) x LC 2260312.4 276.667 63432.58
to 12/2016 LB 100
Material
W x (MQ – MB) x MC 183.467 -7492.02
MB 100
Fuel
W x (FQ – FB) x FC 190.067 -37071.14
Cement FB 100
CV x (CQ – CB) / CB 449939.09 175.633 7641.41

Steel SW x (SQ – SB) 0 0 0.00

Labour
Xth 1/2017 to W x (LQ – LB) x LC 274.333 103674.94
3/2017 LB 100 4098464.2
Material
W x (MQ – MB) x MC 185.467 4138.34
MB 100
Fuel
W x (FQ – FB) x FC 202.900 -30248.74
Cement FB 100
CV x (CQ – CB) / CB 173.833 4211.92
642011.26
Steel SW x (SQ – SB) 0 0 0.00

Labour
Xth Quarter W x (LQ – LB) x LC
04/2017 to LB 100 4514408.5 278.333 135608.90
Material
06/2017 W x (MQ – MB) x MC
MB 100 185.100 976.09
Fuel
W x (FQ – FB) x FC
Cement FB 100 201.200 -38713.06
CV x (CQ – CB) / CB 716167.85 174.200 6220.33
Steel SW x (SQ – SB) 0 0 0.00
Total amount of PVC payable
Amount of PVC already paid R
Overpayment of PVC to Contr
or under Price Variation

pe-II quarters from mid section to nearest station for Gangs under

Extension granted under Clause 17A Extension granted under Clause 17B

27.03.16 to 31.05.17 NA
-2017 indices (2011-12 Base) Percentage Component
▼ ▼
Cement Labour Material Fuel

105.90 30% 40% 15%


Updated Quarter Average index of Item wise final
wise/item wise Quarterly quarter for PVC amount of Price
payment after Jan. 2017 after Jan.2017 Variation
=(4+6) payable/recoverable

7 8 9
NA NA
2960.89
NA NA
-70154.11
Without Updatation
NA NA cost PVC
-71925.06
NA NA 6430.12
0 0 0

NA NA
8398.09908600004
NA NA
-20579.4775224649
Without Updatation
NA NA cost PVC
-21874.2622056185
NA NA 1547.09610671687
0 0 0

NA NA
42775.3205767946
NA NA
-55974.0441393082
Without Updatation
NA NA cost PVC
-71223.2953899461
NA NA -2918.00866299943
0 0 0

NA NA
92470.6760869565
NA NA
-113161.936783351
Without Updatation
cost PVC
Without Updatation
NA NA cost PVC
-157257.188819845
NA NA 3979.61190503764
0 0 0

NA NA
59579.3264497827
NA NA
-23934.7581297297
Without Updatation
NA NA cost PVC
-52922.6578905928
NA NA 3178.59698899826
0 0 0

NA NA
91124.6892168379
NA NA
-9400.14580890806
NA NA Without Updatation
-60137.5995885661 cost PVC
NA NA
6453.89540619573
0 0 0

NA NA
63432.5847005454
NA NA
-7492.01919684318
NA NA Without Updatation
-37071.1354938191 cost PVC
NA NA
7641.40909652582
0 0 0

NA NA
103674.944290838
NA NA
4138.34112877849
NA NA Without Updatation
-30248.7398477038 cost PVC
NA NA
4211.92100509558
0 0 0

NA NA 135608.904565826

4515384.55 112.930 5293.34600690668


For Updation cost
4475695.40 90.730 -17090.329902299 PVC

722388.18 112.367 44114.1113259491


For Updation cost
PVC

0 0 0
ount of PVC payable Rs. -136350.880395539

f PVC already paid Rs.


ment of PVC to Contractor Rs.
Statement showing excess payment to contractor under Price Variation
Name of work:-Work of modification of existing rooms for office set up and dedveloppment of resting cum transit facility at Jaisalmer under Dy.
CE(C)-II/Jodhpur's unit (including electric work)
Name of Agency- M/s B.S Constructions, 2-A, LGF, Rishabh Corporate Tower, Karkardooma Community Centre, New Delhi-110092

Tender opening Date Date of negotiation Original DOC Actual DOC Extension granted under Extension granted under Clause Whether
Clause 17A 17B PVC is
alculated on
12.04.2016 25.06.2016 26.02.2017 05.05.2018 27.02.17 to 05.05.2018 NA updated cost
after January
Base month June-2016 indices (2004-05 Base) Base month January-2017 indices (2011-12 Base) Percentage Component
2017
▼ ▼ ▼
Labour Material Fuel Cement Labour Material Fuel Cement Labour Material Fuel
NA
277.00 182.90 188.00 175.30 112.60 93.10 105.90 30% 40% 15%

Quarter Name of Formula for Payment of Average index Amount of Updated item wise Average index Item wise final
considered component component wise work for of quarter PVC payment of Quarter of quarter for amount of Price
for Price calculation of Price quarter after Jan. 2017 PVC after Variation
Variation Variation consideration =(4+6) Jan.2017 payable/recoverabl
for Price e
Variation

1 2 3 4 5 6 7 8 9 10
Labour
Ist Qtr W x (LQ – LB) x LC 0.00 NA NA
07/2016 to LB 100 0.00
Material
09/2016 W x (MQ – MB) x MC 0.00 NA NA Updation of
MB 100 0.00 0.00
quarterly
Fuel
W x (FQ – FB) x FC 0.00 NA NA payment
Cement FB 100 0.00 was not
required
CV x (CQ – CB) / CB 0.00 0.00 NA NA 0.00
Steel SW x (SQ – SB) 0.00 0 0.00 0 0 0
Total 0.00
Labour
IInd Quarter W x (LQ – LB) x LC 258.333 -25049.85 NA NA
10/2016 to LB 100 -25049.8503721408
Material
12/2016 W x (MQ – MB) x MC 177.833 -13730.50 NA NA Updation of
MB 100 1239051 -13730.4987547513
quarterly
Fuel
W x (FQ – FB) x FC 189.967 1944.58 NA NA payment
Cement FB 100 1944.58482655054 was not
required
CV x (CQ – CB) / CB 264036.08 173.733 -2360.21 NA NA -2360.20842760982
Steel SW x (SQ – SB) 40066.23 0 0.00 0 0 0
Total ###
Labour
IIIrd Quarter W x (LQ – LB) x LC 1176693 264.333 -16142.78 NA NA
01/2017 to LB 100 -16142.78378087
Material
03/2017 W x (MQ – MB) x MC 176.867 -15525.40 NA NA Updation of
-15525.3995173975
Fuel
MB 100 quarterly
W x (FQ – FB) x FC 181.567 -6039.63 NA NA payment
Cement FB 100 -6039.62723403989 was not
required
CV x (CQ – CB) / CB 144843.25 172.170 -2586.19 NA NA -2586.19151454651
Steel SW x (SQ – SB) 82955.68 0 0.00 0 0 0
Total 1404492
Labour
IVth Quarter W x (LQ – LB) x LC ### 268.000 -14106.77 NA NA
04/2017 to LB 100 -14106.767101083
Material
06/2017 W x (MQ – MB) x MC 174.933 -25216.49 NA NA Updation of
-25216.4882149153
Fuel
MB 100 quarterly
W x (FQ – FB) x FC 170.367 -20361.19 NA NA payment
Cement FB 100 -20361.1882178697 was not
required
CV x (CQ – CB) / CB 197513.53 173.867 -1614.59 NA NA -1614.58578716488
Steel SW x (SQ – SB) 425578.03 0 0.00 0 0 0
Total 2070341
Labour
Vth Quarter W x (LQ – LB) x LC ### 274.333 -8834.32 NA NA
07/2017 to LB 100 -8834.32052749811
Material
09/2017 W x (MQ – MB) x MC 180.300 -17391.15 NA NA Updation of
-17391.1493537452
Fuel
MB 100 quarterly
W x (FQ – FB) x FC 181.433 -16025.41 NA NA payment
Cement FB 100 -16025.4073271729 was not
required
CV x (CQ – CB) / CB 512850.46 174.700 -1755.34 NA NA -1755.33528807765
Steel SW x (SQ – SB) 9623.69 0 0.00 0 0 0
Total 3580975
Labour
VIth Quarter W x (LQ – LB) x LC 227172.21 278.330 327.23 NA NA
10/2017 to LB 100 327.226396353787
Material
12/2017 W x (MQ – MB) x MC 183.567 331.38 NA NA
MB 100 331.380785281575 Updation of
Fuel quarterly
W x (FQ – FB) x FC 185.200 -507.51 NA NA payment
-507.512384042555
FB 100 was not
required
Updation of
quarterly
payment
Cement was not
CV x (CQ – CB) / CB 177.767 0.00 NA NA required
0.00 0

Steel SW x (SQ – SB) 56787.09 0 0.00 0 0 0


Total ###
Labour
VIIth W x (LQ – LB) x LC 1154689 276.667 -416.44 NA NA
Quarter LB 100 -416.438527288842
Material
01/2018 to W x (MQ – MB) x MC 183.467 1431.84 NA NA
03/2018 MB 100 1431.84012131221 Updation of
Fuel quarterly
W x (FQ – FB) x FC 190.067 1904.32 NA NA payment
1904.31623175799
Cement FB 100 was not
CV x (CQ – CB) / CB 175.633 237.62 NA NA required
125091.90 237.624658870507

Steel SW x (SQ – SB) 268468.38 0 0.00 0 0 0


Total ###
Labour
VIIIth W x (LQ – LB) x LC 274.333 -7547.54 NA NA
Quarter LB 100 -7547.5372014909
Material
04/2018 to W x (MQ – MB) x MC 185.467 14669.42 NA NA
06/2018 MB 100 2613008 14669.4190698962 Updation of
Fuel quarterly
W x (FQ – FB) x FC 202.900 31064.22 NA NA payment
31064.2189922872
Cement FB 100 was not
CV x (CQ – CB) / CB 173.833 -296.75 NA NA required
35460.26 -296.74958026241

Steel SW x (SQ – SB) 91892.27 0 0.00 0 0 0


Total ###
Labour
IXth Quarter W x (LQ – LB) x LC
07/2018 to LB 100 4514408 278.333 6517.37 NA NA 6517.37163593515
Material Price
09/2018 W x (MQ – MB) x MC Varation
185.100 21720.50 4536128.96 112.930 5317.66450014449
Fuel
MB 100 calculated
W x (FQ – FB) x FC after
Cement FB 100 201.200 47545.37 4561953.83 90.730 -17419.7055320605 updation of
quarterly
CV x (CQ – CB) / CB 716167.85 174.200 -4493.92 711673.93 112.367 43459.8233085648 payment
Steel SW x (SQ – SB) 0 0 0.00 0 0 0
Total amount of PVC payable Rs. -105722.274117073

Amount of PVC already paid Rs.


Overpayment of PVC to Contractor Rs.
Statement showing excess payment to contractor under Price Variation

Name of work:-Work of modification of existing rooms for office set up and dedveloppment of resting cum transit facility at Jaisalmer under
Dy. CE(C)-II/Jodhpur's unit (including electric work)
Name of Agency- M/s B.S Constructions, 2-A, LGF, Rishabh Corporate Tower, Karkardooma Community Centre, New Delhi-110092

Tender opening Date Date of negotiation Original DOC Actual DOC Extension granted under Extension granted under Whether
Clause 17A Clause 17B PVC is
alculated on
12.04.2016 25.06.2016 26.02.2017 05.05.2018 27.02.17 to 05.05.2018 NA updated
cost after
Base month June-2016 indices (2004-05 Base) Base month January-2017 indices (2011-12 Base) Percentage Component
January
▼ ▼ ▼
2017
Labour Material Fuel Cement Labour Material Fuel Cement Labour Material Fuel
NA
277.000 182.900 188.000 175.30 112.60 93.10 105.90 30% 40% 15%

Quarter Name of Formula for Payment of Average Amount of Updated item Average Item wise final
considered componen component wise work for index of PVC wise payment of index of amount of Price
for Price t calculation of Price quarter quarter Quarter after Jan. quarter for Variation
Variation Variation consideration 2017 =(4+6) PVC after payable/recovera
for Price Jan.2017 ble
Variation

1 2 3 4 5 6 7 8 9 10
Labour
Ist Qtr W x (LQ – LB) x LC 278.33 0.00 NA NA
07/2016 to Material LB 100 0.00
09/2016 W x (MQ – MB) x MC 183.567 0.00 NA NA Updation of
MB 0.00 0.00
Fuel quarterly
W x (FQ 100
– FB) x FC 185.200 0.00 NA NA payment
Cement FB 100 0.00 was not
required
CV x (CQ – CB) / CB 0.00 177.767 0.00 NA NA 0.00
Steel SW x (SQ – SB) 0.00 0.00 0.00 0 0 0.00
Total 0.00
Labour
IInd Quarter W x (LQ – LB) x LC 276.670 -442.84 NA NA
10/2016 to Material LB 100 -442.84
12/2016 W x (MQ – MB) x MC 183.467 1536.45 NA NA
MB 1239050.83 1536.45 Updation of
Fuel quarterly
W x (FQ 100
– FB) x FC 190.067 2043.45 NA NA payment
FB 100 2043.45 was not
Cement
CV x (CQ – CB) / CB 175.633 501.56 NA NA required
264036.08 501.56
Steel SW x (SQ – SB) 40066.23 0 0.00 0 0 0.00
Total 1543153.14
Labour
IIIrd Quarter W x (LQ – LB) x LC 1176693.01 274.330 -3402.64 NA NA
01/2017 to Material LB 100 -3402.64
03/2017 W x (MQ – MB) x MC 185.467 6605.95 NA NA Updation of
MB 6605.95
Fuel quarterly
W x (FQ 100
– FB) x FC 202.900 13988.88 NA NA payment
Cement FB 100 13988.88 was not
required
CV x (CQ – CB) / CB 144843.25 173.833 -1212.12 NA NA -1212.12
Steel SW x (SQ – SB) 82955.68 0 0.00 0 0 0.00
Total 1404491.94
Labour
IVth Quarter W x (LQ – LB) x LC 1447249.81 278.330 2084.67
04/2017 to Material LB 100 NA NA 2084.67
Price
06/2017 W x (MQ – MB) x MC 6963.26 Varation
MB 185.100 1454213.07 112.933 1720.26
Fuel calculated
W x (FQ 100
– FB) x FC 15242.31 after
Cement FB 100 201.200 1462492.12 90.730 -5584.49 updation of
quarterly
CV x (CQ – CB) / CB 197513.53 174.200 -1239.39 196274.14 112.367 11985.88 payment
Steel SW x (SQ – SB) 425578.03 0 0.00 0 0 0.00
Total 2070341.37
Labour
Vth Quarter W x (LQ – LB) x LC 3058501.17 285.000 26499.65
07/2017 to Material LB 100 NA NA 26499.65
Price
09/2017 W x (MQ – MB) x MC 14715.59 Varation
MB 185.100 3073216.76 114.533 21103.12
Fuel calculated
W x (FQ 100
– FB) x FC 32211.87 after
Cement FB 100 201.200 3090713.04 89.800 -16432.90 updation of
quarterly
CV x (CQ – CB) / CB 512850.46 174.200 -3218.11 509632.35 111.100 25024.44 payment
Steel SW x (SQ – SB) 9623.69 0 0.00 0 0 0.00
Total 3580975.32
Labour
VIth Quarter W x (LQ – LB) x LC 227172.21 287.000 2460.35
10/2017 to Material LB 100 NA NA 2460.35
12/2017 Price
W x (MQ – MB) x MC 1093.01
185.100 228265.22 115.900 2675.93 Varation
Fuel MB
calculated
W x (FQ 100
– FB) x FC 2392.56 after
FB 100 201.200 229564.77 94.630 565.90
updation of
quarterly
payment
Varation
calculated
after
Cement updation of
quarterly
CV x (CQ – CB) / CB 0.00 174.200 0.00 0.00 110.133 0.00 payment

Steel SW x (SQ – SB) 56787.09 0 0.00 0 0 0.00


Total 283959.30
Labour
VIIth W x (LQ – LB) x LC 1154689.41 287.330 12918.35
Quarter LB 100 NA NA 12918.35
Material Price
01/2018 to W x (MQ – MB) x MC 5555.64
03/2018 185.100 1160245.05 116.133 14561.80 Varation
Fuel MB
calculated
W x (FQ 100
– FB) x FC 12161.09 after
FB 100 201.200 1166850.50 98.100 9399.98
Cement updation of
CV x (CQ – CB) / CB 125091.90 -784.95 quarterly
174.200 124306.95 112.067 7238.91 payment

Steel SW x (SQ – SB) 268468.38 0 0.00 0 0 0.00


Total 1548249.69
Labour
VIIIth W x (LQ – LB) x LC 288.500 32544.69
Quarter LB 100 NA NA 32544.69
Material Price
04/2018 to W x (MQ – MB) x MC 12572.16
05/2018 2613008.13 185.100 2625580.29 117.800 48500.95 Varation
Fuel MB
calculated
W x (FQ 100
– FB) x FC 27519.98 after
FB 100 201.200 2640528.11 100.700 32333.00
Cement updation of
CV x (CQ – CB) / CB -222.51 quarterly
35460.26 174.200 35237.75 113.050 2379.13 payment

Steel SW x (SQ – SB) 91892.27 0 0.00 0 0 0.00


Total 2740360.66 251598.29

Total amount of PVC payable Rs. 251598.29

Amount of PVC already paid Rs.

Overpayment of PVC to Contractor Rs.


Statement showing excess payment to contractor under Price Variation
Name of work:-Work of modification of existing rooms for office set up and development of resting cum transit facility at Jaisalmer under Dy.
CE(C)-II/Jodhpur's unit (including electric work)

Name of Agency- M/s B.S Constructions, 2-A, LGF, Rishabh Corporate Tower, Karkardooma Community Centre, New Delhi-110092
Tender opening Date Date of negotiation Original DOC Actual DOC Extension granted under Extension granted under Whether
Clause 17A Clause 17B PVC is
calculated
12.04.2016 25.06.2016 26.02.2017 05.05.2018 27.02.17 to 05.05.2018 NA on updated
payment of
Base month June-2016 indices (2004-05 Base) Base month January-2017 indices (2011-12 Base) Percentage Component
work after
▼ ▼ ▼
January
Labour Material Fuel Cement Labour Material Fuel Cement Labour Material Fuel 2017
NA
277.000 182.900 188.000 175.30 112.60 93.10 105.90 30% 40% 15%

Quarter Name of Formula for Payment of Average Amount of Updated item Average Item wise final
considered componen component wise work for index of PVC wise payment of index of amount of
for Price t calculation of Price quarter quarter Quarter after Jan. quarter Price Variation
Variation Variation consideration 2017 =(4+6) for PVC payable/recove
for Price after rable
Variation Jan.2017

1 2 3 4 5 6 7 8 9 10
Labour
Ist Qtr W x (LQ – LB) x LC
07/2016 to Material LB 100 278.33 0.00 NA NA 0.00
09/2016 Updating of
W x (MQ – MB) x MC quarterly
MB 0.00 183.567 0.00 NA NA 0.00
Fuel payment
W x (FQ 100
– FB) x FC was not
Cement FB 100 185.200 0.00 NA NA 0.00 required
CV x (CQ – CB) / CB 0.00 177.767 0.00 NA NA 0.00
Total 0.00
Labour
IInd Quarter W x (LQ – LB) x LC
10/2016 to Material LB 100 276.670 -442.84 NA NA -442.84
12/2016 Updating of
W x (MQ – MB) x MC
1239050.83 183.467 1536.45 NA NA 1536.45 quarterly
Fuel MB
payment
W x (FQ 100
– FB) x FC was not
FB 100 190.067 2043.45 NA NA 2043.45
Cement required
CV x (CQ – CB) / CB 264036.08 175.633 501.56 NA NA 501.56
Total 1503086.91
Labour
IIIrd Quarter W x (LQ – LB) x LC
01/2017 to Material LB 100 274.330 -3402.64 NA NA -3402.64
03/2017 Updating of
W x (MQ – MB) x MC quarterly
MB 1176693.01 185.467 6605.95 NA NA 6605.95
Fuel payment
W x (FQ 100
– FB) x FC was not
Cement FB 100 202.900 13988.88 NA NA 13988.88 required
CV x (CQ – CB) / CB 144843.25 173.833 -1212.12 NA NA -1212.12
Total 1321536.26
Labour
IVth Quarter W x (LQ – LB) x LC
04/2017 to Material LB 100 278.330 2084.67 NA NA 2084.67 Price
06/2017 Variation
W x (MQ – MB) x MC
MB 1447249.81 185.100 6963.26 1454213.07 112.933 1720.26 calculated
Fuel after
W x (FQ 100
– FB) x FC updating of
Cement FB 100 201.200 15242.31 1462492.12 90.730 -5584.49 quarterly
CV x (CQ – CB) / CB payment
197513.53 174.200 -1239.39 196274.14 112.367 11985.88
Total 1644763.34
Labour
Vth Quarter W x (LQ – LB) x LC
07/2017 to Material LB 100 285.000 26499.65 NA NA 26499.65Price
09/2017 Variation
W x (MQ – MB) x MC
MB 3058501.17 185.100 14715.59 3073216.76 114.533 21103.12 calculated
Fuel after
W x (FQ 100
– FB) x FC updating of
Cement FB 100 201.200 32211.87 3090713.04 89.800 -16432.90 quarterly
CV x (CQ – CB) / CB payment
512850.46 174.200 -3218.11 509632.35 111.100 25024.44
Total 3571351.63
Labour
VIth Quarter W x (LQ – LB) x LC
10/2017 to Material LB 100 287.000 2460.35 NA NA 2460.35 Price
12/2017 W x (MQ – MB) x MC Variation
MB 227172.21 185.100 1093.01 228265.22 115.900 2675.93 calculated
Fuel after
W x (FQ 100
– FB) x FC
FB 100 201.200 2392.56 229564.77 94.630 565.90 updating of
Cement quarterly
payment
CV x (CQ – CB) / CB 0.00 174.200 0.00 0.00 110.133 0.00
Total 227172.21
Labour
VIIth W x (LQ – LB) x LC
Quarter LB 100 287.330 12918.35 NA NA 12918.35 Price
Material
01/2018 to W x (MQ – MB) x MC Variation
03/2018 MB 1154689.41 185.100 5555.64 1160245.05 116.133 14561.80 calculated
100 after
updating of
quarterly
payment
Quarter Price
01/2018 to Variation
03/2018 1154689.41 calculated
Fuel after
W x (FQ – FB) x FC
FB 100 201.200 12161.09 1166850.50 98.100 9399.98 updating of
Cement quarterly
CV x (CQ – CB) / CB payment
125091.90 174.200 -784.95 124306.95 112.067 7238.91
Total 1279781.31
Labour
VIIIth W x (LQ – LB) x LC
Quarter LB 100 288.500 32544.69 NA NA 32544.69 Price
Material
04/2018 to W x (MQ – MB) x MC Variation
05/2018 MB 2613008.13 185.100 12572.16 2625580.29 117.800 48500.95 calculated
Fuel after
W x (FQ 100
– FB) x FC
FB 100 201.200 27519.98 2640528.11 100.700 32333.00 updating of
Cement quarterly
CV x (CQ – CB) / CB payment
35460.26 174.200 -222.51 35237.75 113.050 2379.13
Total 2648468.39 Total 251598.29

Total PVC payable for Steel Rs. -5139.38

Total amount of PVC including Steel, Cement& others items payable Rs. 246458.91

Amount of PVC already paid Rs. 330921.91

Overpayment of PVC to Contractor Rs. 84463.00

You might also like