supply chain assignmnet

excel4.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	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
	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?