escalataion calculation
DESCRIPTION
bmbTRANSCRIPT
Escalation (65%)
SUMMARY OF PRICE ESCALATION (LOCAL)
Code No.Indes DescriptionSource of IndexUnitFractionBASE INDICESCURRENT INDICESIncrease/DecreaseFractionBase PriceMonth of Bulletin for Base IndicesStatus of Base IndexCurrent IndicesMonth of Bulletin for Current IndicesStatus of Current Index123456789101112=(9-6)13=(9/6x5)aNonadjustable0.4000.40000b LabourMonthly Statistical Bulletin Pakistan Federal Bureau of Statistics (FBS)Day0.08370.00Jan-2013Final 370.00Jan-2013Prov.0.00.08000c Ondinary Portland CementMonthly Statistical Bulletin Pakistan Federal Bureau of Statistics (FBS)Bag0.06450.00Jan-2013Final 505.00Jan-2013Prov.55.000.06730dReinforcing SteelMonthly Statistical Bulletin Pakistan Federal Bureau of Statistics (FBS)Ton0.1070,500Jan-2013Final 77,779.00Jan-2013Prov.7,279.000.11030eStructural Steel WorksMonthly Statistical Bulletin Pakistan Federal Bureau of Statistics (FBS)Ton0.0670,500Jan-2013Final 85,479.00Jan-2013Prov.14,979.000.07270fProvision & Maintenance of Contractors Equpment & PlantPakistan Federal Bureau of Statitics (FBS)0.16175.70Jan-2013Final 189.60Jan-2013Final13.900.17270gFuel (High Speed Diesel)Monthly Statistical Bulletin Pakistan Federal Bureau of Statistics (FBS)Litter0.14109.21Jan-2013Final 116.75Jan-2014Prov.7.540.14970Price Adjustment Factor1.001.05270
Price adjustment factor Pn = 1.0527Total Value of work =73,058,90229,340,342Value of Work Done (PKR) for Adjustement @ 65 % =47,488,287Value of Work Done for Adjustment (PKR) =49,990,919Amount of Escalation (PKR) =2,502,6320.0
0.0
Escalation (35%)SUMMARY OF PRICE ESCALATION (FOREIGN CURRENCY US DOLLAR)
Code No.Indes DescriptionSource of IndexUnitFractionBASE INDICESCURRENT INDICESIncrease/DecreaseFractionBase PriceMonth of Bulletin for Base IndicesStaus of Base IndexCurrent IndicesMonth of Bulletin for Current IndicesStatus of Current Index123456789101112=(9-10)13=(9/6x5)aNonadjustable0.600.600b LabourComposite labor wages for Civil Engineering Contracts (Index number of the Costs of labor and material used in public sector construction project, Census and Statistics Department Hong Kong Special Administrative Region)0.22116.10Jan-2013Final 125.40Nov-2013Prov.9.300.2376cStructural Steel WorksSteel Reinforcement (Index number of the Costs of labor and material used in public sector construction project, Census and Statistics Department Hong Kong Special Administrative Region)0.18206.80Jan-2013Final Not ImportNov-2013Prov.0.1800Price Adjustment Factor1.0176
Price adjustment factor Pn = 1.0176Total Value of work =73,058,902Value of Work Done (USD) @ 35 % = VOW x 0.35/97.4987 = A262,266Adjustment Value (USD) = B = (A x Pn)266,882Amount of Escalation (USD) = C = B-A4,616
10380297150541,753,083174253110,552