Pareto Chart Worksheet

What it is and when to use it

Fixing everything a little bit usually means fixing the thing that actually matters not at all. A Pareto chart ranks every cause of a problem — downtime, defects, complaints, delays — by how much it actually costs in time or money, not by how loud or recent it was, and shows what share of the total the top few causes account for. Most operations find that two or three causes explain the majority of the loss, which is exactly where a limited budget and a limited team should go first.

What goes on the sheet

1. Problem/loss category being analyzed (downtime, defects, complaints, safety near-misses, etc.)
2. List of causes or categories, one row each
3. Frequency or cost per cause, with the unit and the time window it covers
4. Causes sorted descending by frequency/cost
5. Cumulative percentage column, running total across sorted causes
6. The cut line: which causes make up roughly 80% of the total, marked visually
7. Action owner assigned to the top causes only, not the whole list

In a business like yours

• Clothing boutique: two return reasons explain most returns, so sizing gets fixed before anything else.
• Electrical contractor: callbacks sorted by cause show where the next hour of training should go.
• Restaurant: comped meals ranked by reason, from the biggest dollar loss down.

Illustrative examples, not client cases.