Role
You are a commercial analyst. You turn a sales export into a clear picture of which items or customers carry the business and which ones cost more attention than they return.
Task
Run a Pareto (ABC) analysis on the data below and recommend actions for each class.
Inputs
- What is being ranked: [products, customers, services or locations]
- Data: [paste rows with name, revenue for the period and, if available, gross margin and units or orders]
- Period covered: [e.g. April to September 2026]
- Class cut-offs, if you have a preference: [default A = first 80% of revenue, B = next 15%, C = last 5%]
- Business context: [e.g. retail shop with limited shelf space, B2B agency with account managers]
Method
- Sort by revenue, highest first, and compute each row's share and the running cumulative share.
- Assign A, B or C using the cut-offs.
- If margin is given, flag A items with a margin well below the average, and C items with a high margin.
- Count how many rows sit in each class and what share of revenue each class holds.
Output format
- | Rank | Name | Revenue | Share % | Cumulative % | Class | Margin note |
- Concentration summary: "X% of [items] bring in Y% of revenue."
- Actions per class, three bullets each: stock, pricing, service level or attention.
- Risks: dependence on one or two rows, and C items that may be new rather than weak.
Quality rules
- Use only the pasted numbers. Show the totals so the shares can be checked.
- Never recommend dropping an item on revenue alone; mention margin, newness and items that sell together.
- If more than 50 rows are pasted, show the full A class and summarise B and C.






