Question

1 Approved Answer

Posted on Sep 10, 2024

Gage R&R: Perform a gage repeatability and reproducability (GR&R) study using 50 M&M candy pieces. Use the template provided in Excel to do the study.

Gage R&R: Perform a gage repeatability and reproducability (GR&R) study using 50 M&M candy pieces. Use the template provided in Excel to do the study. You be the expert deciding whether a piece is good or not, and use 3 other people to perform the study. After a first run, discuss with the team why the GR&R result is not below 10% and brainstorm to come up with a way that all decide the same. Perform the study again and see what improvement resulted from the test. Submit your results as a PDF file in this assignment. The report needs to show the two spreadsheets for before and after, and a write-up on what was done to improve after the before state to reach the after state. You may conduct this assignment with another student if you would like. Both will get the same grade.

image text in transcribed

GAGE R&R FOR ATTRIBUTE GAGES Gage Name: Part No. and Name = of operators: 3 Date: Gage No = of parts: 30 Performed by: Approved by Gage Type: Operator 2 Operator 1 Adam Bobby Operator 3 Charlie Enter data for 30 parts in shaded areas only. Operator calling Good product Bad Operator calling Bad product Good Adam Operator / Operator Bobby Charlie Known Samples 1 and standard agree Operator 2 readings agree Operator 2 and standard agree Operator Operator 3 and readings standard agree agree readings agree All agree within and between All agree with standard Operator 1 perator Operator 2 perator 2 operator perator Operator 3 Operator 1 Operator 2 perator Operator 3 Operator 1 Operator 2 Operator 3 Sample # Standard Test #1 Test #2 T/F T/F Test 1 Test 2 T/F T/F Test Test 2 T/F T/F TIE T/F 1 2 1 2 1 2 1 2 1 2 1 2 1 G FALSE FALSE E TRUE TRUE TRUE TRUE FALSE FALSE 0 1 0 0 0 0 0 0 0 2 B G G TRUE FALSE B b TRUE TRUE E b FALSE FALSE FALSE FALSE 0 0 0 0 1 1 0 0 1 0 3 B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 4 B G B FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 0 1 0 0 0 0 0 5 G B TRUE FALSE B B TRUE FALSE B B TRUE FALSE TRUE FALSE 1 1 1 1 1 1 0 0 0 0 0 0 6 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 7 G B G FALSE FALSE B B TRUE FALSE B B TRUE FALSE FALSE FALSE 1 1 1 1 1 0 0 0 0 0 8 B B FALSE FALSE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 0 0 1 0 1 0 1 0 9 B G TRUE FALSE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 1 1 1 1 0 10 B B B B TRUE TRUE B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 B B B 11 B B B TRUE TRUE B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 o 0 0 0 0 0 0 0 0 12 B G FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 1 0 0 0 0 0 13 B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 TRUE TRUE B B TRUE TRUE B B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 15 G FALSE FALSE B B TRUE FALSE B B TRUE FALSE FALSE FALSE 0 1 1 1 1 0 0 0 0 0 0 16 B G TRUE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 1 0 0 0 0 17 B B TRUE TRUE B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 0 0 0 0 1 0 1 0 18 B G TRUE FALSE B B G FALSE B G FALSE FALSE FALSE FALSE 0 0 0 0 0 1 1 0 1 0 1 FALSE TRUE 19 B B TRUE TRUE B B TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 20 B TRUE FALSE B B TRUE FALSE B B TRUE FALSE TRUE FALSE 1 1 1 1 1 1 0 0 0 0 0 21 G r FALSE FALSE B r FALSE FALSE B r FALSE FALSE FALSE FALSE 0 0 1 0 1 0 0 0 0 0 0 0 22 B G B FALSE FALSE B B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 0 0 0 0 0 0 23 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 24 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 25 B G B FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 0 0 0 0 0 26 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 TRUE TRUE 27 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 28 G G TRUE TRUE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 1 0 1 0 0 0 0 0 0 29 B B B TRUE TRUE B B TRUE TRUE B b TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 30 B G TRUE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 1 0 0 0 0 0 5 1 10 TOTALS 21 14 20 23 19 14 12 3 4 5 5 5 5 3 1 4 1 Operator v/s self 7096 8096 27 24 Operator v/s standard 4798 6796 639 8.65% 7.6996 Operators agreed % of good product that was rejected % of bad product that went to the customer Operators agreed with standard 4056 Cala Cartolibre GAGE R&R FOR ATTRIBUTE GAGES Gage Name: Part No. and Name = of operators: 3 Date: Gage No = of parts: 30 Performed by: Approved by Gage Type: Operator 2 Operator 1 Adam Bobby Operator 3 Charlie Enter data for 30 parts in shaded areas only. Operator calling Good product Bad Operator calling Bad product Good Adam Operator / Operator Bobby Charlie Known Samples 1 and standard agree Operator 2 readings agree Operator 2 and standard agree Operator Operator 3 and readings standard agree agree readings agree All agree within and between All agree with standard Operator 1 perator Operator 2 perator 2 operator perator Operator 3 Operator 1 Operator 2 perator Operator 3 Operator 1 Operator 2 Operator 3 Sample # Standard Test #1 Test #2 T/F T/F Test 1 Test 2 T/F T/F Test Test 2 T/F T/F TIE T/F 1 2 1 2 1 2 1 2 1 2 1 2 1 G FALSE FALSE E TRUE TRUE TRUE TRUE FALSE FALSE 0 1 0 0 0 0 0 0 0 2 B G G TRUE FALSE B b TRUE TRUE E b FALSE FALSE FALSE FALSE 0 0 0 0 1 1 0 0 1 0 3 B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 4 B G B FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 0 1 0 0 0 0 0 5 G B TRUE FALSE B B TRUE FALSE B B TRUE FALSE TRUE FALSE 1 1 1 1 1 1 0 0 0 0 0 0 6 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 7 G B G FALSE FALSE B B TRUE FALSE B B TRUE FALSE FALSE FALSE 1 1 1 1 1 0 0 0 0 0 8 B B FALSE FALSE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 0 0 1 0 1 0 1 0 9 B G TRUE FALSE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 1 1 1 1 0 10 B B B B TRUE TRUE B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 B B B 11 B B B TRUE TRUE B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 o 0 0 0 0 0 0 0 0 12 B G FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 1 0 0 0 0 0 13 B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 TRUE TRUE B B TRUE TRUE B B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 15 G FALSE FALSE B B TRUE FALSE B B TRUE FALSE FALSE FALSE 0 1 1 1 1 0 0 0 0 0 0 16 B G TRUE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 1 0 0 0 0 17 B B TRUE TRUE B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 0 0 0 0 0 0 1 0 1 0 18 B G TRUE FALSE B B G FALSE B G FALSE FALSE FALSE FALSE 0 0 0 0 0 1 1 0 1 0 1 FALSE TRUE 19 B B TRUE TRUE B B TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 20 B TRUE FALSE B B TRUE FALSE B B TRUE FALSE TRUE FALSE 1 1 1 1 1 1 0 0 0 0 0 21 G r FALSE FALSE B r FALSE FALSE B r FALSE FALSE FALSE FALSE 0 0 1 0 1 0 0 0 0 0 0 0 22 B G B FALSE FALSE B B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 0 0 0 0 0 0 23 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 24 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 25 B G B FALSE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 0 1 0 0 0 0 0 26 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 TRUE TRUE 27 B B B TRUE TRUE B B TRUE TRUE B B TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 28 G G TRUE TRUE G B FALSE FALSE G B FALSE FALSE FALSE FALSE 0 1 0 1 0 0 0 0 0 0 29 B B B TRUE TRUE B B TRUE TRUE B b TRUE TRUE TRUE TRUE 0 0 0 0 0 0 0 0 0 0 0 0 30 B G TRUE FALSE B B TRUE TRUE B B TRUE TRUE FALSE FALSE 0 0 0 0 1 0 0 0 0 0 5 1 10 TOTALS 21 14 20 23 19 14 12 3 4 5 5 5 5 3 1 4 1 Operator v/s self 7096 8096 27 24 Operator v/s standard 4798 6796 639 8.65% 7.6996 Operators agreed % of good product that was rejected % of bad product that went to the customer Operators agreed with standard 4056 Cala Cartolibre