电缆价格详细计算表

Sheet1 电缆价格详细计算 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 铜价 52,000.00 序号 主芯数 辅芯数 铜电线面积mm2 每米铜重量KG 每米铜价 辅料费（铜价5%） 材料费小计 人工费% 成本小计 管理费 利润 税金 出厂除税价 耐火电线电缆NH+10% 低烟无卤电缆WDZA+20% 低烟无卤电缆WDZB+15% 低烟无卤耐火电缆WDZAN+20% 低烟无卤耐火电缆WDZBN+15% 低烟无卤耐火电缆WDZCN WDZBN－KVV 1 5 4 0 0 20 0.178 9.25 0.462 9.708 0.971 10.679 0.534 1.602 1.351 14.165 15.58 17.00 16.29 18.70 17.92 17.14 20.61 2 5 6 0 0 30 0.267 13.87 0.693 14.562 1.456 16.018 0.801 2.403 2.026 21.248 23.37 25.50 24.44 28.05 26.88 25.71 30.91 3 5 10 0 0 50 0.445 23.11 1.156 24.270 2.427 26.697 1.335 4.005 3.377 35.413 38.95 42.50 40.73 46.75 44.80 42.85 51.52 4 5 16 0 0 80 0.711 36.98 1.849 38.832 3.883 42.715 2.136 6.407 5.403 56.661 62.33 67.99 65.16 74.79 71.68 68.56 82.43 5 4 25 1 16 116 1.031 53.62 2.681 56.306 5.631 61.936 3.097 9.290 7.835 82.158 90.37 98.59 94.48 108.45 103.93 99.41 119.52 6 4 35 1 16 156 1.387 72.12 3.606 75.721 7.572 83.294 4.165 12.494 10.537 110.489 121.54 132.59 127.06 145.85 139.77 133.69 160.73 7 4 50 1 25 225 2.000 104.01 5.201 109.214 10.921 120.135 6.007 18.020 15.197 159.359 175.30 191.23 183.26 210.35 201.59 192.82 231.83 8 4 70 1 35 315 2.800 145.62 7.281 152.899 15.290 168.189 8.409 25.228 21.276 223.103 245.41 267.72 256.57 294.50 282.22 269.95 324.56 9 4 95 1 70 450 4.001 208.03 10.401 218.427 21.843 240.270 12.014 36.041 30.394 318.718 350.59 382.46 366.53 420.71 403.18 385.65 463.66 10 4 120 1 70 550 4.890 254.25 12.713 266.967 26.697 293.663 14.683 44.050 37.148 389.544 428.50 467.45 447.98 514.20 492.77 471.35 566.69 11 4 150 1 70 670 5.956 309.73 15.486 325.214 32.521 357.735 17.887 53.660 45.254 474.536 521.99 569.44 545.72 626.39 600.29 574.19 690.33 12 4 185 1 95 835 7.423 386.00 19.300 405.304 40.530 445.834 22.292 66.875 56.398 591.399 650.54 709.68 680.11 780.65 748.12 715.59 860.34 13 4 240 1 120 1080 9.601 499.26 24.963 524.226 52.423 576.648 28.832 86.497 72.946 764.924 841.42 917.91 879.66 1,009.70 967.63 925.56 1,112.77 14 3 25 2 16 107 0.951 49.46 2.473 51.937 5.194 57.131 2.857 8.570 7.227 75.784 83.36 90.94 87.15 100.04 95.87 91.70 110.25 15 3 35 2 16 137 1.218 63.33 3.167 66.499 6.650 73.149 3.657 10.972 9.253 97.032 106.74 116.44 111.59 128.08 122.75 117.41 141.16 16 3 50 2 25 200 1.778 92.46 4.623 97.079 9.708 106.787 5.339 16.018 13.509 141.653 155.82 169.98 162.90 186.98 179.19 171.40 206.07 17 3 70 2 35 280 2.489 129.44 6.472 135.910 13.591 149.501 7.475 22.425 18.912 198.314 218.14 237.98 228.06 261.77 250.87 239.96 288.50 18 3 95 2 70 425 3.778 196.47 9.823 206.292 20.629 226.922 11.346 34.038 28.706 301.012 331.11 361.21 346.16 397.34 380.78 364.22 437.90 19 3 120 2 70 500 4.445 231.14 11.557 242.697 24.270 266.967 13.348 40.045 33.771 354.131 389.54 424.96 407.25 467.45 447.98 428.50 515.17 20 3 150 2 70 590 5.245 272.75 13.637 286.382 28.638 315.021 15.751 47.253 39.850 417.875 459.66 501.45 480.56 551.59 528.61 505.63 607.90 21 3 185 2 95 745 6.623 344.40 17.220 361.619 36.162 397.780 19.889 59.667 50.319 527.656 580.42 633.19 606.80 696.51 667.48 638.46 767.61 22 3 120 360 3.200 166.42 8.321 174.742 17.474 192.216 9.611 28.832 24.315 254.975 280.47 305.97 293.22 336.57 322.54 308.52 370.92 23 3 150 450 4.001 208.03 10.401 218.427 21.843 240.270 12.014 36.041 30.394 318.718 350.59 382.46 366.53 420.71 403.18 385.65 463.66 24 3 300 900 8.001 416.05 20.803 436.855 43.685 480.540 24.027 72.081 60.788 637.436 701.18 764.92 733.05 841.42 806.36 771.30 927.31 黄色为手动输入Sheet2 Sheet3