1 Cost of quality report 2 B Quality Cost Classification 3 Aquality control activity analysis indicated the following four activity costs of a hotel: 4 $ 4,800,000 5 Activity 6 Inspecting cleanliness of rooms 7 Processing lost customer reservations 8 Rework Incorrectly prepared room service meal 9 Employee training 10 Total 11 12 Sales 13 14 Required 15 Prepare a cost of quality report using cell references or Excel formulas. Use the green cells to enter your cell references or Excel formulas. 16 Formulas that you enter in the green cells will automatically show up in the orange cells- do not modify the existing orange cell formulas that do this. 17 Format dollar amounts with dollar signs and no decimals. Format percents as percentages with no decimals. 18 19 20 21 22 Prevention Cost of Quality Report Quality Cost 23 Appraisal 24 Internal failure 25 External failure 26 Total 27 28 DO NOT EDIT THE CELLS BELOW THIS LINE. 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 C Formulas + Percent of Total Quality cost D $ $ $ $ $ Cost 96,000 48,000 288,000 48,000 480,000 E Percent of Total Sales F H J K

A quality control activity an blvitindicated the follewing bur activitycels of a botel: A quality control activity analysis indicated the following four activity costs of a hotel: Required Prepare a cost of quality report using cell references or Excel formulas Use the green cells to enter your cell references or Excel formulas