Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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% |
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