Excel help

Cost Category Amount Quality equipment design $ 27,000 Scrap 322,000 Inspection and retest 348,000 Customer returns 88,000 Supplier quality surveys 9,000 Repair 76,000 What quality cost categories should each of these costs be associated with? What does a Pareto analysis reveal? The data Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Questions 1. Classifying the D.B. Smith Company cost elements into the appropriate cost-of-quality categories, calculate the total cos percentages of the total and cumulative percentages. Round your answers for the total costs to the nearest dollar and rout two decimal places. Quality Cost Category Amount Percent of Total Cumulative Percentage Internal failure 398000 45.75 % % Appraisal 348000 External failure 88000 % Prevention $ 36000 % Total $ 870000 2. Choose the correct graph for the cost-of-quality categories. The correct graph is