A quality control activity analysis indicated the following four activity costs of a hotel:Inspecting cleanliness of rooms$181,350Processing lost customer reservations60,450Rework incorrectly prepared room service meal241,800Employee training120,900    Total$604,500Sales are $3,100,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 ReportQuality Cost Classification Quality Cost Percent of Total Quality Cost Percent of Total SalesPrevention  $   %   % Appraisal      %   % Internal failure      %   % External failure      %   %     Total  $   %   %

Question
Asked Dec 13, 2019
69 views

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

Inspecting cleanliness of rooms $181,350
Processing lost customer reservations 60,450
Rework incorrectly prepared room service meal 241,800
Employee training 120,900
    Total $604,500

Sales are $3,100,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     $       %       %  
check_circle

Expert Answer

Step 1

Prepare a cost of quality report as...

help_outline

Image Transcriptionclose

K Cost of quality report 27 Percent of total Percent Quality cost quality of total 28 classification Quality cost $120,900 $181,350 $241,800 S60,450 $604,500 sales cost 20% 3.9% 5.9% 7.8% 2.0% 29 Prevention 30 Appraisal 30% 40% 31 Internal failure 32 External faihure 10% 33 Total 100% 19.5%

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Accounting

Cost Management

Related Accounting Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: --/1 Question 5 View Policies Current Attempt in Progress If the materials price variance is $3900 F...

A: Direct material variances: The difference between the actual material cost per unit and the standard...

question_answer

Q: The debits and credits from two transactions are presented in the following creditor's (supplier's) ...

A: Accounts payable control account and subsidiary ledger: Accounts payable account and subsidiary ledg...

question_answer

Q: --/1 Question 14 View Policies Current Attempt in Progress A company uses 80000 gallons of materials...

A: Direct material variances:The difference between the actual material cost per unit and the standard ...

question_answer

Q: Mountain Day Spa sold merchandise inventory on credit, terms n/30, to Marvin Smith, $400. Cost of go...

A: Sales JournalSales journal is used to record the selling of Merchandise inventory on account. The sa...

question_answer

Q: Use the following data to determine the total dollar amount of assets to be classified as current as...

A: Current assets: Current assets are assets that which are liquidated to cash with in an accounting pe...

question_answer

Q: In the balance sheet, the account Discount on Bonds Payable is Group of answer choices added to bo...

A: The amount that a company received for bond less than the par value of bond is known as discount on ...

question_answer

Q: The following selected transactions were completed by Amsterdam Supply Co., which sells office suppl...

A: Hence, the above journal entries to record the transaction in the A supply Company’s books of accoun...

question_answer

Q: Crane Company sells office equipment on July 31, 2022, for $20,440 cash. The office equipment origin...

A: Depreciation Depreciation is defined as a reduction in the value of an assets that occurs over time ...

question_answer

Q: Sunland Company sells one product. Presented below is information for January for Sunland Company. ...

A: a. Prepare necessary journal entries to record cost of goods sold: