ABC manufacturing plant manufactures various metallic screws, nuts, plates and other industrial goods defects. There are 250 employees and 25% are relatively new. Training is imparted once in 2 years. On observing one product- metallic Hexagonal nuts of various sizes like 3/8, 3/4, 9/16 etc., they analyzed the Product's quality statistics for three weeks and gathered some data that shows the following. The data shows the following defects during the run of production for 3 weeks. Some defects were seen and measured like some were not properly polished, not properly shaped, not proper winding spirals, perforations in the screws, cracks, not finished well etc. The data is given in the table below. Jane, an excellent CEO wants to improve on the quality of this product. As Jane's Operations Manager, help Jane draw up conclusions to rectify the defects. The Rubric is posted below. ALL are to be done only on the same Excel file- one sheet or multiple sheets, through the following processing order of Answers 1 to 5: 1) Draw a Pareto Chart and identify the most priority defects to address beneath the graph. Why do you say so?. 5 marks 2) Plot a Line chart for the top 2 defects from your pareto chart and analyze beneath the chart. 4 marks 3) Create/Draw an Ishikawa Diagram, Identify areas that can help rectify quality 4 marks 4) Based on all the above, identify and list out 5 measures in point form that you would advise Mike to adopt to increase quality. 5 marks 5) Jane wants to emulate the Japanese concept of TQM. Help suggest ideas to Jane on how and where to apply TQM (Do not write what TQM is) 4 marks Before submission, please ensure your Excel file is named correctly as OPM400 A 2 (your last, first name) and has answers to all the 4 questions. Please use google chrome or Firefox as your browser so the attachment goes through well. Please check your attachment after the submission. To submit> use Google chrome or Firefox> go to Assignments Exams and Tests > Assignment 2 > attach your document and submit. Ensure that the document is submitted. Days 1 to 21 Not polished improper shape Cracks Improper winding spirals not finished Perforations improper thickness 1 21 15 20 10 4 5 2 10 5 5 13 3 3 6 3 19 3 12 1 13 5 4 15 3 4 11 4 2 6 5 2 10 3 1 3 6 3 4 4 2 10 4 7 56 8 7 23 4 3 8 11 2 6 2 3 5 9 34 8 4 6 2 10 10 5 6 4 5 11 15 7 5 6 7 7 4 12 2 3 6 7 3 10 3 13 4 6 4 13 4 2 2 14 16 2 4 5 3 4 2 15 18 2 1 3 3 4 16 13 3 5 5 5 3 5 17 11 7 3 2 3 4 3 18 15 4 5 4 3 2 19 15 6 5 2 4 3 3 20 14 3 3 3 4 2 21 15 4 2 3 3 3