成本计算表_财务管理_经管营销_专业资料.xls

2013月份123456789收入0 34447.86 699870.1 530258.1873328 972511.524401.7 23547.011654021成本30510.2 661419.2 508750.9 860410.1 946828.6 19765.38187631551472成本率0.8856920.945060.95944 0.985208 0.9735910.81 0.7968320.938利润2668.37 38450.86 21507.22利润率0.0774612014月份123456789收入129494.9成本101006成本率0.78#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!利润2668.3700利润率#DIV/0!30000-76450.86219.448123850.001292101112162511284945.31547106 76450.7782984.30.9520.9101112#DIV/0!#DIV/0!81511.625008151.16289662.78科科目目余余额额查查询询分分析析结结果果表表查询条件：试算,2014年01期,(1211)原材料(仅最明细科目)会计期间 科目代码 科目名称 年初数量 年初外币余额 借贷 年初余额 年借方发生数 年借方外币发生额 年借方发生额 2014.011211.001原材料_铜丝0.2658借12,041.015.652279,939.922014.011211.002原材料_石蜡14.7852借59.142014.011211.003原材料_凡士林 78.7529借315.012014.011211.004原材料_炭黑 25,325.66借 143,493.002014.011211.005.001 原材料_辅料_DNP 4.199借75.442014.011211.005.003 原材料_辅料_VA-7 89.2421借1,891.932014.011211.005.004 原材料_辅料_大红粉366.1915借5,126.682014.011211.005.005 原材料_辅料_绿色189.0094借2,079.102014.011211.005.006 原材料_辅料_联苯胺黄15.9482借175.432014.011211.005.007 原材料_辅料_氧化锌168.748借1,518.732014.011211.005.008 原材料_辅料_硬脂酸76.158借700.622014.011211.005.009 原材料_辅料_氯化聚乙烯595.2301借7,141.312014.011211.005.010 原材料_辅料_轻质碳酸钙9.1154借3,895.482014.011211.006.001 原材料_无纺布_无纺布1,046.99借13,027.672014.011211.007.001 原材料_CPE胶料_CPE胶料0.4125借2,150.702014.011211.008.001 原材料_铝丝_铝丝 3.3456借50,415.45合计27,984.05借 244,106.705.652279,939.92核算单位：河北通利达线缆有限公司2014,打印日期：2014年02月15日,第/页 年贷方发生数 年贷方外币发生额 年贷方发生额 期初数量 期初外币余额 借贷 期初余额 本期借方发生数 本期借方外币发生额 本期借方发生额 0.2658借12,041.015.652279,939.9214.7852借59.1478.7529借315.0125,325.66借 143,493.004.199借75.4489.2421借1,891.93366.1915借5,126.68189.0094借2,079.1015.9482借175.43168.748借1,518.7376.158借700.62595.2301借7,141.319.1154借3,895.481,046.99借13,027.670.4125借2,150.703.3456借50,415.4527,984.05借 244,106.705.652279,939.92科科目目余余额额查查询询分分析析结结果果表表 本期贷方发生数 本期贷方外币发生额 本期贷方发生额 期末数量 期末单价 期末外币余额 借贷 期末余额 5.917849,339.44借 291,980.9314.78524借59.1478.75294借315.0125,325.665.67借 143,493.004.19917.97借75.4489.242121.2借1,891.93366.191514借5,126.68189.009411借2,079.1015.948211借175.43168.7489借1,518.7376.1589.2借700.62595.230112借7,141.319.1154427.35借3,895.481,046.9912.44借13,027.670.41255,213.82借2,150.703.345615,069.18借50,415.4527,989.71借 524,046.62科科目目余余额额查查询询分分析析结结果果表表查询条件：试算,2012年09期,(5101)主营业务收入(仅最明细科目)会计期间 科目代码 科目名称 年初数量 年初外币余额 借贷 年初余额 年借方发生数 年借方外币发生额 年借方发生额 2012.045101.01主营业务收入_主营业务收入0平7,389.00734,317.962012.04_003.001电缆_3*10+2*6平_003.002电缆_1*6_003.003电缆_2*2.5_003.004电缆_3*35_003.005电缆_5*10_003.006电缆_4*4_003.007电缆_2*1.5_003.008电缆_3*2.5+1_003.009电缆_10*1_003.010电缆_1*4_003.011电缆_1*1.5_003.012电缆_5*16_003.013电缆_19*1_003.014电缆_3*1_003.015电缆_5*6_003.016电缆_5*2.5_003.017电缆_5*1.5_003.018电缆_4*2.5_003.019电缆_4*1.5_003.020电缆_YC 3*952012.04平2012.04平2012.04平2012.04平2012.04平2012.04平合计平7,389.00734,317.96核算单位：河北通利达线缆有限公司,打印日期：2012年09月26日,第/页 年贷方发生数 年贷方外币发生额 年贷方发生额 期初数量 期初外币余额 借贷 期初余额 本期借方发生数 本期借方外币发生额 本期借方发生额 13,168.00#0平50048,290.60平35029,316.24平50823,446.15平60883,145.30平10124,602.56平402226,769.24平1002,393.16平18,947.00#平科科目目余余额额查查询询分分析析结结果果表表 本期贷方发生数 本期贷方外币发生额 本期贷方发生额 期末数量 期末单价 期末外币余额 借贷 期末余额 05862129,494.875,779.0091.756贷 129,494.87101006401,025.6450096.5812贷1,025.64799.99920.00792100.00341.88341.88296.6664 0.370833300982.05982.05765.999 2.5820217.00382.91382.91368.6698 0.48129310307.69307.69239.9982 0.650984100897.44897.44750.0032 3.1250372044.4444.4434.6632 0.04621735215.38215.38167.9964 4.846535160.001,025.641,025.64799.9992 4.762002100226.50226.50206.67 0.258338200169.23169.23151.9994 0.73546950.002,222.222,222.221853.332 12.19302370.005,376.075,376.073793.335 2.046765200.00495.73495.73386.6694 0.10193450824.79824.79703.33621.818962001,504.271,504.271173.331 1.66823610204,707.694,707.693671.998 3.1295515803,370.943,370.942679.333 0.72966617706,656.416,656.415192 1.93779555098,717.9598,717.9576970 14.824730035083.7607贷050846.1538贷0608136.7521贷0101243.5897贷0402564.1026贷010023.9316贷0380#11,558.00贷#人工电费铜铝其他辅料原材料合计1010.06 962.36693000人工电费7.999992 7.622248 736.894423.76094 23.72161760.616 765.12972083.07 2848.1992.966664 2.826584 263.17668.81135 18.88523 282.06187.659997.2983 657.941422.75109 70.34818 728.28963.686698 3.512619 322.391310.94994 28.12924 350.52052.399982 2.286659 219.31387.128236 8.869512 228.18337.500032 7.145895 701.804222.276 11.27708 713.08130.346632 0.330265 26.317661.029539 6.639107 32.956761.679964 1.600639 130.49174.989696 29.23438 159.72617.999992 7.622248 701.804223.76094 58.81182760.6162.0667 1.969114175.4516.138348 21.04479 196.49581.519994 1.448223 131.58834.514566 12.92833 144.516618.53332 17.658211754.5155.04618 7.583405 1762.09437.93335 36.14221 3083.552112.6666 523.0403 3606.5923.866694 3.684116 263.176611.48455 104.4575367.6347.0333626.70126 657.941420.88993 10.77021 668.711611.73331 11.17928 1096.56934.84933 18.99962 1115.56936.71998 34.98613 3355.501109.0628135.728 3491.22926.7933325.52822544.0479.57943 3.392033 2547.43251.92 49.46843 4658.225154.2087 278.1774 4936.403769.7 733.3562 68754.882286.102 4425.963 73180.840000000000000000000000000原材料其中铜辅料-2048.2 54012.98-56061.2原材料费用分配表单位:应借科目铜丝产品名称 销售数量 销售金额 截面积数量单价金额成品车间完工产品电缆_3*10+2*640.001,025.64 4214.935249.33944736.894404电缆_1*6100.00341.88 65.33449.33944263.176573电缆_2*2.5300.00982.05 513.33549.33944657.941432电缆_3*357.00382.91 1056.5341549.33944322.391302电缆_5*1010.00307.69 504.44549.33944219.313811电缆_4*4100.00897.44 1614.22449.33944701.804195电缆_2*1.520.0044.44 30.533449.3394426.3176573电缆_3*2.5+135.00215.38 8.52.64477549.33944130.491717电缆_10*1160.001,025.64 1014.22449.33944701.804195电缆_1*4100.00226.50 43.55649.33944175.451049电缆_1*1.5200.00169.23 1.52.66749.33944131.588286电缆_5*1650.002,222.22 8035.5649.339441754.51049电缆_19*1370.005,376.07 1962.496749.339443083.55218电缆_3*1200.00495.73 35.33449.33944263.176573电缆_5*650.00824.79 3013.33549.33944657.941432电缆_5*2.5200.001,504.27 12.522.22549.339441096.56905电缆_5*1.51,020.004,707.69 7.568.008549.339443355.50131电缆_4*2.5580.003,370.94 1051.56249.339442544.04021电缆_4*1.51,770.006,656.41 694.411849.339444658.22534电缆_YC 3*95550.0098,717.95 2851393.507549.3394468754.879700.000.00049.33944000.000.00049.33944000.000.00049.33944000.000.00049.33944000.000.00049.33944000.000.00049.33944000.000.00049.3394400049.339440049.3394400049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.33944049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440成品车间完工产品049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.339440049.3394400000000000000000000001828.87390235.57190777-188948铝丝绝缘料填充绳数量单价金额数量调整数量 单价金额数量0.00000000015.069000 0.0000000169.4508.212.32622256264.186323.87#1.6215.0690024.4117854.29164707.221.612.3262225266.24641.65#4.0515.0690061.02945#25.4276.2612.3262225939.99774.03#1.984515.0690029.904430530.61426768.6 9.5386750312.3262225117.57583.8#1.3515.0690020.3431568.033039212.32622250.00002.17#4.3215.0690065.09808#12.32622250.00000#0.16215.069002.44117815.681164712.32622250.00000#0.8032515.0690012.104174372.7841083 12.32622250.00000#4.3215.0690065.09808#12.32622250.00000#1.0815.0690016.2745234.774431412.32622250.00000#0.8115.0690012.2058925.435823512.32622250.00000#10.815.06900162.7452#12.32622250.00000#18.98115.06900286.024689#12.32622250.00000#1.6215.4035024.95367#12.32622250.000004.0515.4035062.384175#12.32622250.000006.7515.40350103.973625#12.32622250.0000020.65515.40350318.159293#12.32622250.0000015.6615.40350241.21881#12.32622250.0000028.67415.40350441.679959#12.32622250.00000423.22515.403506519.14629#12.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500#12.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.00000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.0000015.403500 0.000000012.32622250.000015.403500 0.000000012.32622250.000015.403500 0.000000012.32622250.000015.403500 0.000000012.32622250.000015.403500 0.000000012.32622250.000015.403500 0.000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.0000000012.32622250.000015.403500 0.00000000