文档说明：1、本文档为ExcelHome在线培训中心培训课程专用课件，版权归ExcelHome所有；2、本文档仅作为学员学习课程之用途，不得用于转让、出售、商业培训等任何营利性质的用途；也不得发布到互联网上(包括但不限于网站、论坛、微博、博客、网盘）提供收费下载；3、本文档中的单位名称或相关数据均为虚拟的信息，如有雷同，实属巧合；4、门户：http://www.excelhome.net技术论坛：http://club.excelhome.net培训中心：http://t.excelhome.net5、ExcelHome在线培训课程报名咨询QQ：4000049448财会玩转Excel——第7期培训中心课程官方微信:iexcelhome—第7期方微信:iexcelhome(表8-1）33100KG本期产量：17987KG累计产量：51087KG单位：元名称单位单价本月成本累计成本数量单位成本数量总成本数量单位成本数量累计总成本原材料：7.66137729.597.77397337.12硫酸2.26710.82971.8814,924.5533835.450.82101.7241,940.9188,075.54盐酸5.62750.96405.4317,340.0097580.850.94335.8048,190.00296,272.72玉米6.96020.00580.04104.11724.630.00270.02137.75958.77纸袋条2.69960.05520.15992.002678.010.05230.142,674.007,219.56内衬条0.59010.14080.082,533.001494.720.08420.054,299.002,536.75托盘个83.29060.00090.0817.001415.940.00050.0427.002,273.79动力及制造费：2.5345618.3897141.64水0.000.000.00000.000.000.00电0.6511653.390.00000.550.0028,095.93蒸汽0.549745.030.00000.590.0030,073.67工资1.2622671.760.00000.700.0035,981.65福利0.000.000.00000.000.000.00制造费用0.519239.050.00000.330.0016,799.92维修费0.000.000.00000.020.00769.29其它0.0000.00000.040.002,245.60氨水收入-0.43-41,798.11-7690.850.08-0.333,869.74-16,824.42合计10.19183347.979.68494478.762011年7月成本计算表产品名称：试剂一上期累计产量：KGKGKG(表8-2）14635KG本期产量：7927.5KG累计产量：22562.5KG单位：元名称单位单价本月成本累计成本数量单位成本数量总成本数量单位成本数量累计总成本原材料：6.5051542.966.74152082.67硫酸2.26710.72731.655,765.4513070.850.72731.5116,409.0934,082.32盐酸5.62750.80004.506,342.0035689.610.80005.0518,050.00113,956.02玉米6.95950.00580.0445.89319.370.00230.0252.25363.63纸袋条2.70090.05510.15437.001180.290.03350.09755.002,038.74内衬条0.58980.14090.081,117.00658.780.06430.041,451.00855.75托盘个89.15140.00090.087.00624.060.00040.039.00786.21动力及制造费：2.5320105.6039528.16水0.000.000.00000.000.000.00电0.655136.050.00000.530.0011,931.99蒸汽0.544294.970.00000.560.0012,615.79工资1.269992.240.00000.550.0012,508.08福利0.000.000.00000.000.000.00制造费用0.514071.970.00000.270.006,173.55维修费0.000.000.00000.010.00145.41其它0.0000.00000.060.001,269.40氨水收入-0.43-18,421.89-3389.63-0.43-0.23-9,789.74-5,116.06合计9.0471648.568.49191610.832014年7月成本计算表产品名称：试剂二上期累计产量：KGKGKG
