Cost of Quality Analysis and Reporting using Microsoft Excel

Expertly collect, analyze and present quality cost data (using Microsoft Excel) to help drive continual improvement

Ratings: 4.82 / 5.00




Description

A complete plan of attack for molding your quality cost information into an informative report that will grab the attention of anyone who cares about the bottom line of your company.  Learn the four standard cost of quality categories.  Learn how to gather the essential building blocks of your report.  Then learn to analyze and summarize this data to DRIVE IMPROVEMENT within your company.

In this course, you will learn:

  • What raw data to collect and how to collect it

  • The four cost buckets: Prevention, Appraisal, Internal and External

  • Sources of Quality Costs like payroll, scrap data, training data, customer complaints, returned product freight, etc.

  • How to use Excel formulas like VLOOKUP to speed up your data summary

  • Formatting and distributing your COQ report for maximum impact

  • How products are costed from raw material through finished goods

  • Trends and patterns in COQ data

  • Estimating defect costs in a process series

  • How to effectively use the provided Excel templates

  • And MUCH MORE!!

Cost of Quality is the business foundation for your quality engineering, management and continuous improvement initiatives. By learning the skills provided in this class, you will effectively connect your knowledge and activities as a quality professional to the larger objectives of your company. Sign up today to start learning this critical skill!!

What You Will Learn!

  • The major quality cost "buckets": Preventive, Appraisal, Internal, and External
  • How to collect and correctly analyze cost of quality data
  • How to build a cost of quality report
  • How to format a COQ report for maximum effectiveness
  • How to use an Excel Pivot Table to summarize your internal Scrap data
  • How to apply pareto analysis to your COQ report as a mean of kickstarting your continual improvement initiatives
  • Where payroll, purchases, training costs, internal scrap, return product freight, an all other quality related costs fit into your analysis
  • Key concepts of Quality Engineering and Quality Management

Who Should Attend!

  • Manufacturing Managers
  • Quality Managers
  • Quality Engineers
  • Industrial Engineers
  • Supply Chain Professionals
  • Quality Technicians and Analysts