Business Problem
Most organisations know their headline gross margin, but few understand the true profitability of individual products, customers, or service lines after allocating overhead, logistics, and support costs. High-revenue accounts can quietly destroy value through complex order patterns, excessive returns, or extended payment terms, while smaller accounts subsidise them invisibly. Without a cost-to-serve lens, pricing and resource allocation decisions are based on incomplete information.
Objective
Identify margin drivers by building an activity-based profitability model that attributes all costs to individual customers, products, or service lines — revealing the true net contribution of each segment and informing smarter pricing, resource allocation, and portfolio management decisions.
Who This Is For
- Commercial finance analysts building profitability reports for leadership
- Pricing managers evaluating customer or product tier economics
- Operations directors managing cost-to-serve across channels
- CFOs seeking segment-level margin transparency
Required Data
- Revenue by customer, product, or service line
- Direct costs (COGS, materials, direct labour)
- Overhead and indirect cost allocations
- Customer or product master data with classification attributes
- Activity drivers (order frequency, delivery drops, support tickets, returns volume)
Implementation Steps
- Define the business question: Which customers or products are least profitable on a fully-loaded basis?
- Identify data sources: Revenue ledger, cost of goods sold accounts, overhead allocation tables, customer/product master data, operational activity logs.
- Prepare and validate data: Reconcile revenue and cost totals to the P&L. Define activity drivers for cost allocation. Document allocation assumptions.
- Build the model: Map activities to cost pools, assign drivers, allocate costs to individual customers or products. Calculate contribution margin and net margin by segment.
- Create outputs: Profitability dashboard with top/bottom contributor analysis, scatter plot mapping revenue against cost-to-serve, and segment ranking table.
- Measure success: Track gross margin %, contribution margin by segment, and the number of loss-making segments identified and addressed.
Expected Outputs
- Profitability matrix ranking every customer or product by true net margin
- Top/bottom contributor analysis identifying the most and least profitable segments
- Revenue vs cost-to-serve scatter plot for portfolio segmentation
- Activity-based cost allocation model with documented driver logic
KPIs to Track
- Gross margin % by segment
- Contribution margin after full cost allocation
- Number and revenue share of loss-making segments
- Cost-to-serve ratio (total cost / revenue) by customer tier
Risks and Assumptions
- Allocation accuracy depends on driver selection — poorly chosen drivers distort segment profitability
- Shared costs that cannot be attributed to a single driver require an agreed allocation methodology (e.g. revenue-weighted, headcount-weighted)
- Results may challenge long-held assumptions about key accounts — stakeholder engagement is essential before acting on findings
- Model requires periodic refresh as product mix and cost structures evolve
