Book a consultation
Finance & FP&A

Profitability analysis by customer, product and project

Profitability analysis by product, client and project, with costs allocated fairly, so leaders can decide what to price up, grow or stop.

See how we work
Two large clients earn below-average margin after cost to serveWaterfall for the largest client from 100 percent revenue to 5 percent net margin, with 23 percent spent on cost to serve, beside net margin by client where the two largest clients sit below the 12 percent average (demo data).Two large clients earn below-average margin after cost to serveLast 12 months, % of revenueDemo dataClient A: revenue to net margin100Revenue−61Direct−23To serve−11Overhead5%Net23% of revenue goes to cost to serveNet margin by client, top six by revenueAverage 12%Client A$4.1M5%Client B$3.6M8%Client C$2.2M16%Client D$1.9M14%Client E$1.4M18%Client F$1.1M13%Two large clients earn below-average margin after cost to serveMobile view: Client A keeps 5% net margin after direct cost, cost to serve and overhead; clients A and B earn 5% and 8% against a 12% average (demo data).Two large clients earnbelow-average marginAfter cost to serve, last 12 monthsDemo dataClient A: revenue to net margin, %100Revenue−61Direct−23To serve−11Overhead5%Net23% of revenue goes to cost to serveNet margin by client, top sixClient A$4.1M5%Client B$3.6M8%Client C$2.2M16%Client D$1.9M14%Client E$1.4M18%Client F$1.1M13%Average 12%

A company can know its total profit without knowing which products, clients or projects produce it. Our profitability analysis connects revenue, direct costs and overhead to each segment, so the answer is clear.

You see which clients cost more to serve than they pay. You see which projects overrun. And you see which products carry the business. Then you can decide where to change prices, where to grow and what to stop.

What it is

What is profitability analysis? A view of profit by the parts of your business

What it is

Profitability analysis measures how much profit each part of a business produces. The parts can be products, clients, projects, regions or channels. It starts with revenue, subtracts direct costs and then allocates a fair share of overhead, meaning the shared costs such as rent, IT and management.

What it is not

A good profitability analysis is also repeatable. It is not a one-off spreadsheet built for a board meeting. It runs every month from your accounting, ERP, CRM and time-tracking data, with the same rules each time. That way, trends are real and not the result of a changed method.

What you get

The result shows profit where decisions are actually made. A company can be profitable overall while some clients lose money and some products subsidize others. Total figures hide this. Segment figures reveal it.

Shared overhead turns a healthy gross margin into a thin profitHorizontal bridge: revenue 1,000k, direct costs minus 560k, gross margin 440k, overhead share minus 310k, segment profit 130k.Shared overhead turns a healthy gross margin into a thinprofitOne client segment, one year, $ thousands (demo data)Demo dataRevenue1,000kDirect costs−560kGross margin440kShare of overhead: rent, IT,management−310kSegment profit130kShared overhead turns a healthy gross margin into a thin profitMobile view: Horizontal bridge: revenue 1,000k, direct costs minus 560k, gross margin 440k, overhead share minus 310k, segment profit 130k.Shared overhead turns a healthy grossmargin into a thin profitOne client segment, one year, $ thousands (demo data)Demo dataRevenue1,000kDirect costs−560kGross margin440kShare of overhead: rent, IT, management−310kSegment profit130k

The output supports concrete decisions: which prices to raise, which clients to renegotiate, which projects to scope differently and where to invest.

Types

Four types of profitability analysis answer four different decisions

There are four common types of profitability analysis, plus two specialized views built on the same model. Each answers a different question, and each needs a different mix of data. A common approach is to start with one and add others once the data foundation is in place.

Decide which products to push or drop

Product profitability analysis shows margin by product or service line after direct costs and allocated overhead, so product mix decisions rest on margin.

  • Contribution margin by product
  • Products that subsidize others
  • Pricing and range decisions

Compare regions and channels

Segment views by region, branch or sales channel show where growth is profitable and where it only adds volume.

Serve professional firms precisely

Law firm profitability analysis and similar views measure margin by matter, lawyer, practice area and client.

We build the views that match the decisions you need to make. Because all of them draw on one governed data model, their totals always reconcile to the financial statements. That matters when results are challenged. A sales leader who disputes a client's margin can see exactly how it was built, line by line.

Metrics

Profitability metrics only work when everyone agrees how they are calculated

Profit figures are only useful when everyone agrees how they are calculated. So we define each metric in writing, with finance and leadership, before any build starts. We also agree how overhead is allocated. That is often the most debated step, and the one that most needs a written rule.

Every profitability metric traces from net margin down to price, volume and costKPI tree from net segment margin to contribution margin and allocated overhead, then gross margin, cost to serve and project margin, each with its formula, down to price, volume and cost drivers.Net segment marginContribution − allocated overheadContribution marginRevenue − all variable costsAllocated overheadShared costs × written driverGross margin(Revenue − direct cost) ÷ revenueCost to serveSupport, delivery, account mgmt, logisticsProject marginBilled − labor − expensesPriceVolumeDirect costService effortHours and ratesDriversEach profitability metric has a written formula and its driversMobile view: net segment margin breaks into contribution margin and allocated overhead, then gross margin, cost to serve and project margin, each with its drivers.Net segment marginContribution − allocated overheadContribution marginRevenue − all variable costsGross margin(Revenue − direct cost) ÷ revenueDrivers: Price · Volume · Direct costCost to serveSupport, delivery, account mgmt, logisticsDrivers: Service effortProject marginBilled − labor − expensesDrivers: Hours and ratesAllocated overheadShared costs × written driver

Protect pricing

Demo

Gross margin: revenue minus direct cost of sales, divided by revenue.

Know what each sale contributes

Demo

Contribution margin: revenue minus all variable costs, showing what each unit adds toward overhead and profit.

Find clients that cost too much to serve

Demo

Cost to serve: support, delivery, account management and logistics costs assigned to each client.

Spot projects that overrun

Demo

Project margin: billed revenue minus actual labor and expenses, compared with the original budget.

Compare segments fairly

Demo

Net segment margin: contribution margin minus allocated overhead, using agreed drivers.

Overhead allocation spreads shared costs across products, clients or projects. We use simple, explainable drivers, such as hours worked, orders processed or support tickets. The goal is not perfect precision. It is a fair method that leadership accepts and that stays the same every month, so trends reflect the business.

Company-level profitability ratios, such as gross profit margin, operating profit margin, net profit margin, return on assets and return on equity, describe the whole business. The segment metrics below show where those totals come from.

Examples

Profitability analysis examples show how a profitable total can hide losses

Here is a simple worked example on demo data. A services firm has three clients with similar revenue. On a gross margin basis, all three look healthy.

Once cost to serve is added, the picture changes. Client X needs twice the account management time and frequent rush work. Its net margin falls well below the others. Client Z, which looked average, turns out to be the most profitable once its low support needs are counted.

Client X looks healthy until cost to serve is counted

Margin by client, demo services firm, last 12 months

Demo data
Client X44%Client Z42%Client Y41%44% in Client X: Twice the account management timeClient X44%Client Z42%Client Y41%44% in Client X: Twice the accountmanagement time

So what: Renegotiate terms with Client X, or change how it is served. Grow Client Z.

The decision becomes clear. Renegotiate terms with Client X, or change how it is served. Grow Client Z.

Sample dashboards

Sample profitability dashboards on demo data make the decision obvious

Until we can publish client results, we show our profitability dashboards on demo data. Each one is built on a fictional company with the structure we would build for you.

Profitability dashboards on a fictional company

Demo data
Gross margin41.3%▼ -0.8 pts
Contribution margin27.5%▼ -1.1 pts
Under 10% net margin4 of 22▲ +1
Top 5 net margin19.4%▲ +0.6 pts

Two product lines carry most of the profit

Net margin by product line, year to date

Line 116%Line 214%Line 39%Line 44%Line 5-3%-3% in Line 5: Loses money after overheadLine 116%Line 214%Line 39%Line 44%Line 5-3%-3% in Line 5: Loses money after overhead

So what: Reprice or retire Line 5 before the next catalog update.

Product lineRevenueContribution marginNet margin
Line 1$6.2M34%16%
Line 2$4.8M31%14%
Line 3$3.5M25%9%
Line 4$2.1M17%4%
Line 5$1.4M9%-3%

The product margin dashboard ranks products by contribution and net margin. The client margin dashboard plots revenue against margin, so high-revenue, low-margin clients stand out. The project dashboard compares budget and actual margin by project and manager. Every chart title states its insight, and every number drills down to the transactions behind it. We walk through them live in the first consultation and show how each view supports a pricing or account decision.

Benefits

What profitability analysis gives the CFO and the leadership team

For the CFO, profitability analysis turns the income statement into a decision tool.

Margin pressure can be traced to a product, client or project, not just a cost line. Pricing and budget discussions start from evidence.

One model, four leaders, four better decisionsOne profitability model at the top feeds four roles and the decision each makes.One model, four leaders, four better decisionsThe same numbers, built the same way every monthOne monthly profitability modelBuilt the same way every monthCFOTrace margin pressureto a product, clientor projectCEOChoose which marketsand services to growor exitSales leadersPrice deals and focusaccounts on marginDelivery leadsScope the nextproposal on realproject marginOne model, four leaders, four better decisionsMobile view: One profitability model at the top feeds four roles and the decision each makes.One model, four leaders, four betterdecisionsThe same numbers, built the same way every monthOne monthly profitability modelBuilt the same way every monthCFOTrace margin pressure to a product, client orprojectCEOChoose which markets and services to grow orexitSales leadersPrice deals and focus accounts on marginDelivery leadsScope the next proposal on real project margin

For the CEO, it shows where the business really makes money. That shapes strategy: which markets to enter, which services to expand and which to exit.

For sales leaders, client margin data changes how deals are priced and which accounts get attention. For project and delivery leads, project margin shows where estimates are wrong, so the next proposal is scoped better.

The whole team reads from the same numbers, built the same way every month. Debates move from whose figure is right to what to do about it.

Tools

From ERP exports and spreadsheets to a governed profitability model

Profitability analysis often starts in spreadsheets, and that is a sensible place to begin. Someone exports data from the ERP, adds a cost allocation and builds a pivot table. It works once. But every month the file must be rebuilt, the method drifts and the numbers become hard to defend.

We replace that with a governed profitability model. Data flows in automatically from your accounting system, ERP, CRM and time tracking. Allocation rules are written down and applied the same way every month. The results appear in dashboards your team can explore, and the model is documented so it can be maintained without us. Your team keeps full ownership.

A governed model keeps the method the same every monthFour rows comparing the spreadsheet routine with the governed model for data, allocation, output and upkeep.A governed model keeps the method the same every monthSpreadsheet routine versus governed modelSpreadsheetGoverned modelDataERP exports pasted in each monthLoads automatically fromaccounting, ERP, CRM and timetrackingAllocationMethod drifts with each rebuildWritten rules, applied the sameway every monthOutputA static pivot tableDashboards your team can exploreUpkeepOnly one person knows the fileDocumented; your team owns itA governed model keeps the method the same every monthMobile view: Four rows comparing the spreadsheet routine with the governed model for data, allocation, output and upkeep.A governed model keeps the method thesame every monthSpreadsheet routine versus governed modelDataSpreadsheetERP exports pasted in each monthLoads automatically from accounting,ERP, CRM and time trackingAllocationSpreadsheetMethod drifts with each rebuildWritten rules, applied the same wayevery monthOutputSpreadsheetA static pivot tableDashboards your team can exploreUpkeepSpreadsheetOnly one person knows the fileDocumented; your team owns it
How we work

A profitability analysis engagement works in four clear steps

Every engagement starts with advice and follows four steps, each with a review. The work is remote, across time zones, and your finance team stays involved throughout. A first model typically takes 4 to 8 weeks (typical, depends on scope).

Four steps from questions to a governed model

Select a stage, use Next or the arrow keys

Agree the questions. We confirm which segments matter, which decisions the analysis must support and whether your data is ready.

Step 1 of 4
Frequently asked questions

Profitability analysis: questions finance leaders ask before they start

At a minimum, revenue and costs from your accounting system or ERP, with enough detail to assign them to products, clients or projects. Time tracking, CRM and support data improve cost-to-serve accuracy. We review what you have in the first step and recommend the simplest data set that supports reliable results.

We use simple, explainable drivers, such as hours, orders, transactions or support tickets, agreed with finance and leadership. The goal is a method everyone accepts and that stays consistent each month. We document every rule, so results can be explained and the method can be adjusted when the business changes.

Yes. For professional firms we measure margin by matter, client, lawyer and practice area, using time, billing and expense data. Law firm profitability analysis can show whether a few matters or clients absorb a large share of unbilled time, which changes how work is priced and staffed.

Book a profitability review and find out where your margin goes

Tell us which products, clients or projects you want to understand better. In a first consultation we review your data sources, outline the right type of profitability analysis and suggest a practical scope. You leave the call with a clear next step and an outline of the engagement model that fits, whether a defined project, ongoing advisory or an embedded data team. Book a consultation to start.

See how we work