Customer and Product Profitability Analysis: A 5-Step Guide
Customer and product profitability analysis shows which customers, products, or jobs actually make money once you count every cost they cause, not just their revenue or gross margin. The method has five steps: calculate gross margin by customer or product, subtract variable selling costs to get contribution margin, assign cost to serve using activity rates, rank the results, and act on them by repricing, changing terms, or reshaping the relationship.
Key takeaways
- Revenue and gross margin can hide unprofitable customers; the costs of serving them (orders, deliveries, returns, support, and payment terms) often sit in overhead.
- Contribution margin (revenue minus variable costs) is the foundation for product decisions and break-even analysis.
- Cost to serve can be estimated with a few simple activity rates; you don't need a full costing system to get useful answers.
- In the worked example below, the largest customer earns a profit margin of just 2.6% after cost to serve, while a mid-sized customer earns 23.4%.
- The goal isn't to fire customers; it's to reprice, set minimums, change terms, or reduce the cost of serving them.
Why can revenue and gross margin be misleading?
Most small and mid-sized businesses judge customers by revenue and products by gross margin. Both numbers leave out a lot. Gross margin captures the cost of the goods sold, but not the cost of taking hundreds of small orders, making rush deliveries, processing returns, answering support calls, or waiting 75 days to be paid. Those costs land in overhead, where they're spread evenly across everyone, and the customers who cause most of them look more profitable than they are.
That's what profitability analysis fixes. It's a core management accounting tool, and if you want the broader context of how it fits alongside cost accounting, our post on cost management accounting tools for driving profitability covers the wider toolkit.
Key terms you'll need
| Term | What it means |
|---|---|
| Gross margin | Revenue minus cost of goods sold |
| Variable costs | Costs that rise and fall with sales volume, such as materials, commissions, and freight |
| Contribution margin | Revenue minus all variable costs; what's left to cover fixed costs and profit |
| Cost to serve | The costs a specific customer causes beyond the product itself, such as order handling, delivery, returns, support, and financing their payment terms |
| Activity rate | The cost of one unit of an activity, such as one order processed or one delivery made |
| Break-even point | The sales volume at which contribution margin exactly covers fixed costs |
The 5-step profitability analysis
To make this concrete, the steps below use a worked example: a fictional wholesale distributor, Ridgeline Supply, with $2.5 million in annual revenue across four customers. All figures are illustrative.
Step 1: Calculate gross margin by customer or product
Pull revenue and cost of goods sold for each customer (or product line) from your accounting system for the last 12 months. This requires that sales are tagged by customer and product, and that cost of goods sold is recorded accurately.
| Customer | Revenue | Cost of goods sold | Gross margin | Gross margin % |
|---|---|---|---|---|
| A | $1,200,000 | $912,000 | $288,000 | 24.0% |
| B | $650,000 | $455,000 | $195,000 | 30.0% |
| C | $420,000 | $285,600 | $134,400 | 32.0% |
| D | $230,000 | $161,000 | $69,000 | 30.0% |
| Total | $2,500,000 | $1,813,600 | $686,400 | 27.5% |
Customer A's lower margin reflects the volume discounts it negotiated. On this view, A still looks like the most valuable customer: it brings in the most gross margin dollars.
Step 2: Subtract variable selling costs to get contribution margin
If you pay commissions, card fees, or freight that varies with each sale, subtract them per customer or product to get contribution margin. Ridgeline has no commissions and charges freight separately, so in this example contribution margin equals gross margin. In many businesses, this step alone changes the ranking.
Step 3: Assign cost to serve with activity rates
This is the step most businesses skip, and where most of the insight comes from. Activity-based costing, which the Institute of Management Accountants describes in its Statement on Management Accounting on activity-based management as a way of measuring the cost of activities and tracing them to products and customers, is the formal version. A simplified approach works well for SMBs:
- List the activities that vary by customer: order processing, deliveries, returns, customer support, and carrying their receivables.
- Estimate an annual cost for each activity from your payroll, delivery, and overhead accounts.
- Divide by the annual volume of that activity to get a rate.
- Multiply each customer's activity volume by the rate.
Ridgeline's activity rates:
| Activity | Rate |
|---|---|
| Order processing | $40 per order |
| Delivery | $150 per delivery |
| Returns handling | $60 per return |
| Customer support | $50 per hour |
| Carrying receivables | 8% a year on the average balance outstanding |
Applying those rates to each customer's activity:
| Customer | Orders | Deliveries | Returns | Support hours | Avg. days to pay | Total cost to serve |
|---|---|---|---|---|---|---|
| A | 1,500 | 900 | 200 | 600 | 75 | $256,726 |
| B | 300 | 260 | 20 | 120 | 35 | $63,186 |
| C | 180 | 150 | 10 | 60 | 30 | $36,062 |
| D | 600 | 300 | 60 | 200 | 60 | $85,625 |
For customer A, that's $60,000 of order processing, $135,000 of deliveries, $12,000 of returns, $30,000 of support, and about $19,700 of financing cost on its slow payments.
Step 4: Rank customers by profit after cost to serve
| Customer | Revenue | Gross margin | Cost to serve | Customer profit | Profit margin |
|---|---|---|---|---|---|
| A | $1,200,000 | $288,000 | $256,726 | $31,274 | 2.6% |
| B | $650,000 | $195,000 | $63,186 | $131,814 | 20.3% |
| C | $420,000 | $134,400 | $36,062 | $98,338 | 23.4% |
| D | $230,000 | $69,000 | $85,625 | −$16,625 | −7.2% |
| Total | $2,500,000 | $686,400 | $441,599 | $244,801 | 9.8% |
The picture changes completely. Customer A, nearly half of revenue, earns a profit margin of just 2.6%, because it places many small orders, demands frequent deliveries, returns more, and pays slowly. Customer D loses money. Customers B and C, a little over 40% of revenue together, generate more than 90% of customer profit.
Step 5: Act on the results
The answer is rarely to drop a customer. More often, it's to change how you serve them:
| Situation | Typical actions |
|---|---|
| High margin, low cost to serve (B, C) | Protect and grow; prioritize service; look for similar customers |
| High revenue, low profit (A) | Introduce minimum order sizes, consolidate deliveries, charge for rush orders, tighten payment terms, renegotiate volume discounts |
| Low revenue, negative profit (D) | Reprice, move to a lower-cost service model (online ordering, scheduled deliveries), or have an honest conversation about the relationship |
| Strategic customers with thin margins | Keep deliberately, but track the cost and set a target to improve it |
If Ridgeline cut customer A's deliveries by a third through consolidation, it would save $45,000 a year at $150 a delivery, more than doubling that customer's profit.
How does contribution margin help with product decisions?
The same logic applies to products. Contribution margin per unit is price minus variable cost per unit. Suppose a product sells for $50 and has $32 of variable cost per unit: its contribution margin is $18, or 36%. If the product line carries $180,000 of fixed costs a year, its break-even point is $180,000 ÷ $18 = 10,000 units.
Contribution margin answers practical questions: which products to promote, whether a discount still leaves the sale profitable, whether to accept a large one-off order at a lower price, and which slow-moving products don't cover the fixed costs they carry.
What data do you need to run a profitability analysis?
- Revenue by customer and product, which means consistent customer and item records in your accounting system.
- Accurate cost of goods sold, with inventory properly costed and recorded.
- Activity volumes, such as orders, deliveries, returns, and support hours, from your order system, delivery logs, or helpdesk.
- Cost pools for each activity, from payroll and expense accounts.
- Receivables aging by customer, to estimate the cost of payment terms.
If your books don't track revenue and costs by customer, product, location, or job, that's the first fix. Our post on cost accounting vs management accounting for US startups explains how to set up the underlying records.
What are the most common profitability analysis mistakes?
- Spreading all overhead evenly. It hides exactly the differences you're trying to find. Assign only the costs that genuinely vary by customer or product, and leave true fixed overhead unallocated.
- Chasing false precision. Rough activity rates that are directionally right are far more useful than a perfect model that takes six months to build.
- Acting on a single month. Use at least 12 months of data to smooth out seasonality and one-off orders.
- Ignoring strategic value. A low-margin customer may open doors to others or keep a production line full. Make those trade-offs explicitly.
- Running it once. Profitability shifts as prices, costs, and customer behavior change. Refresh the analysis at least annually, and quarterly for your largest customers.
Where does outsourced accounting fit?
Profitability analysis depends on clean, well-tagged books and someone with time to build and maintain the model. An outsourced accounting team can keep revenue and costs tagged by customer, product, and job, maintain activity data, and produce a profitability report as part of your monthly management reporting pack. Our management reporting services cover this kind of analysis alongside your regular financial statements.
Frequently asked questions
What is customer profitability analysis?
Customer profitability analysis measures the profit each customer generates after deducting not only the cost of goods sold but also the cost of serving them, such as order processing, delivery, returns, support, and financing their payment terms.
What is the difference between gross margin and contribution margin?
Gross margin is revenue minus cost of goods sold. Contribution margin is revenue minus all variable costs, including variable selling costs such as commissions and card fees, so it's usually lower and a better basis for product and pricing decisions.
How do you calculate cost to serve?
List the activities that vary by customer, estimate the annual cost of each, divide by annual activity volume to get a rate, and multiply each customer's activity volume by those rates. Add a financing cost for slow payers based on their average receivables balance.
How do you calculate a break-even point?
Divide fixed costs by contribution margin per unit. For example, $180,000 of fixed costs divided by an $18 contribution margin per unit gives a break-even point of 10,000 units.
What should I do with an unprofitable customer?
Start by changing how you serve them: set minimum order sizes, consolidate deliveries, charge for rush orders, tighten payment terms, or reprice. Ending the relationship is a last resort, and only after considering any strategic value.
This article is general information, not personalized accounting or financial advice. The worked example is illustrative; review pricing and customer decisions with your CPA or finance advisor.
Want to know which of your customers and products actually make money? We can set up your books to track profitability and build a customer and product profitability report into your monthly reporting. Talk to our team.