Question
Cost of quality report A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $351,000 Processing lost
Cost of quality report
A quality control activity analysis indicated the following four activity costs of a hotel:
| Inspecting cleanliness of rooms | $351,000 |
| Processing lost customer reservations | 87,750 |
| Rework incorrectly prepared room service meal | 175,500 |
| Employee training | 263,250 |
| Total | $877,500 |
Sales are $4,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 | $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% | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Hospitality Financial Accounting
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Agnes L.
2nd Edition
9780470598092, 470083603, 978-0470083604
