0% found this document useful (0 votes)
79 views1 page

Calculation of Differential Amount

The document calculates the differential amount for the construction of Nuagaon Minor from RD 00m to RD 3802m including structures, cement concrete lining and inspection road. It provides the agreement amount, percentage allocation for materials and labor, base rates for materials and labor, and calculates the value of work done and differential amount over 10 payment periods from March 2020 to July 2021 totaling approximately ₹4.3 crore.

Uploaded by

Swaroop
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)
79 views1 page

Calculation of Differential Amount

The document calculates the differential amount for the construction of Nuagaon Minor from RD 00m to RD 3802m including structures, cement concrete lining and inspection road. It provides the agreement amount, percentage allocation for materials and labor, base rates for materials and labor, and calculates the value of work done and differential amount over 10 payment periods from March 2020 to July 2021 totaling approximately ₹4.3 crore.

Uploaded by

Swaroop
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
You are on page 1/ 1

CALCULATION OF DIFFERENTIAL AMOUNT

Name of the work :


Construction of Nuagaon Minor from RD 00m to RD 3802m., Sarbana S/M, Purunapani S/M, Tikarbati S/M & Tikargadia Sub-Minor including all structures, Cement
Concrete lining and inspection road.
Other
Labour Machinary
Agreement No: 03P1/2019-20 Cement Pc Steel Ps POL Pf Bitumen Pb Pipes Pp Material Total
Pl Pm
Pm
Agreement Amount in `: 96964171.00 16.31% 6.69% 5% 5% 0.00% 6.88% 1.35% 58.77% 100.0%

Date of Opening of Financial Bid: 17.09.2019

28days Prior to Opening of Financial Bid: 20.08.2019

Name of the Agency : M/s Santosh Kumar Khandelwal,


Super Class Contractor Other Material Cement (OPC) Mild Steel -Long product Labour POL (HSD) Machinary Construction Pipes

D.O.C : 27.02.2020 Base Rate Base Rate Base Rate Base Rate Base Rate Base Rate Base Rate
Stipulated D.O.C : 26.01.2021
Actual D.O.C :
E.O.T Granted up to : Po: 58.77% Pc: 16.31% Ps: 6.69% Pl: 5.00% Pf: 5.00% Pp: 6.88% Ppi: 1.35%
TOTAL
M0: 121.50 C0: 118.50 S0: 104.20 L0: 280.00 F0: 70.17 P0: 74.50 P0: 104.70
Other materials Cement Steel Labour POL Machinary Construction Pipes

Value of work Done VM = 0.85 x Vs = 0.85 x VL = 0.85 x Vf = 0.85 x


R/A Sl No RA Bill Date Month Vc = 0.85 x Pc/100 x Vf = 0.85 x Pf/100 x Vf = 0.85 x Pp/100 x
( R) M1 Pm/100 x R x C1 S1 Ps/100 x R x L1 PL/100 x R x F1 P1 P1 Pp/100 x R x
R x (C1-C0)/C0 R x (F1-F0)/F0 R x (P1-P0)/P0
(M1-M0)/M0 (S1-S0)/S0 (L1-L0)/L0 (P1-P0)/P0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 17 18 17 18 19

1 24.03.2020 Mar-20 2,232,163.33 120.40 -10,095.25 119.70 3,133.73 106.60 2,923.58 298.00 6,098.59 67.20 -4,015.32 74.80 525.65 125.00 4,966.24 3,537.23

2 21.11.2020 Nov-20 11,732,566.79 125.10 173,657.63 118.70 2,745.22 112.80 55,064.13 308.00 49,863.41 80.59 74,045.42 75.60 10,130.64 126.70 28,289.27 393,795.73

3 22.12.2020 Dec-20 10,402,132.86 125.40 166,795.89 118.10 -4,867.85 118.20 79,474.49 308.00 44,209.06 80.87 67,413.00 75.80 10,614.92 129.80 28,615.55 392,255.07

4 25.01.2021 Jan-21 5,495,809.05 126.50 112,979.59 118.50 - 64,183.40 308.00 23,357.19 82.00 39,378.02 76.60 9,059.45 134.70 18,070.03 267,027.68
125.60
5 24.02.2021 Feb-21 11,712,000.17 128.10 317,814.23 120.60 28,774.31 131,027.44 308.00 49,776.00 86.86 118,392.68 76.60 19,306.41 137.50 42,102.79 707,193.87
124.70
6 19.03.2021 Mar-21 17,381,427.25 129.90 600,292.70 125.00 132,176.22 193,505.33 308.00 73,871.07 89.18 200,126.69 76.60 28,652.06 141.40 69,912.93 1,298,536.99
124.60
7 26.04.2021 Apr-21 6,270,134.13 132.00 270,685.17 125.70 52,815.80 80,070.03 308.00 26,648.07 88.37 69,117.13 76.80 11,320.24 140.40 24,533.02 535,189.47
127.60
8 24.05.2021 May-21 4,439,049.95 132.90 208,062.22 123.60 26,485.90 64,681.28 311.00 20,887.32 90.78 55,412.21 77.00 8,711.26 146.40 20,287.67 404,527.86
130.90
9 25.06.2021 Jun-21 1,461,481.37 133.70 73,308.01 124.50 10,258.86 21,534.48 311.00 6,876.79 95.52 22,439.27 76.70 2,523.87 150.00 7,256.00 144,197.29
131.20
10 23.07.2021 Jul-21 1,479,003.05 134.50 79,051.62 123.40 8,478.51 131.40 21,954.08 311.00 6,959.24 98.36 25,252.34 76.40 2,205.84 146.80 6,824.29 150,725.91

Grand Total 72,605,767.95 1,992,551.81 260,000.71 714,418.25 308,546.73 667,561.43 103,050.35 250,857.80 4,296,987.08

or say `. 4,296,987.00

You might also like