M&M Analysis: Tools of Quality Assignment Part #1 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. This assignment includes an Excel spreadsheet that contains one check sheet from an M&M process control study (one team member's check sheet). Open the Excel file and familiarize yourself with the data. The research involves counting the number of each M&M individual candy piece's color and measuring the length of each M&M in a single serving bag. We want to understand the distribution of colors of M&M candy pieces and analyze the production process concerning the size of each M&M. Your job is to complete the following: Analysis Complete Activities 1 through 4 on the Excel Tab titled \"Colors & Lengths\": * Activity #1 (use the Excel Tab titled \"Colors & Lengths\"): Using data from the M&M color recording section of the check sheet, create a bar chart using Excel that details each color's number represented in the bag. The bar chart format should replicate the following (title, axis titles, categories, etc.) Bar Chart - M&M Colors (Test Bag: NAS-567) Number of each color # of Red #of Yellow & of Orange # of Blue #of Green & of Brown ME&M Colors * Adctivity #2 (use the Excel Tab titled \"Colors & Lengths\"): Using the measurement recording section of the spreadsheet, create a histogram using Excel that details the length of the M&Ms. The histogram format should include the following (title, axis titles, number of bins, bin starting and ending values, etc.). Hint format your x-axis by the number of bins and use the value 6. Histogram - M&M Length (Test Bag: NAS-567) Number of each measruement category [10.28, 10.80] (10.80, 11.32] (11.32, 11.84] (11.84, 12.36] (12.36, 12.88] (12.88, 13.40] M&M Measurements You will find hints on creating the charts using excel to create these charts in the Supplemental Material section of the Six Sigma Quality Module in D2L. On average, the mix of colors for M&M''s PEANUT CANDIES is: 23% blue, 23% orange, 15% green, 15% yellow, 12% red, 12% brown * Activity #3 (use the Excel Tab titled \"Colors & Lengths\"): Analyze your sample data by calculating your percentage of the total for each color. * Activity #4 (use the Excel Tab titled \"Colors & Lengths\"): Conclude whether or not the percentages of your sample are reasonably within the expectations communicated by Mars Inc. (within the provided control limits). Assignment Part #2 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, the 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. The employee's data gathering results 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: Analysis Complete Activities 5 through 8 on the Excel Tab titled \"Shipments\": * Activity #5 (use the Excel Tab titled \"Shipments\").: 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. Reason for Defective Shipment Number of Defect Shipments N L Incorrect Bill of Lading Trucks Late Incorrect Truck Load Damaged Product Reason for Defect * Activity #6 (use the Excel Tab titled \"Shipments\"): Develop a Run Chart (in the Excel document), including a line for the average number of shipments per worker per week and a * Adctivity #6 (use the Excel Tab titled \"Shipments\"): 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 graph format should replicate the following example (title, axis titles, etc.). Avg Number of Shipments Per Worker Vs. Number of Defects ., 16.00 14.00 3 s 12.00 2 10.00 800 5 6.00 = 2 400 e g 2.00 000 = 1 2 3 a 5 6 7 8 9 10 Week Number =g Avg. Number of Shipments Per Worker No. of Shipments with Defects Activity #7: Answer the question in the Excel document * Activity #8: Answer the question in the Excel document You must submit one Excel-compatible file with the two worksheets, \"Colors & Lengths\" and \"Shipments,\" to the appropriate dropbox in D2L. No other file type will be accepted for this assignment. M&M Checksheet M&M Analysis: Tools of Quality - Part #1 Team # A Bag Identifier # of Red # of Yellow # of Blue # of Orange # of Green # of Brown NAS-567 3 4 6 6 5 3 Activity #1 Candy Piece # Lengths in (mm) Activity #2 1 .2.0 2 11.38 1.84 3.20 Insert Bar Chart - M&M Colors 11.84 **** Here***** Insert Histogram - M&M Lengths 11.69 **** Here***** 10.75 10.28 9 .0.60 10 11.06 2.15 12 .3.09 12.00 14 12.78 15 11.53 16 .1.2 17 12.16 18 13.25 19 12.78 20 11.69 21 10.92 Activity #3 22 13.40 What are the percentages of each color in your sample (fill in the percentage in each box next to the appropriate candy color)? Candy Color Number of Percentage of Lower Control Pieces Total Limit Upper Control Limit Red 3 10.80% 3.20% Yellow 4 13.50% 6.50% Blue 20.70% 25.30% Orange 20.70% 25.30% Greer 13.50% 16.50% Brown 10.80% 13.20%M&M Analysis: Tools of Quality Part #2 AT M&M Defective Shipment Form Summary No. of Reason for Defective Shipment Avg. Number No. of Shipments with |Incorrect Bill of | Incorrect Truck| Damaged No. of No. of Total No. of of Shipments Week Shipments Defects Lading Load Product Trucks Late Week [NewHires| Terminations Workers Turnover | Per Worker 1 123 5 2 2 1 1 1 0 20 1 2 131 8 1 4 1 2 2 2 1 21 3 3 138 6 2 3 1 3 3 2 22 5 4 145 11 4 4 1 2 4 2 0 23 2 5 165 12 4 4 2 2 5 1 2 25 3 6 190 13 5 5 3 6 1 4 24 5 7 205 15 7 6 1 1 7 2 1 21 3 8 201 15 6 7 0 2 8 1 2 22 3 9 204 15 5 6 2 2 9 1 1 21 2 10 215 17 5 6 4 2 10 1 2 21 3 TOTALS 1717 117 41 47 16 13 Activity #5 Activity #6 Insert your Pareto - Reason for Defective Shipment Chart Insert your Avg Num of Shipments Per Worker Vs. Num of Defects Chart X%k Hare H* *EK Hare *k Activity #7 With limited time and funds for defect analysis, which of the four defect reasons should you focus on based on what you have learned in this module? Activity #8 Analyze the two lines in your Avg Number of Shipments Per Worker vs. Number of Defects graph. Is there a relationship between the two lines? If so, what is the relationship and what can you conclude