Escalation formula

[Mohan]

4% QTY Excluding the Wastage Escalation cost is not for the
wastagae 3%
DESCRIPTION Received Invoice No Dia Qty (MT) Basic Price Total Cost
Excluding VAT/MT Vat Total Amount Including VAT/MT Rate
Difference 8mm 10mm 12mm 16mm 20mm 25mm 32mm Total Paid Balance As Built Qty
used as of RAB-02 As BuiltQty Escalation Qty Difference Rate Amount
RA BILL NO.01 8mm 5.115
28-Mar-08 104174 16 19.73 44350 44350 1774 46124 14,124.00 - -
- 19.155 - - - 19.155 19.155 0.000 SIL used 10mm
instead of 8mm 5.115 13500 69052.5
28-Mar-08 104167 16 19.92 44350 44350 1774 46124 14,124.00 - -
- 19.340 - - - 19.340 18.426 0.914
29-Mar-08 104215 20 19.97 44300 44300 1772 46072 14,072.00 - -
- - 19.388 - - 19.388 19.388 0.000
29-Mar-03 104218 20 19.89 44300 44300 1772 46072 14,072.00 - -
- - 19.311 - - 19.311 19.311 (0.000) 10mm 0
31-Mar-08 104405 10 6.51 43750 43750 1750 45500 13,500.00 - 6.320
- - - - - 6.320 5.115 1.205
14-Apr-08 195 8 1.99 50000 50000 2000 52000 20,000.00 1.932 - -
- - - - 1.932 1.932 0.000
16-Apr-08 226 20 20.01 50000 50250 2010 52260 20,260.00 - -
- - 19.427 - - 19.427 19.427 0.000
18-Apr-08 104701 20 12.98 42500 42500 1700 44200 12,200.00 - -
- - 12.602 - - 12.602 12.602 (0.000) 12mm 0
18-Apr-08 237 8 2.99 50000 50535 2021.4 52556 20,556.00 2.903 -
- - - - - 2.903 2.552 0.351
24-Apr-08 2008/BS1251 16 13.57 38498 46880 1875.2 48755 16,755.00 -
- - 13.175 - - - 13.175
25-Apr-08 2008/35403 8 9.34 37542 45787 1831.48 47618 15,618.00 9.068
- - - - - - 9.068 1.581 7.487
27-Apr-08 325 16 15.23 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - 14.786 - - - 14.786 16mm 20.893
27-Apr-08 325 20 8.23 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - - 7.990 - - 7.990 3.406 4.584
19.155 14124 270545.22
28-Apr-08 333 20 25.00 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - - 24.272 - - 24.272
1.738 14124 24547.512
3-May-08 389 16 9.77 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - 9.485 - - - 9.485
3-May-08 389 20 10.00 36975.58 42308.58 1692.3432 44001 12,001.00 -
- - - 9.709 - - 9.709 20mm 38.457
29-Feb-08 84003610 10 3.58 39711.53 39711.53 1588.4612 41300 9,300.00
- 3.476 - - - - - 3.476
19.388 14072 272827.936
8-May-08 427 8 5.00 37227.89 42597.89 1703.9156 44302 12,302.00 4.854
- - - - - - 4.854
19.069 14072 268338.968
8-May-08 427 20 20.00 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - - 19.417 - - 19.417
8-May-08 001402 32 24.94 37308 45519 1820.76 47340 15,340.00 - -
- - - - 24.214 24.214 25mm 0
8-May-08 001401 32 24.05 37308 45519 1820.76 47340 15,340.00 - -
- - - - 23.350 23.350
14-May-08 481 8 10.00 37227.89 42597.89 1703.9156 44302 12,302.00
9.709 - - - - - -
14-May-08 481 20 5.00 36975.78 42308.78 1692.3512 44001 12,001.00 -
- - - 4.854 - -
32mm. 0

Total Escalation Amount for RAB-01 905,312.14
QTY USED AS OF RAB-01 5.115 0 0 20.893 38.457 0 0

 

[Sean Timmons]

Unfortunately, the below is very hard to read. Could you reply with the
specific question you have?