经典 质量成本分析报告 Monthly_CoQ_Analysis_Report-.xls

Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2011 4 29 by 编制人 XXXX Document No 文件编号 1 CoQ list 质质量量成成本本清清单单 SubjectScopeItem1234567891011121314 1 Prevent ion 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主管数51000000000000 Number of engineers工程师数00000000000000 Number of hours小时数848000000000000 Total costs10001200000000000000 1 3 Internal training 内部培训 Number of supervisor主管数00000000000000 Number of engineers工程师数00000000000000 Number of production personnel 生产人员数 00000000000000 Number of quality personnel品质 人员数 00000000000000 Number of hour小时数00000000000000 Total costs00000000000000 1 4 External training 外部培训 Number of supervisor主管数00000000000000 Number of engineers工程师数00000000000000 Number of production personnel 生产人员 00000000000000 Number of quality personnel品质 人员数 00000000000000 Number of hour小时数00000000000000 meal transportation hotel餐饮 交 通 住宿 00000000000000 Training costs培训费00000000000000 Total costs00000000000000 1 5 Supplier audit 供应商审核 Number of supervisor主管数30000000000000 Number of engineers工程师数00000000000000 Number of hour小时数40000000000000 meal transportation hotel餐饮 交 通 住宿 600000000000000 Total costs3600000000000000 1 6 System certification 体系认证 SGS audit of systems SGS审核费用 160000000000000000 Number of supervisor主管数60000000000000 Number of engineers工程师数20000000000000 meal transportation hotel餐饮 交 通 住宿 17530000000000000 Number of hour小时数30000000000000 Total costs183530000000000000 1 7 Products verification产品认证 Costs of product verification产品 认证费 00000000000000 Total costs00000000000000 1 8 Customer audit 客户审核 Number of supervisor主管数00000000000000 Number of engineers工程师数10000000000000 Number of hour小时数20000000000000 meal transportation hotel 餐饮 交通 住宿 1200000000000000 Total costs1700000000000000 2 Apprais al 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外校费 用 00000000000000 External repair cost 外部维修费 用 00000000000000 Newly purchasing equipment 新购仪器费 00000000000000 Total costs00000000000000 3 Internal failure costs 内内部部 故故障障成成本本 3 1Raw materials scrap 原材料报废 In store库存原材料报废400060015000000000000 Before production 生产前原材料00000000000000 In rework生产返工返修过程00000000000000 In scrap products 在制品成品报废 00000000000000 Total costs400060015000000000000 3 2 products scrap 成品报废 In store库存成品2006000000000000000 In process products 生产过程中 成品半成品报废 00000000000000 Total costs2006000000000000000 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2011 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 1000 00 2000 00 3000 00 4000 00 5000 00 6000 00 7000 00 3 2 Labour costs 人力成本 In rework process返工返修过程00000000000000 In scrap products in production 在制成品半成品报废中人力成本 00000000000000 Downtime caused by quality accidents停工中 00000000000000 Total costs00000000000000 4 Externa l failure costs 外外部部 故故障障成成本本 4 1 Customer rejection顾客退回产 品 Repairing products rejected by customer客户退回产品的维修 00000000000000 Scrap products rejected by customet顾客退回成品的报废 00000000000000 Total costs00000000000000 4 2 Customer counterclaim Customer counterclaim顾客索赔00000000000000 Monthly CoQ Total costs 月月度度质质量量总总成成本本55083780015000000000000 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 1000 00 2000 00 3000 00 4000 00 5000 00 6000 00 7000 00 3 Internal failure costs 内内部部 故故障障成成本本 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2011 4 29 by 编制人 XXXX 1 CoQ list 质质量量成成本本清清单单 SubjectScopeItem 1 Prevent ion 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 Apprais al 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 15Total 11000 0 2200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 360 0 0 0 0 0 18353 0 0 0 0 0 0 0 0 0 170 0 0 0 0 20000 0 0 0 0 0 0 4750 0 0 0 0 0 6200 0 0 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Document No 文件编号 Monthly CoQ Analysis Report 4 月月质质量量成成本本分分析析报报告告 Created date 编制日期 2011 4 29 by 编制人 XXXX 3 2 Labour costs 人力成本 In rework process返工返修过程 In scrap products in production 在制成品半成品报废中人力成本 Downtime caused by quality accidents停工中Total costs 4 Externa l 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 1000 00 2000 00 3000 00 4000 00 5000 00 6000 00 7000 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 1000 00 2000 00 3000 00 4000 00 5000 00 6000 00 7000 00 0 0 0 0 0 0 0 0 0 00 063033 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 1000 00 2000 00 3000 00 4000 00 5000 00 6000 00 7000 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 qualit