QAExcel.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)

					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?