A quality consultant was asked to analyze the data from order errors at the Audubon Books, Inc.,
Question:
A quality consultant was asked to analyze the data from order errors at the Audubon Books, Inc., distribution center as shown in the table in the worksheet Prob07-10 in the Ch07Data.xlsx file on the Student Companion Site for this chapter. The data represent a typical order processed in each month and show the errors found in those orders. Any order can have errors from a number of causes, e.g., wrong item and incorrect customer information. Develop a run chart, a frequency histogram, and a u-chart for these data. What insights do you get from each chart? What would you advise the distribution center manager to do about the errors?
| Audubon Book Co. | |||||||||
| Average Number of Nonconformances Per Unit (u) Chart | |||||||||
| This spreadsheet is designed for up to 75 samples. Enter data ONLY in yellow-shaded cells. | |||||||||
| Click on the sheet tab to display the control chart (some rescaling may be needed). | |||||||||
| Average (u-bar) | 0.030 | ||||||||
| Sample | |||||||||
| Number of | Unit | Defects | Standard | ||||||
| Sample | Nonconformances | Size | per unit | Deviation | LCLu | CL | UCLu | ||
| 1 | 5 | 204 | 0.025 | 0.012 | 0.000 | 0.030 | 0.066 | ||
| 2 | 5 | 188 | 0.027 | 0.013 | 0.000 | 0.030 | 0.068 | ||
| 3 | 6 | 158 | 0.038 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 4 | 9 | 180 | 0.050 | 0.013 | 0.000 | 0.030 | 0.069 | ||
| 5 | 0 | 182 | 0.000 | 0.013 | 0.000 | 0.030 | 0.068 | ||
| 6 | 5 | 155 | 0.032 | 0.014 | 0.000 | 0.030 | 0.072 | ||
| 7 | 3 | 162 | 0.019 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 8 | 5 | 149 | 0.034 | 0.014 | 0.000 | 0.030 | 0.072 | ||
| 9 | 5 | 154 | 0.032 | 0.014 | 0.000 | 0.030 | 0.072 | ||
| 10 | 4 | 164 | 0.024 | 0.013 | 0.000 | 0.030 | 0.070 | ||
| 11 | 4 | 192 | 0.021 | 0.012 | 0.000 | 0.030 | 0.067 | ||
| 12 | 10 | 173 | 0.058 | 0.013 | 0.000 | 0.030 | 0.069 | ||
| 13 | 3 | 174 | 0.017 | 0.013 | 0.000 | 0.030 | 0.069 | ||
| 14 | 3 | 189 | 0.016 | 0.013 | 0.000 | 0.030 | 0.068 | ||
| 15 | 5 | 124 | 0.040 | 0.016 | 0.000 | 0.030 | 0.076 | ||
| 16 | 4 | 195 | 0.021 | 0.012 | 0.000 | 0.030 | 0.067 | ||
| 17 | 3 | 162 | 0.019 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 18 | 7 | 157 | 0.045 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 19 | 6 | 189 | 0.032 | 0.013 | 0.000 | 0.030 | 0.068 | ||
| 20 | 8 | 177 | 0.045 | 0.013 | 0.000 | 0.030 | 0.069 | ||
| 21 | 6 | 158 | 0.038 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 22 | 5 | 156 | 0.032 | 0.014 | 0.000 | 0.030 | 0.071 | ||
| 23 | 4 | 201 | 0.020 | 0.012 | 0.000 | 0.030 | 0.066 | ||
| 24 | 7 | 174 | 0.040 | 0.013 | 0.000 | 0.030 | 0.069 | ||
| 25 | 6 | 168 | 0.036 | 0.013 | 0.000 | 0.030 | 0.070 | ||
| 26 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 27 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 28 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 29 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 30 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 31 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 32 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 33 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 34 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 35 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 36 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 37 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 38 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 39 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 40 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 41 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 42 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 43 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 44 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 45 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 46 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 47 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 48 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 49 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 50 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 51 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 52 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 53 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 54 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 55 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 56 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 57 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 58 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 59 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 60 | #N/A | #N/A | #N/A | #N/A | #N/A | ||||
| 61 | #N/A | #N/A |
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:The run chart frequency distribution and uchart all provide different insights into the problem See ...View the full answer
Answered By
ZIPPORAH KISIO LUNGI
I have worked on several other sites for more than five years, and I always handle clients work with due diligence and professionalism. Am versed with adequate experience in the fields mentioned above in which have delivered quality papers in research, thesis, essays, blog articles, and so forth.
I have gained extensive experience in assisting students to acquire top grades in biological, business and IT papers. Notwithstanding that, I have 7+ years of experience in corporate world software design and development.
194+ Reviews
341+ Question Solved
Related Book For
An Introduction To Six Sigma And Process ImprovementISBN: 9781133604587 2nd Edition Authors: James R. Evans, William M. Lindsay
Question Posted:
| ||||||
