MMProjectQuality1.xlsx

Colors & Lengths

M&M Analysis: Tools of Quality – Part #1
M&M Checksheet
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 Activity #2
Candy Piece # Lengths in (mm)
1 12.00
2 11.38
3 11.84
4 13.20 Insert Bar Chart – M&M Colors Insert Histogram – M&M Lengths
5 11.84 **** Here***** **** Here*****
6 11.69
7 10.75
8 10.28
9 10.60
10 11.06
11 12.15
12 13.09
13 12.00
14 12.78
15 11.53
16 11.22
17 12.16
18 13.25
19 12.78
20 11.69
21 10.92 Activity #3 What are the percentages of each color in your sample (fill in the percentage in each box next to the appropriate candy color)?
22 13.40
Candy Color Number of Pieces Percentage of Total Lower Control Limit Upper Control Limit
Red 3 10.80% 13.20%
Yellow 4 13.50% 16.50%
Blue 6 20.70% 25.30%
Orange 6 20.70% 25.30%
Green 5 13.50% 16.50%
Brown 3 10.80% 13.20%
Activity #4 Conclude whether or not the percentages of your sample are reasonably within the expectations communicated by Mars Inc. (within the provided control limits)

Shipments

M&M Analysis: Tools of Quality – Part #2
M&M Defective Shipment Form Summary
Week No. of Shipments No. of Shipments with Defects Reason for Defective Shipment Week No. of New Hires No. of Terminations Total No. of Workers Turnover Avg. Number of Shipments Per Worker
Incorrect Bill of Lading Incorrect Truck Load Damaged Product Trucks Late
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
*** Here *** *** Here ***
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?