财会玩转Excel第7期-正式课12-5制造业成本计算表及成本管理框架设置.xlsx

文档说明：1、本文档为ExcelHome在线培训中心培训课程专用课件，版权归ExcelHome所有；2、本文档仅作为学员学习课程之用途，不得用于转让、出售、商业培训等任何营利性质的用途；也不得发布到互联网上(包括但不限于网站、论坛、微博、博客、网盘）提供收费下载；3、本文档中的单位名称或相关数据均为虚拟的信息，如有雷同，实属巧合；4、门 户：http:/ 技术论坛：http:/ 培训中心：http:/5、ExcelHome在线培训课程报名咨询QQ：4000049448财会玩转Excel第7期培训中心课程官方微信:iexcelhome财会玩转Excel第7期官方微信:iexcelhome(表8-1）2011年7月成本计算表产品名称：试试剂剂一一上期累计产量：33100 KG本期产量：17987 KG累计产量：51087 KG单位：元名称单位单价本月成本累计成本数量单位成本数量总成本数量单位成本数量累计总成本原原材材料料：7.667.66137729.59137729.597.777.77397337.12397337.12硫酸KG2.26710.82971.8814,924.5533835.450.82101.7241,940.9188,075.54盐酸KG5.62750.96405.4317,340.0097580.850.94335.8048,190.00296,272.72玉米KG6.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.532.5345618.3845618.3897141.6497141.64水电0.6511653.390.5528,095.93蒸汽0.549745.030.5930,073.67工资1.2622671.760.7035,981.65福利制造费用0.519239.050.3316,799.92维修费0.02769.29其它0.042,245.60氨水收入-0.43-41,798.11-7690.850.08-0.333,869.74-16,824.42合合计计10.19183347.97183347.979.68494478.76494478.76(表8-2）2014年7月成本计算表产品名称：试试剂剂二二上期累计产量：14635 KG本期产量：7927.5 KG累计产量：22562.5 KG单位：元名称单位单价本月成本累计成本数量单位成本数量总成本数量单位成本数量累计总成本原原材材料料：6.506.5051542.9651542.966.746.74152082.67152082.67硫酸KG2.26710.72731.655,765.4513070.850.72731.5116,409.0934,082.32盐酸KG5.62750.80004.506,342.0035689.610.80005.0518,050.00113,956.02玉米KG6.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.532.5320105.6020105.6039528.1639528.16水电0.655136.050.5311,931.99蒸汽0.544294.970.5612,615.79工资1.269992.240.5512,508.08福利制造费用0.514071.970.276,173.55维修费0.01145.41其它0.061,269.40氨水收入-0.43-18,421.89-3389.63-0.43-0.23-9,789.74-5,116.06合合计计9.0471648.5671648.568.49191610.83191610.83