M&M Analysis: Tools of Quality Supply Chain Assignment: After completing the videos and readings included in the Six Sigma Quality module, you should have a basic understanding of how to use the seven tools of quality. This exercise will allow you to appl

M&M Analysis: Tools of Quality Supply Chain Assignment: After completing the videos and readings included in the Six Sigma Quality module, you should have a basic understanding of how to use the seven tools of quality. This exercise will allow you to apply what you have learned to an M&M quality study. Your customers have complained about late shipments recently. Therefore, you have decided to implement a process where drivers complete a new form on arrival at the customers’ stores. You had one of your employees summarize the forms for the last ten weeks and total the number of shipments, number of shipments with defects, and the total number of each reason for any defect shipments. You also asked your employee to summarize the total number of workers for each of the same weeks as was included in the above analysis. The results of the employee’s data gathering are in the Excel spreadsheet (M&M Project Quality – Part 2) attached to this assignment in D2L. Open the Excel file and familiarize yourself with the data. Your job is to complete the following: • Activity #1: Develop a Pareto chart (in the Excel document) for the type of defects that have occurred. The Pareto diagram format should replicate the following example (title, axis titles, etc.). Hint: A Pareto diagram needs to have a percentage line. (12 points) • Activity #2: Develop a Run Chart (in the Excel document) including a line for the average number of shipments per worker per week and a line for the number of defects per week. You will need to calculate the average number of shipments per worker in column N. The format of the graph should replicate the following example (title, axis titles, etc.). (15 points) • Activity #3: Answer the question in the Excel document (3 points) • Activity #4: Answer the question in the Excel document (5 points) You will find hints on creating the charts using excel to create these charts in the Supplemental Material section of the Quality Module in D2L. You must submit an Excel file to the appropriate dropbox in D2L. Grading: Assignment is worth 35 points as follows: • Activity #1 - Pareto Diagram 12 points o Correct chart title 1 point o x-axis Title 1 point o y-axis Title 1 point o correct secondary y-axis labels 1 point o Correct x-axis labels 1 point o Correct y-axis labels 1 point o Correct number of bins 1 point o Correct number value for each defect 4 points o Correct Pareto line 1 point • Activity #2 – Run Chart 15 points o Correct chart title 1 point o x-axis Title 1 point o y-axis Title 1 point o Correct x-axis labels 1 point o Correct y-axis labels 1 point o Correct line series for Average number of shipments per worker 5 points o Correct line series for Average number of defects 5 points • Activity #3 – answer question 3 points • Activity #4 – answer question 5 points • TOTAL 35 points