Cost of quality report A quality control activity analysis indicated the following four activity costs of a hotel: Sales are $4,500,000. Inspecting deanliness of rooms $189,000 Processing lost customer reservations 378,000 Rework incorrectly prepared room service meal Employee training Total 283,500 94,500 $945,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. Quality Cost Classification. Prevention Appraisal Internal failure External failure Total Cost of Quality Report Quality Cost Percent of Total Quality Cost Percent of Total Sales % % % % % % % % % % Cost of quality report A quality control activity analysis indicated the following four activity costs of a hotel: DATA Inspecting cleanliness of rooms $180.000 Processing lost customer reservations 378,000 Rework incorrectly prepared room service meal 283.500 9 Employee training 94.500 10 Total $945,000 II 12 Sales $4,500,000 13 G Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C, D, and E 14 columns. Transfer the numeric results for the green entry cells (C18:E22) into the appropriate fields in CNOWV2 for grading 15 16 Cost of Quality Report Percent of Total 17 Quality Cost Classification Quality Cost Quality Cost Percent of Total Sales 18 Prevention 19 Appraisal 20 Internal tailure 21 External failure 22 23 Total Formulas Cost of quality report A quality control activity analysis indicated the following four activity costs of a hotel: Sales are $4,500,000. Inspecting cleanliness of rooms Processing lost customer reservations $189,000 378,000 Rework incorrectly prepared room service meal Employee training Total 283,500 94,500 $945,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. Quality Cost Classification Prevention Appraisal Internal failure External failure Total Cost of Quality Report Quality Cost Percent of Total Quality Cost Percent of Total Sales % % 56 % % % % % C18 A 1 Cost of quality report 2 3 A quality control activity analysis indicated the following four activity costs of a hotel: 4 DATA 6 Inspecting cleanliness of rooms $189,000 7 Processing lost customer reservations 378,000 Rework incorrectly prepared room service meal 283,500 9 Employee training 94,500 10 Total $945,000 2 Sales $4,500,000 3 G H Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C, D, and E columns. Transfer the numeric results for the green entry cells (C18:E22) into the appropriate fields in CNOWV2 for grading. 4 6 Cost of Quality Report Percent of Total Quality Cost Classification Quality Cost Quality Cost Percent of Total Sales 3 Prevention Appraisal Internal failure External failure Total Formulas