A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms Processing lost customer reservations Reworking incorrectly prepared room service meals Employee training Total Sales are $4,700,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. X 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 Percent of Total Quality Cost Quality Cost Classification Prevention Appraisal Internal failure External failure Total $155,100 310,200 232,650 77,550 $775,500 Quality Cost % % % % % Percent of Total Sales % % % % %

Transcribed Image Text:

A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $155,100 Processing lost customer reservations 310,200 Reworking incorrectly prepared room service meals 232,650 Employee training 77,550 Total $775,500 Sales are $4,700,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 Percent of Percent of Quality Cost Total Quality Cost Total Sales Classification Prevention Appraisal Internal failure External failure Total 96 " 96 % A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $155,100 Processing lost customer reservations 310,200 Reworking incorrectly prepared room service meals 232,650 Employee training 77,550 Total $775,500 Sales are $4,700,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 Percent of Percent of Quality Cost Total Quality Cost Total Sales Classification Prevention Appraisal Internal failure External failure Total 96 " 96 %