Question

The Healthy Foods grocery store is attempting to isolate the root causes of unexpected delays at the checkout counters. Their research resulted in the following possible causes:

Cause of Error	Frequency
Price check	141
Register out of money	14
Bagger unavailable	33
Register out of tape	44
Customer forgot item	12
Management override for incorrect entry	86
Wrong item	52
Other	8
Total Errors	390

Make a Pareto chart by ranking the causes from the most frequent to the least frequent and graphing the resulting data.

Answer 1

Pareto Chart

A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total percentage is represented by the line.

Pareto chart
Cause of error	Frequency	Cummulative %	Formula example
Price check	141	36.15%	(SUM($B$4:B4))/$B$12
Management override for incorrect entry	86	58.21%
Wrong item	52	71.54%
Register out of tape	44	82.82%
Bagger unavailable	33	91.28%
Register out of money	14	94.87%
Customer forgot item	12	97.95%
Other	8	100.00%
Total	390

Unexpexted Delays 160 140 120 120.00% 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% Price check Other Wrong item Bagger unavailable Register out of tape Management override... Register out of money Customer forgot item 1 Frequency Cummulative %