Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Price Adjustments

    Uploaded by

    Roshan de Silva
    3,735,911.00 Total Amount (Rs.) treatment& backfill of anthills 287,620.52 - 287,620.52 70,033.50 - 70,033.50 963,100.00 - 963,100.00 557,898.00 - 557,898.00 1,051,885.00 56,564.00 1,108,449.00 181,000.00 - 181,000.00 3.3.3 Mobil

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Price Adjustments

    Uploaded by

    Roshan de Silva
    2K views9 pages
    3,735,911.00 Total Amount (Rs.) treatment& backfill of anthills 287,620.52 - 287,620.52 70,033.50 - 70,033.50 963,100.00 - 963,100.00 557,898.00 - 557,898.00 1,051,885.00 56,564.00 1,108,449.00 181,000.00 - 181,000.00 3.3.3 Mobil

    Original Description:

    Price Adjustments.xls

    Original Title

    Price Adjustments.xls

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    3,735,911.00 Total Amount (Rs.) treatment& backfill of anthills 287,620.52 - 287,620.52 70,033.50 - 70,033.50 963,100.00 - 963,100.00 557,898.00 - 557,898.00 1,051,885.00 56,564.00 1,108,449.00 181,000.00 - 181,000.00 3.3.3 Mobil

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    2K views9 pages

    Price Adjustments

    Uploaded by

    Roshan de Silva
    3,735,911.00 Total Amount (Rs.) treatment& backfill of anthills 287,620.52 - 287,620.52 70,033.50 - 70,033.50 963,100.00 - 963,100.00 557,898.00 - 557,898.00 1,051,885.00 56,564.00 1,108,449.00 181,000.00 - 181,000.00 3.3.3 Mobil

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 9
    At a glance
    Powered by AI
    The document outlines calculations for price adjustments on an infrastructure project based on fluctuating material costs.

    The document appears to be calculating price adjustments for interim payments on a dam rehabilitation project based on changes to input costs over time.

    The main components being tracked and calculated include the valuation of work done, non-adjustable elements, and the cost contributions and indices of various construction materials.

    REMEDIAL WORKS FOR TABBOWA DAM

    Contract No: DSWRPP-1/WORKS/NCB/11


    PRICE ADJUSTMENT - ( AS PER -CLAUSE - GCC 44 )

    FORMULA
    F =
    0.966( V - Vna )
    100

    Sl
    No:
    Tx (Ixc - Ixb)
    S
    all
    Ixb
    inputs

    V = V2-V1
    V1 - Cum. value of work done up to the previous IPC
    IPC NO:

    V2 - Cum. value of work done in the current IPC


    IPC NO:

    13,541,881.91

    15,853,906.30

    Vna1 -Previous Non Adjustable Elements

    6,368,842.17

    Vna2 -Cum. Non Adjustable Elements.

    6,699,889.01

    13,541,881.91 -

    V - Vna = (V2 - Vna2) - (V1 - Vna1)


    V - Vna =(
    15,853,906.30 6,699,889.01 )
    V - Vna =
    1,980,977.55

    0.966( V - Vna )
    100

    19,136.24

    F = 0.966( V - Vna ) x Tx ( Ixc - Ixb )


    100
    all
    Ixb
    inputs
    F = 19,136.24

    PRICE ADJUSTMENT SHEET FOR THE IPC No. - 02

    3.97

    75,972.79
    F = Price adjustment for the period
    V = Valuation of work done during the period concerned
    Vna = Valuation of non adjustable element
    Tx = Percentage cost contribution of input X
    Ixc = Current index for input X, as published by ICTAD
    Ixb = Base index for input X, as published by ICTAD

    L1
    L3
    P1
    P2
    P3
    M4
    M6
    M8
    M7
    M13

    Description
    Skilled labour
    Unskill labour
    Small Equipment
    Heavy Equipment
    Fuel
    Cement
    Rubble
    Sand
    Metal
    Reinforcement Steel

    Tx
    9.20
    10.10
    6.30
    4.90
    9.90
    12.20
    13.40
    1.30
    15.20
    7.50

    Ixb
    Ixc
    10/10
    8/11
    343.10 363.50
    382.50 407.40
    336.70 336.70
    313.70 313.70
    713.40 747.60
    432.20 432.20
    457.30 475.00
    1769.00 1796.10
    260.40 278.60
    472.60 516.10

    (Ixc-Ixb) Tx (Ixc-Ixb)
    Ixb
    Ixb
    0.0595
    0.5474
    0.0651
    0.6575
    0.0000
    0.0000
    0.0000
    0.0000
    0.0479
    0.4742
    0.0000
    0.0000
    0.0387
    0.5186
    0.0153
    0.0199
    0.0699
    1.0625
    0.0920
    0.6900

    6,368,842.17 )

    Px ( Ixc -Ixb )
    Ixb

    ------------------------------------------------>

    3.9701

    REMEDIAL WORKS FOR TABBOWA DAM


    Contract No: DSWRPP-1/WORKS/NCB/11

    Interiam Payments Applications No : 03


    Work Done Up To 7th October 2011
    NON ADJUSTABLE ELEMENTS

    Se. No.

    Bill Ref.

    Description
    Preliminaries
    Variation

    Non adjustable element total carried to escalation sheet

    BOQ Amount
    (Rs.)

    Previous Amount
    (Rs.)

    This Month
    Amount (Rs.)

    Total Amount
    (Rs.)

    10,498,500.00

    3,658,572.00

    77,339.00

    3,735,911.00

    2,694,962.12

    2,710,270.17

    253,707.84

    2,963,978.01

    13,193,462.12

    6,368,842.17

    331,046.84

    6,699,889.01

    REMEDIAL WORKS FOR TABBOWA DAM


    Contract No: DSWRPP-1/WORKS/NCB/11
    PRICE ADJUSTMENT - ( AS PER -CLAUSE - GCC 44 )

    FORMULA
    F =
    0.966( V - Vna )
    100

    Sl
    No:
    Tx (Ixc - Ixb)
    S
    all
    Ixb
    inputs

    V = V2-V1
    V1 - Cum. value of work done up to the previous IPC
    IPC NO:

    V2 - Cum. value of work done in the current IPC


    IPC NO:

    19,607,539.73

    22,388,877.23

    Vna1 -Previous Non Adjustable Elements

    7,078,968.76

    Vna2 -Cum. Non Adjustable Elements.

    7,179,371.76

    19,607,539.73 -

    V - Vna = (V2 - Vna2) - (V1 - Vna1)


    V - Vna =(
    22,388,877.23 7,179,371.76 )
    V - Vna =
    2,680,934.50

    0.966( V - Vna )
    100

    25,897.83

    F = 0.966( V - Vna ) x Tx ( Ixc - Ixb )


    100
    all
    Ixb
    inputs
    F = 25,897.83

    PRICE ADJUSTMENT SHEET FOR THE IPC No. - 02

    3.97

    102,816.97
    F = Price adjustment for the period
    V = Valuation of work done during the period concerned
    Vna = Valuation of non adjustable element
    Tx = Percentage cost contribution of input X
    Ixc = Current index for input X, as published by ICTAD
    Ixb = Base index for input X, as published by ICTAD

    L1
    L3
    P1
    P2
    P3
    M4
    M6
    M8
    M7
    M13

    Description
    Skilled labour
    Unskill labour
    Small Equipment
    Heavy Equipment
    Fuel
    Cement
    Rubble
    Sand
    Metal
    Reinforcement Steel

    Tx
    9.20
    10.10
    6.30
    4.90
    9.90
    12.20
    13.40
    1.30
    15.20
    7.50

    Ixb
    Ixc
    10/10
    8/11
    343.10 363.50
    382.50 407.40
    336.70 336.70
    313.70 313.70
    713.40 747.60
    432.20 432.20
    457.30 475.00
    1769.00 1796.10
    260.40 278.60
    472.60 516.10

    (Ixc-Ixb) Tx (Ixc-Ixb)
    Ixb
    Ixb
    0.0595
    0.5474
    0.0651
    0.6575
    0.0000
    0.0000
    0.0000
    0.0000
    0.0479
    0.4742
    0.0000
    0.0000
    0.0387
    0.5186
    0.0153
    0.0199
    0.0699
    1.0625
    0.0920
    0.6900

    7,078,968.76 )

    Px ( Ixc -Ixb )
    Ixb

    ------------------------------------------------>

    3.9701

    REMEDIAL WORKS FOR TABBOWA DAM


    Contract No: DSWRPP-1/WORKS/NCB/11

    Interiam Payments Applications No : 04


    Work Done Up To 7th November 2011
    NON ADJUSTABLE ELEMENTS

    Se. No.

    Bill Ref.

    Vo 01.1
    Vo 01 R
    Vo 01.2
    Vo.03R
    Vo.04
    Vo.05
    Vo.06
    Vo 07
    Vo.08

    Description
    Preliminaries

    43,839.00

    Total Amount
    (Rs.)
    3,779,750.00

    45,000.00

    45,000.00

    Excavation of stilling basing area with rubble,boulders and stacking

    296,924.76

    296,924.76

    Preparation of temporary platform to excute the excavation

    355,500.00

    326,250.00

    326,250.00

    49,875.00

    62,700.00

    62,700.00

    Forming wheep holes using T1000, 50mm PVC pipes at


    Exixting
    (New
    rate)(SSR-02)
    Forming wheep
    of 15 xhole
    10mm
    Expansion
    Joint and filling with
    poly
    seal
    PS Sealent
    at concrete
    Stilling Basing
    End Sill.
    75
    mm
    thick
    Grade 15
    (lean con.)
    Dewatering
    Form atrench on existing stlling basin of end wall
    Excavation
    of embankment material with boulders of
    (900x200mm)
    existing dam to foundation level.

    3.3.3
    3.4.3
    3.6.4

    Furnishing and placing of geotextiles


    Mobilisation and demobilisation of all equipment,labour &
    materials for exploratory drilling.
    Mobilisation and demobilisation of all equipment,labour &
    materials for grout curtain & contact grouting.
    Furnishing and placing of geotextiles

    4.1.3

    3,735,911.00

    This Month
    Amount (Rs.)

    45,000.00

    Removal, treatment& backfill of anthills

    3.6.14

    10,498,500.00

    Previous Amount
    (Rs.)

    287,620.52

    Construction of Temporary Road works For End Wall Excavation

    3.1.5

    3.6.9

    BOQ Amount
    (Rs.)

    271,568.00

    70,033.50

    Deleted

    963,100.00
    557,898.00
    -

    Pay on day work basis


    557,898.00
    1,051,885.00

    56,564.00

    181,000.00

    Furnishing and placing of geotextiles

    4,539,000.00

    Furnishing and placing of geotextiles

    801,000.00

    8,811,000.00

    95,000.00

    50,890.00

    107,000.00

    4.3.1

    Construction of cofferdam, dealing with water and dewatering of


    foundations, complete removal of cofferdam and reinstating
    approach canal.

    966,000.00

    4.3.2

    Provide, install, operate and maintain pumps for discharges


    arround 5-10 cusecs for downstream water issues.

    1,000,000.00

    4.3.9

    Dismantling of existing sluice structure.

    133,000.00

    869,400.00

    557,898.00
    1,108,449.00

    869,400.00

    133,000.00

    133,000.00

    4.4.1

    Construction of cofferdam, dealing with water and dewatering of


    foundations, complete removal of cofferdam and reinstating
    approach canal.

    966,000.00

    4.4.2

    Provide, install, operate and maintain pumps for discharges


    arround 5-10 cusecs for downstream water issues.

    1,000,000.00

    Mechanical works

    32,702,895.00

    Non adjustable element total carried to escalation sheet

    64,451,880.02

    7,078,968.76

    100,403.00

    7,179,371.76

    NAWALOKA CONSTRUCTION COMPANY PVT. LTD


    REMEDIAL WORKS FOR TABBOWA DAM

    PRICE EXCALATION

    REMEDIAL WORKS FOR TABBOWA DAM


    Contract No: DSWRPP-1/WORKS/NCB/11
    PRICE ADJUSTMENT - ( AS PER -CLAUSE - GCC 44 )

    FORMULA
    F =
    0.966( V - Vna )
    100

    Sl
    No:
    Tx (Ixc - Ixb)
    S
    all
    Ixb
    inputs

    V = V2-V1
    V1 - Cum. value of work done up to the previous IPC
    IPC NO:

    V2 - Cum. value of work done in the current IPC


    IPC NO:

    19,562,539.73

    45,613,058.69

    Vna1 -Previous Non Adjustable Elements

    7,052,282.76

    Vna2 -Cum. Non Adjustable Elements.

    8,095,203.94

    19,562,539.73 -

    V - Vna = (V2 - Vna2) - (V1 - Vna1)


    V - Vna =(
    45,613,058.69 8,095,203.94 )
    V - Vna =
    25,007,597.78

    0.966( V - Vna )
    100

    241,573.39

    F = 0.966( V - Vna ) x Tx ( Ixc - Ixb )


    100
    all
    Ixb
    inputs
    F = 241,573.39

    PRICE ADJUSTMENT SHEET FOR THE IPC No. - 02

    3.94

    952,378.93
    F = Price adjustment for the period
    V = Valuation of work done during the period concerned
    Vna = Valuation of non adjustable element
    Tx = Percentage cost contribution of input X
    Ixc = Current index for input X, as published by ICTAD
    Ixb = Base index for input X, as published by ICTAD

    L1
    L3
    P1
    P2
    P3
    M4
    M6
    M8
    M7
    M13

    Description
    Skilled labour
    Unskill labour
    Small Equipment
    Heavy Equipment
    Fuel
    Cement
    Rubble
    Sand
    Metal
    Reinforcement Steel

    Tx
    9.20
    10.10
    6.30
    4.90
    9.90
    12.20
    13.40
    1.30
    15.20
    7.50

    Ixb
    Ixc
    10/10
    8/11
    343.10 363.50
    382.50 407.40
    336.70 336.70
    313.70 313.70
    713.40 745.60
    432.20 432.20
    457.30 475.00
    1769.00 1796.10
    260.40 278.60
    472.60 516.10

    (Ixc-Ixb) Tx (Ixc-Ixb)
    Ixb
    Ixb
    0.0595
    0.5474
    0.0651
    0.6575
    0.0000
    0.0000
    0.0000
    0.0000
    0.0451
    0.4465
    0.0000
    0.0000
    0.0387
    0.5186
    0.0153
    0.0199
    0.0699
    1.0625
    0.0920
    0.6900

    7,052,282.76 )

    Px ( Ixc -Ixb )
    Ixb

    ------------------------------------------------>

    3.9424

    REMEDIAL WORKS FOR TABBOWA DAM


    Contract No: DSWRPP-1/WORKS/NCB/11

    Interiam Payments Applications No : 04


    Work Done Up To 7th November 2011
    NON ADJUSTABLE ELEMENTS

    Se. No.

    Bill Ref.

    Description

    BOQ Amount
    (Rs.)

    Previous Amount
    (Rs.)

    This Month
    Amount (Rs.)

    10,498,500.00

    3,652,661.00

    45,000.00

    45,000.00

    45,000.00

    Excavation of stilling basing area with rubble,boulders and stacking

    287,620.52

    296,924.76

    296,924.76

    Preparation of temporary platform to excute the excavation

    355,500.00

    326,250.00

    326,250.00

    Forming wheep holes using T1000, 50mm PVC pipes at


    Exixting wheep
    (New
    rate)(SSR-02)
    Forming
    of 15 xhole
    10mm
    Expansion
    Joint and filling with
    poly
    seal
    PS
    Sealent
    at
    Stilling
    Basing
    End Sill.
    75 mm thick Grade 15 concrete (lean con.)

    49,875.00

    62,700.00

    62,700.00

    271,568.00

    Preliminaries

    82,089.00

    Vo.08

    Construction of Temporary Road works For End Wall Excavation

    Dewatering
    Form atrench on existing stlling basin of end wall
    Excavation
    of embankment material with boulders of
    (900x200mm)
    existing dam to foundation level.

    3.1.5

    Removal, treatment& backfill of anthills

    3.3.3

    Furnishing and placing of geotextiles

    3.4.3

    Furnishing and placing of geotextiles

    3.6.4

    Furnishing and placing of geotextiles


    Mobilisation and demobilisation of all equipment,labour &
    materials for exploratory drilling.
    Mobilisation and demobilisation of all equipment,labour &
    materials for grout curtain & contact grouting.
    Furnishing and placing of geotextiles

    3.6.9
    3.6.14
    4.1.3

    3,734,750.00
    960,832.18

    Provide & maintain Project Manager's offices.

    Vo 01.1
    Vo 01 R
    Vo 01.2
    Vo.03R
    Vo.04
    Vo.05
    Vo.06
    Vo 07

    Total Amount
    (Rs.)

    70,033.50
    963,100.00
    557,898.00
    -

    Deleted
    -

    Pay on day work basis

    557,898.00

    557,898.00

    1,108,449.00

    1,108,449.00

    181,000.00

    4,539,000.00

    801,000.00

    8,811,000.00

    95,000.00

    50,890.00

    107,000.00

    4.3.1

    Construction of cofferdam, dealing with water and dewatering of


    foundations, complete removal of cofferdam and reinstating
    approach canal.

    966,000.00

    4.3.2

    Provide, install, operate and maintain pumps for discharges


    arround 5-10 cusecs for downstream water issues.

    1,000,000.00

    869,400.00

    869,400.00

    4.3.9

    Dismantling of existing sluice structure.

    133,000.00

    4.4.1

    Construction of cofferdam, dealing with water and dewatering of


    foundations, complete removal of cofferdam and reinstating
    approach canal.

    966,000.00

    4.4.2

    Provide, install, operate and maintain pumps for discharges


    arround 5-10 cusecs for downstream water issues.

    1,000,000.00

    Mechanical works

    32,702,895.00

    Non adjustable element total carried to escalation sheet

    64,451,880.02

    133,000.00

    7,052,282.76

    82,089.00

    133,000.00

    8,095,203.94

    You might also like