1、财务成本核算管理系统-BOM表Financial cost accounting management system原料单价表原料领用明细表成品产量表原料投入统计BOM表财务成本核算表使用说明原料单价表原料编号原料名称原料规格原料单价B001木材SACV50B002塑料GTR60B003水纯净水40B004胶水GF30B005纸20*3025首首页页原料领用明细表日期原料编号领用数量原料名称原料规格2019/12/1B00111木材SACV2019/12/1B0029塑料GTR2019/12/1B0035水纯净水2019/12/1B0044胶水GF2019/12/1B0057纸20*30201
2、9/12/2B00112木材SACV2019/12/2B00212塑料GTR2019/12/2B0039水纯净水2019/12/2B0048胶水GF2019/12/2B00513纸20*302019/12/3B0019木材SACV2019/12/3B0023塑料GTR2019/12/3B0045胶水GF2019/12/3B0055纸20*302019/12/4B0018木材SACV2019/12/4B0026塑料GTR2019/12/4B0045胶水GF2019/12/4B0055纸20*302019/12/5B00110木材SACV2019/12/5B00210塑料GTR2019/12/5B
3、00410胶水GF2019/12/5B00513纸20*302019/12/6B0015木材SACV2019/12/6B0023塑料GTR2019/12/6B0034水纯净水2019/12/7B00112木材SACV2019/12/7B00210塑料GTR2019/12/7B0034水纯净水2019/12/7B0057纸20*302019/12/8B00213塑料GTR2019/12/8B00310水纯净水2019/12/8B0045胶水GF2019/12/8B0054纸20*302019/12/9B00112木材SACV2019/12/9B0037水纯净水2019/12/9B0044胶水GF
4、2019/12/9B0056纸20*302019/12/10B0015木材SACV2019/12/10B00211塑料GTR2019/12/10B00413胶水GF2019/12/10B0057纸20*30单价总价所生产的成品50550A00160540A00240200A00330120A00325175A00150600A00260720A00140360A00330240A00325325A00250450A00160180A00330150A00125125A00250400A00160360A00330150A00125125A00250500A00160600A00330300A0
5、0125325A00250250A00160180A00340160A00150600A00260600A00140160A00325175A00160780A00240400A00330150A00125100A002首首页页50600A00340280A00130120A00225150A00350250A00160660A00230390A00325175A002成品产量表日期产品编号数量2019/12/1A00172019/12/1A00262019/12/1A00372019/12/2A00182019/12/2A00292019/12/2A003102019/12/3A001112
6、019/12/3A002132019/12/3A003142019/12/4A00192019/12/4A002112019/12/4A003102019/12/5A00192019/12/5A002112019/12/5A00382019/12/6A00182019/12/6A00272019/12/6A00382019/12/7A00172019/12/7A00262019/12/7A0038首首页页2019/12/8A00182019/12/8A00292019/12/8A003102019/12/9A00192019/12/9A002102019/12/9A003112019/12/1
7、0A001102019/12/10A002112019/12/10A00312成本核算表产品编号本期产量本期总成本本期单位成本A00186526061.16A00293447548.12A00398394040.200000000000000000000000000000000000000000000000000000000000000000000000首首页页原料投入表-BOM表输入成品编码：A002产量：93原料编号原料名称原料规格原料总数量B001木材SACV24B002塑料GTR33B003水纯净水0B004胶水GF4B005纸20*30470000000000000000000000
8、00000000000000000000000000000000000000000000000000000000000000000000000单位用量0.2580.3550.0000.0430.5050.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000首首页页0.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000
9、.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000使用说明1、首先把原料编号及原料价格录入到原料单价表里面2、在原料领用明细表中逐项录入（单价、总价自动生成无需录入）,本表格领用即默认为消耗3、在成品产量表中逐项录入4、成本核算表中录入产品编号其他自动生成5、原料投入统计表：该表可以自动核算某种成品的BOM原料表首首页页首首页页
