D.B. Smith Company produces machine tools. The company conducted a cost-of-quality study and found the following: Cost Category Amount Quality equipment design $ 20,000 Scrap 333,000 Inspection and retest 330,000 Customer returns 80,000 Supplier quality surveys 8,000 Repair 82,000 What quality cost categories should each of these costs be associated with? What does a Pareto analysis reveal? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Questions 1. Classifying the D.B. Smith Company cost elements into the appropriate cost-of-quality categories, calculate the total costs in each category and their percentages of the total and cumulative percentages. Round your answers for the total costs to the nearest dollar and round your answers for the percentages to two decimal places. Quality Cost Category Amount Percent of Total Cumulative Percentage Internal failure Appraisal External failure Prevention Total
D.B. Smith Company produces machine tools. The company conducted a cost-of-quality study and found the following:
Cost Category | Amount | |
Quality equipment design | $ | 20,000 |
Scrap | 333,000 | |
Inspection and retest | 330,000 | |
Customer returns | 80,000 | |
Supplier quality surveys | 8,000 | |
Repair | 82,000 |
What quality cost categories should each of these costs be associated with? What does a Pareto analysis reveal? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Questions
1. Classifying the D.B. Smith Company cost elements into the appropriate cost-of-quality categories, calculate the total costs in each category and their percentages of the total and cumulative percentages. Round your answers for the total costs to the nearest dollar and round your answers for the percentages to two decimal places.
Quality Cost Category | Amount | Percent of Total | Cumulative Percentage | |||
Internal failure | ||||||
Appraisal | ||||||
External failure | ||||||
Prevention | ||||||
Total |


Trending now
This is a popular solution!
Step by step
Solved in 2 steps









