In: Operations Management
Resistors for electronic circuits are manufactured on a high-speed automated machine. The machine is set up to produce a large run of resistors of 1,000 ohms each. Use Exhibit 10.13.
To set up the machine and to create a control chart to be used throughout the run, 15 samples were taken with four resistors in each sample. The complete list of samples and their measured values are as follows: Use three-sigma control limits.
SAMPLE NUMBER | READINGS (IN OHMS) | ||||
1 | 1092 | 1099 | 1016 | 979 | |
2 | 1011 | 978 | 1023 | 976 | |
3 | 974 | 1003 | 996 | 998 | |
4 | 981 | 988 | 1001 | 1007 | |
5 | 992 | 976 | 978 | 1001 | |
6 | 988 | 1030 | 1030 | 1014 | |
7 | 1022 | 1010 | 1021 | 990 | |
8 | 1010 | 998 | 981 | 975 | |
9 | 997 | 1018 | 983 | 1024 | |
10 | 1028 | 974 | 989 | 989 | |
11 | 972 | 1010 | 1007 | 992 | |
12 | 1013 | 981 | 1002 | 1009 | |
13 | 1005 | 1021 | 996 | 1014 | |
14 | 995 | 973 | 971 | 975 | |
15 | 1011 | 1001 | 987 | 1015 |
a. Calculate the mean and range for the above samples. (Round "Mean" to 2 decimal places and "Range" to the nearest whole number.)
b. Determine X=X= and R−R− . (Round your answers to 3 decimal places.)
c. Determine the UCL and LCL for a X−X− chart. (Round your answers to 3 decimal places.)
d. Determine the UCL and LCL for R-chart. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 3 decimal places.)
e. What comments can you make about the process?
Below is the screenshot of the formula applied -
Below is the screenshot of the result -