Costing _27.07.18.xlsx

  • Uploaded by: Muhammad Afzal
  • 0
  • 0
  • December 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Costing _27.07.18.xlsx as PDF for free.

More details

  • Words: 3,898
  • Pages: 20
Total Amount

S.No

1

Discreption

Chiller Cooling and Heating 300 Tr Air Cooled

2

PUMP

3

Hot Water Generator Generator HW PUMP 280 USGPM

4

ii iii iv v vi vii viii ix x xi xii xiii xiv xv xvi xvii xviii xix xx xxi xxii xxiii xxiv xxv xxvi xxvii xxviii

Unit

Qty.

Make

Basic

Nos

3

Trane

5050000

Discount

3% 2558.81141 85293.7137 94450.3969 2833.511907

Nos Nos

3 8

Kirlosker Kirlosker

Nos Nos

1 2

Rapid Cool Kirlosker

529930.8 88507.35

Nos Nos Nos Nos Nos

8 56 51 7 2

Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech

11000 11660 13200 17600 18700

Fan Coil Unit 1 TR 1.5 TR 2.0 TR 2.5 TR 3.0 TR

5 i

62999999

Air Handling Unit 9 TR ( 3900 cfm) 8 TR ( 3500 cfm) 10 TR(4500 cfm) 21 TR(9800cfm) 3.0 TR(2500 cfm) 5.5 TR(2500 cfm) 5.3 TR(2500 cfm) 12 TR(5300 cfm) 11 TR(5200 cfm) 10.5 TR ( 5800 cfm) 7 TR ( 3000cfm) 15 TR (5700 cfm) 6.5TR (2900cfm) 2.5TR (1200 cfm) 20 TR (7900 cfm) 5 TR (1900 cfm) 6 TR(2800 cfm) 5 TR (1800 cfm) 9 TR ( 3200 cfm) 12 TR ( 3800cfm) 6 TR (2100 cfm) 9 TR (2900cfm) 7 TR (2700 cfm) 10TR(3900 cfm) 11TR (4100 cfm) 6.25 TR (3700 cfm) 5 TR (3150 cfm) OT 6 TR (3500 cfm) OT

Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech

25% 127162.625 31790.65631 122309.846 30577.46148 152713.994 38178.49847 240658.239 60164.55984 95173.8963 23793.47408 95173.8963 23793.47408 95173.8963 23793.47408 160537.863 40134.46564 159349.427 39837.3567 185990.195 46497.54872 106265.963 26566.49083 184900.795 46225.19886 105869.818 26467.45452 63185.1674 15796.29184 226397.01 56599.25259 78832.9048 19708.22619 98937.2762 24734.31905 77545.4327 19386.35817 109534.162 27383.54041 125974.19 31493.54738 88439.4271 22109.85677 105869.818 26467.45452 97649.8041 24412.45103 127162.625 31790.65631 143899.762 35974.94052 124785.754 31196.43844 107454.399 26863.59977 122309.846 30577.46148

xxix xxx xxxi xxxii xxxiii

6 TR (3500 cfm) OT 6 TR (3500 cfm) OT 5.7 TR (3400 cfm) OT 7.2 TR (3800 cfm) OT Exhaust air unit 450 cfm

Nos Nos Nos Nos Nos

1.00 1.00 1.00 1.00 7.00

Edge Tech Edge Tech Edge Tech Edge Tech Edge Tech

122309.846 30577.46148 122309.846 30577.46148 111911.033 27977.75828 125974.19 31493.54738 88715.6863 22178.92156

Chilled Water Piping Burried 250 mm Dia 100 mm Dia

Nos Nos

130.00 130.00

Jindal Jindal

18% 2916.07842 874.823526 997.88031 179.6184558

i ii iii iv v vi vii viii ix x xi xii xiii

250 mm dia. 200 mm dia. 150 mm dia. 125 mm dia. 100 mm dia. 75 mm dia. 65 mm dia. 50 mm dia. 40 mm dia. 32 mm dia. 25 mm dia. 20 mm dia. 15 mm dia

Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos

900.00 450.00 200.00 300.00 1200.00 200.00 150.00 800.00 700.00 400.00 1500.00 600.00 400.00

Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal Jindal

2763.21799 497.3792389 2204.39944 396.7918987 1382.83872 248.9109687 1164.27883 209.5701889 920 165.6 646.48621 116.3675178 545.894149 98.26094682 416.970751 75.05473518 301.439275 54.2590695 258.888718 46.59996924 201.398746 36.25177428 136.661281 24.59903058 107.778412 19.40011416

7 i ii iii iv v vi vii viii ix x xi

2 Way Valve 150 mm dia 125 mm dia 100 mm dia 75 mm dia 65 mm dia 50 mm dia 40 mm dia 32 mm dia 25 mm dia 20 mm dia 15 mm dia

Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos

1.00 1.00 1.00 1.00 1.00 11.00 21.00 6.00 5.00 7.00 13.00

Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance

15% 90548.271 13582.24065 71789.5926 10768.43889 64057.8677 9608.68016 37605.4846 5640.822693 34386.612 5157.991798 21899.0164 3284.852462 18168.1742 2725.226128 17059.8671 2558.980067 14728.2795 2209.241925 14101.9337 2115.290059 14101.9337 2115.290059

i ii iii iv v vi vii viii ix x xi xii xiii

Butterfly Valve 250 mm dia. (200 mm dia. 150 mm dia. 125 mm dia. 100 mm dia. 80 mm dia. 65 mm dia. 50 mm dia. 40 mm dia. 32 25 20 15

Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos

4.00 12.00 1.00 16.00 6.00 1.00 54.00 63.00 105.00 30.00 25.00 35.00 65.00

Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance Advance

i ii iii

Balancing Valve (200 mm dia. 150 mm dia. 125 mm dia.

Nos Nos Nos

3.00 1.00 1.00

Advance Advance Advance

6 i ii

14758.4144 2213.762153 7653.81418 1148.072126 3674.61615 551.1924225 3224.1993 483.629895 2554.2726 383.14089 1999.32725 299.8990875 1842.5345 276.380175 1716.156 257.4234 1909.53373 286.4300588 1314.29441 197.1441615 772.36463 115.8546945 504.77167 75.7157505 372.020475 55.80307125 0 0 47526.087 7128.91305 22670.857 3400.62855 17257.472 2588.6208

iv v vi vii viii ix x xi xii

100 mm dia. 80 mm dia. 65 mm dia. 50 mm dia. 40 mm dia. 32 25 20 15

Nos Nos Nos Nos Nos Nos Nos Nos Nos

1.00 1.00 1.00 11.00 21.00 6.00 5.00 7.00 13.00

Advance Advance Advance Advance Advance Advance Advance Advance Advance

i ii iii

Non-Return Valve 200 mm dia 125 mm dia 100 mm dia

Nos Nos Nos

2.00 8.00 3.00

Advance Advance Advance

Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos Nos

3.00 8.00 1.00 1.00 1.00 11.00 21.00 6.00 5.00 7.00 13.00

Sant Sant Sant Sant Sant Sant Sant Sant Sant Sant Sant

Nos

50.00

Sant

Nos

1.00

Emrald

Nos

12.00 16.00

Nos Nos Nos

196.00 268.00 100.00 3.00

i ii iii iv v vi vii viii ix x xi xii

Y-Strainer 200 mm dia 125 mm dia 100 mm dia 75 mm dia 65 mm dia 50 mm dia 40 mm dia 32 mm dia 25 mm dia 20 mm dia 15 mm dia Ball Valve 25 mm dia

i

Expension Valve Emrald 1000 L

i ii

Flexible Coupling Emrald 250 150

i ii iii iv

Piping Acessories Emrald Pressure gauges V-grooved thermometers Auto air vent 15 mm dia. Pressure switch (for 200 mm)

v

Pressure switch (for 125 mm)

vi

Manual air vent (G.M. globe valve) 25 mm dia. Temperature Element (for 200 mm) Water Flow Switch suitable for 200 mm dia

Nos

viii

1776.61305 1270.82355 1061.181825 944.05395 651.96885 554.53875 417.8499 274.162875 211.348875

1643.6805 743.45955 529.75515

1902.78825 809.41425 633.39825 520.19625 461.308125 412.490475 300.995625 233.402175 217.630275 217.630275 217.630275 116.02863

284699.275 28469.9275

Resistoflex 8628.91625 862.891625 5276.28 527.628

H-Guru H-Guru H-Guru

304.7 720.2 842.08

10% 30.47 72.02 84.208

H-Guru

914.1

91.41

H-Guru

853.16

85.316

H-Guru

842.08

84.208

H-Guru

914.1

91.41

H-Guru

1662

166.2

8.00 Nos

vii

11844.087 8472.157 7074.5455 6293.693 4346.459 3696.925 2785.666 1827.7525 1408.9925 0 0 10957.87 4956.397 3531.701 0 0 12685.255 5396.095 4222.655 3467.975 3075.3875 2749.9365 2006.6375 1556.0145 1450.8685 1450.8685 1450.8685 0 773.5242

1.00 Nos 3.00 Nos 3.00 Nos

ix

Water Flow Switch suitable for 100 mm dia.

1.00 Nos

H-Guru

1357.3

135.73

Nos Nos Nos

Jindal Jindal Jindal

421 305 210

18% 75.78 54.9 37.8

Drain Piping i ii iii

Jindal 50 mm 40 mm 25 mm

400.00 400.00 2000.00

Ventilation Fan i ii iii i ii iii iv

Axial 5000 2500 Inline Fan (i) 75 cfm (ii) 100 cfm (iii) 150 cfm (iv) 200 cfm

v vi vii

(v) 100 cfm (vi) 200 cfm (vii) 900 cfm

Nos Nos

2.00 2.00

Fan Air Fan Air

25569.28 19755.588

10% 2556.928 1975.5588

Nos Nos Nos Nos

2.00 6.00 12.00 8.00

Fan Air Fan Air Fan Air Fan Air

3861.12063 4454.3505 4454.3505 4424.43975

386.1120625 445.43505 445.43505 442.443975

Nos Nos Nos

90.00 15.00 3.00

Fan Air Fan Air Fan Air

4454.3505 445.43505 4962.83325 496.283325 13230.8044 1323.080438

Sqm Sqm Sqm Sqm

3000 1500 300 200

Ductofab Ductofab Ductofab Ductofab

Sqm Sqm Sqm Sqm

500 500 10 10

Ductofab Ductofab Ductofab Ductofab

Sqm Sqm Sqm Sqm Sqm

15 42 60 35 35

Sqm Sqm Sqm Sqm

550 5500 500 1000

Nos Nos Nos Nos Nos Nos

Air Distribution System i ii iii iv i ii iii iv i ii iii iv v

Gi Duct 24 22 20 18 Al Duct 24 22 20 18 Smoke Damper With Actuator Fire Damper Actuator SAG VCD Louvers

397.230625 482.62375 583.08625 693.595 0 608.201875 688.571875 864.38125 1070.32938 6352.5 7938.75 6234.06 3775.3725 4686.9375

Insulation Work i ii iii iv

25 mm 9 Below 18 mm thicK Under Deck

Armacall Armacall Armacall Armacall

215 312 406 212

1 1

Cadlek Cadlek

700943.42 499871.384

1500 500 500 200

Skytone Skytone Skytone Skytone

154 171 220 2234

Electrical Works EP-1 EP-2 Power Cable 4 C X 10 4 C X 16 4 C X 25 4 C X 400 sqmm Al.

40% 61.6 68.4 88 893.6

2 C X 1.5 sqmm CU Cable Tray 100 mm 150 mm 200 mm 300 mm

Nos

4000

Nos Nos Nos Nos

500 1000 500 500

Nos Nos

2 2

Skytone

90

36

338.5648 135.42592 463.99824 185.599296 568.18892 227.275568 691.59924 276.639696

Air Curtain 3 Feet 5 Feet

Mitzva Mitzva

17752 31779.15

5% 887.6 1588.9575

Price

5050000

Total

0

Fittings

Freight

5050000

Paint

Insulation

Unit Rate

5050000

82734.90224 91616.88499

82734.9022 91616.885

3% 2482.04707 2748.50655

85216.94930772 94365.39154279

529930.8 88507.35

529930.8 88507.35

15897.924 2655.2205

545828.724 91162.5705

11000 11660 13200 17600 18700

330 349.8 396 528 561

11330 12009.8 13596 18128 19261

95371.9689 91732.3845 114535.495 180493.68 71380.4222 71380.4222 71380.4222 120403.397 119512.07 139492.646 79699.4725 138675.597 79402.3635 47388.8755 169797.758 59124.6786 74202.9571 58159.0745 82150.6212 94480.6421 66329.5703 79402.3635 73237.3531 95371.9689 107924.822 93589.3153 80590.7993 91732.3845

2861.15907 2751.97153 3436.06486 5414.81039 2141.41267 2141.41267 2141.41267 3612.10191 3585.3621 4184.77938 2390.98417 4160.2679 2382.07091 1421.66627 5093.93273 1773.74036 2226.08871 1744.77224 2464.51864 2834.41926 1989.88711 2382.07091 2197.12059 2861.15907 3237.74465 2807.67946 2417.72398 2751.97153

98233.12800563 94484.35598672 117971.5602684 185908.4899172 73521.83490141 73521.83490141 73521.83490141 124015.4988295 123097.4322127 143677.4255409 82090.45665891 142835.8644755 81784.43445328 48810.54179719 174891.6905147 60898.41891938 76429.04585484 59903.84675109 84615.13985531 97315.06138875 68319.45740578 81784.43445328 75434.47368656 98233.12800563 111162.5661933 96396.99477188 83008.52327578 94484.35598672

11000 11660 13200 17600 18700

95371.96894 91732.38445 114535.4954 180493.6795 71380.42223 71380.42223 71380.42223 120403.3969 119512.0701 139492.6462 79699.47248 138675.5966 79402.36355 47388.87553 169797.7578 59124.67856 74202.95714 58159.07452 82150.62122 94480.64213 66329.5703 79402.36355 73237.35309 95371.96894 107924.8215 93589.31531 80590.7993 91732.38445

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

91732.38445 91732.38445 83933.27484 94480.64213 66536.76469

2041.254894 818.2618542 2265.838755 1807.607538 1133.927746 954.7086381 754.4 530.1186922 447.6332022 341.9160158 247.1802055 212.2887488 165.1469717 112.0622504 88.37829784

76966.03035 61021.15371 54449.18757 31964.66193 29228.62019 18614.16395 15442.94806 14500.88704 12519.03758 11986.64367 11986.64367

12544.6522 6505.742049 3123.423728 2740.569405 2171.13171 1699.428163 1566.154325 1458.7326 1623.103666 1117.150249 656.5099355 429.0559195 316.2174038

40397.17395 19270.22845 14668.8512

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

91732.3845 91732.3845 83933.2748 94480.6421 66536.7647

2751.97153 2751.97153 2517.99825 2834.41926 1996.10294

94484.35598672 94484.35598672 86451.27308906 97315.06138875 68532.86762813

2041.25489 600 61.2376468 818.261854 300 24.5478556 15% AL Clading 2265.83876 339.8758133 67.9751627 1807.60754 271.1411308 54.2282262 1133.92775 170.0891619 34.0178324 954.708638 143.2062957 28.6412591 754.4 113.16 22.632 530.118692 79.51780383 15.9035608 447.633202 67.14498033 13.4289961 341.916016 51.28740237 10.2574805 247.180206 37.07703083 7.41540617 212.288749 31.84331231 6.36866246 165.146972 24.77204576 4.95440915 112.06225 16.80933756 3.36186751 88.3782978 13.25674468 2.65134894

2702.49254082 1142.809709826 125 100 100 100 100 100 100 100 100 100 100 100 100

2798.689730994 2232.976895241 1438.034740634 1226.556193005 990.192 725.540056796 628.2071785724 503.4608986676 391.67264249 350.5007235368 294.8734266296 232.2334554956 204.2863914512

76966.0304 61021.1537 54449.1876 31964.6619 29228.6202 18614.164 15442.9481 14500.887 12519.0376 11986.6437 11986.6437

11544.90455 2308.98091 9153.173057 1830.63461 8167.378136 1633.47563 4794.699289 958.939858 4384.293028 876.858606 2792.124593 558.424919 2316.442209 463.288442 2175.133057 435.026611 1877.855636 375.571127 1797.99655 359.59931 1797.99655 359.59931

90819.915813 72004.9613778 64250.04133419 37718.30107386 34489.77182096 21964.71346324 18222.67871157 17111.04671133 14772.4643385 14144.23952618 14144.23952618

12544.6522 6505.74205 3123.42373 2740.56941 2171.13171 1699.42816 1566.15433 1458.7326 1623.10367 1117.15025 656.509936 429.05592 316.217404

1881.69783 376.339566 975.8613073 195.172261 468.5135591 93.7027118 411.0854108 82.2170822 325.6697565 65.1339513 254.9142244 50.9828449 234.9231488 46.9846298 218.80989 43.761978 243.4655499 48.69311 167.5725373 33.5145075 98.47649033 19.6952981 64.35838793 12.8716776 47.43261056 9.48652211

14802.68959305 7676.775617525 3685.63999845 3233.8718979 2561.9354178 2005.32523175 1848.0621035 1721.304468 1915.262326175 1318.23729323 774.68172389 506.28598501 373.136536425

40397.174 6059.576093 2019.8587 19270.2285 2890.534268 963.511423 14668.8512 2200.32768 733.44256

48476.60874 23124.27414 17602.62144

10067.47395 7201.33345 6013.363675 5349.63905 3694.49015 3142.38625 2367.8161 1553.589625 1197.643625

10067.474 7201.33345 6013.36368 5349.63905 3694.49015 3142.38625 2367.8161 1553.58963 1197.64363

9314.1895 4212.93745 3001.94585

9314.1895 1397.128425 465.709475 4212.93745 631.9406175 210.646873 3001.94585 450.2918775 150.097293

11177.0274 5055.52494 3602.33502

10782.46675 4586.68075 3589.25675 2947.77875 2614.079375 2337.446025 1705.641875 1322.612325 1233.238225 1233.238225 1233.238225

10782.4668 4586.68075 3589.25675 2947.77875 2614.07938 2337.44603 1705.64188 1322.61233 1233.23823 1233.23823 1233.23823

1617.370013 539.123338 688.0021125 229.334038 538.3885125 179.462838 442.1668125 147.388938 392.1119063 130.703969 350.6169038 116.872301 255.8462813 85.2820938 198.3918488 66.1306163 184.9857338 61.6619113 184.9857338 61.6619113 184.9857338 61.6619113

12938.9601 5504.0169 4307.1081 3537.3345 3136.89525 2804.93523 2046.77025 1587.13479 1479.88587 1479.88587 1479.88587

657.49557 98.6243355 32.8747785

788.994684

256229.3475

256229.348

12811.4674

269040.814875

7766.024625 4748.652

7766.02463 4748.652

388.301231 237.4326

8154.32585625 4986.0846

274.23 648.18 757.872

274.23 648.18 757.872

13.7115 32.409 37.8936

287.9415 680.589 795.7656

822.69

822.69

41.1345

863.8245

767.844

767.844

38.3922

806.2362

757.872

757.872

37.8936

795.7656

822.69

822.69

41.1345

863.8245

1495.8

1495.8

74.79

1570.59

657.49557

1510.121093 503.373698 1080.200018 360.066673 902.0045513 300.668184 802.4458575 267.481953 554.1735225 184.724508 471.3579375 157.119313 355.172415 118.390805 233.0384438 77.6794813 179.6465438 59.8821813

12080.96874 8641.60014 7216.03641 6419.56686 4433.38818 3770.8635 2841.37932 1864.30755 1437.17235

1221.57

1221.57

345.22 250.1 172.2

345.22 250.1 172.2

17.261 12.505 8.61

61.0785

1282.6485

34.522 25.01 17.22

397.003 287.615 198.03

23012.352 17780.0292

23012.352 17780.0292

2301.2352 1778.00292

25313.5872 19558.03212

3475.008563 4008.91545 4008.91545 3981.995775

3475.00856 4008.91545 4008.91545 3981.99578

347.500856 400.891545 400.891545 398.199578

3822.50941875 4409.806995 4409.806995 4380.1953525

4008.91545 4466.549925 11907.72394

4008.91545 4466.54993 11907.7239

400.891545 446.654993 1190.77239

4409.806995 4913.2049175 13098.49633125

397.230625 482.62375 583.08625 693.595

397.230625 482.62375 583.08625 693.595

19.86153125 39.7230625 24.1311875 48.262375 29.1543125 58.308625 34.67975 69.3595

456.81521875 555.0173125 670.5491875 797.63425

608.201875 688.571875 864.38125 1070.329375

608.201875 688.571875 864.38125 1070.32938

30.41009375 60.8201875 34.42859375 68.8571875 43.2190625 86.438125 53.51646875 107.032938

699.43215625 791.85765625 994.0384375 1230.87878125

6352.5 7938.75 6234.06 3775.3725 4686.9375

6352.5 7938.75 6234.06 3775.3725 4686.9375

317.625 396.9375 311.703 188.768625 234.346875

7305.375 9129.5625 7169.169 4341.678375 5389.978125

215 312 406 212

700943.42 499871.384 92.4 102.6 132 1340.4

635.25 793.875 623.406 377.53725 468.69375

215 312 406 212

21.5 31.2 40.6 21.2

700943.42 499871.384

21028.3026 14996.1415 3% 2.772 3.078 3.96 40.212

92.4 102.6 132 1340.4

5% 4.62 5.13 6.6 67.02

80 80 80 80

316.5 423.2 526.6 313.2

721971.7226 514867.52552 99.792 110.808 142.56 1447.632

54

54

203.13888 278.398944 340.913352 414.959544

203.13888 278.398944 340.913352 414.959544

16864.4 30190.1925

16864.4 30190.1925

2.7 0 10.156944 13.9199472 17.0456676 20.7479772

1.62

58.32

6.0941664 8.35196832 10.2274006 12.4487863

219.3899904 300.67085952 368.18642016 448.15630752

1686.44 3019.01925

18550.84 33209.21175

TOTAL PROJECT VALUE

Total Supply Amoount

Transport

Installation

Total Amount Basic Installation S + ITC Amount

GST

Total Amount

0% 15150000

180000

540000

15690000

0

15690000

255650.848 754923.132

10% 8522 9437

25565.084792 281215.9327155 0 75492.313234 830415.4455766 0

281215.933 830415.446

545828.724 182325.141

27291 9116

27291.4362 18232.5141

573120.1602 200557.6551

0 0

573120.16 200557.655

90640 672548.8 693396 126896 38522

1133 1201 1360 1813 1926

9064 67254.88 69339.6 12689.6 3852.2

99704 739803.68 762735.6 139585.6 42374.2

0 0 0 0 0

99704 739803.68 762735.6 139585.6 42374.2

98233.128 94484.356 117971.56 185908.49 73521.8349 73521.8349 73521.8349 124015.499 123097.432 143677.426 82090.4567 142835.864 81784.4345 48810.5418 174891.691 60898.4189 76429.0459 59903.8468 84615.1399 97315.0614 68319.4574 81784.4345 75434.4737 98233.128 111162.566 96396.9948 83008.5233 94484.356

9823 9448 11797 18591 7352 7352 7352 12402 12310 14368 8209 14284 8178 4881 17489 6090 7643 5990 8462 9732 6832 8178 7543 9823 11116 9640 8301 9448

9823.3128006 9448.4355987 11797.156027 18590.848992 7352.1834901 7352.1834901 7352.1834901 12401.549883 12309.743221 14367.742554 8209.0456659 14283.586448 8178.4434453 4881.0541797 17489.169051 6089.8418919 7642.9045855 5990.3846751 8461.5139855 9731.5061389 6831.9457406 8178.4434453 7543.4473687 9823.3128006 11116.256619 9639.6994772 8300.8523276 9448.4355987

108056.4408062 103932.7915854 129768.7162953 204499.3389089 80874.01839155 80874.01839155 80874.01839155 136417.0487125 135407.1754339 158045.168095 90299.5023248 157119.450923 89962.87789861 53691.59597691 192380.8595662 66988.26081131 84071.95044033 65894.2314262 93076.65384084 107046.5675276 75151.40314636 89962.87789861 82977.92105522 108056.4408062 122278.8228126 106036.6942491 91309.37560336 103932.7915854

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

108056.441 103932.792 129768.716 204499.339 80874.0184 80874.0184 80874.0184 136417.049 135407.175 158045.168 90299.5023 157119.451 89962.8779 53691.596 192380.86 66988.2608 84071.9504 65894.2314 93076.6538 107046.568 75151.4031 89962.8779 82977.9211 108056.441 122278.823 106036.694 91309.3756 103932.792

94484.356 94484.356 86451.2731 97315.0614 479730.073

9448 9448 8645 9732 6853

9448.4355987 9448.4355987 8645.1273089 9731.5061389 47973.00734

103932.7915854 103932.7915854 95096.40039797 107046.5675276 527703.0807366

0 0 0 0 0

103932.792 103932.792 95096.4004 107046.568 527703.081

351324.03 148565.262

2400 960

312000 124800

663324.0303066 0 273365.2622774 0

663324.03 273365.262

2518820.76 1004839.6 287606.948 367966.858 1188230.4 145108.011 94231.0768 402768.719 274170.85 140200.289 442310.14 139340.073 81714.5566

2400 1920 1440 1200 960 720 720 480 480 360 240 240 240

2160000 864000 288000 360000 1152000 144000 108000 384000 336000 144000 360000 144000 96000

4678820.757895 1868839.602859 575606.9481268 727966.8579016 2340230.4 289108.0113592 202231.0767859 786768.7189341 610170.849743 284200.2894147 802310.1399444 283340.0732974 177714.5565805

0 0 0 0 0 0 0 0 0 0 0 0 0

4678820.76 1868839.6 575606.948 727966.858 2340230.4 289108.011 202231.077 786768.719 610170.85 284200.289 802310.14 283340.073 177714.557

90819.9158 72004.9614 64250.0413 37718.3011 34489.7718 241611.848 382676.253 102666.28 73862.3217 99009.6767 183875.114

1380 1150 920 690 690 460 460 345 230 230 230

1380 1150 920 690 690 5060 9660 2070 1150 1610 2990

92199.915813 73154.9613778 65170.04133419 38408.30107386 35179.77182096 246671.8480957 392336.2529429 104736.280268 75012.3216925 100619.6766832 186865.1138403

0 0 0 0 0 0 0 0 0 0 0

92199.9158 73154.9614 65170.0413 38408.3011 35179.7718 246671.848 392336.253 104736.28 75012.3217 100619.677 186865.114

59210.7584 92121.3074 3685.64 51741.9504 15371.6125 2005.32523 99795.3536 108442.181 201102.544 39547.1188 19367.0431 17720.0095 24253.8749

2300 1840 1380 1150 920 690 690 460 460 345 230 230 230

9200 22080 1380 18400 5520 690 37260 28980 48300 10350 5750 8050 14950

68410.7583722 114201.3074103 5065.63999845 70141.9503664 20891.6125068 2695.32523175 137055.353589 137422.181484 249402.5442484 49897.1187969 25117.04309725 25770.00947535 39203.87486763

0 0 0 0 0 0 0 0 0 0 0 0 0

68410.7584 114201.307 5065.64 70141.9504 20891.6125 2695.32523 137055.354 137422.181 249402.544 49897.1188 25117.0431 25770.0095 39203.8749

145429.826 23124.2741 17602.6214

1840 1380 1150

5520 1380 1150

150949.82622 24504.27414 18752.62144

0 0 0

150949.826 24504.2741 18752.6214

12080.9687 8641.60014 7216.03641 70615.2355 93101.1518 22625.181 14206.8966 13050.1529 18683.2406

920 690 690 460 460 345 230 230 230

920 690 690 5060 9660 2070 1150 1610 2990

13000.96874 9331.60014 7906.03641 75675.23546 102761.15178 24695.181 15356.8966 14660.15285 21673.24055

0 0 0 0 0 0 0 0 0

13000.9687 9331.60014 7906.03641 75675.2355 102761.152 24695.181 15356.8966 14660.1529 21673.2406

22354.0548 40444.1995 10807.0051

1840 1150 920

3680 9200 2760

26034.0548 49644.19952 13567.00506

0 0 0

26034.0548 49644.1995 13567.0051

38816.8803 44032.1352 4307.1081 3537.3345 3136.89525 30854.2875 42982.1753 9522.80874 7399.42935 10359.2011 19238.5163

1840 1150 920 690 690 460 460 345 230 230 230

5520 9200 920 690 690 5060 9660 2070 1150 1610 2990

44336.8803 53232.1352 5227.1081 4227.3345 3826.89525 35914.28753 52642.17525 11592.80874 8549.42935 11969.20109 22228.51631

0 0 0 0 0 0 0 0 0 0 0

44336.8803 53232.1352 5227.1081 4227.3345 3826.89525 35914.2875 52642.1753 11592.8087 8549.42935 11969.2011 22228.5163

39449.7342

230

11500

50949.7342

0

50949.7342

269040.815

13452

13452.040744 282492.8556188 0

282492.856

97851.9103 79777.3536

408 249

4892.5955138 102744.5057888 0 3988.86768 83766.22128 0

102744.506 83766.2213

56436.534 182397.852 79576.56

41 97 114

8062.362 26056.836 11368.08 370.2105

64498.896 208454.688 90944.64 2961.684

0 0 0 0

64498.896 208454.688 90944.64 2961.684

2591.4735

123 921.4128

7371.3024

0

7371.3024

6449.8896

115 113.6808

909.4464

0

909.4464

795.7656

114 370.2105

2961.684

0

2961.684

2591.4735

123 673.11

5384.88

0

5384.88

4711.77

224

183.2355

1465.884

0

1465.884

1282.6485

183

158801.2 115046 396060

395 360 320

158000 144000 640000

316801.2 259046 1036060

0 0 0

316801.2 259046 1036060

50627.1744 39116.0642

6000 4000

12000 8000

62627.1744 47116.06424

0 0

62627.1744 47116.0642

7645.01884 26458.842 52917.6839 35041.5628

1000 1000 1000 1000

2000 6000 12000 8000

9645.0188375 32458.84197 64917.68394 43041.56282

0 0 0 0

9645.01884 32458.842 64917.6839 43041.5628

396882.63 73698.0738 39295.489

1000 1000 2000

90000 15000 6000

486882.62955 0 88698.0737625 0 45295.48899375 0

486882.63 88698.0738 45295.489

1370445.66 832525.969 201164.756 159526.85

220 220 220 220

660000 330000 66000 44000

2030445.65625 1162525.96875 267164.75625 203526.85

0 0 0 0

2030445.66 1162525.97 267164.756 203526.85

349716.078 395928.828 9940.38438 12308.7878

220 220 220 220

110000 110000 2200 2200

459716.078125 505928.828125 12140.384375 14508.7878125

0 0 0 0

459716.078 505928.828 12140.3844 14508.7878

109580.625 383441.625 430150.14 151958.743 188649.234

150 150 150 150 150

2250 6300 9000 5250 5250

111830.625 389741.625 439150.14 157208.743125 193899.234375

0 0 0 0 0

111830.625 389741.625 439150.14 157208.743 193899.234

174075 2327600 263300 313200

100 100 100 100

55000 550000 50000 100000

229075 2877600 313300 413200

0 0 0 0

229075 2877600 313300 413200

721971.723 514867.526

7000 7000

7000 7000

728971.7226 521867.52552

0 0

728971.723 521867.526

149688 55404 71280 289526.4

109 118 150 300

163500 59213.5 75000 60000

313188 114617.5 146280 349526.4

0 0 0 0

313188 114617.5 146280 349526.4

233280

50

200000

433280

0

433280

109695 300670.86 184093.21 224078.154

50 50 50 50

25000 50000 25000 25000

134694.9952 350670.85952 209093.21008 249078.15376

0 0 0 0

134694.995 350670.86 209093.21 249078.154

37101.68 66418.4235

800 800

1600 1600

38701.68 68018.4235

0 0

38701.68 68018.4235

First Charge

Profit

Amount (S + E)

Rate (S + E)

5% 122500

784500

16597000

5532333.33333

10% 28121.5932715459 83041.5445576552

309337.525987005 913456.990134207

103112.508662 114182.123767

57312.01602 20055.76551

630432.17622 220613.42061

630432.17622 110306.710305

9970.4 73980.368 76273.56 13958.56 4237.42

109674.4 813784.048 839009.16 153544.16 46611.62

13709.3 14531.858 16451.16 21934.88 23305.81

10805.6440806188 10393.2791585391 12976.8716295281 20449.9338908906 8087.4018391547 8087.4018391547 8087.4018391547 13641.7048712484 13540.7175433922 15804.5168095031 9029.9502324797 15711.9450923016 8996.2877898609 5369.1595976906 19238.0859566156 6698.8260811313 8407.1950440328 6589.4231426203 9307.6653840844 10704.6567527625 7515.1403146359 8996.2877898609 8297.7921055219 10805.6440806188 12227.8822812609 10603.6694249063 9130.9375603359 10393.2791585391

118862.084886806 114326.07074393 142745.587924809 224949.272799797 88961.4202307016 88961.4202307016 88961.4202307016 150058.753583733 148947.892977314 173849.684904534 99329.4525572766 172831.396015317 98959.1656884703 59060.7555745969 211618.945522772 73687.0868924438 92479.1454843609 72483.6545688235 102384.319224928 117751.224280388 82666.5434609953 98959.1656884703 91275.7131607406 118862.084886806 134506.70509387 116640.363673969 100440.313163695 114326.07074393

118862.084887 114326.070744 142745.587925 224949.2728 88961.4202307 88961.4202307 88961.4202307 150058.753584 148947.892977 173849.684905 99329.4525573 172831.396015 98959.1656885 59060.7555746 211618.945523 73687.0868924 92479.1454844 72483.6545688 102384.319225 117751.22428 82666.543461 98959.1656885 91275.7131607 118862.084887 134506.705094 116640.363674 100440.313164 114326.070744

10393.2791585391 10393.2791585391 9509.6400397969 10704.6567527625 52770.3080736562

114326.07074393 114326.07074393 104606.040437766 117751.224280388 580473.388810219

114326.070744 114326.070744 104606.040438 117751.22428 82924.76983

66332.40303066 27336.526227738

729656.43333726 300701.788505118

5612.7417949 2313.09068081

467882.075789496 186883.960285854 57560.69481268 72796.685790156 234023.04 28910.80113592 20223.107678586 78676.871893408 61017.0849743 28420.028941472 80231.01399444 28334.007329736 17771.455658048

5146702.83368446 2055723.56314439 633167.64293948 800763.543691716 2574253.44 318018.81249512 222454.184464446 865445.590827488 671187.9347173 312620.318356192 882541.15393884 311674.080627096 195486.012238528

5718.55870409 4568.27458477 3165.8382147 2669.21181231 2145.2112 1590.09406248 1483.02789643 1081.80698853 958.839906739 781.55079589 588.360769293 519.456801045 488.715030596

9219.9915813 7315.49613778 6517.0041334193 3840.830107386 3517.9771820955 24667.1848095662 39233.6252942907 10473.628026798 7501.23216925 10061.9676683225 18686.5113840275

101419.9073943 80470.45751558 71687.0454676123 42249.131181246 38697.7490030505 271339 431569.878237198 115209.908294778 82513.55386175 110681.644351548 205551.625224303

101419.907394 80470.4575156 71687.0454676 42249.1311812 38697.7490031 24667 20550.9465827 19201.6513825 16502.7107724 15811.6634788 15811.6634788

6841.07583722 11420.13074103 506.563999845 7014.19503664 2089.16125068 269.532523175 13705.5353589 13742.2181484 24940.2544248375 4989.71187969 2511.704309725 2577.000947535 3920.3874867625

75251.83420942 125621.43815133 5572.203998295 77156.14540304 22980.77375748 2964.857754925 150760.8889479 151164.3996324 274342.798673212 54886.83067659 27628.747406975 28347.010422885 43124.2623543875

18812.9585524 10468.4531793 5572.2039983 4822.25908769 3830.12895958 2964.85775493 2791.86831385 2399.4349148 2612.78855879 1829.56102255 1105.14989628 809.914583511 663.450190068

15094.982622 2450.427414 1875.262144

166044.808842 26954.701554 20627.883584

55348.269614 26954.701554 20627.883584

1300.096874 933.160014 790.603641 7567.523546 10276.115178 2469.5181 1535.68966 1466.015285 2167.324055

14301.065614 10264.760154 8696.640051 83242.759006 113037.266958 27164.6991 16892.58626 16126.168135 23840.564605

14301.065614 10264.760154 8696.640051 7567.523546 5382.726998 4527.44985 3378.517252 2303.738305 1833.889585

2603.40548 4964.419952 1356.700506

28637.46028 54608.619472 14923.705566

14318.73014 6826.077434 4974.568522

4433.68803 5323.21352 522.71081 422.73345 382.689525 3591.428753 5264.217525 1159.280874 854.942935 1196.920109 2222.851631

48770.56833 58555.34872 5749.81891 4650.06795 4209.584775 39505.716283 57906.392775 12752.089614 9404.372285 13166.121199 24451.367941

16256.85611 7319.41859 5749.81891 4650.06795 4209.584775 3591.428753 2757.447275 2125.348269 1880.874457 1880.874457 1880.874457

5094.97342

56044.70762

1120.8941524

28249.285561875

310742.141180625

310742.141181

10274.450578875 8376.622128

113018.956367625 92142.843408

9418.24636397 5758.927713

6449.8896 20845.4688 9094.464 296.1684

70948.7856 229300.1568 100039.104 3257.8524

361.9836 855.5976 1000.39104 1085.9508

737.13024

8108.43264

1013.55408

90.94464

1000.39104

1000.39104

296.1684

3257.8524

1085.9508

538.488

5923.368

1974.456

146.5884

1612.4724

1612.4724

31680.12 25904.6 103606

348481.32 284950.6 1139666

871.2033 712.3765 569.833

6262.71744 4711.606424

68889.89184 51827.670664

34444.94592 25913.835332

964.50188375 3245.884197 6491.768394 4304.156282

10609.52072125 35704.726167 71409.452334 47345.719102

5304.76036063 5950.7876945 5950.7876945 5918.21488775

48688.262955 8869.80737625 4529.548899375

535570.892505 97567.88113875 49825.037893125

5950.7876945 6504.52540925 16608.3459644

203044.565625 116252.596875 26716.475625 20352.685

2233490.221875 1278778.565625 293881.231875 223879.535

744.496740625 852.51904375 979.60410625 1119.397675

45971.6078125 50592.8828125 1214.0384375 1450.87878125

505687.6859375 556521.7109375 13354.4228125 15959.66659375

1011.37537188 1113.04342188 1335.44228125 1595.96665938

11183.0625 38974.1625 43915.014 15720.8743125 19389.9234375

123013.6875 428715.7875 483065.154 172929.6174375 213289.1578125

8200.9125 10207.51875 8051.0859 4940.8462125 6093.9759375

22907.5 287760 31330 41320

251982.5 3165360 344630 454520

458.15 575.52 689.26 454.52

72897.17226 52186.752552

801868.89486 574054.278072

801868.89486 574054.278072

31318.8 11461.75 14628 34952.64

344506.8 126079.25 160908 384479.04

229.6712 252.1585 321.816 1922.3952

43328

476608

119.152

13469.49952 35067.085952 20909.321008 24907.815376

148164.49472 385737.945472 230002.531088 273985.969136

296.32898944 385.737945472 460.005062176 547.971938272

3870.168 6801.84235

42571.848 74820.26585

21285.924 37410.132925

5002955

62999999

Related Documents

Costing
December 2019 40
Costing
November 2019 42
Costing
November 2019 39
Costing
November 2019 42

More Documents from ""

Rao Rehan Irshad
May 2020 9
Resume Afzal
May 2020 10
A Davis
May 2020 11
Costing _27.07.18.xlsx
December 2019 13