Question

Case Study: You are a supply chain engineer and have been assigned by your manager to determine which of two suppliers you should use to purchase specialized stainless steel rods cut to a specific length. You are provided with the specifications, pricing from each of the suppliers, and sample data from each supplier representing product made in their respective processes. Your understanding is that each supplier buys the base rod and they each have a different cut to length process. You are asked to purchase 10,000 rods. Analyze the data and provide a full technical report including a discussion, conclusions, and recommendations.

Specifications - Specialized Stainless Steel Rods
Material Density	7700	kg/m3
Length Target	0.5	m
Length Tolerance	+/- 0.02	m
Diameter Target	2.50	cm
Diameter Tolerance	+/- 0.01	cm

Marquis Enterprises
Length (m)	Diameter (cm)	Price per 100 Pieces
0.506	2.501	$                 4,000.00
0.501	2.499
0.496	2.498
0.497	2.497
0.501	2.501
0.503	2.500
0.502	2.502
0.499	2.502
0.498	2.500
0.500	2.500
0.501	2.499
0.501	2.498
0.498	2.499
0.498	2.500
0.501	2.499
0.500	2.498
0.497	2.501
0.498	2.502
0.503	2.499
0.498	2.500
0.501	2.501
Clark Incorporated
Length (m)	Diameter (cm)	Price per 100 Pieces
0.510	2.500	$                 3,200.00
0.530	2.499
0.480	2.497
0.480	2.498
0.490	2.503
0.510	2.500
0.520	2.502
0.480	2.501
0.490	2.499
0.490	2.500
0.500	2.498
0.500	2.502
0.490	2.500
0.480	2.501
0.500	2.499
0.510	2.498
0.480	2.502
0.480	2.501
0.490	2.498
0.490	2.504
0.500	2.501

full technical report and and discussions, plus recommendations. please.

Answer 1

length (m) Diameter (cm) $ 0.506 2.501 4,000.00 2.499 2.498 2.497 0.501 0.496 0.497 0.501 2.501 2.5 2.502 2.502 2.5 2.5 0.503 0.502 0.499 0.498 0.5 0.501 2.499 2.498 2.499 2.5 2.499 2.498 0.501 0.498 0.498 0.501 0.5 0.497 0.498 0.503 0.498 2.501 2.502 2.499 2.5 0.501 2.501 0.49995238: Average 2.499809524 0.001435933 SD 0.00243877 length (m) Diameter (cm) $ 2.5 3,200.00 0.51 0.53 0.48 0.48 0.49 2.499 2.497 2.498 2.503 0.51 2.5 2.502 0.52 0.48 0.49 0.49 2.501 2.499 2.5

0.5 2.498 2.502 2.5 0.5 0.49 0.48 2.501 0.5 2.499 2.498 0.51 0.48 0.48 2.502 2.501 2.498 2.504 0.49 0.49 0.5 2.501 0.4952381 2.500142857 Average 0.00185164 SD 0.01435933

Technical Report fAamp les are given There are two the arerage attribute Compan o both the Spplien Fa Marquis En terpsses Leng th Avernge Lwant to Diameter ti O.4.9995 Q.4998 is Stel. deviabin 0.0024 For Clark InCer parated lengrs Diametor 2-5001428577 Aremge O.9952381 Std deviahan 0.014 95933 00185164 Since our length target is 0Sm with tength toferavee e .02m ie We are ok with leng th betiseon 0.46m amdl 0 S2m Ane Our diameter tarjet s 2.50 Cm widh diameter to lerenee 0.ol Cm ok oith digmeter beta can we Gre 2.49 Cm andl 2.1 em

f2n remair riation Since cleyk Inerporatea attributes (lenyfe diameters) are Specificatio anol howe lous cosf thom Marqui Entertices, So T oulol recommord to elark ncapareted supplier. af broticafe wsi h our