Question

DEFECT OBSERVED Improperly Seated Unacceptable Spill Mixed Missing tem Taste Underfilled Line Date Time 1 0900 5/12 2 5/12 1330 2 1000 5/13 1 1345 5/13 1530 5/13 0830 5/14 1100 5/14 1 5/1 1400 1 1030 5/15 2 1145 5/15 1 1500 5/15 2 0845 5/16 1 1030 5/16 1 1400 5/16 2 1545 5/16

A) Chart the data to produce a Pareto chart.B) Break the data by:

a) each production line and by AM and PM
b) prepare a Pareto chart by showing columns of the 5 defects from the largest to the

smallest.
c) color the columns with one color for line 1 and a different color for line 2.

C) Ann's Recommendations backed by data'

Answer 1

First, create a chart as follows:

Time	Line	Underfilled	Missing Item	Spill/Mixed	Unacceptable Taste	Improperly Sealed
AM	1		2	1	3
PM	2			2		2
AM	2				1	3
PM	1	2		2
PM	2		2	3		1
AM	1		3		3
AM	2	1		1	2
PM	1			1		1
AM	1		3		5
AM	2			1	2
PM	1	1		1
AM	2				2	2
AM	1		3	1	3
PM	1
PM	2	1	4	1	1	2

This data is organized after sorting by production line by AM and PM as follows:

Line 1 AM
Defect Observed	Frequency
Underfilled
Missing Item	11
Spill/Mixed	2
Unacceptable Taste	14
Improperly Sealed

Line 2 AM
Defect Observed	Frequency
Underfilled	1
Missing Item
Spill/Mixed	2
Unacceptable Taste	7
Improperly Sealed	5

Line 1 PM
Defect Observed	Frequency
Underfilled	3
Missing Item
Spill/Mixed	4
Unacceptable Taste
Improperly Sealed	1

Line 2 PM
Defect Observed	Frequency
Underfilled	1
Missing Item	6
Spill/Mixed	6
Unacceptable Taste	1
Improperly Sealed	5

Pareto chart for each production line and by AM and PM is following:

Steps to draw pareto chart 1. Sort the complaint/reasons in descending order of frequency 2. Compute % frequency for each complaint/reason by dividing its frequency by Total. 3. Compute cumulative % frequency as running sum of % frequency. 4. Plot the frequency on primary axis and cumulative % frequency 5. Focus on the complaint/reasons that comprise top 20% of all, but has 80% cumulative frequency secondary axis of the same chart. on

Line 1 AM 16 II. 100% 14 90% 12 80% 70% 10 60% 8 50% 6 -40% -30% 4 20% 2 10% 0 0% Unacce ptable Taste Defect reason Frequency MissingItem Spill/Mixed Underfilled Improperly Sealed Cumulative % frequency

Line 2 AM 8 7 100% 6 90% 80% 5 70% 4 60% 3 50% -40% 2 -30% 1 20% 0 10% 0% Missingltem Underfilled Unacce ptable Taste Defect reason Frequency Spill/Mixed Improperly sealed Cumulative % frequency

Line 1 PM 4.5 100% 4 90% 3.5 80% 3 70% 60% 2.5 50% 2 40% 1.5 30% 1 20% 0.5 10% 0 0% Missing Item Defect reason st Frequency Unacceptable Taste Spill/Mixed Underfilled mproperly Sealed Cumulative % freq uency

Line 2 PM 7 100% И. 90% 80% 5 70% 4 60% 50% 3 40% - 2 30% 1 20% 10% 0 0% Missing Item Defect reason LO Frequency st m Unacceptable Taste Spill/Mixed pax Underfilled paje mproperly Se aled Cumulative % freq uency