l< I M) I'OK.Ml I,A .MSTIIO!) Annex A Sheet A10 CONTRIBUTION OF INPUTS TO THE COST (After eleminating of inputs for which the contribution is less than 0.50%) No ICTAD Bulletin Name of input Amount Percentage No 1 M4 Cement 886,867.45 11.16 % 260,000.00 3.27 % 2 M6 Rubble 124,043.40 1.56 % 428,745.25 5.39 % 3 M7 Metal 661,251.60 8.32 % 177,843.60 2.24 % 4 M8 Sand 294,756.00 j 3.71 % 344,126.25 \\ 4.33 % 5 M9 Brick 138,470.33 1.74 % N \\ 76-412.00 0.96 % 6 M12 Lime \\ 94,860.00 1.19 % \\ 231,289.50 2.91 % 7 M13 R/f steel 141,570.00 1.78 % 1.17 % 8 M16 Asbestoes roof 93,324.00 0.57 % 45,360.00 5.64 % 9 M20 PVC pipe 448,593.75 2.98 % 237,150.00 16.15 % 10 M22 General timber 1,284,197.32 13.81 % 1,097,853.07 1.11 % 11 M26 Electrical wiring__ 88,257.00 90.00 % 12 M27 Wall paint 7,154,670.51 13 M32 Floor tile a \\■■ 14 M33 Wall tile? V. y\\ T7 V” a T~ \\7 15 M35 Coloured pigment 16 M36 C\\ \\ Aluminium work 17 (V' M38 \\ Electrical fittings 18 L1 Skilled labour 19 L3 Unskilled labour 20 P2 Heavy equipment SUB TOTAL * GRAND TOTAL ** 7,949,633.90 100.00 % * The Sub Total amount of Rs. 7,154,670.51 Is considered as 90% of the cost ** Hence, Grand Total is computed by multiplying the Sub Total by a factor of [100/90] SKCOM) l »n ION, Jl'NK 2008 41 Institute for Construction Training and Development (1C I AD)
!( J \\l) 1'OK.Ml LA >111non Annex A Sheet A1 I FINAL INPUT PROPORTIONS FOR THE CONTRACT ICTAD Bulletin Name of input Amount Percentage No M4 Cement 886,867.45 11.16 % 3.27 % M6 Rubble 260,000.00 1.56 % 5.39 % M7 Metal 124,043.40 8.32 % 2.24 % M8 Sand 428,745.25 3.71 % 4.33 % M9 Brick 661,251.60 1,74 % M12 Lime 177,843.60 \\ &96 % 11.19 % M13 R/f steel 294,756.00 2.91 % 1.78 % M16 Asbestoes roof 344,126.25 1.17 % 0.57 % M20 PVC pipe 138,470.33 5.64 % 2.98 % M22 General timber 76,142.00, i 16.15 % v 13.81 % _ 94,860\\00 , \\ 1.11 % M2.6 Electrical wiring 7 . \\ \\ It M27 Wall paint 231,289.50 \\ - M32 Floor tile / 141,570.00 M33 Wall tile j 93,324.00 M35 Coloured pigment 45,360,00 M36 Aluminium work 448,593.75 M38 Electrical fittings 237,150,00 L1 Skilled labour 1,284,197.32 L3 Unskilled labour 1,097,853.07 88,257.00 P2 Heavy equipment 90.00 % SIT ONI) I 1)11 ION, .11 NK 2(108 42 Institute for Construction Training anti Development (1C I AD)
ICI.VJ) IOUMI I.A Mi i ison Annex B ANNEX B Sheet 1 of 2 SPECIMEN CALCULATION SHEET FOR MONTHLY PRICE FLUCTUATION CLAIM 1.0 Price adjustment computation for the valuation No, 2.0 Previous Valuation Rs a. Date Rs. b. Cumulative value of certified work done Rs. c. Cost of material at site d. Cumulative cost of non-adjustable element 3.0 Current Valuation a. Date Rs. b. Cumulative value ofcertified work done c. Cost ofmaterials delivered to site Rs. d. Cumulative cost of non adjustable element Rs. e. Indices applicable for current valuation (month/ycar) 4.0 Computation of V - V„a. (3b-i 3c - 3d)-(2b + 2c-2d) V-Vna 5.0 0.966(V - V.,.1 100 SKCOM) MOTION..II Ni: 2008 43 Institute lor Construction Training and Development (K TAD)
ICTAI) FORMULA MKTMOD Annex B ANNEXB Sheet 2 of 2 >; ■Px (Ixcrixh) 6.0 Computation of all I xb (refer the table below) inputs 7.0 Price Adjustment for the Current Valuation F Step 5 x Step 6 8.0 fhe above sum should be subjected to payment of VAT as any other payment made to the contractor Specimen calculation sheet for step 6.0 1 2 3 4 5 Name of input Px (Ixc - Ixb) Input percentage Base index Current Index (Px) Ixb (Ixb) (Ixc) Total Sum SIX ONI) 1.1)11 ION. ,11 NF. 2003 44 Institute for Construction framing and Development (ICTAI))
l< I Al) IOKMU.A MKTIKM) Annex C ANNEX C Sheet Cl EXAMPLE FOR COMPUTATION OF PRICE FLUCTUATION FOR WORKS EXCEEDING RUPEES TEN MILLION (>RS. 10M) The example given below illustrate the computation of price fluctuation for two interim bills, l'he data given below includes the General Contract data required for computations and the details of interim claim Nos. 1.3 & 4. CONTRACT DATA Total Contract Sum Rs. 15,647,281.26 13-Feb-2007 Date of Closing Bids 04-May-2007 Dale of commencement of Works 05-July-2007 1,248.634.51 CLAIM NO. 1 50.000.00 Date of Submission 90.500.00 Value of Certified Work done (cumulative) Rs. 07-Aug-2007 5,702,864.53 80% of Cost of Material at site Rs. 70.000.00 Value of Non-adjustable Element (cumulative) Rs. 90.500.00 CLAIM NO. 3 08-Dec-2007 8.864,251.54 Date of Submission 40,000.00 Value of Certified Work done (cumulative) Rs. 108,335.00 80% of Cost of Material at site Rs. Value of Non-adjustable Element (cumulative) Rs. CLAIM NO. 4 Dale of Submission Value of Certified Work done (cumulative) Rs. 80% of Cost of Material al site Rs. Value of Non-adjustable Element (cumulative) Rs. SIX OM) 1,1)11 ION, .U NI 2(1(18 45 Institute lor Construction Training and Development (1C I AD)
UTAH IOUMI I X Mi: | MOD Annex C Sheet C'2 C omputation Sheet (Claim No. 01) 1.0 Price adjustment computation for the valuation No. 01 2.0 Previous Valuation a. Dale NA b. Cumulative value of certified work done NA c. Cost of material at site NA d. Cumulative value of non-adjustable clement NA 3.0 Current Valuation a. Date 05-July-2007 b. Cumulative value of certified work done Rs. 1.248.634.51 c. Cost of material at site Rs. 50.000.00 d. Cumulative value of non adjustable element Rs. 90.000.00 e. Month applicable for Current Indices May-2007 f. Month applicable for Base Indices Jan-2007 4.0 Computation of V - Vna- Rs. 1.208.134.51 V - V„a - (3b + 3c - 3d)-(2b + 2c - 2d) Rs. 11.670.58 5.0 0.966( V - Vn4 2.40 100 Rs. 28.009.39 6.0 Computation of £ P\\ (l.xc ~ I\\h) I xb (See Sheet C’3) 7.0 Price Adjustment for the current valuation l; Step 5 x Step 6 - 1 1.670.58 x 2.40 sr.( DM) ijmtiov.m ni: 2008 46 Institute lor Construction Training anti Development (1C I \\l >i
KTAI) IOUMI i A MS;ni()l) Amies (' Sliccl C A Computation of £ Px (1,r - U ) for Claim no 01 100 Input No Name of Input Input % Base Index Current Index P *(Ur~Lh) (Px) dxb) dxc) 'xb Jan-07 May-07 M4 Cement 11.16 352.4 353.6 0.04 M6 Rubble 3.27 387.0 396.5 0.08 M7 Metal 1.56 208.3 223.5 0.11 M8 Sand 5.39 1430.1 1444.9 0.06 M9 Brick 8.32 771.6 760.1 -0.12 M12 Lime 2.24 319.4 336.0 0.12 M13 R/f steel 3.71 294.8 343.7 0.62 M16 Asbestoes roof 4.33 223.7 s\\ 239,0 0.30 c\" r 427.9 « M20 PVC products 1.74 \\ 427.9 0.00 M22 General Timber 0.96 \\ 649.5 \\ \\6>t:4 0.03 ■\\— M26 Electrical wiring fj19 A, V ' 4,02.6 \\ 350.8 -0.15 M27 Wall paint T 424.5 0.18 2:91 \\ \\\\4poi M32 Floor tile 1.7.8 143.1 149.6 0.08 261.9 0.19 M33 Wall tile V \\ ^ 11.17 226.2 \\ -A M35 Colour pigment, \\ A 0.57 225.6 226.3 0.00 291.4 293.3 0.04 M36 \\1 5.64 , Aluminium workv-''- M38 Elect. Fittings 2.98 140.8 142.0 0.03 16.15 290.1 295.6 0.31 T 13.81 320.1 331.0 0.47 238.4 249.3 0.05 L1 Skilled labour 1.11 L3 Unskilled labour P2 Heavy eguipmerU 90.00 Sum 2.40 SI C ON!) l.nmON. JUNT. 2(108 17 Institute tor Construction Training and Development (1C TAD)
1C I U) !•'()l<Mi l,A MICH 101) Annex C Sheet C4 Computation Sheet (Claim No. 04) 1.0 Price adjustment computation for the valuation No. 04 2.0 Previous Valuation a. Date 07-Aug-2007 b. Cumulative value of certified work done Rs. 5.702.864.53 c. Cost of material at site Rs. 70.000.00 d. Cumulative value of non-adjustable element Rs. 90.500.00 3.0 Current Valuation a. Date 18-Dec-2007 b. Cumulative value of certified work done Rs. 8.864.251.54 e. Cost of material at site Rs. 40.000.00 d. Cumulative value of non adjustable element Rs. 108,335.00 e. Month applicable for Current Indices Sep-2007 f. Month applicable for Base Indices Jan-2007 4.0 Compulation of V - V na- Rs. 3,113,552.01 Rs. 30,076.91 v - V„a = (3b + 3c - 3d)-(2b + 2c - 2d) 4.95 5.0 0.966CV - Vng) 100 Rs. 148.880.70 6.0 Computation of Z P\\ (l\\c ~ l\\h) Ixb (Sec Sheet C5) 7.0 Price Adjustment for the current valuation P = Step 5 x Step 6 = 30.076.91 x 4.95 SIX ONI) 1,1)1 I ION..II M: 2008 48 Institute lor Construction Training and Development (1C I AD)
l< I A!) 1 ORMIU.A Mi; 11fOI> Annex (' Sheet C'5 Computation of £ Px ( U - U) for Claim no 04 100 Input % Base Index Current Index i Input No Name of Input (Px) ' (Ixb) (Ixc) Pv(U-U) Jan-07 Sep-07 Ixb M4 Cement 11.16 352.4 368.9 0.52 M6 Rubble 3.27 387.0 401.8 0.13 M7 Metal 1.56 208.3 227.4 0.14 M8 Sand 5.39 1430.1 1475.4 0.17 M9 Brick 8.32 771.6 764.2 -0.08 M12 Lime 2.24 319.4 341.3 0.15 M13 R/f steel 3.71 294.8 397.2 1.29 M16 Asbestoes roof 4.33 223.7 245.9 0.43 M20 PVC products_ \\ 0.04 M22 General Timber 1.74 ___ 4?7.9, -0.01 M26 _ Electrical wiring 0.96 •\"'\\\\ 649.5 \\ 438.1 •0.14 M27 Wall paint___ 1.19 \\ \\MP2-6 0.18 2.91 \\ T 400.3 \\ 639.9 355.7 424.5 M32 Floor tile \\T\" 1.78 \\ 143.1 158.3 0.19 M33 Wall tile \\ 11.17 226.2 321.4 0.49 M35 Colour pigment 0.57 225.6 227.1 0.00 5.64 291.4 296.0 0.09 V 2.98 140.8 144.4 0.08 16.15 290.1 299.2 0.51 M36 J 7 Aluminium work . M38 Elect. Fittings ,j L1 Skilled labour L3 Unskilled labour 13.81 320.1 335.3 0.66 P2 Heavy equipment 1.11 238.4 264.6 0.12 * Sum 4.95 si.com) r.omoN, junk 2aos IV Institute for Consti uction Training and Development (IC l AI) >
ft f »
!( I Vi) IORVH I A Mi lllOl) Annex D ANNEX I) Sheet D1 EXAMPLE FOR COMPUTATION OF PRICE FLUCTUATION USING SIMPLIFIED FORMULA (<Rs. 10 M) The example given below illustrate the computation of price fluctuation for two interim bills i using simplified formula. The data given below includes the General Contract Data required for computations and the details of interim claim Nos. 1,3 & 4. CONTRACT DATA Total Contract Sum Rs. 4,327,355.33 13-Feb-2007 Date of Closing Bids 04-May-2007 Average office building Date of commencement of Works 05-July-2007 Type of Work 767.885.73 50.000.00 CLAIM NO. I 15.000.00 Date of Submission 07-Aug-2007 2,135.133.27 Value of Certified Work done (cumulative) Rs. 70.000.00 80% of Cost of Material at site Rs. 15.000.00 Value of Non-adj ustable Clement (cumulative) | Rs. 08-Dec-2007 3,995,333.27 CLAIM NO. 3 40,000.00 Date of Submission 15,000.00 Value of Certified Work done (cumulative) Rs. 80% of Cost of Material at site Rs. Value of Non-adjustable Element (cumulative) Rs. CLAIM NO. 4 Date of Submission Value of Certified Work done (cumulative) Rst 80% of Cost of Material at site Rs. Value of Non-adjustable Element (cumulative) Rs. Indiees for Average office building - (Table 5 - “Non Residential Building\" of ICTAD Publication; Bulletin of Construction Statistics) January 2007 366.5 May 2007 381.3 September 2007 399.0 SKCOM) 1.1)11 ION,.H Nr! 200)1 51 institute for Construction Training and Development (ICTAD)
|( 'TAD IOHMI l .\\ MK! HOI) Annex I) Sheet D2 Computation Sheet (Claim No. 01) 01 i 1.0 Price adjustment computation for the valuation No. 2.0 Previous Valuation NA XX NA a. Date NA b. Cumulative value of certified work done NA c. Cost of material at site d. Cumulative value of non-adjustablc element 3.0 Current Valuation a. Date Rs. 05-July-2007 b. Cumulative value of certified work done 767.885.73 50.000.00 c. Cost of material at site Rs. 15.000.00 May-2007 d. Cumulative value of non adjustable element Rs. Jan-2007 e. Month applicable for Current Indices f. Month applicable for Base Indices 4.0 Computation of V - Vna v - Vna = (3b -I- 3c - 3d)-(2b + 2c - 2d) Rs. 802.885.73 Rs. 697.707.70 5.0 0.869(V - Vna) 0.040 6.0 Computation of Rs. 27.908.31 ObizM (381.3 - 366.5) kb 366.5 (See Sheet C3) 7.0 Price Adjustment for the current valuation P Step 5 x Step 6 - 697.707.70 x 0.04 sr.COM) I I)11 ION, ,»1 \\i: 2008 S2 Institute lor Construction (‘raining and Development (IC'TAD)
K:i.\\n iOK.il i.a *;i;: wm Annex D Sheet 1)3 Computation Sheet (Claim No. 04) 1.0 Price adjustment computation for the valuation No. 04 » 2.0 Previous Valuation a. Date 07-Aug-2007 b. Cumulative value ofcertified work done Rs. 2,135.133.27 c. Cost of material at site Rs. 70.000.00 d. Cumulative value of non-adjustable element Rs. 15.000.00 3.0 Current Valuation a. Date Rs. 08-Dcc-2007 b. Cumulative value of certified work done 3.995.333.27 c. Cost of material at site Rs. 40.000.00 15,000.00 d. Cumulative value of non adjustable element Rs. Sep-2007 Jan-2007 e. Month applicable for Current Indices f. Month applicable for Base I ndices 4.0 Compulation ofV - Vna Rs. 1,830,200.00 V - Vna - (3 b + 3c - 3d)-(2b + 2c - 2d) vl 5.0 0.869(V - Vna) Rs. 1,590,443.80 6.0 Computation of (Iicjilib)_= (381.3 - 366.5) 0.089 hb 366.5 (See Sheet C5) 7.0 Price Adjustment for the current valuation Rs. 141,549.50 F ^ Step 5 x Step 6 1,590,443.80x0.089 swoM) i:i)moN,Jt:Ni:?.no8 53 Institute lor C onstruction ('raining and Development (IC ! AD)
Search
