Product Profitability Analysis
Product Profitability Analysis (PPA) builds a fully-loaded P&L per product or SKU — assigning revenue, COGS, and indirect costs (R&D allocation, marketing, support, supply chain complexity) to each line. The output reveals which products generate disproportionate profit, which break even, and which destroy value. The shape that PPA reveals is almost always Pareto: the top 20% of SKUs generate 80% of profit, while the bottom 20-40% are profit-neutral or negative once complexity costs are loaded. KnowMBA POV: SKU proliferation is the silent margin killer in most consumer goods, manufacturing, and B2B catalog businesses. Product managers add SKUs for revenue (incentivized) but no one is incentivized to kill them — so the long tail grows unchecked for years.
The Trap
The trap is allocating overhead by revenue or unit volume instead of by activity. A specialty SKU with 1% of volume might require 20% of R&D, 15% of marketing carve-outs, and 10% of supply chain complexity. Allocating overhead by revenue makes the specialty SKU look as profitable per unit as the volume product. Activity-based loading reveals the truth. The other trap: pruning SKUs without understanding cannibalization. Killing a 'low-volume' SKU may push customers to a competitor if the SKU is a 'must-have' part of the assortment. Always test cannibalization before pruning.
What to Do
Build SKU-level profitability for the top 80% of revenue (or top 100 SKUs, whichever is more comprehensive). Allocate fixed overhead via Activity-Based Costing — drivers like SKU count, production runs, R&D project hours, marketing campaigns. Sort SKUs into four buckets: Hero SKUs (top quartile profit, invest more), Workhorses (steady, protect), Diluters (low margin but strategically necessary, monitor), Long-Tail Killers (bottom quartile, prune unless strategic). For Killers, run a 12-week cannibalization test: stop active selling, see if revenue migrates to other SKUs (good — kill) or evaporates (bad — keep but reprice).
Formula
In Practice
Procter & Gamble's famous SKU rationalization in the early 2000s eliminated ~25% of its product portfolio over 5 years (from ~16,000 to ~12,000 SKUs in some divisions). The cuts focused on the long tail of low-volume specialty variants. Result: revenue declined slightly (~3%) but operating margin expanded by 400+ basis points and brand-level investment efficiency improved dramatically. The same playbook has been run by Unilever, Coca-Cola, and Nestlé since. The recurring lesson: SKU complexity is exponentially expensive to serve and almost never as profitable as simple SKU counts make it look.
Pro Tips
- 01
Use the 'Pareto squared' heuristic for SKU rationalization: in any catalog, ~64% of profit (80% × 80%) typically comes from 4% of SKUs. The bottom 50% of SKUs typically generate <5% of profit. The math is so consistent across industries that you can use it as a smell test before running the full analysis.
- 02
Long-tail SKUs disproportionately consume: warehouse space (slow-mover bin allocation), forecasting effort (low-volume = high error), purchasing complexity (small POs), and customer service overhead (configuration questions). These costs rarely show up in standard cost accounting but are visible in ABC.
- 03
When pruning SKUs, the canonical mistake is killing the SKU and keeping the variants. If you have 12 colors of a product and 8 of them sell <2% of volume, killing 8 colors usually moves the customer to one of the remaining 4. If you keep 2 colors, you risk losing the customer entirely. Granular cuts beat coarse cuts.
Myth vs Reality
Myth
“Long-tail SKUs are necessary to attract loyal customers”
Reality
Sometimes true, mostly false. Most long-tail SKUs are legacy artifacts — added for a specific account or market segment that no longer exists, never sunset. Empirical SKU rationalization studies (P&G, Walmart) show <10% of long-tail SKUs are genuinely strategic. The other 90%+ can be cut without revenue impact.
Myth
“Adding SKUs grows revenue”
Reality
Above a saturation point, adding SKUs cannibalizes existing volume rather than expanding total demand. Studies of consumer goods aisles show that increasing assortment beyond ~7-12 options per category often DECREASES total category sales due to choice paralysis. SKU count is not a growth lever past saturation.
Try it
Run the numbers.
Pressure-test the concept against your own knowledge — answer the challenge or try the live scenario.
Knowledge Check
A consumer goods company has 5,000 SKUs. The CFO runs PPA and finds 60% of SKUs generate <2% of profit. What's the directionally correct response?
Industry benchmarks
Is your number good?
Calibrate against real-world tiers. Use these ranges as targets — not absolutes.
% of SKUs Generating <2% of Profit (Pareto Tail)
Consumer goods, industrial parts, B2B catalog businessesDisciplined Catalog
< 25%
Average
25-50%
Bloated
50-65%
Severe SKU Sprawl
65-80%
Critical Rationalization Needed
> 80%
Source: P&G SKU Rationalization Playbook (industry-standard reference)
Real-world cases
Companies that lived this.
Verified narratives with the numbers that prove (or break) the concept.
Procter & Gamble
2001-2006
Under A.G. Lafley's leadership, P&G eliminated approximately 25% of its product portfolio across multiple divisions — focusing on long-tail variants, regional duplicates, and underperforming brands (most famously, divesting Folgers, Pringles, Sunny Delight in subsequent years). The SKU rationalization freed manufacturing capacity, reduced supply chain complexity, and concentrated marketing investment behind hero brands. Operating margin expanded over 400 bps. Revenue dipped slightly (~3%) but earnings grew strongly. The lesson became a permanent part of P&G's operating model.
SKU Reduction
~25%
Revenue Impact
~-3%
Operating Margin Expansion
+400+ bps
Free Cash Flow Lift
Significant
SKU rationalization is one of the most reliable margin levers in consumer goods. The pattern — slight revenue decline, large margin expansion — appears across nearly every well-executed SKU pruning program. Revenue is overrated; SKU count discipline is underrated.
Hypothetical: Mid-Cap Industrial Distributor
2022-2024
A $180M industrial distributor carried 22,000 SKUs. PPA revealed 14,500 SKUs generated <1% of profit collectively while consuming 30% of warehouse space. After a 24-month pruning effort (with cannibalization testing), the catalog shrunk to 12,800 SKUs. Warehouse was reorganized to free 25% of pallet space, which was rented out as overflow storage to a neighboring business. Net result: $3.4M annual operating profit improvement plus $400K rental income.
SKUs Eliminated
9,200 (42%)
Revenue Impact
-2.5%
Operating Profit Lift
+$3.4M
Bonus Rental Income
$400K/yr
SKU rationalization releases capacity in unexpected places. The biggest wins often aren't the direct cost savings but the freed warehouse, manufacturing, or marketing capacity that can be redeployed.
Related concepts
Keep connecting.
The concepts that orbit this one — each one sharpens the others.
Beyond the concept
Turn Product Profitability Analysis into a live operating decision.
Use this concept as the framing layer, then move into a diagnostic if it maps directly to a current bottleneck.
Typical response time: 24h · No retainer required
Turn Product Profitability Analysis into a live operating decision.
Use Product Profitability Analysis as the framing layer, then move into diagnostics or advisory if this maps directly to a current business bottleneck.