Question: A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $43,750 Processing lost customer reservations 87,500 Rework
A quality control activity analysis indicated the following four activity costs of a hotel:
| Inspecting cleanliness of rooms | $43,750 |
| Processing lost customer reservations | 87,500 |
| Rework incorrectly prepared room service meal | 218,750 |
| Employee training | 87,500 |
| Total | $437,500 |
Sales are $3,500,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 | ||||||||||||
| Appraisal | ||||||||||||
| Internal failure | ||||||||||||
| External failure | ||||||||||||
| Total | ||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
