Restaurant Complaints Jan - Dec
Practical Management for Career Readiness
Effective Problem Solving and Decision Making Module 2
with Rob Stone, M.Ed., PMP
Pareto Charts Cause and Effect Diagrams Histograms
Pareto Chart
Pareto Principle: 80/20 Rule
Vilfredo Pareto
Pareto chart A vertical bar graph in which values are plotted in decreasing order of relative frequency from left to right
What Does a Pareto Chart Show Us? Information in a descending hierarchical order Issues that cause most of our problems The most important things
Pareto Analysis
200
Most Often Occurs
Pareto Chart Used for problem solving Data is put into different categories
FREQUENCY
150
Ordered starting with most problematic 100
Least Often Occurs
50
0 Category 1
Category 2
Category 3
Category 4
CATEGORIES
Category 5
Category 6
Pareto Chart
Restaurant Complaints Jan - Dec 100
Category
90
Parking Problems
112
Rude Waiters
73
70
Cooking Problems
50
60
Noisy
11
Food Cold
5
Dirty
3
Coffee Bad
2
Long Wait
1
80
COUNT
Measure
50 40 30
TOTAL
20
257
10 0 Parking problems (112)
Rude Waiters Cooking (73) Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad Long Wait (1) (2)
Pareto Chart
Restaurant Complaints Jan - Dec 100 90
Vital Few
80
COUNT
70 60 50 40 30 20
Trivial Many 10 0 Parking problems (112)
Rude Waiters Cooking (73) Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad Long Wait (1) (2)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
How and why to do it
Determine the Problem Categories Tabulate the Data Plot the Chart Understand and Act on the Results
Effective Problem Solving and Decision Making Module 2
with Rob Stone, M.Ed., PMP
Pareto Charts Cause and Effect Diagrams Histograms
Pareto Chart
Pareto Principle: 80/20 Rule
Vilfredo Pareto
Pareto chart A vertical bar graph in which values are plotted in decreasing order of relative frequency from left to right
What Does a Pareto Chart Show Us? Information in a descending hierarchical order Issues that cause most of our problems The most important things
Pareto Analysis
200
Most Often Occurs
Pareto Chart Used for problem solving Data is put into different categories
FREQUENCY
150
Ordered starting with most problematic 100
Least Often Occurs
50
0 Category 1
Category 2
Category 3
Category 4
CATEGORIES
Category 5
Category 6
Pareto Chart
Restaurant Complaints Jan - Dec 100
Category
90
Parking Problems
112
Rude Waiters
73
70
Cooking Problems
50
60
Noisy
11
Food Cold
5
Dirty
3
Coffee Bad
2
Long Wait
1
80
COUNT
Measure
50 40 30
TOTAL
20
257
10 0 Parking problems (112)
Rude Waiters Cooking (73) Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad Long Wait (1) (2)
Pareto Chart
Restaurant Complaints Jan - Dec 100 90
Vital Few
80
COUNT
70 60 50 40 30 20
Trivial Many 10 0 Parking problems (112)
Rude Waiters Cooking (73) Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad Long Wait (1) (2)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec 100 250
Restaurant Complaints Jan - Dec
COUNT
200
150
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
Pareto Chart
Restaurant Complaints Jan - Dec
COUNT
200
150
100
112 + 73 + 50 = 235 235 / 257 = .914 91.4%
250
Restaurant Complaints Jan - Dec
112 + 73 = 185 185 / 257 = .7198 72.0%
112 / 257 = .436 43.6%
Parking Problems
112
43.6%
Rude Waiters
73
72.0%
Cooking Problems
50
91.4%
Noisy
11
95.7%
Food Cold
5
97.7%
80
60
40
100
50
Dirty
3
98.8%
Coffee Bad
2
99.6%
Long Wait
1
100%
TOTAL
20
257 0
0 Parking problems (112)
Rude Waiters (73)
Cooking Problems (50)
Noisy (11)
Food Cold (5)
Dirty (3)
Coffee Bad (2)
Long Wait (1)
How and why to do it
Determine the Problem Categories Tabulate the Data Plot the Chart Understand and Act on the Results
