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

Cost of Quality Analysis and Reporting using Microsoft Excel

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

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!!