Blog · Finance metrics and formulas · Finance and FP&A teams
Profitability analysis identifies the products, customers and business units behind reported profit. Use a reconciled ledger example to separate gross profit, service costs and shared allocations, then assign actions to the underlying business drivers.
Profitability analysis identifies which products, customers and business units produce the company's profit, and which activities consume it. Start with reconciled ledger slices, then distinguish product economics, service demands and shared costs. The useful result is an action on a business driver, supported by a total that ties to the accounts.
The P&L establishes the total to explain. Use how to analyze a P&L for the methods of comparing statement lines and explaining changes between periods. This review begins after that work and asks which parts of the business sit behind those lines.
Keep profit levels distinct. The SEC's financial-statements guide explains that gross profit subtracts the cost of sales, while operating expenses are deducted afterward. A high gross margin therefore does not establish that a customer or product earns enough after service and support costs.
Ratio definitions belong in the profitability ratios guide. Ask: does the apparent winner still contribute after service, and does the reported loser actually consume avoidable resources?
Use a closed period and one reporting currency. Start with net revenue after credits and rebates, cost of goods sold, operating costs and a finance-approved mapping of accounts. Add product, customer and business-unit identifiers from the invoice or sales export where the ledger lacks them.
Specify the grain before combining files. Invoice lines can carry product costs; delivery or support records can carry customer activity. Summarize each to the review's grain before combining totals, so an invoice with several support tickets does not acquire repeated revenue.
Retain unmatched customers, products and accounts in a visible exception group. Also retain costs that cannot be assigned reliably. An explicit unassigned amount is more useful than a complete-looking table built on arbitrary guesses.
For service-cost pool selection and allocation formulas, use the dedicated cost-to-serve guide. In this review, record the supplied rates, their period and their owner rather than redesigning the allocation during the meeting.
An illustrative US industrial supplier reviews September results across three product groups. Finance supplies the attributable service costs and approved shared-overhead allocations. All values are exact USD; displayed percentages below are exact, with no rounding required.
For this management view, contribution means revenue less cost of goods sold and attributable service costs. It is explicitly defined here because other reports may use contribution to mean revenue less variable costs.
| Product group | Revenue (USD) | COGS (USD) | Service costs (USD) | Contribution (USD) | Shared overhead (USD) | Operating profit (USD) |
|---|---|---|---|---|---|---|
| Standard products | 600,000 | 390,000 | 90,000 | 120,000 | 60,000 | 60,000 |
| Custom products | 300,000 | 150,000 | 120,000 | 30,000 | 30,000 | 0 |
| Service contracts | 100,000 | 20,000 | 10,000 | 70,000 | 10,000 | 60,000 |
| Total | 1,000,000 | 560,000 | 220,000 | 220,000 | 100,000 | 120,000 |
With the headings in row 1 and columns in the displayed order, enter these formulas in E2 and G2, then fill down through row 4:
E2 =B2-C2-D2
G2 =E2-F2
The custom group has gross profit of $300,000 - $150,000 = $150,000, or 50% of revenue. After $120,000 of service costs, it leaves $30,000, or 10% of revenue, toward shared costs. Its attractive product margin is real, but does not explain the cost of handling the business.
Standard products contribute $120,000, while service contracts contribute $70,000 despite much lower sales. That is a reason to examine service demand and sales capacity, rather than immediately giving the largest revenue group all the attention.
The company reconciliation is $1,000,000 - $560,000 - $220,000 - $100,000 = $120,000. Contributions sum to $220,000, and shared overhead sums to $100,000. Both must equal their source pools.
In row 5, sum each numeric column. These independent checks must return zero:
=B5-C5-D5-E5
=E5-F5-G5
Then compare revenue, COGS and each operating-cost pool with the closed ledger. Formulas cannot detect an export missing a customer. Preserve the same reconciliation when switching from product groups to customers or business units; those are alternative views of the same company, not amounts to add together.
OpenStax's overhead-allocation discussion explains that overhead is assigned using a chosen allocation basis. Treat an allocation as a transparent management assumption. It does not, by itself, establish which expenditure would disappear if sales stopped.
Ask operations why custom products consume $120,000 of service resources. Investigate small production runs, expedited delivery, design changes and support requests using the underlying records. Sales should check whether those demands are reflected in customer terms and prices.
For example, suppose operations supplies a documented proposal reducing custom service costs by $20,000 with revenue and every other cost unchanged. Custom contribution becomes $150,000 - $100,000 = $50,000, and company operating profit rises to $140,000. This is a proposal to verify with the cost owner, not a saving inferred merely from ranking the table.
By contrast, closing the custom group would remove $30,000 of contribution if all its product and service costs were avoidable but shared overhead remained. Company profit would fall to $90,000 despite the group's reported zero after allocation. Confirm avoidability before treating a low rank as an exit decision.
Use the product profitability report for product-level follow-through and project margin analysis for work organized by project. For delivery-led businesses, route profitability analysis addresses the route-specific review.
Bring your ledger, sales export and supplied service-cost assumptions; Covirage maps the columns and its tools compute and check the reconciled comparisons. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See customer profitability for the supporting business context.
Its purpose is to connect company profit with business decisions. A review identifies the revenue, product costs and service demands behind each segment's result, then assigns an action and an owner. It should explain where profit comes from rather than simply rank margins.
Yes. Gross profit excludes costs below cost of goods sold, including many delivery, support and selling costs. A product can have a strong gross margin while consuming enough service resources to leave little contribution toward shared overhead.
First identify which costs would actually disappear. A product with no profit after shared overhead allocation may still contribute toward costs that remain if it closes. Compare the avoidable revenue and costs, then consider capacity, customer relationships and replacement opportunities.
Finance owns reconciliation, cost definitions and allocation transparency. Sales and product teams explain pricing and mix, while operations owns service consumption and delivery costs. A useful review assigns each proposed change to the manager who can change its underlying driver.