As they were reviewing the report, Elsoe asked Tran what he now thought of the quality improvement program. Tran replied. "I'm relieved that the new quality improvement program hasn't hurt our bonuses, but the program has increased the workload in the Production Department. It is true that customer returns are way down, but the cell phones that were returned by customers to retail outlets were rarely sent back to us for rework." Required: 1. Expand the company's quality cost report by showing the costs in both years as percentages of both total production cost and total quality cost. (Round your percentage answers to 1 decimal place (i.e 0.1234 should be entered as 12.3 ).) Mercury, Incorporated Quality cost Report (in thousands) Prevention costs: Last Year This Year Machine maintenance Training suppliers Quality circles Total prevention cost Appraisal costs : Incoming inspection Final testing Total appraisal cost Internal failure costs : Rework Scrap Total internal failure cost External failure costs: Warranty repairs Customer returns Total external failure cost Total quality cost Total production cost \begin{tabular}{rr} $230 & $120 \\ 7 & 10 \\ 23 & 70 \\ \hline 260 & 200 \\ \hline 45 & 26 \\ 165 & 84 \\ \hline 210 & 110 \\ \hline 130 & 66 \\ 66 & 60 \\ \hline 196 & 126 \\ \hline 64 & 28 \\ 256 & 87 \\ \hline 320 & 115 \\ \hline$986 & $551 \\ \hline \hline 4,130 & $4,530 \\ \hline \hline \end{tabular} Mercury, Incorporated, produces cell phones at its plant in Texas. In recent years, the company's market share has been eroded by stiff competition from overseas. Price and product quality are the two key areas in which companies compete in this market. A year ago, the company's cell phones had been ranked low in product quality in a consumer survey. Shocked by this result, Jorge Gomez, Mercury's president, initiated an intense effort to improve product quality. Gomez set up a task force to implement a formal quality improvement program. Included on this task force were representatives from the Engineering, Marketing. Customer Service, Production, and Accounting departments. The broad representation was needed because Gomez believed that this was a companywide program and that all employees should share the responsibility for its success. After the first meeting of the task force, Holly Elsoe, manager of the Marketing Department, asked John Tran, production manager, what he thought of the proposed program. Tran replied, "I have reservations. Quality is too abstract to be attaching costs to it and then to be holding you and me responsible for cost improvements, I like to work with goals that I can see and count! I'm nervous about having my annual bonus based on a decrease in quality costs; there are too many variables that we have no control over." Mercury's quality improvement program has now been in operation for one year. The company's most recent quality cost report is shown below. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Morcury, Incorporated } \\ \hline \multicolumn{7}{|c|}{ Quality Cost Report } \\ \hline \multicolumn{7}{|c|}{ (in thousands) } \\ \hline & \multicolumn{3}{|c|}{ Last Yoar } & \multicolumn{3}{|c|}{ This Year } \\ \hline & Amount & \begin{tabular}{c} Percentage of \\ Total Production \\ Cost \end{tabular} & \begin{tabular}{c} Percentage of \\ Total Quality \\ Cost \end{tabular} & Amount & \begin{tabular}{l} Percentage of \\ Total Production \\ Cost \end{tabular} & \begin{tabular}{c} Percentage of \\ Total Quality \\ Cost \end{tabular} \\ \hline \multicolumn{7}{|l|}{ Prevention costs: } \\ \hline Machine maintenance & 230 & & & 1207 & & \\ \hline Training suppliors & 7 & & & 107 & & \\ \hline Quality circles & 23 & & & 70 & & \\ \hline Total prevention costs & 260 & 0.0 & 0.0 & 200 & 0.0 & 0.0 \\ \hline \multicolumn{7}{|l|}{ Appraisal costs: } \\ \hline Incoming inspection & 45 & & & 263 & & \\ \hline Final testing & 165 & & & 848 & & \\ \hline Total appraisal costs & 210 & 0.0 & 0.0 & 110 & 0.0 & 0.0 \\ \hline \multicolumn{7}{|l|}{ Internal failure costs: } \\ \hline Rework & 130 & & & 667 & & \\ \hline Scrap & 66 & & & 60 & & \\ \hline Total internal falure costs & 196 & 0.0 & 0.0 & 126 & 0.0 & 0.0 \\ \hline \multicolumn{7}{|l|}{ External falure costs: } \\ \hline Warranty repairs & 4 & & & 28 & & \\ \hline Customer returns & 256 & & - & 8773 & & \\ \hline Total external failure costs & 320 & 0.0 & 0.0 & 115 & 0.0 & 0.0 \\ \hline Total quality cost & 986 & 0.0 & 0.0 & 551 & 0.0 & 0.0 \\ \hline Total production cost & $4,130 & & -1 & 4,530 & & \\ \hline \end{tabular}