Explore BrainMass

Using Pareto Chart in Prioritizing Grocery Store Complaints

Below is a table of data collected over a six-month period in a local grocery store. Construct a Pareto analysis of the data and determine the percentage of total complaints represented by the two most common categories.

Description Count
Stock Condition 170
Product Request 105
Product Quality 87
All other 71
Checker 59
General 58
Service Level 55
Price Marking 45
Policy/Procedure 40
Checkout Queue 33

© BrainMass Inc. brainmass.com June 20, 2018, 11:01 pm ad1c9bdddf

Solution Preview

Step-by-step Guide in Pareto Chart construction.

1. Arrange the data from highest to lowest.

2. Compute for the cumulative data and ...

Solution Summary

The solution contains a spreadsheet file utilizing a Pareto Chart in identifying complaints that need to be prioritized.