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

Inspecting cleanliness of rooms	$320,000
Processing lost customer reservations	128,000
Rework incorrectly prepared room service meal	64,000
Employee training	128,000
Total	$640,000

Sales are $3,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.

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

$

%

%

Appraisal

%

%

Internal failure

%

%

External failure

%

%

Total

$