Explore BrainMass

Using Pareto Chart in Prioritizing Grocery Store Complaints

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 22, 2018, 4:38 pm ad1c9bdddf - https://brainmass.com/business/business-management/using-pareto-chart-in-prioritizing-grocery-store-complaints-502044

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.