Data table Annual COQ Report, Gallatin Company 2016 2017 Supplier evaluation 4,000 $ 6,200 Scrap 7,900 $ 5,700 Warranty repair costs 9,950 $ 7,740 Design engineering 4,560 $ 6,820 Inspection 3,300 $ 4,800 Rework 9,370 $ 5,600 Total COQ Total Revenue 39,080 $ 36,860 440,000 $ 520,000 Print Done Requirements 1. Identify costs-of-quality category (prevention, appraisal, internal failure, and external failure) for each of these costs. 2. Prepare a COQ Report by calculating the costs of quality for each category and the ratio of each COQ category to revenues and total quality costs. 3. Based on the results of requirement 2, would you conclude that Gallatin's quality program has been successful? Prepare a short report to present your case. Gallatin Company makes chairs for outside living spaces. The company has been working on improving quality over the last year and wants to evaluate how well it has done on costs-of-quality (COQ) measures. Here are the results: (Click the icon to view the results.) Data Table Read the requirements. Requirement 1. Identify costs of quality category (prevention, appraisal, internal failure, and external failure) for each of these costs. Cost Supplier evaluation Scrap Warranty repair costs Design engineering Inspection Rework Cost of quality category Requirement 2. Prepare a COQ Report by calculating the costs of quality for each category and the ratio of each COQ category to revenues and total quality costs. Begin with 2016 costs and ratios, then complete the report with 2017 costs and ratios. (Round percentages to one decimal place, X.X%.) 2016 2017 % of % of Total Costs Total COQ Revenue Total Costs % of Total COQ % of Revenue Prevention costs % % % % Appraisal costs % % % % Internal failure costs % % % % External failure costs % % % % Total Costs of Quality % % % % Gallatin Company makes chairs for outside living spaces. The company has been working on improving quality over the last year and wants to evaluate how well it has done on costs-of-quality (COQ) measures. Here are the results: (Click the icon to view the results.) Read the requirements. Design engineering Inspection Rework Requirement 2. Prepare a COQ Report by calculating the costs of quality for each category and the ratio of each COQ category to revenues and total quality costs. Begin with 2016 costs and ratios, then complete the report with 2017 costs and ratios. (Round percentages to one decimal place, X.X%.) Prevention costs Appraisal costs Internal failure costs External failure costs Total Costs of Quality 2016 2017 % of % of % of % of Total Costs Total COQ Revenue Total Costs Total COQ Revenue % % % % % % % % % % % % % % % % % % % % Requirement 3. Based on the results of requirement 2, would you conclude that Gallatin's quality program has been successful? Prepare a short report to present your case. Total Costs of Quality as a percentage of sales. Quality costs have shifted to the area of starts. The where problems are solved before production In these costs has In terms of reducing Internal and External failure costs. In summary, Gallatin's quality program appears to have been