Even though you do not have a technical background, you are asked to provide recommendations on how to reduce defects from an operational perspective. Assignment: (To be completed on the next tab "ECO Insole") 1. Perform a Pareto Analysis for the monthly Reject Log of the manufacturing process based on the total number of rejects from each category. Ensure you provide the Pareto Table and Chart. Include a text box with your observations on the Pareto Analysis (4 marks) 2. Draw a Run Chart (Line Chart) for the top 2 defects indicated on your Pareto Chart, using the monthly reject data. This chart should plot each day's rejects for the top 2 defects. Include a text box with your observations on the run chart. (4 marks) 3. Draw a Fish-Bone (Cause and Effect) diagram, which indicates some possible reasons for the defects listed in the case. Aim for at least 3-4 points on each line. (3 marks) 4. Include a text box and from the information you have discovered, give your top THREE recommendations to the VP of operations on how to reduce defects at ECO Insole. (one paragraph each, please number recommendations \# 1,2,3) (6 marks) 5. The VP of operations is thinking of incorporating the concept of Total Quality Management to their manufacturing process. Discuss how TQM can help ECO Insole to increase the quality of their products. (Do not provide the concept of TQM. Discuss how TQM can be applied to ECO Insole) Check before you submit. Submit one EXCEL document with the filename your firstname.lastnameAss2. Ensure that you use EXCEL formulas for all calculations. Round all numbers to whole numbers. The charts and graphs must be generated using Excel. Please remember to identify your charts/graphsMain Titles, X-Axis and Y-Axis labels, data series names. This assignment is NOT to be written in the first person. Format your charts and table. There are 5 questions in this assignment. Make sure to answer them all. Please view the rubric for this assignment before handing in