含公式-全-工业企业成本核算系统.xls

1、首页 成成本本核核算算系系统统初初始始化化区区材材料料类类别别名名称称设设置置、添添加加及及期期初初结结存存录录入入-序序号号材材料料名名称称及及规规格格期期初初结结存存数数量量单单价价期期初初结结存存金金额额1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23-24-25-26-27-28-29-30-31-32-33-34-35-36-37-38-39-40-41-42-43-44-45-46-47-48-49-50-51-52-53-54-55-56-57-58-59-60-61-62-63-64-65-66-67-68-

2、69-70-71-72-73-74-75-76-77-78-79-80-81-82-83-84-85-86-87-88-89-90-91-92-93-94-95-96-97-98-99-100-0合计：-0000000000000000002011年产产品品名名称称业业务务属属性性设设置置 材材料料名名称称设设置置提提示示：1、本系统材料明细帐及成本计算单均使用这里的材料名称，请分类设置材料名称。2、在这里，建议材料项目按材料、燃料、包装物的顺序排列为好，以便使成本计算单上的成本项目排列有序。3、材料类别名称不要重复。4，后增加的材料类别名称也在此添加进去（B列）。盘亏销售报废毁损其他减少业业

3、务务附附注注添添加加、修修改改发出退回（-）销售退回（-）首页 材材 料料 明明 细细 帐帐 （增增加加）合计：记记帐帐月月进货月进货日单号 进货地点税业业务务属属性性记事材材料料名名称称计量单位单价增加数量1 111 11增加金额结存数量结存金额业务属性添加修改列名称月份数量单价金额购入1购入退回（-）1盘盈1受赠1其他增加111111111111111111111Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z

4、1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1Z1累计数量累计金额ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ首页 材材 料料 明明 细细 帐帐 （发发出出）记帐月发出月份发出日单号 记事 业业务务附附注注发发出出对对象象及及属属性性材料名称单价表 单价发出数量1 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11

5、 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 159476000600060006,000.006,000.00-5319548039096010195470发出金额结存数量结存金额白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z

6、白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z 材材 料料 明明 细细 帐帐 （发发出出）白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸1Z白板纸

7、1Z白板纸1Z白板纸1Z白板纸1Z100月名称数量金额ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ盘亏ZZ销售ZZ报废ZZ毁损ZZ其他减少ZZZZZZZZZZ业务附注添加、修改ZZ发出退回（-）ZZ销售退回（-）ZZZZZZZ首页材材料料名名称称期期初初结结存存数数量量单单价价期期初初结结存存金金额额本本年年累累计计购购入入数数量量ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

8、ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ1 1 月月 份份 库库 存存 材材 料料 结结 存存 表表打印时间：本本年年累累计计购购入入金金额额本本年年累累计计发发出出数数量量本本年年累累计计发发出出金金额额本本期期结结存存单单价价本本期期结结存存数数量量2014/9/24选择月份11 1 月月 份份 购购 入入 材材 料料 汇汇 总总 表表本本期期结结存存金金额额购入月份名称本月购入数量本月平均购入单价1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00

9、1.001.001.001.001.001.001.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1

10、.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z1.00Z100.00 选择月份22 2 月月份份发发出出材材料料汇汇总总表表本月购入金额发出月份名称本月发出数量2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00

11、Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00Z2.00

12、Z2.00Z2.00Z2.00Z2.00Z2.00Z本月发出金额123456789101112月月份份发发出出材材料料汇汇总总表表首页分配表一1 1 月月份份工工资资及及福福利利费费分分配配表表应分配工资总额应分配福利费总额45,000.0045,000.005,000.005,000.00产品品种分配标准工资分配率福利费分配率分配的工资分配的福利费合合计计1000100045.045.05.05.045,000.0045,000.005,000.005,000.0070045.05.031,500.003,500.0030045.05.013,500.001,500.0045.05.0-45

13、.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.

14、0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45

15、.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-45.05.0-合计10003825.045,000.005,000.00分配表二1 1 月月份份电电分分配配表表电应分配总额5,000.005,000.00分配的工资及福利费合计产品品种分配标准分配率分配额50,00050,000合合计计100010005.005.005,0005,00035,000.007005.003,500.0015,000.003005.001,500.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00

16、-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00

17、-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-5.00-50,000.00合计1000425.005,000.00分配表三（自定义）分配表四（自定义）1 1 月月份份N3N3分分配配表表1 1N3应分配总额产品品种分配标准分配率分配额产品品种合合计计-合合计计合计合计分配表五月月份份N4N4分分配配表表1 1 月月份份N4 应分配总额分配标准分配率分配额产品品种分配标准合合计计10001000700300分配表四（自定义）合计1000分配表六（选用）制制造造费费用用分分配配表表1 1 月月份份管管理理费费用用制造费用应分配总额管理费用6,

18、000.006,000.00分配率分配额产品品种分配标准分配率6.006.006,0006,000合合计计1000100020.0020.006.004,200.0070020.006.001,800.0030020.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.0

19、06.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.00分配表五6.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-

20、20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-20.006.00-

21、20.006.00-20.006.00-20.006.00-20.006.00-20.00510.006,000.00合计10001,700.00分配表七（自定义）分分配配表表1 1 月月份份N7N7分分配配表表应分配总额N7应分配总额20,000.0020,000.001,000.001,000.00分配额产品品种分配标准分配率分配额20,00020,000合合计计100010001.001.001,0001,00014,000.007001.00700.006,000.003001.00300.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-

22、1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-

23、1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-20,000.00合计100085.001,000.00分配表八（自定义）1 1 月月份份N8N8分分配配表表N8应分配总额产品品种分配标准分配率分配额合合计计-N8合计-白板纸-首页 产产 品品 产产 量量合计00000产产品品名名称称月月份份期期初初在在产产品品数数量量期期初初在在产产品品约约当当产产量量百百分分比比期期初初在在产产品品约约当当产产量量本本期期完完工工产产品品数数量量期期末末在在产产品品数数量量期期末末在在产产品品约约当当百百分分比比期

24、期末末在在产产品品约约当当产产量量0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

25、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

26、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

27、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

28、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

29、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

30、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

31、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

32、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

33、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000