In your report you need to consider the following for both sets of data: 1. Analyse and explain the data. 2. Set up appropriate 3-sigma control limits and generate the control charts. Explain your approach. What does 3-sigma indicate about the acceptable quality? 3. Is the process in control? Explain. 4. Explain your findings and the consequences. 5. How could implementing TQM help the company? 6. Provide two key recommendations for the company.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Case Study 2: Quality Management Your line manager has become increasingly concerned about the product and service quality. This results from a surge in the number of customers who have contacted her to highlight problems they have encountered while shopping at the Pet Kingdom store. The complains seem to focus on two areas; billing errors being made at the checkout and variations in the weight of Pet Kingdom branded dried dog food bags. To better understand the situation, Ms Lionheart has requested detailed data to be collected. Table 3 shows the data from the audit of 50 random bills per day issued over the past 30 days. Table 4 presents the weight sampling data (mean and range in kg) for 27 random samples of five observations each taken from the daily dog food deliveries.   Ms Lionheart noticed that the number of billing errors increased in the last third of the month. She knows that the company wants high quality standards and wonders if both processes meet 3 sigma standards. She wants you to analyse the available data and produce a short report (1,000 words ± 10%) with all relevant tables and figures, to address the highlighted issues.   In your report you need to consider the following for both sets of data: 1. Analyse and explain the data. 2. Set up appropriate 3‐sigma control limits and generate the control charts. Explain your approach. What does 3‐sigma indicate about the acceptable quality? 3. Is the process in control? Explain. 4. Explain your findings and the consequences. 5. How could implementing TQM help the company? 6. Provide two key recommendations for the company.

Table 3: Number of incorrect bills issued at checkout (50 observations) Day Number of Incorrect Bills Day Number of Incorrect Bills Day Number of Incorrect Bills 1 2 11 1 21 3 2 2 12 2 22 3 3 1 13 3 23 3 4 2 14 3 24 4 5 2 15 2 25 5 6 3 16 3 26 5 7 2 17 2 27 6 8 2 18 2 28 8 9 1 19 1 29 5 10 2 20 3 30 5 Table 4: Dog food weight (kg) samples (5 observations) Sample Mean Range Sample Mean Range 1 44.96 0.42 15 45.00 0.39 2 44.98 0.39 16 44.95 0.41 3 44.96 0.41 17 44.94 0.43 4 44.97 0.37 18 44.94 0.40 5 45.02 0.39 19 44.73 0.38 6 45.03 0.40 20 44.95 0.41 7 45.04 0.39 21 44.93 0.39 8 45.02 0.42 22 44.96 0.41 9 45.08 0.38 23 44.99 0.40 10 45.12 0.40 24 45.00 0.44 11 45.07 0.41 25 45.03 0.42 12 45.02 0.38 26 45.04 0.38 13 45.01 0.41 27 45.03 0.40 14 44.98 0.40      

 

Case Study 2: Quality Management
Your line manager has become increasingly concerned about the product and service
quality. This results from a surge in the number of customers who have contacted her to
highlight problems they have encountered while shopping at the Pet Kingdom store. The
complains seem to focus on two areas; billing errors being made at the checkout and
variations in the weight of Pet Kingdom branded dried dog food bags. To better understand
the situation, Ms Lionheart has requested detailed data to be collected. Table 3 shows the
data from the audit of 50 random bills per day issued over the past 30 days. Table 4
presents the weight sampling data (mean and range in kg) for 27 random samples of five
observations each taken from the daily dog food deliveries.
Ms Lionheart noticed that the number of billing errors increased in the last third of the
month. She knows that the company wants high quality standards and wonders if both
processes meet 3 sigma standards. She wants you to analyse the available data and produce
a short report (1,000 words ± 10%) with all relevant tables and figures, to address the
highlighted issues.
In your report you need to consider the following for both sets of data:
1. Analyse and explain the data.
2. Set up appropriate 3-sigma control limits and generate the control charts. Explain
your approach. What does 3-sigma indicate about the acceptable quality?
3. the process in control? Explain.
4. Explain your findings and the consequences.
5. How could implementing TQM help the company?
6. Provide two key recommendations for the company.
Transcribed Image Text:Case Study 2: Quality Management Your line manager has become increasingly concerned about the product and service quality. This results from a surge in the number of customers who have contacted her to highlight problems they have encountered while shopping at the Pet Kingdom store. The complains seem to focus on two areas; billing errors being made at the checkout and variations in the weight of Pet Kingdom branded dried dog food bags. To better understand the situation, Ms Lionheart has requested detailed data to be collected. Table 3 shows the data from the audit of 50 random bills per day issued over the past 30 days. Table 4 presents the weight sampling data (mean and range in kg) for 27 random samples of five observations each taken from the daily dog food deliveries. Ms Lionheart noticed that the number of billing errors increased in the last third of the month. She knows that the company wants high quality standards and wonders if both processes meet 3 sigma standards. She wants you to analyse the available data and produce a short report (1,000 words ± 10%) with all relevant tables and figures, to address the highlighted issues. In your report you need to consider the following for both sets of data: 1. Analyse and explain the data. 2. Set up appropriate 3-sigma control limits and generate the control charts. Explain your approach. What does 3-sigma indicate about the acceptable quality? 3. the process in control? Explain. 4. Explain your findings and the consequences. 5. How could implementing TQM help the company? 6. Provide two key recommendations for the company.
Table 3: Number of incorrect bills issued at checkout (50 observations)
Number of
Number of
Incorrect Bills
Incorrect Bills
1
Day
1
2
3
4
5
6
7
8
9
10
2
2
1
2
2
3
2
2
1
2
7
8
9
10
11
12
13
14
Day
11
12
13
Mean
44.96
44.98
44.96
44.97
45.02
45.03
45.04
45.02
45.08
45.12
45.07
45.02
45.01
44.98
14
15
16
17
18
19
20
3
Range
0.42
0.39
0.41
0.37
0.39
0.40
0.39
0.42
0.38
0.40
0.41
0.38
0.41
0.40
3
NN
2
2
Table 4: Dog food weight (kg) samples (5 observations)
Sample
1
2
3
4
5
6
1
Day
21
22
23
24
25
26
27
28
29
30
Sample
15
16
17
18
19
20
21
22
23
24
25
26
27
Number of
Incorrect Bills
Mean
45.00
44.95
44.94
44.94
44.73
44.95
44.93
44.96
44.99
45.00
45.03
45.04
45.03
3
3
3
4
5
5
6
8
5
5
Range
0.39
0.41
0.43
0.40
0.38
0.41
0.39
0.41
0.40
0.44
0.42
0.38
0.40
Transcribed Image Text:Table 3: Number of incorrect bills issued at checkout (50 observations) Number of Number of Incorrect Bills Incorrect Bills 1 Day 1 2 3 4 5 6 7 8 9 10 2 2 1 2 2 3 2 2 1 2 7 8 9 10 11 12 13 14 Day 11 12 13 Mean 44.96 44.98 44.96 44.97 45.02 45.03 45.04 45.02 45.08 45.12 45.07 45.02 45.01 44.98 14 15 16 17 18 19 20 3 Range 0.42 0.39 0.41 0.37 0.39 0.40 0.39 0.42 0.38 0.40 0.41 0.38 0.41 0.40 3 NN 2 2 Table 4: Dog food weight (kg) samples (5 observations) Sample 1 2 3 4 5 6 1 Day 21 22 23 24 25 26 27 28 29 30 Sample 15 16 17 18 19 20 21 22 23 24 25 26 27 Number of Incorrect Bills Mean 45.00 44.95 44.94 44.94 44.73 44.95 44.93 44.96 44.99 45.00 45.03 45.04 45.03 3 3 3 4 5 5 6 8 5 5 Range 0.39 0.41 0.43 0.40 0.38 0.41 0.39 0.41 0.40 0.44 0.42 0.38 0.40
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

what is standard deviation and how do you find it ?

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.