this is the full question!

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. 150 Mercury, Inc. Quality Cost Report (in thousands) Last Year This Year Prevention costs: Machine maintenance $ 70 $ 120 Training suppliers 10 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 410 110 Total quality cost $ 670 $ 590 Total production cost $4,200 $4,800 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 rctail 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. Carry all computations to one decimal place. By analyzing the report, determine if Mercury, Inc.'s quality improvement program has been successful. List specific cvidence to support your answer. 2. Do you expect the improvement program as it progresses to continue to increase the workload in the Production Department? 3. Jorge Gomez believed that the quality improvement program was essential and that Mercury, Inc., could no longer afford to ignore the importance of product quality. Discuss how Mercury, Inc., could measure the cost of not implementing the quality improvement program Total production cost $ 4,200 $ 4,800 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, Inc. Quality Cost Report (in thousands) Last Year Percentage of Percentage of Total Production Total Quality Cost Cost This Year Percentage of Total Production Cost Amount Amount Percentage of Total Quality Cost $ 70 % % $ % % 1.7 0.0 0.0 1.7 10.4 0.0 0.0 10.4 120 10 20 150 2.5 0.2 0.4 3.1 20.3 1.7 3.4 25.4 0.5 3.0 11.9 14.9 1.9 2.4 40 90 130 0.8 1.9 2.7 6.8 15.3 22.1 100 Prevention costs: Machine maintenance Training suppliers Quality circles Total prevention costs Appraisal costs: Incoming inspection Final testing Total appraisal costs Internal failure costs: Rework Scrap Total internal failure costs External failure costs: Warranty repairs Customer returns Total external failure costs Total quality cost Total production cost 50 1.2 1.0 2.2 7.5 6.0 13.5 130 70 200 2.7 1.5 4.2 22.0 11.9 33.9 90 90 0.6 2.1 7.6 320 13.4 47.8 61.2 30 80 110 1.7 5.1 13.6 18.7 410 9.7 2.3 12.3 16.0 100.0 100.1 $ $ 670 4,200 $ $ 590 4,800 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. 150 Mercury, Inc. Quality Cost Report (in thousands) Last Year This Year Prevention costs: Machine maintenance $ 70 $ 120 Training suppliers 10 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 410 110 Total quality cost $ 670 $ 590 Total production cost $4,200 $4,800 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 rctail 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. Carry all computations to one decimal place. By analyzing the report, determine if Mercury, Inc.'s quality improvement program has been successful. List specific cvidence to support your answer. 2. Do you expect the improvement program as it progresses to continue to increase the workload in the Production Department? 3. Jorge Gomez believed that the quality improvement program was essential and that Mercury, Inc., could no longer afford to ignore the importance of product quality. Discuss how Mercury, Inc., could measure the cost of not implementing the quality improvement program Total production cost $ 4,200 $ 4,800 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, Inc. Quality Cost Report (in thousands) Last Year Percentage of Percentage of Total Production Total Quality Cost Cost This Year Percentage of Total Production Cost Amount Amount Percentage of Total Quality Cost $ 70 % % $ % % 1.7 0.0 0.0 1.7 10.4 0.0 0.0 10.4 120 10 20 150 2.5 0.2 0.4 3.1 20.3 1.7 3.4 25.4 0.5 3.0 11.9 14.9 1.9 2.4 40 90 130 0.8 1.9 2.7 6.8 15.3 22.1 100 Prevention costs: Machine maintenance Training suppliers Quality circles Total prevention costs Appraisal costs: Incoming inspection Final testing Total appraisal costs Internal failure costs: Rework Scrap Total internal failure costs External failure costs: Warranty repairs Customer returns Total external failure costs Total quality cost Total production cost 50 1.2 1.0 2.2 7.5 6.0 13.5 130 70 200 2.7 1.5 4.2 22.0 11.9 33.9 90 90 0.6 2.1 7.6 320 13.4 47.8 61.2 30 80 110 1.7 5.1 13.6 18.7 410 9.7 2.3 12.3 16.0 100.0 100.1 $ $ 670 4,200 $ $ 590 4,800