Product Line Profitability for CPG: Which SKUs Actually Make Money?

Key Takeaways

• Gross margin at the company level is structurally incapable of answering the question “which products make money.” It aggregates products with different cost structures, channels with different trade terms, and customers with different return profiles into a single number that is useful for trend analysis and useless for portfolio decisions.
• The answer requires a fully loaded contribution margin view by SKU and product line, one that nets out trade spend, allocates overhead based on actual consumption rather than revenue percentage, and accounts for the working capital each SKU consumes relative to the cash it generates.
• Bottom line: The CFO who can answer “which of our product lines actually makes money, and by how much” with a clean, defensible number has a meaningful strategic advantage over the one who cannot.

Most CPG companies have a working theory about which products are profitable. Ask the sales team, and they’ll point to the highest-revenue SKUs. Ask the supply chain team, and they’ll point to the highest-volume items. Ask the finance team, and they’ll show you a gross margin percentage that looks roughly the same across the portfolio.

None of these answers is wrong. None of them is fully correct, either.

Product line profitability in CPG is a constructed number, not a reported one. It requires deliberate analytical choices about how to allocate costs, assign trade spend, and measure working capital efficiency at the SKU level. Companies that build this analysis consistently make better pricing, promotion, and portfolio decisions. Companies that skip it are generally working from assumptions that haven’t been tested in years.

Why Gross Margin Doesn’t Tell You What You Think It Does

Gross margin is the right place to start, not the right place to stop. It captures the cost of goods sold against revenue, but it misses most of the costs that determine whether a specific product line is actually creating value for the business.

Consider what gross margin does not include:

• Trade spend, promotional allowances, slotting fees, co-op advertising, and other variable selling costs that are directly attributable to specific SKUs or channels
• Outbound freight costs, when the company bears them, vary materially by channel, customer location, and order size
• Working capital costs: the inventory carrying cost of a slow-turning SKU versus a fast-turning one is real, even if it never appears as an explicit line item
• Co-manufacturer minimums that force production runs larger than justifiable demand, creating obsolescence exposure on the back end
• Sales force or broker commissions attributable to specific product categories

When you load these costs into the analysis at the SKU or product line level, the ranking changes. Routinely, the top-revenue SKU is not the top-contributor SKU. Routinely, a product line that appears healthy at the gross margin level is generating less value per dollar of working capital deployed than a smaller, quieter line that management hasn’t looked at closely.

Building a Fully Loaded Product Line P&L

The analytical framework that actually answers the profitability question has four layers. Each layer gets closer to economic reality.

Layer 1: Gross margin by SKU

Start with net revenue per unit, which means gross selling price minus all items that reduce the consideration actually received. Under ASC 606, promotional allowances, cooperative advertising payments, and volume discounts are variable consideration to be deducted from revenue at the time of recognition, not when the deduction arrives. An SKU with a $12.00 wholesale price, a $1.50 promotional allowance, and a $0.40 slotting fee amortization has a net revenue of $10.10, not $12.00. COGS, not gross revenue, is the starting point for an accurate gross margin figure.

Layer 2: Contribution margin after trade spend

Trade spend is the category that most consistently produces distorted profitability views in CPG. It tends to be tracked at the account or campaign level, reported in aggregate, and rarely connected back to the specific SKUs it was deployed against. The contribution margin analysis that is actually useful requires trade spend allocated to the SKUs it was promoting. A product with a 40% gross margin that is running a $ 3.00-per-case promotional allowance on its two largest accounts is generating something quite different from what the gross margin percentage suggests.

Layer 3: Contribution margin after direct channel costs

Channel costs vary by customer and order configuration in ways that overhead allocations based on revenue percentages never capture. Outbound freight for a full pallet order to a distribution center is materially different from freight for a mixed case order to a small-format retailer. Amazon fulfillment fees are a direct SKU-level cost that should appear in the product’s contribution margin, not in a blended operating expense line.

Layer 4: Working capital efficiency

This layer is the one most CPG finance teams skip entirely. Inventory turns per SKU, combined with payment terms on both the supply and customer sides, determine how much capital a product line consumes relative to the cash it generates. Two SKUs with identical contribution margins at Layer 3 have very different economic profiles if one turns 12 times per year and the other turns four times per year. The slower-turning product is consuming three times as much working capital for the same contribution, which means it requires three times as much financing and generates three times as much exposure to obsolescence, expiration, and markdown events.

The Co-Manufacturer Minimum Problem

One dimension of product line profitability that mid-market CPG companies frequently underanalyze is the financial cost of co-manufacturer minimum order quantities (MOQs) on low-velocity SKUs.

When a product line requires a 5,000-unit minimum production run but the market consumes only 2,500 units per quarter, the company carries 2,500 units of excess inventory each cycle. At face value, this is an inventory management problem. In the product line P&L, it is a profitability problem: the carrying cost of that inventory, the risk of expiration or obsolescence before it sells, and the working capital tied up in units that won’t generate revenue for six months all belong in the economics of that product line.

The contribution margin of a slow-moving SKU produced in excess quantities to meet a co-manufacturer minimum is lower than the gross margin calculation suggests, often materially so. Controllers who build working capital consumption into their product line analysis catch this. Those who stop at gross margin miss it until an inventory write-down shows up, and nobody can explain which decision created it.

Where Overhead Allocation Goes Wrong

Fixed overhead is the most consistently misallocated cost in CPG product line profitability analysis. The standard approach, spreading overhead as a percentage of revenue or units, assigns more overhead to high-revenue products and less to low-revenue ones. This is administratively convenient and economically arbitrary.

A product line that requires complex co-manufacturer scheduling, specialized ingredients with long lead times, and frequent quality hold cycles is consuming more operational overhead than a product line that runs on a standard formula with commodity inputs and predictable production. Allocating identical overhead rates to both produces cost figures that neither reflect the true cost of the complex product nor give the simple product the credit for its operational efficiency.

For CPG companies with enough operational data to support it, activity-based overhead allocation, assigning costs based on actual consumption drivers such as production runs, warehouse touches, and quality events, produces more accurate product line economics and better decisions. For companies without that data infrastructure, the minimum standard is to identify the products consuming disproportionate operational resources and adjust the allocation methodology to reflect that.

Translating the Analysis Into Portfolio Decisions

The point of building a fully loaded product line P&L is not to eliminate everything below a certain margin threshold. It is to make decisions from accurate information rather than imprecise information.

A product line with thin, fully loaded margins might have a clear path to improvement through pricing, trade spend reduction, or volume growth that changes the overhead absorption. A product line with strong gross margins but heavy working capital consumption might be a rational target for rationalization, even though it looks healthy in the standard reporting. A product line with modest margins, low capital requirements, and minimal trade support might be generating more real value per dollar deployed than anything else in the portfolio.

These distinctions are only visible when the analysis is built correctly. Wiss works with CPG companies to build the product line profitability infrastructure that makes these questions answerable on a recurring basis, not just as a one-time exercise before a board meeting or a diligence request. If your current reporting answers “how much revenue did each product generate,” but not “which products are actually making money,” that gap is worth closing.

Previous"Construction Invoice Processing: Automation and Cash Flow for Controllers"