電線報價、成本核算_第1頁
電線報價、成本核算_第2頁
電線報價、成本核算_第3頁
電線報價、成本核算_第4頁
全文預(yù)覽已結(jié)束

付費下載

下載本文檔

版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進行舉報或認領(lǐng)

文檔簡介

報價時間:,2012年11月16日,,,,,,,,,,,,今日銅板價,,,,,,,,,,,,,銅板價,58000,,,,,,

成本核算系統(tǒng),,,,,,,,,,,,,58000,,,電線各工序生產(chǎn)成本,,,,,,,,,,,,,,,,,

客戶:,,,,,,,,制定:張仲文,,,,,,輸入其他導(dǎo)體價格,,工序,,設(shè)備功率(KW/臺),設(shè)備成本(元),人工成本(元),當(dāng)班產(chǎn)能(M),加工成本(元/M),換算成HKD/M,,,,,,,,,,

型號規(guī)格:,,,,,,,,,,,,,鋁,45.00,,絞銅,,5.5,396,150,250000,0.002184,0.002481818,,,,,,,,,,

導(dǎo)體,導(dǎo)體結(jié)構(gòu),,外徑,導(dǎo)體,芯數(shù),,材料比重(g/cm3),重量,材料單價,工序加工成本,成本,,銅包鋁,52.00,,芯線,銅包鋁,43,516,300,190000,0.004294737,0.004880383,,,,單支線徑,,材料價格,,,,

,條數(shù),直徑(mm),(mm),類別,,,,(kg/km),,,(元/米),,銅包鋼,12.00,,,銅箔絲,43,516,300,190000,0.004294737,0.004880383,,,導(dǎo)體1,0.100,TS,68.00,,,,

導(dǎo)體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,,,,銅價計算過程(隱藏)

導(dǎo)體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,,,導(dǎo)體2,0.120,TS,68.00,,,,

導(dǎo)體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,,,導(dǎo)體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),,外徑,材料,芯數(shù),,材料比重(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,,編織錠數(shù),16,,,,,,,,,,,,,,AS,70.40,,,,

芯線2,,,0.00,PVC,0,,1.5,0.0000,9.40,,0.0000,,編織條數(shù),4,,,,,,,,集合外徑計算之絞合系數(shù)表,,,,外覆地線,0.102,TS,68.00,,,,

芯線3,,,0.00,HDPE,0,,1.6,0.0000,8.00,,0.0000,,,,,集合外徑計算:,,,,,,芯數(shù)N,系數(shù)K值,,,,,AS,65.90,,,,

芯線(中被),,,,,,,1.5,0.0000,9.00,,0.0000,,編織銅線徑,0.1,,ID,芯數(shù),系數(shù),,,,2,2,,,,單支線徑,,,,,,

屏蔽,結(jié)構(gòu),,外徑,導(dǎo)體,芯數(shù),,材料比重(g/cm3),重量,材料單價,,成本,,編織目數(shù),8,,3.00,1,1,,,,3,2.155,,,纏繞銅,0.100,TD,68.00,,,,

纏繞,條數(shù),直徑(mm),,類別,,,,(kg/km),,,,,反正切弧度,0.376873644,,過程參數(shù),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,,,,

編織,錠數(shù),直徑(mm),/,類別,條數(shù)/密度%,,/,,,,,,正弦值,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,,,,,,,,,,

包帶,厚度,,包覆線徑,重疊率,芯數(shù),,材料比重(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,,,,,,,,,,

外被,/,,外徑,材料,芯數(shù),,材料比重(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,,導(dǎo)體重量(Kg),單支線徑(mm),導(dǎo)體條數(shù)(條),芯線條數(shù)(條),導(dǎo)體密度,導(dǎo)體長度(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,,,,,,,,,,

米數(shù)(mm),英寸(inch),,,,,,,,,,,,,,,9.3390,,,,,,29,6.414,,,,,,,,,,

1,0.0394,,,,,,,,,,,,,,你的線材長度(M),,線材重量為(Kg),,,,,30,6.414,,,,,,,,,,

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

英寸(inch),米數(shù)(mm),,,,,,,,,,,,,,你的線材重量(Kg),,你的線材長度(M),,,,,32,6.7,,,,,,,,,,

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

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

mil,米數(shù)(mm),,,,,,,,,,,,,,絞銅產(chǎn)量計算,,,,,,,35,7,,,,,,,,,,

26,0.6604,,,,,,,,,,,,,,,條數(shù)(條),線徑(mm),絞距,轉(zhuǎn)速(R/min),產(chǎn)量(Kg/小時),M/小時,36,7,,,,,,,,,,

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

米數(shù)(mm),mil,,,,,,,,,,,,,,,,,,,,,38,7.305,,,,,,,,,,

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

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

,,,,,,,,,,,,,,,通電截面積計算,,,,,,,41,7.613,,,,,,,,,,

,,,,,,,,,,,,,,,,導(dǎo)體單支線徑,導(dǎo)體條數(shù),通電截面積,,,,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,,,,,,,,,,

,,,,,,,,,,,,,,,,絞合外徑,纏繞銅線條數(shù),纏繞銅線線徑,纏繞屏蔽率,100%纏繞需要銅線根數(shù),,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,,,,,,,,,,,,

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

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

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

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

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

,,,,,,,,,,,,,,,,纏繞用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,單支線徑,纏繞條數(shù),密度,用量(Kg/KFT),用量(Kg/M),計算用量(Kg),,,,,,,,,,,,

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

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

,,,,,,,,,,,,,,,,導(dǎo)體用量,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,單支線徑,條數(shù),密度,用量(Kg/KFT),用量(Kg/M),計算用量(Kg),,,,,,,,,,,,

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

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

,,,,,,,,,,,,,,,,絕緣用量,,,,,,,,,,,,,,,,,

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

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論