PLEASE SHOW HOW TO CALCULATE EACH STEP IN EXCEL. Siders Breakfast Foods Inc., produces a popular...

90.2K

Verified Solution

Question

Basic Math

PLEASE SHOW HOW TO CALCULATE EACH STEP IN EXCEL.
Siders Breakfast Foods Inc., produces a popular brand of raisinbran cereal. The package indicates it contains 25.0 ounces ofcereal. To ensure that the firm makes good in its marketing promoclaim regarding box weight content, the Siders inspectiondepartment makes hourly check on the production process. As part ofthe hourly check, four boxes are selected and their contentsweighed. The results for 25 samples are reported below.
Sample Number
Weight-1
Weight-2
Weight-3
Weight-4
1
25.1
24.4
25.6
23.2
2
23.2
23.9
25.1
24.8
3
25.6
24.5
25.7
25.1
4
22.5
23.8
24.1
25
5
23.2
24.2
22.3
25.7
6
22.6
24.1
20
24
7
23
26
24.9
25.3
8
24.5
25.1
23.9
24.7
9
24.1
25
23.5
24.9
10
25.8
25.7
24.3
26
11
24.5
23
23.7
24
12
25.1
24.4
25.6
23.2
13
23.2
24.2
23
25.7
14
23.1
23.3
24.4
24.7
15
24.6
25.1
24
25.3
16
24.4
24.4
22.8
23.4
17
25.1
24.1
23.9
26.2
18
24.5
24.5
26
26.2
19
25.3
24.5
24.3
25.5
20
24.6
25.3
25.5
24.3
21
24.9
24.4
25.4
24.8
22
23.2
24.2
22.3
25.7
23
24.8
24.3
25
25.2
24
23.2
24.2
23
25.7
25
24.8
24.3
25
25.2
Develop the appropriate control charts to evaluate and monitorthe boxing process (10 pts)
What do the control charts tell you about the process duringthe 25-hour inspection period (i.e. Do a thorough interpretationand analysis of the charts.)? (10 pts)
An FDA regulation controlling the contents of packaged fooditems states that no more than 5 percent of the items produced andsold can contain less than 95 percent of the stated/labeled weight.Assuming that the standard deviation of the process, when incontrol or is operating as expected, is 0.90, determine if SidersBreakfast Foods, Inc., is in compliance or not in compliance withthe FDA regulation given these parameters, i.e. process mean of 25ounces and standard deviation of 0.90. Explain and show evidencesupporting your conclusion. (10 pts). What should Siders Breakfastdo if they discover their process to be in violation of the Federalregulation? (5 pts)
(Assume that the content weight follows the normaldistribution).

Answer & Explanation Solved by verified expert

4.2 Ratings (785 Votes)

a Develop the appropriate control charts toevaluate and monitor the boxing process 10 ptsLoad the data into ExcelGo to DataMegastatSelect the option Quality Control ProcessCharts and go to VariablesX bar andRSelect the Input Range as the data setClick OKThe output obtained will be as followsSample size4Number of samples25MeanRangeUpper Control Limit UCL258674500Center244291972Lower Control Limit LCL229910000b What do the control charts tell you aboutthe process See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Sample Number	Weight-1	Weight-2	Weight-3	Weight-4
1	25.1	24.4	25.6	23.2
2	23.2	23.9	25.1	24.8
3	25.6	24.5	25.7	25.1
4	22.5	23.8	24.1	25
5	23.2	24.2	22.3	25.7
6	22.6	24.1	20	24
7	23	26	24.9	25.3
8	24.5	25.1	23.9	24.7
9	24.1	25	23.5	24.9
10	25.8	25.7	24.3	26
11	24.5	23	23.7	24
12	25.1	24.4	25.6	23.2
13	23.2	24.2	23	25.7
14	23.1	23.3	24.4	24.7
15	24.6	25.1	24	25.3
16	24.4	24.4	22.8	23.4
17	25.1	24.1	23.9	26.2
18	24.5	24.5	26	26.2
19	25.3	24.5	24.3	25.5
20	24.6	25.3	25.5	24.3
21	24.9	24.4	25.4	24.8
22	23.2	24.2	22.3	25.7
23	24.8	24.3	25	25.2
24	23.2	24.2	23	25.7
25	24.8	24.3	25	25.2