MBA 6300 online Homework Assignment #7 complete solutions correct answers key

MBA 6300 online Homework Assignment #7 – Statistical Quality Control complete solutions correct answers key

Instructions: The homework must be placed in the Assignment Submittal link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions, for the assignment, will be released in Bb the morning after the due date for access by students. Total points for the assignment is 110. Note: There is no partial credit given; either the answer is correct or incorrect.

Please place your answers in the Excel File provided by the Instructor.

Question 1: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an X-bar Chart that had 20 subgroups of size 5. The sum of X-bar is 15.36 and the sum of R is 14.75. (2.5 points)

Question 2: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 20 subgroups of size 5. The sum of X-bar is 15.36 and the sum of R is 14.75. (2.5 points)

Question 3: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an X-bar Chart that had 25 subgroups of size 4. The sum of X-bar is 42.16 and the sum of R is 36.85. (2.5 points)

Question 4: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 25 subgroups of size 4. The sum of X-bar is 42.16 and the sum of R is 36.85. (2.5 points)

Question 5: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an X-bar Chart that had 30 subgroups of size 6. The sum of X-bar is 21.74 and the sum of R is 19.65. (2.5 points)

Question 6: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 30 subgroups of size 6. The sum of X-bar is 21.74 and the sum of R is 19.65. (2.5 points)

Question 7: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a p-chart with data gathered from 30 subgroups of size 20 that had a total of 65 non-conforming units. (2.5 points)

Question 8: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a p-chart with data gathered from 25 subgroups of size 40 that had a total of 90 non-conforming units. (2.5 points)

Question 9: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a p-chart with data gathered from 25 subgroups of size 25 that had a total of 75 non-conforming units. (2.5 points)

Question 10: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a c-chart with data gathered from 15 samples that had a total of 60 non-conforming units. (2.5 points)

Question 11: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a c-chart with data gathered from 30 samples that had a total of 65 non-conforming units. (2.5 points)

Question 12: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a c-chart with data gathered from 20 samples that had a total of 75 non-conforming units. (2.5 points)

Scenario: A manufacturer of automobile glass employs a constant quality control technique where the thickness of glass is checked periodically by taking a sample of 5 units and measuring the thickness. The results of one shift’s quality control inspections are shown in the table below.

Sample

Thickness

Sample

Thickness

1

4, 3, 4, 2, 4

11

1, 6, 4, 4, 2

2

5, 3, 5, 4, 2

12

3, 3, 4, 5, 4

3

3, 3, 3, 3, 4

13

6, 3, 5, 5, 7

4

4, 5, 5, 4, 5

14

3, 2, 5, 4, 2

5

7, 1, 1, 6, 1

15

3, 3, 3, 2, 1

6

4, 5, 2, 5, 4

16

4, 4, 4, 5, 3

7

3, 5, 4, 4, 5

17

5, 3, 4, 4, 3

8

2, 4, 4, 4, 3

18

4, 4, 5, 3, 3

9

5, 4, 3, 2, 5

19

6, 4, 3, 3, 3

10

4, 4, 4, 4, 4

20

4, 4, 3, 5, 4

Question 13: Using the data contained in the scenario calculate the Upper Control Limit for an X-bar chart that reflect a 99.7% confidence level. (2.5 points)

Question 14: Using the data contained in the scenario calculate the Lower Control Limit for an X-bar chart that reflect a 99.7% confidence level. (2.5 points)

Question 15: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an X-bar chart, which samples are out of control? (5 points)

Question 16: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points)

Question 17: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points)

Question 18: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points)

Scenario: A canning company packages canned soup for a major soup manufacturer for distribution to regional wholesalers.  The company processes 5,000 cans of soup each day using an automated packaging machine that is programmed to fill each can with 74.0 ± 0.1 ounces net weight of soup.  The company's quality assurance process consists of randomly selecting five cans from the production line each hour and carefully weighing them. Sample observations for a 24-hour production run are reflected in the table below. 

Hour

Sample 1

Sample 2

Sample 3

Sample 4

Sample 5

1

74.030

74.002

74.019

73.992

74.008

2

73.995

73.992

74.001

74.011

74.004

3

73.988

74.024

74.021

74.005

74.002

4

74.002

73.996

73.993

74.015

74.009

5

73.992

74.007

74.015

73.989

74.014

6

74.009

73.994

73.997

73.985

73.993

7

73.995

74.006

73.994

74.000

74.005

8

73.985

74.003

73.993

74.015

73.988

9

74.008

73.995

74.009

74.005

74.004

10

73.998

74.000

73.990

74.007

73.995

11

73.994

73.998

73.994

73.995

73.990

12

74.004

74.000

74.007

74.000

73.996

13

73.983

74.002

73.998

73.997

74.012

14

74.006

73.967

73.994

74.000

73.984

15

74.012

74.014

73.998

73.999

73.004

16

74.000

73.984

74.005

73.015

73.996

17

73.994

74.012

73.025

74.005

74.007

18

74.006

73.825

74.018

74.003

74.000

19

73.001

74.002

74.003

74.005

73.997

20

74.000

74.010

74.013

74.020

74.003

21

73.982

74.001

74.015

74.005

73.996

22

74.004

73.999

73.990

74.006

74.009

23

74.010

73.989

73.990

74.009

74.014

24

74.015

74.008

73.993

74.000

74.010

25

73.982

73.984

73.995

74.017

74.013

Question 19: Using the data contained in the scenario calculate the Upper Control Limit for an X-bar chart that reflect a 99.7% confidence level. (5 points)

Question 20: Using the data contained in the scenario calculate the Lower Control Limits for an X-bar chart that reflect a 99.7% confidence level. (5 points)

Question 21: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an X-bar chart, which samples are out of control? (5 points)

Question 22: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (5 points)

Question 23: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (5 points)

Question 24: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points)

Scenario: The manager of the customer service hotline for an internet service provider has been approached by the President of the company regarding a perceived increase in the number of customer complaints regarding the lack of timely technical assistance being provided by hotline technicians.  In order to evaluate the validity of the President’s concerns he decided to survey customers regarding their satisfaction with the timeliness of the technical assistance they received.  Surveys were conducted during a thirty-day period with one hundred fifty (150) randomly selected customers participating in the survey each day.  The number of customers surveyed who expressed dissatisfaction with the timeliness of the technical assistance they received is summarized in the following table.

Day

No. Complaints

Day

No. Complaints

1

22

16

15

2

29

17

17

3

25

18

17

4

17

19

19

5

20

20

22

6

16

21

23

7

34

22

27

8

11

23

29

9

31

24

33

10

29

25

21

11

15

26

24

12

10

27

22

13

33

28

24

14

23

29

23

15

27

30

31

Question 25: Using the data contained in the scenario calculate the Upper Control Limit for the number of complaints that reflect a 95.5% confidence level. (5 points)

Question 26: Using the data contained in the scenario calculate the Lower Control Limit for the number of complaints that reflect a 95.5%confidence level. (5 points)

Question 27: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the number of complaints, which samples are out of control? (5 points)

Question 28: Using the data contained in the scenario calculate the Upper Control Limit for the proportion of complaints that reflect 95.5% level of confidence. (5 points)

Question 29: Using the data contained in the scenario calculate the Lower Control Limit for the proportion of complaints that reflect 95.5% level of confidence. (5 points)

Question 30: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the proportion of complaints, which samples are out of control? (5 points)