Customer Profitability Analysis

A wholesaler sells $200,000 to one buyer and $120,000 to another, but the larger buyer demands frequent small shipments and custom support while the smaller buyer orders predictable full cases, so revenue ranking alone cannot reveal which relationship contributes more profit. Choose the decision first, since the analysis may guide pricing, service design, retention spending or account coverage and the relevant costs and time horizon can differ for each choice.

Start with customer-attributable revenue, including billed sales after valid discounts, returns and credits for a defined period, with taxes and pass-through amounts kept consistent with the accounting basis. Assign direct product or service costs, which for a distributor may be the cost of goods sold and for a service firm may include delivery labour and subcontractors linked to the customer.

Add costs to acquire, serve and retain the account where the data supports them, because sales visits, order handling, delivery, support tickets, special packaging and financing terms can vary greatly between customers. The Corporate Finance Institute explains customer profitability as a managerial-accounting view of activities and expenses incurred to serve customers, and it differs from product-line profitability because two buyers of the same product can demand different levels of service.

Use sensible cost drivers, since delivery cost might follow the number of stops, not simply sales value, and support cost may follow case time, with care for unusual one-off incidents. Avoid allocating all corporate overhead mechanically and calling the answer exact, because a revenue-based overhead allocation can mislead if the cost would remain without the account.

Show contribution at several layers, as one subtracts direct costs and another may add a defensible share of shared resources, and each answers a different question. An illustrative customer contribution is net customer revenue minus cost of goods or delivery minus attributable customer-service costs, so if revenue is $100,000, product cost $60,000 and service costs $15,000, contribution is $25,000, which is not necessarily the company's net profit.

Check timing, since a new customer may incur onboarding costs now while recurring revenue arrives later, and another account may be profitable this year but require a costly contract renewal. Look beyond one account too, because a flagship buyer can provide references, volume for a supplier contract or access to a new market, and those benefits should be noted separately rather than hidden in an invented allocation.

Oracle describes reporting sales, costs and margin by customer in an advanced cost-accounting workflow, and a software report can organise the numbers, but the business still needs to decide which costs belong to each relationship. Segment customers when individual figures are noisy, grouping small accounts by purchasing behaviour, channel or service needs while preserving meaningful differences rather than treating every buyer in a broad region as alike.

Review data quality, since one customer may have multiple account IDs, returns may be credited in a later period and a delivery cost may be booked to the wrong branch, so reconcile totals before using the ranking. Use the findings constructively: a low-contribution buyer might benefit from consolidated deliveries, self-service ordering or a clearer minimum-order policy, and abruptly cutting service based on a rough model can cost future business.

Do not ignore fairness or contracts, because existing service commitments must be honoured and pricing changes require a sound commercial basis, so the analysis is an input to decisions, not permission to rewrite terms. Revisit the model as behaviour changes and track whether an intervention changes the real contribution, not just the spreadsheet assumption; for an owner, the value is seeing what remains after the work required to win and serve each customer, and the clearest report shows the cost drivers, uncertain allocations and possible actions rather than declaring a single perfect customer score.