Chat with us, powered by LiveChat 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 - Writeedu
Login

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

Posted at 02:03h in Business & Finance /Operations Management by

 

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

Click here to Place your Order Now



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