针织面料成本核算.xls

《针织面料成本核算.xls》由会员分享，可在线阅读，更多相关《针织面料成本核算.xls（9页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Benchmark charges and lossRMB/KGLossFnishing BenchmarkKnitting charge2.50Yarn Dye$1.59/kgKnitting loss2.50%Jacquard$1.59/kgDyeing&Finishing charge10.50Brushed$0.16/kgdyeing&Finishing loss8.00%Carbon$0.25/kgEnzyme wash charge2.00Dyeing$1.67/kgEnzyme wash loss2.00%Printing$3.17/kgBrush charge1.00Brush

2、 loss1.50%Carbon charge(2 times)1.50Carbon loss2.00%使用说明黄色部分输入数字计算信息输入蓝蓝色色字字体体为为自自动动计计算算得得出出绿色部分可下拉选择无需理会针针织织面面料料成成本本计计算算 I.基基本本信信息息Date:2012.8.15 品名描述纱线280g/sm cvc 6040 拉毛绒布32s+50D+14S克重280gm/M2448gm/LY门幅170CM门幅描述MINIMUM CUTTABLEII.成成本本计计算算货币单位RMB组成纱纱线线描描述述成本 US$汇率占比纱比纱纱价价备注纱纱线线纱线132s 100%cotton co

3、mbed2.26US$/KG6.330.8%45.0%31.7纱线250D poly0.37US$/KG6.35.1%13.0%18 纱线314s t/c 65/351.39US$/KG6.318.9%42.0%20.8纱线4 0.00US$/KG6.3-纱纱线线成成本本=(J25+J26+J27+J28)/(1-J31)包含织造损耗4.13US$/KG56.1%100%织织造造织织造造费费 =O30/L300.40US$/KG6.35.4%2.5织织造造损损耗耗2.5%坯坯布布成成本本=(J29+J30)/(1-J40)/(1-J41)包含染整印花损耗5.00US$/KG 68.0%染染色色

4、费费 =O33/L331.83US$/KG6.324.8%11.5印印花花费费=O34/L34/H18*100（公斤价换成码价）0.00US$/KG6.3-/LY后后整整理理整理10.16US$/KG6.32.2%1整理2 0.00US$/KG6.3-整理3 0.00US$/KG6.3-整理4 0.00US$/KG6.3-后整总成本=35+J36+J37+J380.16US$/KG2.2%染染整整损损耗耗 9.5%印印花花损损耗耗0.0%检验包装成本 =O42/L420.00US$/KG6.3-额外费用销销售售，行行政政成成本本%0.0%利利润润 5.0%5.0%公公斤斤价价=(J32+J33

5、+J34+J39+J42)/(1-J43)/(1-J44)USD7.35/KGEUR 5.12 RMB46.3码码价价=K45*H18/1000USD3.29/LYEUR 2.30 RMB20.8ABCDEFGHIJKLMNOP使用说明黄色部分输入数字计算信息输入蓝蓝色色字字体体为为自自动动计计算算得得出出绿色部分可下拉选择无需理会 18 25262728293031323334353637383940414243444546ddlDrop Down ListCurrencyupdate4Please select15USD1.006 EUR0.707 RMB6.308 TWD30.409 T

6、HB33.5010 Malaysia RM3.2511 INDIA42.7612 Turkish Lira1.2113 Indonesia9,158.0014 Singapore1.3615 Pakistan70.7316 Japan106.9017 Korea1,016.5018 Canada1.0519 UK0.5120 Mexico10.2121 Brazil1.5922 Vietnam16,809.0023 Sri Lanka*107.6324Bangladesh*68.51 WidthIndicatorY/D?EDGE TO EDGEY/DFOLDEDMINIMUM CUTTABLEMINIMUM TUBULARVARIESPlease select