电线报价、成本核算

报价时间：,2012年11月16日,,,,,,,,,,,,今日铜板价,,,,,,,,,,,,,铜板价,58000,,,,,,

成本核算系统,,,,,,,,,,,,,58000,,,电线各工序生产成本,,,,,,,,,,,,,,,,,

客户：,,,,,,,,制定：张仲文,,,,,,输入其他导体价格,,工序,,设备功率（KW/台）,设备成本（元）,人工成本（元）,当班产能（M),加工成本（元/M）,换算成HKD/M,,,,,,,,,,

型号规格：,,,,,,,,,,,,,铝,45.00,,绞铜,,5.5,396,150,250000,0.002184,0.002481818,,,,,,,,,,

导体,导体结构,,外径,导体,芯数,,材料比重（g/cm3）,重量,材料单价,工序加工成本,成本,,铜包铝,52.00,,芯线,铜包铝,43,516,300,190000,0.004294737,0.004880383,,,,单支线径,,材料价格,,,,

,条数,直径（mm）,（mm）,类别,,,,（kg/km）,,,(元/米）,,铜包钢,12.00,,,铜箔丝,43,516,300,190000,0.004294737,0.004880383,,,导体1,0.100,TS,68.00,,,,

导体1,7,0.100,0.30,TS,4,,8.9,2.0159,68.00,,0.1371,,铝镁合金,32.00,,,裸铜,43,516,300,250000,0.003264,0.003709091,,,,,AS,65.90,,,,铜价计算过程(隐藏）

导体2,7,0.120,0.36,TS,0,,8.9,0.0000,68.00,,0.0000,,,,,对绞,,5.5,264,150,180000,0.0023,0.002613636,,,导体2,0.120,TS,68.00,,,,

导体3,0,0.120,0.00,TS,8,,8.9,0.0000,68.00,,0.0000,,,,,总绞,,9.5,228,300,40000,0.0132,0.015,,,,,AS,65.60,,,,

地线1,0,0.150,0.00,TS,0,,8.9,0.0000,64.40,,0.0000,,,,,包铝箔,,1.5,72,300,20000,0.0186,0.021136364,,,导体3,0.120,TS,68.00,,,,

地线2,0,0.080,0.00,TS,0,,8.9,0.0000,72.50,,0.0000,,,,,编织,,2.5,180,300,15000,0.032,0.036363636,,,,,AS,65.60,,,,

外覆地线,0,0.102,0.00,TS,0,,8.9,0.0000,68.00,,0.0000,,,,,缠绕,,1.5,120,300,20000,0.021,0.023863636,,,地线1,0.150,TS,64.40,,,,

绝缘,绝缘颜色（mm）,,外径,材料,芯数,,材料比重（g/cm3）,重量,材料单价,,成本,,编织计算,,,外被押出,,70,840,900,70000,0.024857143,0.028246753,,,,,AS,62.00,,,,

,,,,,,,,（kg/km）,,,,,集合外径,3,,,,,,,,,,,,地线2,0.080,TS,72.50,,,,

芯线1,,,3.00,PVC,1,0,1.5,10.8118,15.70,,0.1697,,编织锭数,16,,,,,,,,,,,,,,AS,70.40,,,,

芯线2,,,0.00,PVC,0,,1.5,0.0000,9.40,,0.0000,,编织条数,4,,,,,,,,集合外径计算之绞合系数表,,,,外覆地线,0.102,TS,68.00,,,,

芯线3,,,0.00,HDPE,0,,1.6,0.0000,8.00,,0.0000,,,,,集合外径计算：,,,,,,芯数N,系数K值,,,,,AS,65.90,,,,

芯线（中被）,,,,,,,1.5,0.0000,9.00,,0.0000,,编织铜线径,0.1,,ID,芯数,系数,,,,2,2,,,,单支线径,,,,,,

屏蔽,结构,,外径,导体,芯数,,材料比重（g/cm3）,重量,材料单价,,成本,,编织目数,8,,3.00,1,1,,,,3,2.155,,,缠绕铜,0.100,TD,68.00,,,,

缠绕,条数,直径（mm）,,类别,,,,（kg/km）,,,,,反正切弧度,0.376873644,,过程参数,1.00E+00,ERROR,ERROR,ERROR,,4,2.414,,,,,AD,65.90,,,,

,41,0.1,3.20,TD,1,,8.89,2.9784,68.00,,0.2025,,夹角角度,21.59326923,,集合外径,3,,,,,5,2.7,,,编织铜,0.100,TD,68.00,,,,

编织,锭数,直径（mm）,/,类别,条数/密度%,,/,,,,,,正弦值,0.368015326,,,,,,,,6,3,,,,,AD,65.90,,,,

,16,0.1,3.40,AD,4,57%,8.89,5.0048,65.90,,0.3298,,F值,0.342334254,,,,,,,,7,3,,,,,,,,,,

包带,厚度,,包覆线径,重叠率,芯数,,材料比重（g/cm3）,重量(kg/km),材料单价,,成本,,cosα,0.929819725,,,,,,,,8,3.305,,,,,,,,,,

对绞非金属包带,0,,0.25,0.25,0,,1.0,0.0000,0.00,,0.0000,,,,,计算线号的公式,,,,,,9,3.613,,,,,,,,,,

集合非金属包带,0,,3.00,0.25,0,,1.4,0.0000,20.00,,0.0000,,编织率,56.75%,,Dm:,0.5,,,,,10,4,,,PE料价格,15.7,,,,,,

对绞包覆铝箔,0,,6.00,0.25,0,,2.0,0.0000,88.00,,0.0000,,重量,5.00,,AWG:,24,,,,,11,4,,,,,,,,,,

集合包覆铝箔,0,,3.20,0.25,1,,2.7,0.0000,30.00,,0.0000,,,,,,,,,,,12,4.155,,,,,,,,,,

外被,/,,外径,材料,芯数,,材料比重（g/cm3）,重量,材料单价,,成本,,,,,,,,,,,13,4.414,,,,,,,,,,

,,,（mm）,,,,,（kg/km）,,,,,,,,,,,,,,14,4.419,,,,,,,,,,

,0,,4.30,PVC/90C,1,,1.51,9.8088,9.40,,0.0922,,,,,,,,,,,15,4.549,,,,,,,,,,

,,,,,,,总重（kg/km）：,30.6197,,总成本:,0.9314,,,,,,,,,,,16,4.7,,,,,,,,,,

,,,,,,,,,,0,,,,,,,,,,,,17,5,,,,,,,,,,

報價/FT,報價/M,毛利,,,,,,输入其他加工成本,,0.01,0.9414,,,,,,,,,,,18,5,,,,,,,,,,

0.33,1.0957,15.00%,,,,,,,,,,,,,,,,,,,,19,5,,,,,,,,,,

,,毛利率,报价/M,绝对值,,,,不含税成本,,,毛利,,价格为,绝对值,,,,,,,,20,5.305,,,,,,,,,,

7.52E+00,,35.00%,1.4329,152.96,,,,0.7960,,,15.00%,,1.11,50.6683,,导体重量（Kg),单支线径(mm),导体条数(条）,芯线条数（条）,导体密度,导体长度（M）,21,5.305,,,,,,,,,,

,,输入价格,毛利率为,绝对值为,,,,不含税单价,,,有其他加工成本价格,,,,,20.128,0.16,17,1,8.89,6623.9965,22,5.613,,,,,,,,,,

,,2.5000,62.74%,478.43,,,,1.2247,不含税报价,,,,,,,,,,,,,23,5.613,,,,,,,,,,

,,输入绝对值,报价为,毛利率为,,,毛利率,12.00%,1.3917,,,,,,,,,,,,,24,6,,,,,,,,,,

,,150.00,1.4232,34.56%,,,,,,,,,,,,,,,,,,25,6,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,26,6,,,,,,,,,,

,,,,,,,缠绕屏蔽率,,,,,,,,,,,,,,,27,6.155,,,,,,,,,,

单位换算,,,,,,,42.10%,,,,,,,,每KFT线材重量（Kg）,,,,,,,28,6.155,,,,,,,,,,

米数（mm）,英寸（inch）,,,,,,,,,,,,,,,9.3390,,,,,,29,6.414,,,,,,,,,,

1,0.0394,,,,,,,,,,,,,,你的线材长度（M）,,线材重量为（Kg）,,,,,30,6.414,,,,,,,,,,

,,,,,,,,,,,,,,,,305.00,9.3390,,,,,31,6.7,,,,,,,,,,

英寸（inch）,米数（mm）,,,,,,,,,,,,,,你的线材重量（Kg）,,你的线材长度（M）,,,,,32,6.7,,,,,,,,,,

1,25.4000,,,,,,,,,,,,,,,7.0000,228.61,,,,,33,6.7,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,34,7,,,,,,,,,,

mil,米数（mm）,,,,,,,,,,,,,,绞铜产量计算,,,,,,,35,7,,,,,,,,,,

26,0.6604,,,,,,,,,,,,,,,条数（条）,线径（mm）,绞距,转速（R/min）,产量（Kg/小时）,M/小时,36,7,,,,,,,,,,

,,,,,,,,,,,,,,,,16,0.150,120,2000,72,28644.3092,37,7,,,,,,,,,,

米数（mm）,mil,,,,,,,,,,,,,,,,,,,,,38,7.305,,,,,,,,,,

1,39.3700,,,,,,,,,,,,,,,,,,,,M/分钟,39,7.305,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,477.4052,40,7.305,,,,,,,,,,

,,,,,,,,,,,,,,,通电截面积计算,,,,,,,41,7.613,,,,,,,,,,

,,,,,,,,,,,,,,,,导体单支线径,导体条数,通电截面积,,,,42,7.613,,,,,,,,,,

,,,,,,,,,,,,,,,,0.254,21,1.0641,,,,43,7.613,,,,,,,,,,

,,,,,,,,,,,,,,,,0.120,7,0.0792,,,,44,8,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,45,8,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,46,8,,,,,,,,,,

,,,,,,,,,,,,,,,缠绕屏蔽率计算,,,,,,,47,8.1,,,,,,,,,,

,,,,,,,,,,,,,,,,绞合外径,缠绕铜线条数,缠绕铜线线径,缠绕屏蔽率,100%缠绕需要铜线根数,,48,8.155,,,,,,,,,,

,,,,,,,,,,,,,,,,1.80,53,0.12,105.44%,50,,49,8.5,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,50,8.5,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,需求长度(M),,,,,,,,,,,,

,,,,,,,,,,,,,,,,用量计算,,,,,10000,,,,,,,,,,,,

,,,,,,,,,,,,,,,,包带用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,集合外径,厚度,密度,用量（Kg/KFT),用量（Kg/M),计算用量（Kg）,,,,,,,,,,,,

,,,,,,,,,,,,,,,,2.414,0.025,2.7,0.1972,0.0006,6.4651,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,缠绕用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,单支线径,缠绕条数,密度,用量（Kg/KFT),用量（Kg/M),计算用量（Kg）,,,,,,,,,,,,

,,,,,,,,,,,,,,,,0.1,36,8.89,0.7976,0.0026,26.1514,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,导体用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,单支线径,条数,密度,用量（Kg/KFT),用量（Kg/M),计算用量（Kg）,,,,,,,,,,,,

,,,,,,,,,,,,,,,,0.15,11,8.89,0.5429,0.0018,17.7993,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,绝缘用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,