Purchase Solution

Pareto Analysis to Determine the Most Common Categories

Not what you're looking for?

Ask Custom Question

Construct a Pareto analysis of the data and determine the percentage of total complaints represented by the two most common categories.

Over a 6 mo. period:

Stock Condition: 170
Checkout Queue: 33
Product request: 105
Product Quality: 87
Price Marking: 45
Policy/Procedures: 40
Service Level: 55
General: 58
Checker: 59
All other: 71.

Purchase this Solution

Solution Summary

The solution shows step-by-step method of creating Pareto chart in Excel and also discusses how to conduct Pareto analysis.

Solution Preview

See attached Excel file.

There are many internet sites that will show you step by step method of Pareto analysis in detail. Here I am providing you the information from Wikipedia. I am also showing you the analysis in Excel.

Pareto analysis is a statistical technique in decision making that is used for selection of a limited number of tasks ...

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Introduction to Finance

This quiz test introductory finance topics.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.