M5 Problem Set - Quality Through Process Control

A process filling small bottles with baby formula has a target of 3 ounces 0.10 ounces. In other words, a bottle must contain between 2.9 and 3.1 ounces of baby formula.As part of a periodic process capability study, two hundred bottles from the process were sampled. The results showed the average amount of formula placed in the bottles to be 3.042 ounces with a standard deviation of 0.033 ounces.

a. Would you consider this process capable of meeting the required specifications?Answer by calculating an appropriate measure of capability.

b.Assuming that the quantity of formula in a bottle is normally distributed, out of a batch of a million bottles how many do you think would be unacceptable - i.e., outside the specification limits?

c.Currently the process is not centered.If the process is adjusted so that it becomes centered, what is the impact on the process capability measure that you calculated in (a)?

d.Assume that the process is centered.What should the process standard deviation be in order for the process to be considered Six-Sigma compliant (i.e., have C_p or C_pk of 2.0)?

Table below: Please include all calculations/formulas in excel

?

Number of late flights out of 100 randomly selected flights Sample Late Flights (Week) 1 2 2 4 3 10 4 4 1 6 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 B 16 2 17 3 18 7 19 3 20 2 21 3 22 7 23 4 24 3 25 2 26 2 27 0 28 29 3 30 4