Template · Stock and products · Opening soon

Pareto analysis and ABC classes from your sales

Rank every product, customer or SKU by what it brings in, with its share and the running share, and mark the few that make up 80% as class A. Refreshed with your sales.

Book a demo

You bring

Sales lines900 rows

ItemAmount

Mammoth does the work

You get

One table28 rows

Every item ranked by its total, with its share, the running share and an A, B or C class.

RankItemAmountLinesShare %Cumulative %Class

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Pareto (ABC) analysis: the resultSample data28 rows

Rank	Item	Amount	Lines	Share %	Cumulative %	Class
1	Single origin beans S	6,585	268	25.1	25.1	A
2	House espresso S	3,672	85	14	39.1	A
3	Single origin beans L	3,090	127	11.8	50.9	A
4	House espresso L	2,727	64	10.4	61.3	A
5	Ceramic dripper S	1,410	27	5.4	66.7	A
6	Decaf beans S	1,170	40	4.5	71.1	A
7	Paper filters L	1,128	31	4.3	75.4	A
8	Ceramic dripper L	1,080	22	4.1	79.5	A

28 rows in the result · made from 900 input rows · first 8 shown. Sample data: illustrative figures, not business results.

What is Pareto analysis?

Pareto analysis ranks items by their contribution and adds up their shares, to find the few that make up most of the total, often about 20% of items giving 80% of sales. ABC analysis is the same ranking cut into three classes: A, B and C.

How it works

How to use the pareto (ABC) analysis template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Sales lines: the item (product, customer or SKU) and an amount

Sales lines

ItemWhat to rank: a product, a customer, a supplier, a defect.
Amount

The steps it runs

1Match columns
2Rank by total, with the running share

Every step is an ordinary Mammoth step you can open and change.

Pareto (ABC) analysis: questions

Can I use it for ABC inventory analysis?

Yes. Point it at your products and their sales value (or usage value) and each product gets its class. Change the cuts from 80% and 95% if your policy uses different ones.

Does it work on customers instead of products?

Yes. The item can be any column: customers for customer concentration, suppliers for spend, defect types for quality.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.