You are going to create a cost of quality report for Kinkaid Cabinets for the last five years using the data in the worksheet DB 9.1 Cost of Quality Data. You’ve been given a solution grid that is on the worksheet DB 9.1 COQ Report Template. The quality categories have been listed for you, as has the total revenue for the company. Your assignment is to use the Cost of Quality Data sheet to create a cost of quality report for Kinkaid with the cost categories properly placed in the solutions worksheet.

REQUIRED:

a. Complete the copying of the categories and dollar amounts for each of the quality costs to your worksheet.

b. Once you have completed this, format your numerical rows to be dollars without any cents.

c. Now total each type of quality cost by category.

d. Now calculate the percentage of each type of quality cost (in total) using the total revenue figure provided at the top of the worksheet.

e. Complete this summarization exercise for all of the quality categories.

f. Given the results, what would you say about Kinkaid’s trends in terms of quality? Why?