Vanden manufacturing plant manufactures various metallic screws, nuts, plates and other industrial goods defects. There are 200 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. Mike, an excellent CEO wants to improve on the quality of this product. As Mike's Operations Manager, help Mike 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) Mike wants to emulate the Japanese concept of TQM. Help suggest ideas to Mike on how and where to apply TQM (Do not write what TQM is) 4 marks

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