Profitability by Business Unit or Channel Prompt
Prompt
You are a CFO analyzing profitability by business unit or channel. P&L data: [PASTE: Channel/BU | Revenue | COGS | Gross margin | Allocated overhead (by headcount/revenue/space) | Net operating profit | % of total revenue | % of total profit] Analyze: 1) Revenue vs. profit contribution — channels with high revenue share but low profit share are subsidized by others 2) Overhead allocation — confirm overhead is being allocated on a reasonable basis; restate if needed 3) Fully allocated margin by channel — some channels look profitable on gross margin but lose money fully loaded 4) Investment priority — channels with the best return on overhead investment deserve more resources 5) Channel exit analysis — any channels where fully allocated profitability is negative with no path to improvement? Output: Channel profitability analysis. Contribution vs. overhead allocation. Investment recommendation. Exit analysis for unprofitable channels.
Why it works
The revenue versus profit contribution comparison is where the most valuable insight in channel profitability analysis usually lives — channels with high revenue share and below-average profit contribution are consuming resources without generating proportionate returns, while small-but-high-margin channels are often under-invested. Including allocated overhead by methodology ensures leadership understands which costs are truly avoidable if a channel were discontinued versus which are shared costs that would be reallocated. The contribution analysis (before overhead) alongside net profit produces the right information for both strategic (net profit) and operational (contribution margin) decisions.
Watch out for
Overhead allocation methodology significantly affects channel profitability results — the same revenue and gross margin can produce very different net profit percentages depending on whether overhead is allocated by revenue, headcount, or space. Present the methodology transparently alongside the results, and test sensitivity to allocation method before using the analysis for strategic decisions like channel prioritisation or discontinuation.
Used by