Quality Assurance

Assignment.xlsx

Problem

	You are the Quality Control Manager for a lithium battery company
	One of the products is a cathode and the length specification is
	LSL	26.45	inches
	USL	26.70	inches
	Your current process yields the following;
	Mean	26.540	in.
	Std Dev	0.050	in.
	Rejected parts cost		$ 2.41
	Determine the coefficient k for the Loss Function
1 mark
	Determine the average cost (per part)
1 mark
3 marks	Create a histogram of the current situation.
2 marks	Add the Loss function Curve to your chart.
1 mark	Add a text box showing the total losses for a batch of 5000 pcs
	Recalculate the average cost per unit if the process were centered
1 mark
	Recalculate again for the process centered and with a reduced standard deviation (50%)
1 mark
3 marks	Generate a new histogram for the new centered process with half the standard deviation
2 marks	Add the Loss function Curve to your chart.
1 mark	Add a text box showing the total losses for a batch of 5000 pcs