Question

Check my work Mercury, Inc., 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.

Answer 1

Answer is given below

Also excel screen shot is given for formulas

Mercury Inc. Quality Cost Report (in thousands) Last year Percentage Percentage of of Amount Total Total Production Quality cost cost of This year Percentage Percentage of Total Total Production Quality cost cost Particulars of Cost Amou 2.5% Prevention Cost Machine maintenance Training suppliers Quality circle 1.7% 0.0% 0.0% 10.4% 0.0% 0.0% 0.2% 20.3% 1.7% 3.4% $20 0.4% 1.7% 10.4% $150 3.1% 25.4% Total Preventive Costs Appraisal Cost Income inspection Final testing 0.5% 0.8% 3.0% 11.9% $40 $901 6.8% 15.3% 1.9% 1.9% $100 2.4% 14.9% $130 2.7% 22.0% Total Appraisal Costs Internal Failure Costs Rework Scrap $50 1.2% 1.0% 7.5% 6.0% 2.7% 1.5% 22.0% 11.9% $90 2.1% 13.4% $200 4.2% 33.9% Total Internal Failure Costs External Failure Costs Warranty Repairs Customer returns 5.1% $320 2.1% 7.6% 13.4% 47.8% $30 $80 0.6% 1.7% 13.6% Total External Failure Costs $410 9.8% 61.2% $110 2.3% 18.6% 16.0% 100.0% 12.3% 100.0% Total Quality cost Total Production cost $670 $4,200 $590 $4,800

C D Percentage Percentage Percentage Particulars of Cost Amount Percentage of Total Quality cost Total Production cost Amount Total Production cost Total Quality cost Prevention Cost Machine maintenance Training suppliers Quality circle =F11/F$33 =F12/F$33 =F13/F$33 =F11/F$32 =F12/F532 =F13/F$32 =111/1$33 =112/1$33 =113/1$33 =111/1$32 =112/1$32 =113/1$32 -SUM(F11:F14) =F15/F533 =F15/F$32 =SUM(111:114) I=115/1$33 =115/1$32 Total Preventive Costs Appraisal Cost Income inspection Final testing =F17/F$33 =F18/F$33 =F17/F$32 =F18/F$32 =117/1$33 =118/1$33 =117/1$32 =118/1$32 -SUM(F17:F18) =F20/F$33 =F20/F$32 =SUM(117:118) =120/1$33 = 120/1$32 Total Appraisal Costs Internal Failure Costs Rework Scrap 130 =F22/F$33 =F23/F$33 =F22/F$32 =F23/F532 =122/1$33 =123/1533 =122/1$32 =123/1$32 -SUM(F22:F24) 1=F25/F$33 -F25/F532 =SUM(122:124) =125/1$33 =125/1$32 Total Internal Failure Costs External Failure Costs Warranty Repairs Customer returns =F27/F$33 =F28/F$33 =F27/F$32 =F28/F$32 =127/1$33 =128/1$33 =127/1$32 =128/1$32 320 Total External Failure Costs =SUM(F27:F29) |=F30/F$33 =F30/F$32 =SUM(127:129) =130/1$33 =130/1$32 =F32/F$32 =132/1$33 =132/1$32 Total Quality cost Total Production cost =F15+F20+F25+F30-F32/F$33 4200 =115+120+125+130 4800