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.

Inspection

Rework

appraisal

internal failure

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 $2019$ costs and ratios, then complete the report with $2020$ costs and ratios. $($Round percentages to one decimal place, X$.$X$\%.)$

$\backslash$table$[[,2019],[,$Total Costs,$\backslash$table$[[\%$ of$],[$Total COQ$]],\backslash$table$[[\%$ of$],[$Revenue$]]],[$Prevention costs,,$\%,\%$

Data table

$\backslash$table$[[$Annual COQ Report, Gallatin Company$],[,2019,2020,],[$Supplier evaluation,$$,6,500$$$,6,200],[$Scrap$,$$$,7,600$$$,5,500],[$Warranty repair costs,$$,8,450$$$,7,450],[$Design engineering,$$,3,870$$$,6,550],[$Inspection$,$$$,3,200$$$,4,400],[$Rework$,$$$,9,010$$$,6,300],[$Total COQ,$$,38,630$$$,36,400],[$Total Revenue,$$,600,000$$$,675,000]]$