质量成本管理：质量成本分析和核算报告(案例模板).xls

Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2017 4 29 by 编制人 XXXX Document No 文件编号 1 CoQ list 质质量量成成本本清清单单 SubjectScopeItem1234567891011 1 Prevention costs 预预防防成成本本 1 1 Salaries of quality management personels质 量管理人员的工资 Number of supervisor主管数2 Number of engineers工程师数0 DCC quality personnel 文控0 Total costs11000 1 2 Internal audit 内部审核 Number of supervisor主管数51000000000 Number of engineers工程师数00000000000 Number of hours小时数848000000000 Total costs10001200000000000 1 3 Internal training 内部培训 Number of supervisor主管数00000000000 Number of engineers工程师数00000000000 Number of production personnel生产 人员数 00000000000 Number of quality personnel品质人员 数 00000000000 Number of hour小时数00000000000 Total costs00000000000 1 4 External training 外部培训 Number of supervisor主管数00000000000 Number of engineers工程师数00000000000 Number of production personnel生产 人员 00000000000 Number of quality personnel品质人员 数 00000000000 Number of hour小时数00000000000 meal transportation hotel餐饮 交通 住宿 00000000000 Training costs培训费00000000000 Total costs00000000000 1 5 Supplier audit 供应商审核 Number of supervisor主管数30000000000 Number of engineers工程师数00000000000 Number of hour小时数40000000000 meal transportation hotel餐饮 交通 住宿 600000000000 Total costs3600000000000 1 6 System certification 体系认证 SGS audit of systems SGS审核费用160000000000000 Number of supervisor主管数60000000000 Number of engineers工程师数20000000000 meal transportation hotel餐饮 交通 住宿 17530000000000 Number of hour小时数30000000000 Total costs183530000000000 1 7 Products verification产 品认证 Costs of product verification产品认证 费 00000000000 Total costs00000000000 1 8 Customer audit 客户审核 Number of supervisor主管数00000000000 Number of engineers工程师数10000000000 Number of hour小时数20000000000 meal transportation hotel 餐饮 交通 住宿 1200000000000 Total costs1700000000000 2 Appraisal costs 鉴鉴定定成成本本 2 1 Salaries of QC 专职QC人员的工资 Number of QC QC人数8 Total costs20000 2 2 Calibration and repair of measuring and testing equipment量测设备 External calibration cost外校费用00000000000 External repair cost 外部维修费用00000000000 Newly purchasing equipment 新购仪器费 00000000000 Total costs00000000000 3 Internal failure costs 内内部部 故故障障成成本本 3 1Raw materials scrap 原材料报废 In store库存原材料报废400060015000000000 Before production 生产前原材料00000000000 In rework生产返工返修过程00000000000 In scrap products 在制品成品报废 00000000000 Total costs400060015000000000 3 2 products scrap 成品报废 In store库存成品2006000000000000 In process products 生产过程中成品 半成品报废 00000000000 Total costs2006000000000000 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2017 4 29 by 编制人 XXXX Document No 文件编号 51 32 17 0 Prevention costs预防成本 Appraisal costs鉴定成本 Internal Failure costs内部故 障成本 External Failure costs外部故 障成本 4750 00 6200 00 0 000 000 00 12345 0 00 2000 00 4000 00 6000 00 8000 00 3 2 Labour costs 人力成本 In rework process返工返修过程00000000000 In scrap products in production在制 成品半成品报废中人力成本 00000000000 Downtime caused by quality accidents停工中 00000000000 Total costs00000000000 4 External failure costs 外外部部 故故障障成成本本 4 1 Customer rejection顾客 退回产品 Repairing products rejected by customer客户退回产品的维修 00000000000 Scrap products rejected by customet 顾客退回成品的报废 00000000000 Total costs00000000000 4 2 Customer counterclaim Customer counterclaim顾客索赔00000000000 Monthly CoQ Total costs 月月度度质质量量总总成成本本55083780015000000000 2 CoQ structure质质量量成成本本的的构构成成 SubjectScopeCostsRate CoGQ Prevention costs预防成本32083 0050 90 Appraisal costs鉴定成本20000 0031 73 CoPQ Internal Failure costs内部故 障成本 10950 0017 37 External Failure costs外部 故障成本 0 000 00 Total costs 月度质量总成本63033 00100 00 3 CoPQ analysis SubjectScopeCostsRate Internal failure costs 内部故障成本 Raw materials scrap原材料 报废 4750 0043 379 Products scrap成品报废6200 0056 621 Labour costs人力成本0 000 External failure costs 外部故障成本 Customer rejection顾客退 回产品 0 000 Customer counterclaim顾客 索赔 0 000 Total costs10950 00100 4 The most significant factors of CoQ影影响响质质量量成成本本的的关关键键因因素素 5 Compare with sales status与与销销售售业业绩绩相相比比较较 51 32 17 0 Prevention costs预防成本 Appraisal costs鉴定成本 Internal Failure costs内部故 障成本 External Failure costs外部故 障成本 4750 00 6200 00 0 000 000 00 12345 0 00 2000 00 4000 00 6000 00 8000 00 3 Internal failure costs 内内部部 故故障障成成本本 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2017 4 29 by 编制人 XXXX 1 CoQ list 质质量量成成本本清清单单 SubjectScopeItem 1 Prevention costs 预预防防成成本本 1 1 Salaries of quality management personels质 量管理人员的工资 Number of supervisor主管数 Number of engineers工程师数 DCC quality personnel 文控 Total costs 1 2 Internal audit 内部审核 Number of supervisor主管数 Number of engineers工程师数 Number of hours小时数 Total costs 1 3 Internal training 内部培训 Number of supervisor主管数 Number of engineers工程师数 Number of production personnel生产 人员数 Number of quality personnel品质人员 数 Number of hour小时数 Total costs 1 4 External training 外部培训 Number of supervisor主管数 Number of engineers工程师数 Number of production personnel生产 人员 Number of quality personnel品质人员 数 Number of hour小时数 meal transportation hotel餐饮 交通 住宿 Training costs培训费 Total costs 1 5 Supplier audit 供应商审核 Number of supervisor主管数 Number of engineers工程师数 Number of hour小时数 meal transportation hotel餐饮 交通 住宿 Total costs 1 6 System certification 体系认证 SGS audit of systems SGS审核费用 Number of supervisor主管数 Number of engineers工程师数 meal transportation hotel餐饮 交通 住宿 Number of hour小时数 Total costs 1 7 Products verification产 品认证 Costs of product verification产品认证 费 Total costs 1 8 Customer audit 客户审核 Number of supervisor主管数 Number of engineers工程师数 Number of hour小时数 meal transportation hotel 餐饮 交通 住宿 Total costs 2 Appraisal costs 鉴鉴定定成成本本 2 1 Salaries of QC 专职QC人员的工资 Number of QC QC人数 Total costs 2 2 Calibration and repair of measuring and testing equipment量测设备 External calibration cost外校费用 External repair cost 外部维修费用 Newly purchasing equipment 新购仪器费 Total costs 3 Internal failure costs 内内部部 故故障障成成本本 3 1Raw materials scrap 原材料报废 In store库存原材料报废 Before production 生产前原材料 In rework生产返工返修过程 In scrap products 在制品成品报废 Total costs 3 2 products scrap 成品报废 In store库存成品 In process products 生产过程中成品 半成品报废 Total costs 12131415Total 11000 0000 2200 0000 0000 0000 0000 0 0000 0000 0000 0000 0000 0000 0 0000 0000 0000 0000 0000 0000 0000 0000 360 0000 0000 0000 0000 0000 18353 0000 0000 0000 0000 0000 0000 0 0000 0000 170 0000 0000 0000 0000 20000 0000 0 0000 0000 0000 0000 4750 0000 0000 0000 0000 0000 6200 0000 0000 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Document No 文件编号 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2017 4 29 by 编制人 XXXX 3 2 Labour costs 人力成本 In rework process返工返修过程 In scrap products in production在制 成品半成品报废中人力成本 Downtime caused by quality accidents停工中Total costs 4 External failure costs 外外部部 故故障障成成本本 4 1 Customer rejection顾客 退回产品 Repairing products rejected by customer客户退回产品的维修 Scrap products rejected by customet 顾客退回成品的报废 Total costs 4 2 Customer counterclaim Customer counterclaim顾客索赔 Monthly CoQ Total costs 月月度度质质量量总总成成本本 2 CoQ structure质质量量成成本本的的构构成成 SubjectScopeCosts CoGQ Prevention costs预防成本32083 00 Appraisal costs鉴定成本20000 00 CoPQ Internal Failure costs内部故 障成本 10950 00 External Failure costs外部 故障成本 0 00 Total costs 月度质量总成本63033 00 3 CoPQ analysis SubjectScopeCosts Internal failure costs 内部故障成本 Raw materials scrap原材料 报废 4750 00 Products scrap成品报废6200 00 Labour costs人力成本0 00 External failure costs 外部故障成本 Customer rejection顾客退 回产品 0 00 Customer counterclaim顾客 索赔 0 00 Total costs10950 00 4 The most significant factors of CoQ影影响响质质量量成成本本的的关关键键因因素素 5 Compare with sales status与与销销售售业业绩绩相相比比较较 51 32 17 0 Prevention costs预防成本 Appraisal costs鉴定成本 Internal Failure costs内部故 障成本 External Failure costs外部故 障成本 4750 00 6200 00 0 000 000 00 12345 0 00 2000 00 4000 00 6000 00 8000 00 51 32 17 0 Prevention costs预防成本 Appraisal costs鉴定成本 Internal Failure costs内部故 障成本 External Failure costs外部故 障成本 4750 00 6200 00 0 000 000 00 12345 0 00 2000 00 4000 00 6000 00 8000 00 0000 0 0000 0000 0000 0000 0 0000 0000 00000 000063033 51 32 17 0 Prevention costs预防成本 Appraisal costs鉴定成本 Internal Failure costs内部故 障成本 External Failure costs外部故 障成本 4750 00 6200 00 0 000 000 00 12345 0 00 2000 00 4000 00 6000 00 8000 00 Internal Failure Costs of Production Dpt 4 月月内内部部故故障障成成本本 制制造造部部 Created date 编制日期 2011 4 29 by 编制人 xxx Document No 文件编号 Scope 范范围围Item 项项123456789101112131415 Raw materials scrap before production 生产前原材料报废 Name of product产品名称 Name of raw materials 原材料名称 Quantity of raw materials原材料料数量 Unit price单价 Total costs 总总成成本本000000000000000 Raw materials scrap used in rework返工返修过 程中使用和报废的 原材料 Name of product产品名称 Name of materials材料名称 Quantity of materials原材料数量 Unit price单价 Total costs 总总成成本本000000000000000 Labour costs in rework process 返工返修过程中的 人工成本 Number of production personnels 生产此产品的 生产员工数量 Number of quality personnels 检验此产品的品质 员工数量 Number of hours小时数 Total costs 总总成成本本000000000000000 In process products and final products scrap在制 品 成品报废中原 材料的损失 Name of product产品名称 Name of raw materials原材料名称 Quantity of raw materials原材料数量 Unit price 单价 Total costs 总总成成本本000000000000000 In process products 生产过程 中成品半成品报废 不能拆分成原材 料的 Name of product产品名称 Quantity of raw products 产品数量 Unit price 单价 Total costs 总总成成本本000000000000000 Labour costs of in process products and final products scrap在制品 成品 报废中人工的损失 Number of production personnels 生产此产品的 生产员工数量 Number of quality personnels 检验此产品的品质 员工数量 Number of hours小时数 Total costs 总总成成本本000000000000000 Labour costs of downtime 停工过程人工损失 Number of production personnels 停工的生产员 工数 Number of quality personnels 停工的检验员工数 量 Number of hours小时数 Total costs 总总成成本本000000000000000 Production Total costs 生生产产总总成成本本000000000000000 Internal Failure Costs of Warehouse 4 月月内内部部故故障障成成本本 仓仓库库 Created date 编制日期 2008 10 29 by 编制人 Melody MU Document No 文件编号 Scope 范范围围Item 项项123456789101112131415 Raw materials scrap in store 库存原材料报废 Name of raw materials原材料名称 Quantity of raw materials原材料料数量100020010 Unit price单价4315 Reason of scrap报废原因 Total costs 总总成成本本4000600150000000000000 Products scrap成品 报废 Name of product产品名称 Quantity of products产品数量1002000 Reason of scrap报废原因 Unit price单价23 Total costs 总总成成本本20060000000000000000 Warehouse Total costs 仓仓库库总总成成本本42006600150000000000000 注 成品报废中成品的单价按成品的财务成本计 External Failure Costs of Customer Complain 4 月月外外部部故故障障成成本本 顾顾客客服服务务 Created date 编制日期 2008 10 29 by 编制人 Melody MU Document No 文件编号 Scope 范范围围Item 项项123456789101112131415 Name of rejective products退回产品名 Reason of rejection退回原因 Repairing products rejected by customer客户退回 产品的维修 Name of raw materials used and scrap in repairing维修时消耗和报废原材料名称 Quantity of raw materials原材料料数量 Unit price单价 Total costs 总总成成本本000000000000000 Scrap products rejected by customet顾客退回 成品的报废 Name of product产品名称 Quantity of products产品数量 Reason of scrap报废原因 Unit price单价 Total costs 总总成成本本000000000000000 Customer counterclaim顾客索 赔 Name of product产品名称 Quantity of products产品数量 Reason of counterclaim索赔原因 Costs of counterclaim索赔金额 Customer Service Total costs 顾顾客客服服务务总总成成本本000000000000000 注 成品报废中成品的单价按成品的销售成本计 Prevention costs Qulity Dept 4 月月预预防防成成本本 品品质质部部 Created date 编制日期 2008 10 29 by 编制人 Melody MU Document No 文件编号 Scope 范范围围Item 项项123456789101112131415 Internal audit 内部审核 Name of audit审核名称体系体系 Number of supervisor主管 经理数51 Number of engineers工程师数 Number of hours小时数848 Total costs 总总成成本本100012000000000000000 Supplier audit 供应商审核 Name of audit审核名称3M Number of supervisor主管 经理数3 Number of engineers工程师数 Number of hour小时数4 meal transportation hotel餐饮 交通 住宿60 Total costs 总总成成本本36000000000000000 System certification 体系认证 Name of audit审核名称TS复审 Audit costs 审核费用16000 Number of supervisor主管 经理数6 Number of engineers工程师数2 meal transportation hotel餐饮 交通 住宿1753 Number of hour小时数3 Total costs 总总成成本本1835300000000000000 Products verification产品认 证 Name of products verification认证名称 Costs of product verification产品认证费 Customer audit 客户审核 Name of audit审核名称KOSL Number of supervisor主管 经理数 Number of engineers工程师数1 Number of hour小时数2 meal transportation hotel餐饮 交通 住宿120 Total costs 总总成成本本17000000000000000 Calibration and repair of measuring equipment量测设 备 Name of equipment仪器名称 External calibration cost外校费用 External repair cost 外部维修费用 Newly purchasing equipment新购仪器费 Total costs 总总成成本本000000000000000 Qulity Dept Total costs 品品质质部部总总成成本本1988312000000000000000 Prevention costs HR Dept 4 月月预预防防成成本本 人人力力资资源源 Created date 编制日期 2008 10 29 by 编制人 Melody MU Document No 文件编号 ScopeItem123456789101112131415 Salaries of quality management pe