中润110车间物料盘存核算表.xls

《中润110车间物料盘存核算表.xls》由会员分享，可在线阅读，更多相关《中润110车间物料盘存核算表.xls（30页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。

1、备注：1、手工录入原辅料消耗表和附表1-6.2、每周录入1次。110 车车 间间 原原 材材 料料 消消 耗耗 总总 结结 表表2007年4.10-4.17产品中间体在制品系数:期初结存本期领料本期总量名称1.002.003=1+21.原材料数量金 额数量金 额数量7-ACA3295.001768030.782860.001534618.806155.00噻二唑3995.00198186.250.000.003995.00焦亚硫酸钠537.00939.971000.001750.401537.00三乙胺1.008.560.000.001.00EDTA 432.505134.640.000.00

2、432.50盐酸1212.00914.124670.003522.245882.00丙酮20991.00131538.76-2432.00-15239.9718559.00小计336722.30-9,967.33计2104753.091,524,651.472.辅助材料活性炭116.00494.39200.00852.00316.00计3.包装材料塑料袋486.002245.090.000.00486.00计合合计计2107492.571,524,651.47工资制造费经费动力费合合计计1.在制品产量：606.38备2.在制品系数：0.15注110 车车 间间 原原 材材 料料 消消 耗耗 总

3、总 结结 表表2007年4.10-4.17产品头孢唑啉酸在制品系数:材料期初结存本期领料本期总量名称1.002.003=1+2原材料数量金 额数量金 额数量中间体3264.951968250.663350.462,018,392.076615.41二氯甲烷14823.0054076.632500.009,120.3917323.00四氮唑乙酸1828.00221882.011500.00182,069.483328.00三乙胺2159.0018730.255600.0048,582.417759.002.6-二甲基吡啶154.3015389.800.000.00154.30特戊酰氯1490.3

4、723499.20800.0012,613.892290.37四甲基胍909.3034844.351360.0052,115.162269.30液氮29241.0018267.1666540.0041,568.2495781.00丙酮536.003362.152432.0015,255.122968.00乙酸乙酯10185.0065224.410.000.0010185.00盐酸5958.004492.478350.006,296.0914308.00醋酸钠2796.0017702.275000.0031,656.417796.00醋酸1441.007376.421000.005,118.96

5、2441.00国产氧化铝-1405.00-48036.85500.0017,094.97-905.0032%液碱37433.0022039.0113580.007,995.3551013.0030%液碱2439.001197.902000.00982.284439.00片碱0.000.000.000.000.00小计460047.18430,468.76计2428297.842,448,860.830.00纸桶52.000.00114.001,810.37166.00标签824.00172.490.000.00824.00计172.490.001,810.37合合计计2428470.342,4

6、50,671.20工资制造费经费动力费合合计计1.在制品产量276.00公斤备2.在制品系数:0.05注110 车车 间间 原原 材材 料料 消消 耗耗 总总 结结 表表2007年4.10-4.17产品头孢唑啉钠在制品系数:材料期初结存本期领料本期总量名称1.002.003=1+21.原材料数量金 额数量金 额数量唑啉酸2845.631878275.672966.781,950,289.175812.41碳酸氢钠1279.293939.030.000.001279.29计1882214.700.002.辅助材料除菌板478.001447.40400.001,211.22878.00酒精826.

7、003447.451000.004,173.661826.00氢氧化钠120.00806.730.000.00120.00氟利昂27.525172.1061.2911,520.5088.81计10,873.6816,905.383.包装材料铝瓶584.0022954.31900.0035,385.871484.00胶圈326.00375.901500.001,725.651826.00纸箱618.002727.581120.005,006.911738.00打包带20.00121.390.000.0020.00打包扣6384.0055.660.000.006384.00标签1765.00348

8、.650.000.001765.00计26583.4942,118.430.00工资制造费经费动力费合合计计1910245.5959,023.81备1.在制品产量1318.20公斤2.在制品系数:0.25注0.15产量:本月用量期末盘存本月实际4=3-6在制品5实物6小计7=5+68=4-5金 额数量 金 额数量金 额数量 金 额 数量金 额数量3302649.583915.00600.002240.002840.001523887.053315.00198186.252285.00350.001710.002060.00102193.661935.002690.371083.00166.00

9、454.00620.001085.25917.008.561.000.000.000.000.001.005134.64220.0034.00212.50246.502926.45186.004436.375882.00901.000.00901.00679.564981.00116298.794313.00661.0014246.0014907.0093413.763652.00326754.98200298.683629404.561724185.741346.39196.0030.00120.00150.00639.11166.002245.09186.0028.00300.00328.

10、001515.20158.003631649.65 1726340.053451611.04在制品系数:从中间体丙酮期初转入唑林酸丙酮期初2432公斤.0.05产量:入库量本月用量期末盘存本月实际4=3-6在制品5实物6小计7=5+68=4-5金 额数量 金 额数量 金 额 数量 金 额 数量金 额数量3986642.734262.36233.002353.052586.051558430.614029.3663197.033478.00190.0013845.0014035.0051201.893288.00403951.491943.00106.001385.001491.00180977

11、.071837.0067312.662904.00159.004855.005014.0043498.612745.0015389.8072.704.0081.6085.608537.7068.7036113.081866.34102.00424.03526.038294.101764.3486959.521878.70103.00390.60493.6018914.741775.7059835.4181781.004465.0014000.0018465.0011535.2877316.0018617.262968.00162.000.00162.001016.172806.0065224.

12、413035.00166.007150.007316.0046851.432869.0010788.566251.00341.008057.008398.006332.285910.0049358.683046.00166.004750.004916.0031124.592880.0012495.392091.00114.00350.00464.002375.201977.00-30941.89475.0026.00(1380.00)(1354.00)(46293.17)449.0030034.3631713.001732.0019300.0021032.0012382.7829981.002

13、180.181319.0072.003120.003192.001567.731247.000.000.000.000.000.00#DIV/0!0.00890515.94#DIV/0!4877158.670.00#DIV/0!1810.37131.007.0035.0042.000.00124.00172.49131.007.00693.00700.00146.54124.001982.87146.544879141.54#DIV/0!在制品系数:#DIV/0!0.25产量:本月用量期末盘存本月实际4=3-6在制品5实物6小计7=5+68=4-5金 额数量 金 额数量金 额数量 金 额 数量

14、金 额数量3828564.855138.661284.00673.751957.751289546.483854.663939.03989.46247.00289.83536.831652.94742.463832503.881652.942658.62198.0049.00680.00729.002207.44149.007621.111090.00272.00736.001008.004207.05818.00806.7318.004.00102.00106.00712.6114.0016692.6015.264.0073.54877.5514576.4611.2627,779.06217

15、03.5758340.181062.00265.00422.00687.0027007.89797.002101.551056.00264.00770.001034.001190.03792.007734.49808.00202.00930.001132.005037.65606.00121.3915.004.005.009.0054.6311.0055.660.000.006384.006384.0055.660.00348.651117.00279.00648.00927.00183.11838.0068701.910.000.0033528.973044.003903864.415688

16、5.48在制品系数:本周:3350.46公斤累 计:本月单耗上月累计用量金 额实际单价数量计划金额实际金额数量金额1778762.53536.580.9894530.89530.8953063.0028006735.9495992.5949.610.577528.6528.6530362.001510582.101605.121.750.27370.480.4814182.5024833.788.568.560.00030.000.00415.003552.012208.1911.870.05550.660.663123.5037091.753756.810.751.48671.121.127

17、9957.0060457.5022885.026.271.09006.836.8358183.00361681.83126456.291905218.82615.39568.63568.6330004934.91707.284.260.04950.210.212465.0010468.70729.884.620.04720.220.221184.005469.410.220.221905948.71620.01568.85569.0630010404.3230010404.324.5216.440.0012.401909762.02633.631171.32602.4260040173.02本

18、月:4779.58公斤本月:1812.8公斤本月单耗上月累计用量金 额实际单价数量计划金额实际金额数量金额2428212.12602.630.8430507.84508.0253556.5731968658.2311995.143.650.68792.512.5146948.00173845.27222974.43121.380.384346.6546.6524299.002950740.1323814.068.680.57434.984.9836146.00312646.866852.1099.740.01441.441.44962.6696075.0027818.9815.770.3691

19、5.825.8223252.64364962.0268044.7838.320.371514.2414.2423286.26906166.3248300.120.6216.176310.1110.11955147.00595843.1117601.096.270.58713.683.6829847.00186227.5218372.986.400.60033.843.8430077.00191400.484456.280.751.23650.930.9390910.0068690.8618234.096.330.60263.823.8255557.00351498.6510120.195.12

20、0.41362.122.1233831.00171804.3515351.2834.190.09393.213.218054.00275355.7517651.580.596.27273.693.69550388.00322936.47612.450.490.26090.130.139409.004511.110.000.000.00000.000.007.0015.64512199.552940411.67615.01615.1838941377.780.000.000.02590.410.00346.00207.6325.960.210.02590.010.00344.0072.0125.

21、960.420.002940437.63615.43615.1838941657.425.9116.720.0019.572962495.007.03657.3838941657.42本周:3958.72公斤本月单耗上月累计用量金 额实际单价数量计划金额实际金额数量金额2539018.37658.690.9737640.09641.3657640.2437861846.152286.093.080.18760.580.5811034.1633946.612286.09661.77640.67641.9437895792.75451.183.030.03760.110.112124.006434

22、.183414.064.170.20660.860.8624015.00101214.3794.126.720.00350.020.02205.001384.492116.13187.970.00280.530.53137.5825859.286075.491.521.53134892.3331332.3039.310.20137.917.9111843.00465563.79911.511.150.20010.230.2311647.0013415.752696.834.450.15310.680.685922.0026780.4166.776.070.00280.020.02280.001

23、699.270.000.000.00000.000.000.000.00165.530.200.21170.040.0411747.002173.6935172.9451.188.888.88509632.91652.353.0641.580.0031.7137910.21715.98727.42728.7038540317.9856856.82公斤本年累累计单耗单价计用量 数量金额累计单价数量计划金额 累计金额56378.0029785498.47528.320.9916532.06523.87536.5832297.001606574.6949.740.568028.1828.2549.6

24、115099.5026438.901.750.26560.460.471.75416.003560.578.560.00730.060.068.563309.5039299.9411.870.05820.690.6911.8784938.0064214.310.761.49391.131.130.7561835.00384566.856.221.08766.826.766.2731910153.73569.40561.23672.572631.0011175.984.250.04630.200.204.261342.006199.304.620.02360.110.114.620.110.11

25、31916353.0331916353.03569.51561.3463852945.671139.371123.04累 计:68377.84公斤累计入库量：8183.80公斤本年累累计单耗单价计用量 数量金额累计实际单价数量计划金额 实际金额57585.9334396870.35597.310.8422507.36503.06602.4250236.00185840.413.700.73472.682.723.6526136.003173714.56121.430.382246.3946.41121.3838891.00336460.918.650.56884.934.928.681031.

26、36102927.1099.800.01511.511.5199.7425016.98392781.0015.700.36595.775.7415.7725061.96974211.1038.870.366514.0414.2538.321032463.00644143.230.6215.09949.439.420.6232653.00203828.616.240.47753.002.986.2732946.00209773.466.370.48183.093.076.4096820.0073147.140.761.41601.071.070.7558437.00369732.756.330.

27、85465.415.416.3335808.00181924.545.080.52372.682.665.128503.00290707.0334.190.12444.254.2534.19580369.00340588.050.598.48775.004.980.5910656.005123.560.480.15580.080.070.497.0015.642.230.00010.000.002.2341881789.450.00612.45470.00207.630.440.00690.110.0015.88468.0097.970.210.00680.000.000.210.004188

28、2095.06616.80612.4542426511.73624.80620.41累 计:63204.33公斤本年累累计单耗单价计用量 数量金额累计实际单价数量累计计划金额累计实际金额61494.9040400864.52656.980.9730639.63639.24657.3811776.6236232.703.080.18630.570.573.0840437097.21640.20639.81667.062273.006885.353.030.03600.110.113.0324833.00104628.434.210.39291.641.664.17219.001478.616.7

29、50.00350.020.026.72148.8427975.41187.960.00240.450.45187.97140967.812.222.2412640.00496896.0939.310.20007.867.8639.3212439.0014327.261.150.19680.230.231.156528.0029477.244.520.10330.460.474.47291.001766.036.070.00460.030.036.070.000.000.000.00000.000.000.0012585.002339.230.190.19910.040.040.203044.0

30、0544805.850.04828.628.6251.2141122870.88651.04650.67 110车间项项目目名名称称上上月月成成本本本本周周成成本本成成本本差差异异唑唑林林钠钠单耗价格成本单耗单耗价格成本1231*2中间体唑林酸4564*576-3一一、原原辅辅材材料料单单位位0.9731571.520.98940.84300.9737569.29-2.23碳酸氢钠kg0.18643.080.5740.18763.080.580.00除菌板kg0.03543.030.1070.03763.030.110.01酒精kg0.40634.171.6960.20664.170.86-0

31、.83氢氧化钠kg0.00266.720.0170.00356.720.020.01氟利昂kg0.0027187.970.5080.0028187.970.530.02二氯甲烷kg0.69893.652.5500.68790.66983.652.44-0.11四氮唑乙酸kg0.3712121.3845.0610.38430.3742121.3845.420.36三乙胺kg0.55178.684.7870.57430.55928.684.850.062.6-二甲基吡啶kg0.014899.741.4750.01440.014099.741.40-0.08特戊酰氯kg0.355215.775.60

32、00.36910.359415.775.670.07四甲基胍kg0.358338.3213.7300.37150.361738.3213.860.13液氮kg15.70740.629.81316.176315.75090.629.840.03丙酮kg0.55176.273.4610.58710.57176.273.590.12乙酸乙酯kg0.05446.400.3480.60030.58456.403.743.39盐酸kg1.42230.751.0721.23651.20400.750.91-0.16醋酸钠kg0.84656.335.3590.60260.58686.333.71-1.64醋酸

33、kg0.55415.122.8360.41360.40275.122.06-0.77国产氧化铝kg0.117734.194.0260.09390.091434.193.13-0.9032%液碱kg8.30920.594.8926.27276.10770.593.60-1.3030%液碱kg0.28330.490.1390.26090.25400.490.12-0.01片碱kg0.00012.230.0000.00000.00002.230.000.007-ACAkg0.8120536.58435.6820.98940.8121536.58435.770.09噻二唑kg0.468049.6123

34、.2150.57750.474049.6123.520.30焦亚硫酸钠kg0.22231.750.3890.27370.22471.750.390.00三乙胺kg0.00208.560.0180.00030.00028.560.00-0.02EDTA kg0.048311.870.5730.05550.045611.870.54-0.03盐酸kg1.22490.750.9241.48671.22030.750.920.00丙酮kg1.05146.276.5891.09000.89476.275.61-0.98活性炭kg0.03654.260.1560.04950.04064.260.170.0

35、2其他kg-4.08-4.0800.00二二、包包装装材材料料8.709.070.37塑料袋0.01234.61950.060.04720.0400.03874.620.180.12纸桶0.000215.88050.000.02590.000015.880.000.00酸签0.00020.20930.000.02590.00000.210.000.00铝瓶0.201439.31767.920.201339.327.910.00胶圈0.19901.15040.230.20011.150.230.00纸箱0.09394.47050.420.15314.470.680.26打包带0.00476.06

36、960.030.00286.070.02-0.01打包扣0.00000.00000.000.00000.000.000.00标签0.22230.19750.040.21170.200.040.00三三、直直接接人人工工31.66934.422.75中间体工资12.6610.3720.00合成酸工资12.3970.00唑啉钠工资8.908.9000.00福利费四四、动动力力费费用用43.34145.972.63中间体8.827.2260.00合成酸13.5460.00唑啉钠22.5722.5700.00电五五、制制造造费费用用69.07069.07090.2790.2721.2014.8912.

37、1990.0014.7910.0042.0842.0800.00成成本本合合计计.724.30749.0324.73周分析：（本周原辅料成本比上月降低2.23元/Kg）1、本周无菌室减少工器具、管路的酒精清洗次数，使酒精使用量比上月减少，造成本周酒精成本比上月降低。2、本周因离心机漏粉和使用噻二唑残留高的中间体投料，使唑林酸收率比上月降低，造成四氮唑乙酸成本比上月升高。3、本周乙酯为正常单耗，由于上月外卖丙酮废液返还乙酯，使上月乙酯单耗降低，造成本周乙酯成本比上月升高。4、本周生产奥奇德唑林酸18批，不进行纯化工艺，即不用处理氧化铝柱，造成盐酸、醋酸钠、醋酸、32%液碱消耗比上月降低。5、本周

38、中间体收率比上月提高0.17%，并将中间体三合一设备的放空阀接入丙酮碳纤维中，提高了丙酮回收率，造成中间体丙酮单耗比上月降低。因本周产量比上月略低，造成人工、动力、制造成本比上月升高。唑林酸成本元/公斤表一(基)（）公公司司单单位位产产品品成成本本项项目目量量差差、价价差差分分析析表表2003年年 12 月月产品名称：唑啉钠产品计量单位：kg实际产量：8365.018365.01实际产量：8365.018365.01项项目目名名称称计计量量单单位位目目标标成成本本本本周周实实际际成成本本成成本本差差异异数数量量差差异异价价格格差差异异单单位位影影响响额额实实际际耗耗量量目目标标总总成成本本实实

39、际际总总成成本本总总成成本本差差异异差差异异分分析析单耗价格成本单耗价格成本单耗差异量差影响额单价差异价差影响额产产量量影影响响量量差差影影响响价价差差影影响响1231*24564*576-384-198*2105-21110*4129+11=713=4*实产14=3*标产15=6*实产1615-1417（实产-标产）*3189*实产 1911*实产一一、原原辅辅材材料料单单位位0.9737548.850.98940.84300.9737528.99-19.87-2.35-13.210.000.00-13_4,474,7164,364,252-110,4640-110,4640碳酸氢钠kg0.

40、21043.100.6520.18763.100.58-0.07-0.02-0.070.000.00-0.071,5695,4554,865-5900-5900除菌板kg0.04013.030.1210.03763.030.11-0.010.00-0.010.000.00-0.013151,016953-630-630酒精kg0.26054.241.1060.20664.240.88-0.23-0.05-0.230.000.00-0.231,7289,2497,336-1,9120-1,9120氢氧化钠kg0.00186.520.0120.00356.520.020.010.000.010.0

41、00.000.012998191930930氟利昂kg0.0053194.311.0220.0028194.310.54-0.480.00-0.480.000.00-0.48238,5484,551-3,9970-3,9970二氯甲烷kg0.85554.103.5090.68790.66984.102.75-0.76-0.19-0.760.000.00-0.765,60329,35022,978-6,3720-6,3720四氮唑乙酸kg0.3755121.3745.5680.38430.3742121.3745.41-0.150.00-0.150.000.00-0.153,130381,174

42、379,896-1,2780-1,2780三乙胺kg0.56598.584.8570.57430.55928.584.80-0.06-0.01-0.060.000.00-0.064,67840,62940,150-4790-47902.6-二甲基吡啶kg0.014695.221.3900.01440.014095.221.34-0.060.00-0.060.000.00-0.0611711,63011,168-4630-4630特戊酰氯kg0.359015.215.4620.36910.359415.215.470.010.000.010.000.000.013,00645,68645,737

43、510510四甲基胍kg0.358039.3214.0740.37150.361739.3214.220.150.000.150.000.000.153,026117,728118,9661,23801,2380液氮kg14.06180.628.65616.176315.75090.629.701.041.691.040.000.001.04131,75672,40981,1068,69808,6980丙酮kg0.41155.742.3610.58710.57175.743.280.920.160.920.000.000.924,78219,74727,4357,68907,6890乙酸乙酯k

44、g0.77166.354.9020.60030.58456.353.71-1.19-0.19-1.190.000.00-1.194,88941,00631,065-9,9410-9,9410盐酸kg1.54330.751.1611.23651.20400.750.91-0.26-0.34-0.260.000.00-0.2610,0719,7107,575-2,1350-2,1350醋酸钠kg0.90546.065.4830.60260.58686.063.55-1.93-0.32-1.930.000.00-1.934,90845,86129,721-16,1400-16,1400醋酸kg0.4

45、6304.612.1360.41360.40274.611.86-0.28-0.06-0.280.000.00-0.283,36917,86415,539-2,3250-2,3250国产氧化铝kg0.138933.484.6490.09390.091433.483.06-1.59-0.05-1.590.000.00-1.5976538,88525,605-13,2800-13,280032%液碱kg9.20820.605.5096.27276.10770.603.65-1.85-3.10-1.850.000.00-1.8551,09146,08430,567-15,5170-15,517030

46、%液碱kg0.10290.500.0510.26090.25400.500.130.070.150.070.000.000.072,1254271,05362706270片碱kg0.01032.090.0220.00000.00002.090.00-0.02-0.01-0.020.000.00-0.0201800-1800-18007-ACAkg0.8252482.00397.7520.98940.8121482.00391.45-6.31-0.01-6.310.000.00-6.316,7933,327,1963,274,448-52,7480-52,7480噻二唑kg0.477451.28

47、24.4810.57750.474051.2824.31-0.170.00-0.170.000.00-0.173,965204,786203,346-1,4390-1,4390焦亚硫酸钠kg0.20991.750.3680.27370.22471.750.390.03-1.12-6.690.000.00-6.69_189,010135,275-53,7350-55,9490三乙胺kg0.08238.580.7060.00030.00028.580.00-0.70-0.08-0.700.000.00-0.7025,90618-5,8880-5,8880EDTA kg0.057611.880.68

48、40.05550.045611.880.54-0.14-0.01-0.140.000.00-0.143815,7214,527-1,1940-1,1940盐酸kg1.23470.750.9291.48671.22030.750.92-0.01-0.01-0.010.000.00-0.0110,2087,7687,678-900-900丙酮kg1.91055.7410.9601.09000.89475.745.13-5.83-1.02-5.830.000.00-5.837,48491,68142,934-48,7470-48,7470活性炭kg0.04126.670.2740.04950.040

49、66.670.270.000.000.000.000.000.003402,2952,266-290-290其他kg0.0000.0000.00二二、包包装装材材料料9.049.310.260.000.000.000.000.00075,63977,8532,213000塑料袋0.01624.600.070.04720.03970.03874.600.180.10-0.02-0.060.000.00-0.06_69,00068,479-5210-5210纸桶0.010216.070.160.02590.000016.070.00-0.16-0.01-0.160.000.00-0.1601,36

50、50-1,3650-1,3650酸签0.01020.210.000.02590.00000.210.000.00-0.010.000.000.000.000180-180-180铝瓶0.198840.678.080.201340.678.190.100.000.100.000.000.101,68467,61868,47986208620胶圈0.19881.150.230.20011.150.230.000.060.220.000.000.22_4,1005,9531,85301,8530纸箱0.10014.280.430.15314.280.660.230.050.230.000.000.2