Sunday, April 29, 2007

Pareto Chart

The theory behind the Pareto Chart originated in 1897 when an Italian economist named Vilfredo Pareto created a formula representing the uneven distribution of wealth - what later came to be known as the 80-20 rule. You have probably heard a version of it like: "20% of the people cause 80% of the problems", or a derivative. Dr. J. M. Juran started applying this principal to defect analysis - separating the "vital few" from the "trivial many", and called it the "Pareto Chart". In fact, many (most) defect distributions follow a similar pattern, with a relatively small number of issues accounting for an overwhelming share of the defects. The Pareto Chart shows the relative frequency of defects in rank-order, and thus provides a prioritization tool so that process improvement activities can be organized to "get the most bang for the buck", or "pick the low-hanging fruit". Following is an example of paint defects from an automotive assembly plant:

After reviewing the chart above, there is no question which defect to work on first. However, this pareto chart is constructed from one dimension only - defect frequency. If you learned that it costs $10 to fix a Dirt defect, while Sag defects cost $100 to correct, Sags would probably be the highest priority. Likewise, if one category represents a constraint on the whole process, its priority would be elevated. You may wish to consult the Project Priority Calculator for a template to prioritize along multiple dimensions.

You can generate a pareto chart using virtually any spreadsheet or charting software. These charts were created using Microsoft Excel, Minitab. Pareto charts are often constructed with horizontal bars, and without the cumulative percentage line, as shown below:

No comments: