Cost of quality report

A quality control activity analysis indicated the following four activity costs of a hotel:

Inspecting cleanliness of rooms	$113,400
Processing lost customer reservations	56,700
Rework incorrectly prepared room service meal	226,800
Employee training	170,100
Total	$567,000

Sales are $4,200,000.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

Prepare a cost of quality report. Round the percents of total quality cost to the nearest whole number and the percents of total sales to one decimal place.

Cost of Quality Report

Quality Cost Classification

Quality Cost

Percent of Total Quality Cost

Percent of Total Sales

Prevention

$fill in the blank 2

fill in the blank 3%

fill in the blank 4%

Appraisal

fill in the blank 5

fill in the blank 6%

fill in the blank 7%

Internal failure

fill in the blank 8

fill in the blank 9%

fill in the blank 10%

External failure

fill in the blank 11

fill in the blank 12%

fill in the blank 13%

Total

$fill in the blank 14

fill in the blank 15%

fill in the blank 16%