Ac 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:

Q1. Draw a Pareto Chart and identify the most priority defects to address beneath the graph. Why do you say so?

Q2. Plot a Line chart for the top 2 defects from your pareto chart and analyze beneath the chart.

Q3. Create/Draw an Ishikawa Diagram, Identify areas that can help rectify quality 4 marks

Q4. Based on all the above, identify and list out 5 measures in point form that you would advise Mike to adopt to increase quality.

Q5. 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)

Days 1 to 21 Not polished improper shape Cracks mproper winding spiral not finished Perforations improper thickness 21 15 20 10 4 5 10 5 5 13 3 W 6 19 w 12 1 13 UT 15 W 11 4 6 - N 2 10 3 3 3 2 10 4 56 23 3 N CO 11 2 34 10 IN 10 5 11 15 7 6 12 2 10 13 4 6 13 A W M W W A W - U A W 14 16 IN A 15 18 IN WU ANN WA W N 16 13 17 11 4 W W N UI N UT W U 18 15 3 19 15 6 5 20 14 w 21 15 2 317 72 100 151 86 83 58