In: Operations Management
Consider the two processes below with specifications 100 plus or minus 10:
Q. What is the fraction non-conforming for each process?
process 1:
DPMO is calculated using Excel formula
Yield =1-(DPMO/1000000)
99.91% of Items are fall in between USL or 110 and LSL or 90
hence, Fraction non conforming for this process=1-0.9991=0.0009
| 1 | B | C | D | E |
| 2 | Continuous process (normally distributed) | |||
| 3 | Mean: | 100 | DPMO: | 858.1 |
| 4 | Standard Deviation | 3 | Yield | 0.9991 |
| 5 | LSL: | 90 | ||
| 6 | USL: | 110 |
Formula:
| 1 | B | C | D | E |
| 2 | Continuous process (normally distributed) | |||
| 3 | Mean: | 100 | DPMO: | =((1-NORMDIST(C6,C3,C4,TRUE))+(NORMDIST(C5,C3,C4,TRUE)))*1000000 |
| 4 | Standard Deviation | 3 | Yield | =1-(E3/1000000) |
| 5 | LSL: | 90 | ||
| 6 | USL: | 110 |
process 2:
here, we find that 100% items are falling in between USL or 110 and LSL or 90
so, we can conclude that fraction nonconforming for this process= 1-yield=1-1=0 or zero
| 1 | B | C | D | E |
| 2 | Continuous process (normally distributed) | |||
| 3 | Mean: | 105 | DPMO: | 0.3 |
| 4 | Standard Deviation | 1 | Yield | 1.0000 |
| 5 | LSL: | 90 | ||
| 6 | USL: | 110 |
| 1 | B | C | D | E |
| 2 | Continuous process (normally distributed) | |||
| 3 | Mean: | 105 | DPMO: | =((1-NORMDIST(C6,C3,C4,TRUE))+(NORMDIST(C5,C3,C4,TRUE)))*1000000 |
| 4 | Standard Deviation | 1 | Yield | =1-(E3/1000000) |
| 5 | LSL: | 90 | ||
| 6 | USL: | 110 |