M&M Analysis Tools of Quality - Part #2

MMProjectQuality-Part2.xlsx

Data

					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	6	1	4	1	2	2	2	1	21	3
3	138	6	2	3	1		3	3	2	22	5
4	145	9	4	4	1	2	4	2	0	23	2
5	165	10	4	4	2	2	5	1	2	25	3
6	190	13	5	5	3		6	1	4	24	5
7	205	14	7	6	1	1	7	2	1	21	3
8	201	13	6	7	0	2	8	1	2	22	3
9	204	13	5	6	2	2	9	1	1	21	2
10	215	15	5	6	4	2	10	1	2	21	3
TOTALS	1717	104	41	47	16	13
	Insert your Pareto - Reason for Defective Shipment Chart						Insert your Avg Num of Shipments Per Worker Vs. Num of Defects Chart
		* Here *							* Here *
	Activity
	3	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?
	4	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?