Cost of Quality Analysis and Reporting using Microsoft Excel

Cost of Quality Analysis and Reporting using Microsoft Excel, available at $69.99, has an average rating of 4.27, with 28 lectures, 1 quizzes, based on 634 reviews, and has 2471 subscribers.

You will learn about 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 This course is ideal for individuals who are Manufacturing Managers or Quality Managers or Quality Engineers or Industrial Engineers or Supply Chain Professionals or Quality Technicians and Analysts It is particularly useful for Manufacturing Managers or Quality Managers or Quality Engineers or Industrial Engineers or Supply Chain Professionals or Quality Technicians and Analysts.

Enroll now: Cost of Quality Analysis and Reporting using Microsoft Excel

Summary

Title: Cost of Quality Analysis and Reporting using Microsoft Excel

Price: $69.99

Average Rating: 4.27

Number of Lectures: 28

Number of Quizzes: 1

Number of Published Lectures: 28

Number of Published Quizzes: 1

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $29.99

Quality Status: approved

Status: Live

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Cost of Quality Analysis and Reporting, Lecture Material

Lecture 1: Introduction to the Course

Lecture 2: Cost of Quality Categories

Lecture 3: Downloadable Resources

Lecture 4: Gathering Your Quality Cost Information

Lecture 5: Quality Purchases

Lecture 6: Quality Payroll

Lecture 7: Payroll Summary

Lecture 8: External Quality Costs

Lecture 9: Internal Scrap Data

Lecture 10: Summarizing Internal Rework Hours

Lecture 11: Training Cost Data

Lecture 12: Introduction to Product Costing

Lecture 13: Calculating Internal Scrap Cost, Part 1

Lecture 14: Calculating Internal Scrap Cost (VLOOKUP), Part 2

Lecture 15: Calculating Internal Scrap Cost, Part 3

Lecture 16: Summarizing External Quality Costs

Lecture 17: Total External Quality Costs

Lecture 18: Total Internal Quality Costs

Lecture 19: Total Appraisal Quality Costs

Lecture 20: Total Preventive Quality Costs

Lecture 21: Total Cost of Quality

Lecture 22: Formatting and Distribution the COQ Report

Lecture 23: Month over Month Summary

Lecture 24: More Analysis Methods

Lecture 25: Estimating Defect Costs in a Process Series

Lecture 26: Conclusion

Lecture 27: Additional Resources in Quality Engineering

Lecture 28: Bonus Lecture

Instructors

Ray Harkins, The Manufacturing Academy
Senior Manufacturing Professional, Online Educator

Rating Distribution

1 stars: 3 votes
2 stars: 6 votes
3 stars: 89 votes
4 stars: 247 votes
5 stars: 289 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu