成本核算表 (2).xls-淘文阁

资源描述

《成本核算表 (2).xls》由会员分享，可在线阅读，更多相关《成本核算表 (2).xls（32页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。

1、9da79897dd0a67086738a3696afcd4d1.xls成本构成比例劲帆472Q海帆472Q江字472Q劲帆462Q海帆462Q江字462Q劲帆DA462数量单价金额数量单价金额数量单价金额数量单价金额数量单价金额数量单价金额数量单价水泵壳体116206.9211210.4006.920.0006.920.0042376.6228048.946536.924518.7606.620.0006.62水封总成116202.604212.0002.600.0002.600.0042372.6011016.206532.601697.8002.600.0002.60轴连轴轴承11620

2、10.0016200.00010.000.00010.000.0042376.5027540.506536.504244.5006.500.0006.50叶轮116201.652673.0001.650.0001.650.0042371.656991.056531.651077.4501.650.0001.65法兰盘116202.103402.0002.100.0002.100.0042371.606779.206531.601044.8001.600.0001.60主材小计1620-37697.400-0.000-0.004237-80375.89653-12583.310-0.000-护罩

3、10.000.000.0042370.301271.106530.30195.9000.300.0000.30水泵垫116200.12194.4000.120.0000.120.0042370.08338.966530.0852.2400.080.0000.08M8双头螺栓10.000.000.000.000.000.0000.25小纸盒116200.761231.2000.760.0000.760.0042370.632669.316530.63411.3900.630.0000.63大纸箱0.11354.08550.8004.080.0004.080.00423.7 3.191351.60

4、65.33.19208.3103.190.0003.19塑料袋116200.12194.4000.120.0000.120.0042370.08338.966530.0852.2400.080.0000.08防伪商标116200.0464.8000.040.0000.040.0042370.04169.486530.0426.1200.040.0000.04116200.0456.7000.040.0000.040.0042370.04148.306530.0422.8600.040.0000.04合格证10.000.000.000.000.000.0000.01KB609胶摊销116200.

5、0348.5000.030.0000.030.0042370.03126.846530.0319.5500.030.0000.03辅材小计16202340.8000.0000.0042376414.55653988.6000.000合计162040038.2000.0000.00423786790.4465313571.9100.000KB609胶摊销表-数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率-16200.0348.5000.030.0000.030.0042370.03126.846530.0319.550

6、0.030.0000.03水泵生产投入制表时间：2011-02-22制表：张燕丽第 1 页，共 32 页9da79897dd0a67086738a3696afcd4d1.xls海帆DA462江字DA462劲帆465海帆465江字465劲帆DA465-2Q海帆DA465-2金额数量单价金额数量单价金额数量单价金额数量单价金额数量单价金额数量单价金额数量单价0.0006.620.0006.620.0010066.626659.725016.623316.6206.620.0007.500.0007.500.0002.600.0002.600.0010062.602615.605012.601302

7、.6002.600.0002.600.0002.600.0006.500.0006.500.0010066.506539.005016.503256.5006.500.0006.500.0006.500.0001.650.0001.650.0010061.651659.905011.65826.6501.650.0001.650.0001.650.0001.600.0001.600.0010061.601609.605011.60801.6001.600.0001.600.0001.600.000-0.000-0.00100619083.82501-9503.970-0.000-0.000-0

8、.0000.300.0000.300.0010060.30301.805010.30150.3000.300.0000.300.0000.300.0000.080.0000.080.0010060.0880.485010.0840.0800.080.0000.080.0000.080.0000.250.0000.250.0010060.25251.505010.25125.2500.250.000.000.0000.630.0000.630.0010060.63633.785010.63315.6300.630.0000.630.0000.630.0003.190.0003.190.00100

9、.63.19320.9150.13.19159.8203.190.0003.260.0003.260.0000.080.0000.080.0010060.0880.485010.0840.0800.080.0000.080.0000.080.0000.040.0000.040.0010060.0440.245010.0420.0400.040.0000.040.0000.040.0000.040.0000.040.0010060.0435.215010.0417.5400.040.0000.040.0000.040.0000.010.0000.010.0010060.0110.065010.0

10、15.0100.010.0000.040.0000.040.0000.030.0000.030.0010060.0330.125010.0315.0000.030.0000.030.0000.030.0000.0000.0010061784.58501-888.740-0.000-0.000-0.0000.0000.00100620868.40501-10392.710-0.000-0.000-金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率金额数量费用分配率0.0000.030.0000.030.0010060.0330.12501

11、0.0315.0000.030.0000.030.0000.03劲帆DA462成本构成比例水泵壳体1水封总成1轴连轴轴承1叶轮1法兰盘1主材小计护罩1水泵垫1M8双头螺栓1小纸盒1大纸箱0.1塑料袋1防伪商标11合格证1KB609胶摊销1辅材小计合计KB609胶摊销表-水泵生产投入第 2 页，共 32 页9da79897dd0a67086738a3696afcd4d1.xls江字DADA465-2合计金额数量单价金额数量单价金额0.0007.500.0080176.7153754.440.0002.600.0080172.6020844.200.0006.500.0080177.215778

12、0.500.0001.650.0080171.6513228.050.0001.600.0080171.7013637.200.000-0.008017-159244.390.0000.300.0063970.301919.100.0000.080.0080170.09706.160.000.0015070.25376.750.0000.630.0080170.665261.310.0003.260.00774.73.352591.440.0000.080.0080170.09706.160.0000.040.0080170.04320.680.0000.040.0080170.04280.6

13、00.0000.040.0015070.0115.070.0000.030.0080170.03240.000.000-0.008017-12417.270.000-0.008017-171661.66金额数量费用分配率金额数量费用分配率实际发生的金额0.0000.030.0080170.03240.00本表直接材料费用171661.66直接费用表材料费用171661.66间接费用分配表材料171661.66三表平衡情况海帆DA465-2成本构成比例水泵壳体1水封总成1轴连轴轴承1叶轮1法兰盘1主材小计护罩1水泵垫1M8双头螺栓1小纸盒1大纸箱0.1塑料袋1防伪商标11合格证1KB609胶摊销

14、1辅材小计合计KB609胶摊销表-水泵生产投入第 3 页，共 32 页成本构成比例劲帆462海帆462江字462劲帆474数量单价金额数量单价金额数量单价金额数量单价机油泵壳体1172114.7525384.75014.750.00014.750.001016.80齿轮,齿圈117217.0012047.0007.000.0007.000.00108.28机油泵盖板117213.806539.8003.800.0003.800.00103.40主要材料小计172125.5543971.5500.0000.0010z/1/4锥形螺117210.31533.5100.310.0000.310.0

15、0z/3/8锥形螺1*220.000.000.00200.66M12*1.25螺塞117210.40688.4000.400.0000.400.00弹簧117210.17292.5700.170.0000.170.00474弹簧10.000.000.00100.38阀芯117210.651118.6500.650.0000.650.00100.65定位销20.000.000.00200.04M6*12沉头螺钉6103260.05516.3000.050.0000.050.00600.05M6*12带垫螺钉117210.11189.3100.110.0000.110.00卡簧10.000.00

16、0.00100.06弹簧座10.000.000.00100.05小纸盒117210.901548.9000.900.0000.900.00100.95大纸箱1:10172.13.19549.0003.190.0003.190.0013.53塑料袋117210.08137.6800.080.0000.080.00100.12防伪商标或商标117210.0468.8400.040.0000.040.00100.04合格证117210.0460.2400.040.0000.040.00100.04474胶堵头大10.000.000.00100.30474胶堵头小10.000.000.00100.25

17、辅助材料小计17215703.3900.0000.0010合计-172128.8649674.9400.0000.001033.37机油泵生产投入制表时间：2011-02-22海帆474江字474劲帆DA465-2海帆DA465-2金额数量单价金额数量单价金额数量单价金额数量单价168.001016.80168.00016.800.004014.75590.001014.7582.80108.2882.8008.280.00407.00280.00107.0034.00103.4034.0003.400.00403.80152.00103.80284.8010284.8000.00401022

18、.00100.000.000.00400.3112.40100.3113.20200.6613.2000.660.000.000.000.000.00400.4016.00100.400.000.000.00400.176.80100.173.80100.383.8000.380.000.006.50100.656.5000.650.00400.6526.00100.650.80200.040.8000.040.000.003.00600.053.0000.050.002400.0512.00600.050.000.000.00400.114.40100.110.60100.060.6000.

19、060.000.000.50100.050.5000.050.000.009.50100.959.5000.950.00400.9036.00100.903.5313.533.5303.530.0043.1912.7613.191.20100.121.2000.120.00400.083.20100.080.40100.040.4000.040.00400.041.60100.040.35100.040.3500.040.00400.041.40100.043.00100.303.0000.300.000.002.50100.252.5000.250.000.0048.881048.8800.

20、0040132.5610333.6810333.6800.004028.861154.5610制表：张燕丽劲帆474江字DA465-2合计金额数量单价金额数量单价金额147.50014.750.00179114.7726458.2570.0007.000.0017917.0112562.6038.0003.800.0017913.806797.80255.5000.00179125.583 45818.653.1000.310.0017710.31549.010.000.00400.6626.404.0000.400.0017710.40708.401.7000.170.0017710.173

21、01.070.000.00200.387.606.5000.650.0017910.651164.150.000.00400.041.603.0000.050.00107460.05537.301.1000.110.0017710.11194.810.000.00200.061.200.000.00200.051.009.0000.900.0017910.901612.903.1903.190.00179.13.19572.010.8000.080.0017910.08144.080.4000.040.0017910.0471.640.3500.040.0017910.0462.690.000

22、.00200.306.000.000.00200.255.0033.1400.0017913.33165966.85288.6400.00179128.914 51785.50本表直接材料费用51785.50直接费用表材料费用51785.50间接费用分配表材料51785.50三表平衡情况海帆DA465-2成本构成比例劲帆462海帆462江字462其它型号数量单价金额数量单价金额数量单价金额数量单价包胶轴承19961.901892.4001.900.0031.905.700轴承10.000.000.000固定板19961.401394.4001.400.0031.404.200铆钉19960.7

23、5747.0000.750.0030.752.250限位套19960.30298.8000.300.0030.300.900主要材料小计996-4332.600-0.003-13.050-小纸盒19960.17169.3200.170.0030.170.510大纸箱0.0219.923.2063.7403.200.000.063.200.190塑料袋19960.0549.8000.050.0030.050.150商标或防伪商标19960.0439.8400.040.0030.040.120合格证19960.0434.8600.040.0030.040.110外加工费摊销19960.75747.

24、0000.750.0030.752.250尼龙材料费19960.62617.5200.620.0030.621.860辅助材料小计9961.731722.0800.0031.735.190合计-996-6054.680-0.003-18.240-张紧轮生产投入制表时间：2011-02-22劲帆474合计金额数量单价金额数量单价金额0.000.009991.901898.100.004809.504560.004809.504560.000.000.009991.401398.600.000.009990.75749.250.000.009990.30299.700.000-4560.00999

25、8.918905.650.004800.1781.6014790.17251.430.00243.2076.8043.983.20140.740.004800.0524.0014790.0573.950.004800.0419.2014790.0459.160.004800.0416.8014790.0451.770.000.009990.75749.250.000.009990.62619.380.000218.409991.951945.670.00480-4778.4099910.8610851.32制表：张燕丽本表直接材料费用10851.32直接费用表材料费用10851.32间接费用分

26、配表材料10851.32三表平衡情况其它型号间接费用分配表完工产品系列完工产品名称生产费用产品单位定额工资计入各种完工产品成本的生产费用产品生产数量单件产品工资定额（元）产品工资定额合计产品工资定额百分含量(费用分配率）%费用要素原材料辅助材料燃料和动力工资及福利制造费用煤油料水电小计工资加班工资其他小计维修费低耗品月初费用0.000.00状态本月发生的费用213968.6920329.790.002547.824224.006771.8231652.0031652.00515.0031068.63下期分配的费用0.000.000.000.000.000.000.000.000.000.00

27、0.000.00本月完工产品分配费用合计213968.6920329.790.002547.824224.006771.8231652.000.000.0031652.00515.0031068.63ABCDEFGH甲【1】【2】【3】【4】【5】【6】【7】【8】【9】【10】【11】【2】水泵系列472Q量材比例件劲帆件16200.901462.861.00本月费用分配37697.402340.800.00280.62457.02737.643424.640.000.003424.6455.723361.52海帆件00.900.000.00本月费用分配0.000.000.000.000.

28、000.000.000.000.000.000.000.00江字件00.900.000.00本月费用分配0.000.000.000.000.000.000.000.000.000.000.000.00小计件16200.901462.860.20本月费用分配小计37697.402340.800.00280.62457.02737.643424.640.000.003424.6455.723361.52462Q量材比例件劲帆件42370.903826.010.87本月费用分配80375.896414.550.00733.941195.311929.258956.910.000.008956.9

29、1145.748791.83海帆件653 0.90589.660.13本月费用分配12583.31988.600.00113.11184.22297.331380.430.000.001380.4322.461354.98江字件00.900.000.00本月费用分配0.000.000.000.000.000.000.000.000.000.000.000.00小计件48900.904415.670.61本月费用分配小计92959.207403.150.00847.051379.532226.5810337.340.000.0010337.34168.2010146.81DA462量材比例件劲

30、帆件00.900.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!海帆件00.900.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!江字件00.900.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV

31、/0!#DIV/0!小计件0#DIV/0!0.000.00本月费用分配小计0.000.000.000.000.000.000.000.000.000.000.000.00465量材比例件劲帆件10060.90908.420.67本月费用分配19083.821784.580.00174.26283.81458.072126.660.000.002126.6634.602087.46海帆件501 0.90452.400.33本月费用分配9503.97888.740.0086.78141.34228.121059.100.000.001059.1017.231039.58江字件00.900.00

32、0.00本月费用分配0.000.000.000.000.000.000.000.000.000.000.000.00小计件15070.901360.820.19本月费用分配小计28587.792673.320.00261.04425.14686.193185.760.000.003185.7651.833127.04DA465-2Q量材比例件劲帆件00.940.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!第 9 页，共 32 页间接费用分配表海帆件00

33、.940.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!江字件00.940.00#DIV/0!本月费用分配0.000.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!小计件0#DIV/0!0.000.00本月费用分配小计0.000.000.000.000.000.000.000.000.000.000.000.00合计件80170.907239.350.54本

34、月费用分配小计159244.3912417.270.001388.712261.703650.4116947.740.000.0016947.74275.7516635.38机油泵系列462机油泵量材比例件劲帆件17213.375792.891.00本月费用分配43971.555703.390.001111.241809.802921.0313561.480.000.0013561.48220.6513311.53海帆件03.370.000.00本月费用分配0.000.000.000.000.000.000.000.000.000.000.000.00江字件03.370.000.00本月费

35、用分配0.000.000.000.000.000.000.000.000.000.000.000.00小计件17213.375792.890.96本月费用分配小计43971.555703.390.001111.241809.802921.0313561.480.000.0013561.48220.6513311.53474机油泵量材比例件劲帆件104.0640.630.50本月费用分配284.8048.880.007.7912.6920.4995.120.000.0095.121.5593.36海帆件04.060.000.00本月费用分配0.000.000.000.000.000.000.0

36、00.000.000.000.000.00江字件104.0640.630.50本月费用分配284.8048.880.007.7912.6920.4995.120.000.0095.121.5593.36小计件204.0681.260.01本月费用分配小计569.6097.760.0015.5925.3940.97190.230.000.00190.233.10186.73AD465-2机油泵量材比例件劲帆件403.37134.640.80本月费用分配1022.00132.560.0025.8342.0667.89315.200.000.00315.205.13309.39海帆件103.37

37、33.660.20本月费用分配255.5033.140.006.4610.5216.9778.800.000.0078.801.2877.35江字件03.370.000.00本月费用分配0.000.000.000.000.000.000.000.000.000.000.000.00小计件503.37168.300.03本月费用分配小计1277.50165.700.0032.2852.5884.86394.000.000.00394.006.41386.74合计件17913.376042.4460.45本月费用分配小计45818.655966.8540.001159.111887.763046

38、.8714145.710.000.0014145.71230.1613885.00张紧轮系列张紧轮量材比例件462劲帆件996 0.21209.160.88本月费用分配4332.601722.08-65.3565.35489.660.000.00489.667.97480.63462海帆件00.210.000.00本月费用分配0.000.00-0.000.000.000.000.000.000.000.00462江字件30.210.630.00本月费用分配13.055.19-0.200.201.470.000.001.470.021.45其他张紧轮件00.000.000.00本月费用分配0.

39、000.00-0.000.000.000.000.000.000.000.00DA465-2Q完工产品系列完工产品名称生产费用产品单位定额工资计入各种完工产品成本的生产费用产品生产数量单件产品工资定额（元）产品工资定额合计产品工资定额百分含量(费用分配率）%费用要素原材料辅助材料燃料和动力工资及福利制造费用煤油料水电小计工资加班工资其他小计维修费低耗品月初费用0.000.00状态本月发生的费用213968.6920329.790.002547.824224.006771.8231652.0031652.00515.0031068.63下期分配的费用0.000.000.000.000.000.

40、000.000.000.000.000.000.00本月完工产品分配费用合计213968.6920329.790.002547.824224.006771.8231652.000.000.0031652.00515.0031068.63ABCDEFGH甲【1】【2】【3】【4】【5】【6】【7】【8】【9】【10】【11】【2】第 10 页，共 32 页间接费用分配表474劲帆件480 0.0628.800.12本月费用分配4560.00218.40-9.009.0067.420.000.0067.421.1066.18合计件14790.16238.590.02本月费用分配小计8905.65

41、1945.670.000.0074.5474.54558.550.000.00558.559.09548.26总计件112871.2013520.39100.00本月费用分配小计213968.6920329.790.002547.824224.006771.8231652.000.000.0031652.00515.0031068.63练算总计件112871.2013520.39-213968.6920329.790.002547.824224.006771.8231652.000.000.0031652.00515.0031068.63油料分配率0.191828张紧轮系列完工产品系列完工产品

42、名称生产费用产品单位定额工资计入各种完工产品成本的生产费用产品生产数量单件产品工资定额（元）产品工资定额合计产品工资定额百分含量(费用分配率）%费用要素原材料辅助材料燃料和动力工资及福利制造费用煤油料水电小计工资加班工资其他小计维修费低耗品月初费用0.000.00状态本月发生的费用213968.6920329.790.002547.824224.006771.8231652.0031652.00515.0031068.63下期分配的费用0.000.000.000.000.000.000.000.000.000.000.000.00本月完工产品分配费用合计213968.6920329.790.

43、002547.824224.006771.8231652.000.000.0031652.00515.0031068.63ABCDEFGH甲【1】【2】【3】【4】【5】【6】【7】【8】【9】【10】【11】【2】第 11 页，共 32 页间接费用分配表折旧费合计其他小计0.000.002388.0033971.636122.00312815.930.000.000.000.002388.0033971.636122.00312815.93【13】【14】【15】【16】258.373675.62662.3848538.470.000.000.000.000.000.000.000.0025

44、8.373675.62662.3848538.470.00675.769613.321732.41109022.33104.151481.59267.0016998.260.000.000.000.00779.9111094.911999.41126020.580.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.000.000.000.000.00160.452282.51411.3326146.9779.901136.72204.8513021.500.000.00

45、0.000.00240.353419.23616.1839168.470.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!制造费用第 12 页，共 32 页间接费用分配表#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.000.000.000.001278.6318189.763277.96213727.520.001023.1514555.342623.0183335.800.000.000.000.000.000.000.000.001023.1514555.342623.0183335.800.007.1810

46、2.0918.40569.770.000.000.000.007.18102.0918.40569.7714.35204.1836.791139.540.0023.78338.3060.961936.925.9584.5715.24484.230.000.000.000.0029.73422.8776.212421.141067.2315182.392736.0186896.480.0036.94525.5494.717229.930.000.000.000.000.111.580.2921.780.000.000.000.00折旧费合计其他小计0.000.002388.0033971.636

47、122.00312815.930.000.000.000.002388.0033971.636122.00312815.93【13】【14】【15】【16】制造费用第 13 页，共 32 页间接费用分配表5.0972.3613.044940.2242.14599.49108.0312191.932388.0033971.636122.00312815.932388.0033971.636122.00312815.93折旧费合计其他小计0.000.002388.0033971.636122.00312815.930.000.000.000.002388.0033971.636122.003128

48、15.93【13】【14】【15】【16】制造费用第 14 页，共 32 页直接费用分配表（水泵）产品名称水泵系列472Q462QDA462465DA465-2Q量材比例劲帆海帆江字小计量材比例劲帆海帆江字小计量材比例劲帆海帆江字小计量材比例劲帆海帆江字小计量材比例劲帆海帆江字小计产品直接消耗原材料耗用水泵壳体数量11620001620142376530489010000110065010150710000单价-6.926.926.92-6.626.926.62-6.626.626.62-6.626.626.62-7.507.507.50-金额-11210.400.000.0011210.40

49、-28048.944518.760.0032567.70-0.000.000.000.00-6659.723316.620.009976.34-0.000.000.000.00水封总成数量11620001620142376530489010000110065010150710000单价-2.602.602.60-2.602.602.60-2.602.602.60-2.602.602.60-2.602.602.60-金额-4212.000.000.004212.00-11016.201697.800.0012714.00-0.000.000.000.00-2615.601302.600.0039

50、18.20-0.000.000.000.00轴连轴轴承数量11620001620142376530489010000110065010150710000单价-10.0010.0010.00-6.506.506.50-6.506.506.50-6.506.506.50-6.506.506.50-金额-16200.000.000.0016200.00-27540.504244.500.0031785.00-0.000.000.000.00-6539.003256.500.009795.50-0.000.000.000.00叶轮数量1162000162014237653048901000011006

展开阅读全文