prepare a cost of quality report, using cell references or excel formulas. Use the green cells to enter your cell references or excel formulas. Forumulas 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. Format dollar amounts with dollar signs, and no decimals format percent as percentages with no decimals.

A quality control activity analysis indicated the following four activity costs of a hotel: \begin{tabular}{l|rr|} \hline Activity & \multicolumn{2}{c|}{ Cost } \\ \hline Inspecting cleanliness of rooms & $ & 96,000 \\ \hline Processing lost customer reservations & $48,000 \\ \hline Rework incorrectly prepared room service meal & $288,000 \\ \hline Employee training & $48,000 \\ \hline Total & $480,000 \\ \hline \end{tabular} Sales $4,800,000 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 that you enter in the green cells will automatically show up in the orange cells - do not modify the existing orange cel Format dollar amounts with dollar signs and no decimals. Format percents as percentages with no decimals