使用说明：1、首先把原料编号及原料价格录入到原料单价表里面2、在原料领用明细表中逐项录入（单价、总价自动生成无需录入）,本表格领用即默认为消耗3、在成品产量表中逐项录入4、成本核算表中录入产品编号其他自动生成生产成本核算原材料领用明细表成品产量表成本核算表原材料单价表原料领用明细表日期原料编号领用数量原料名称原料规格5/1/2016B00111木材SACV5/1/2016B0029塑料GTR5/1/2016B0035水纯净水5/1/2016B0044胶水GF5/1/2016B0057纸20*305/2/2016B00112木材SACV5/2/2016B00212塑料GTR5/2/2016B0039水纯净水5/2/2016B0048胶水GF5/2/2016B00513纸20*305/3/2016B0019木材SACV5/3/2016B0023塑料GTR5/3/2016B0045胶水GF5/3/2016B0055纸20*305/4/2016B0018木材SACV5/4/2016B0026塑料GTR5/4/2016B0045胶水GF5/4/2016B0055纸20*305/5/2016B00110木材SACV5/5/2016B00210塑料GTR5/5/2016B00410胶水GF5/5/2016B00513纸20*305/6/2016B0015木材SACV5/6/2016B0023塑料GTR5/6/2016B0034水纯净水5/7/2016B00112木材SACV5/7/2016B00210塑料GTR5/7/2016B0034水纯净水5/7/2016B0057纸20*305/8/2016B00213塑料GTR5/8/2016B00310水纯净水5/8/2016B0045胶水GF5/8/2016B0054纸20*305/9/2016B00112木材SACV5/9/2016B0037水纯净水5/9/2016B0044胶水GF5/9/2016B0056纸20*305/10/2016B0015木材SACV5/10/2016B00211塑料GTR5/10/2016B00413胶水GF5/10/2016B0057纸20*30表单价总价所生产的成品50550A00160540A00240200A00330120A00325175A00150600A00260720A00140360A00330240A00325325A00250450A00160180A00330150A00125125A00250400A00160360A00330150A00125125A00250500A00160600A00330300A00125325A00250250A00160180A00340160A00150600A00260600A00140160A00325175A00160780A00240400A00330150A00125100A00250600A003返回首页40280A00130120A00225150A00350250A00160660A00230390A00325175A002成品产量表日期产品编号数量5/1/2016A00175/1/2016A00265/1/2016A00375/2/2016A00185/2/2016A00295/2/2016A003105/3/2016A001115/3/2016A002135/3/2016A003145/4/2016A00195/4/2016A002115/4/2016A003105/5/2016A00195/5/2016A002115/5/2016A00385/6/2016A00185/6/2016A00275/6/2016A00385/7/2016A00175/7/2016A00265/7/2016A00385/8/2016A0018返回首页5/8/2016A00295/8/2016A003105/9/2016A00195/9/2016A002105/9/2016A003115/10/2016A001105/10/2016A002115/10/2016A00312成本核算表产品编号本期产量本期总成本本期单位成本A00186526061.16A00293447548.12A00398394040.20000000000000000000000000000000000000000000000000000000000000返回首页原料单价表原料编号原料名称原料规格原料单价B001木材SACV50B002塑料GTR60B003水纯净水40B004胶水GF30B005纸20*3025返回首页
