09 Oct This week’s assignment is all about Yogurt.? Manufacturing of yogurt, that is.? Filling of those little cups, to be exact. Complete the attached MS Excel file (both worksheets / tabs) as yo
This week's assignment is all about Yogurt. Manufacturing of yogurt, that is. Filling of those little cups, to be exact.
Complete the attached MS Excel file (both worksheets / tabs) as your assignment this week. No APA formatted report required; just complete the template's questions.
Part 1 of 2
| Week Two Assignment | |||||||||||||||||||
| Assignment: Part 1 – Is my manufacturing process in control? (Statistically speaking…) | |||||||||||||||||||
| Background on Statistical Controls in Manufacturing: A state of statistical control is defined as a process with a constant mean and variance that is not changing over time. Generally speaking, the upper and lower control limits are set at ± three standard deviations from the mean. If a normal probability distribution is assumed, these control limits will include 99.74 percent of the random variation observed. | |||||||||||||||||||
| UCL = Average + 3*Standard-Deviation | (Upper Control Limit) | ||||||||||||||||||
| CL = Average | (Center Line) | ||||||||||||||||||
| LCL = Average – 3*Standard-Deviation | (Lower Control Limit) | ||||||||||||||||||
| Activity: For our hypothetical single-port yogurt filing machine (shown below). See the filing results of the first 100 cups of yogurt and their actual weight after filing. Compute the UCL, CL, and LCL to determine if your process is in control. As a reminder, your process is "in control" if you nearly all of the products produced (99.74% or higher) are within the Upper Control Limit (UCL) and Lower Control Limit (LCL) values. Otherwise, your process is not in control and needs to be triaged. | |||||||||||||||||||
| Sample # | Actual Fill (oz) | Within Control Limits? | Statistical Calculations | ||||||||||||||||
| 1 | 8.028 | FALSE | |||||||||||||||||
| 2 | 7.986 | FALSE | Average = | oz | Tip: Reminder that to calculate the average, you can use Excel's AVERAGE function. Just add the function and select all of the actual fill examples. The same is true with standard deviation, by using Excel's STDEV formula. Select the same actual fill examples. | ||||||||||||||
| 3 | 7.985 | FALSE | Standard Deviation = | oz | |||||||||||||||
| 4 | 8.036 | FALSE | |||||||||||||||||
| 5 | 8.018 | FALSE | |||||||||||||||||
| 6 | 7.937 | FALSE | UCL = | oz | |||||||||||||||
| 7 | 8.026 | FALSE | Center Line = | oz | |||||||||||||||
| 8 | 8.050 | FALSE | LCL = | oz | |||||||||||||||
| 9 | 7.920 | FALSE | |||||||||||||||||
| 10 | 7.974 | FALSE | |||||||||||||||||
| 11 | 7.890 | FALSE | Is this process in control? (Yes/No) and Why? | ||||||||||||||||
| 12 | 8.032 | FALSE | |||||||||||||||||
| 13 | 7.948 | FALSE | |||||||||||||||||
| 14 | 8.013 | FALSE | Should I keep making yogurt? | ||||||||||||||||
| 15 | 7.943 | FALSE | |||||||||||||||||
| 16 | 8.069 | FALSE | |||||||||||||||||
| 17 | 7.918 | FALSE | |||||||||||||||||
| 18 | 7.650 | FALSE | |||||||||||||||||
| 19 | 7.895 | FALSE | |||||||||||||||||
| 20 | 7.959 | FALSE | |||||||||||||||||
| 21 | 8.030 | FALSE | |||||||||||||||||
| 22 | 7.845 | FALSE | |||||||||||||||||
| 23 | 7.952 | FALSE | |||||||||||||||||
| 24 | 8.036 | FALSE | |||||||||||||||||
| 25 | 8.004 | FALSE | |||||||||||||||||
| 26 | 7.861 | FALSE | |||||||||||||||||
| 27 | 7.899 | FALSE | |||||||||||||||||
| 28 | 8.036 | FALSE | |||||||||||||||||
| Graph Data (automatically pulls entered values) | 29 | 8.067 | FALSE | ||||||||||||||||
| UCL | CL | LCL | 30 | 8.037 | FALSE | ||||||||||||||
| 1 | 0 | 0.000 | 0 | 31 | 7.959 | FALSE | |||||||||||||
| 100 | 0.000 | 0.000 | 0.000 | 32 | 7.700 | FALSE | |||||||||||||
| 33 | 7.844 | FALSE | |||||||||||||||||
| 34 | 7.990 | FALSE | |||||||||||||||||
| 35 | 7.949 | FALSE | |||||||||||||||||
| 36 | 7.991 | FALSE | |||||||||||||||||
| 37 | 7.986 | FALSE | |||||||||||||||||
| 38 | 7.947 | FALSE | |||||||||||||||||
| 39 | 7.890 | FALSE | |||||||||||||||||
| 40 | 8.071 | FALSE | |||||||||||||||||
| 41 | 8.063 | FALSE | |||||||||||||||||
| 42 | 8.048 | FALSE | |||||||||||||||||
| 43 | 7.900 | FALSE | |||||||||||||||||
| 44 | 8.067 | FALSE | |||||||||||||||||
| 45 | 7.834 | FALSE | |||||||||||||||||
| 46 | 7.946 | FALSE | |||||||||||||||||
| 47 | 7.925 | FALSE | |||||||||||||||||
| 48 | 7.977 | FALSE | |||||||||||||||||
| 49 | 8.007 | FALSE | |||||||||||||||||
| 50 | 8.045 | FALSE | |||||||||||||||||
| 51 | 7.875 | FALSE | |||||||||||||||||
| 52 | 7.928 | FALSE | |||||||||||||||||
| 53 | 7.869 |
