Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Cost of Quality Analysis and Reporting using Microsoft Excel

via Udemy

Overview

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

What you'll 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

A complete plan of attack for molding your quality cost information into an informativereport 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 DRIVEIMPROVEMENT 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 COQdata

  • Estimating defect costs in a process series

  • How to effectively use the provided Excel templates

  • And MUCHMORE!!

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

Taught by

Ray Harkins, The Manufacturing Academy

Reviews

4.5 rating at Udemy based on 657 ratings

Start your review of Cost of Quality Analysis and Reporting using Microsoft Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.