Template · Operations & process
Pareto Analysis template
For finding the few causes behind most of the trouble, by ranking the losses and seeing where the weight sits. Leave it alone when the causes are all about the same size; forcing a vital few onto a flat spread invents a priority. Instead A Fishbone Diagram; when the causes are all the same size, look at how they connect rather than which is biggest.
Download it
Nothing here asks for an email. The files are static and you can link straight to them.
Or work it through here
List the categories with their count and, where you have it, their cost. Choose which measure to rank by; the cumulative percentages and the vital-few cut compute below. Where the count ranking and the cost ranking disagree, the cost ranking usually deserves the decision, and the disagreement is itself a finding.
| Category | Count | Cost (£) | Share | Cumulative |
|---|
What you may do with it
This sheet, meaning our drawing and layout of it, is released under Creative Commons Attribution 4.0 International. Use it commercially, put it in a client deck, print it for a workshop, adapt it. Keep the attribution line that is printed on the sheet and you have met the licence.
Originator: Joseph M. Juran, after Vilfredo Pareto. The framework itself is not ours to license, and the written entry behind this page, its worked example, critiques and sources, stays all rights reserved. The full licence position is set out in plain English.
Before you fill it in
A blank template is the easy part. The entry behind it covers how to run Pareto Analysis properly, a worked example, the pitfalls real teams hit, and the situations where it is the wrong tool and something else would serve better.