Supply Chain Operation

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	11.11%	10.80%	13.20%
				Yellow	4	14.81%	13.50%	16.50%
				Blue	6	22.22%	20.70%	25.30%
				Orange	6	22.22%	20.70%	25.30%
				Green	5	18.52%	13.50%	16.50%
				Brown	3	11.11%	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)
				The expectations are close to the actual percentages. Blue, brown, orange, yellow and red has close to the expectation. The only colour that deviates is green which has a deviation of 3%.

Bar Chart-M&M Colors (Test Bag:NAS-567)

# of Red # of Yellow # of Blue # of Orange # of Green # of Brown 3 4 6 6 5 3

M&M Color

Number of each colour

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	20.00
2	131	8	1	4	1	2		2	2	1	21	3	7.00
3	138	6	2	3	1			3	3	2	22	5	4.40
4	145	11	4	4	1	2		4	2	0	23	2	11.50
5	165	12	4	4	2	2		5	1	2	25	3	8.33
6	190	13	5	5	3			6	1	4	24	5	4.80
7	205	15	7	6	1	1		7	2	1	21	3	7.00
8	201	15	6	7	0	2		8	1	2	22	3	7.33
9	204	15	5	6	2	2		9	1	1	21	2	10.50
10	215	17	5	6	4	2		10	1	2	21	3	7.00
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?
		One should focus on the incorrect truck load as it has the highest cause of defects.
	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?
		As the number of shipments with defects increase, the average number of shipments per worker decreases.

Avg Number of Shipments Per Worker Vs. Number of Defects

No. of Shipments with Defects 1 2 3 4 5 6 7 8 9 10 5 8 6 11 12 13 15 15 15 17 Avg. Number o f Shipments Per Worker 1 2 3 4 5 6 7 8 9 10 20 7 4.4000000000000004 11.5 8.3333333333333339 4.8 7 7.333333333333333 10.5 7

Week Number

Number of shipments with defects

image1.jpeg

image2.jpeg