SKU profitability analysis is the process of calculating true contribution profit for each product you sell, after every direct cost, fee, and allocated expense is accounted for. The outcome that matters most is a ranked, per-SKU profit figure you can actually act on: which products to keep, which to fix, and which to kill. If you have not run this analysis in the last quarter, the fastest next step is a prioritized SKU contribution report.
TL;DR:
- SKU contribution profit analysis reveals which products are truly profitable after accounting for all direct, indirect, and allocated costs, including inventory carrying costs.
- Using activity-based allocation instead of flat overhead improves accuracy by linking costs to actual drivers like warehouse space and handling time.
- Regular ranking by contribution profit, combined with demand stability and return rates, guides decisions to keep, fix, or retire SKUs quarterly due to market shifts.
- Pricing and packaging adjustments are the fastest levers to improve margins on underperforming SKUs, especially through targeted price tests and size modifications.
- Effective SKU analysis depends on robust systems that track detailed cost and sales data, and often benefits from external diagnostics and advisory support.
Table of Contents
- Why SKU-level granularity changes decisions
- All costs to include and the reproducible formulas
- Step-by-step calculation on one SKU
- Ranking SKUs and the decision framework to keep, fix, or kill
- What to use and what data you need
- How SKU profitability shapes stocking, reorder, and assortment
- Commercial levers to improve SKU margins
- Activity-based costing and explainable multi-criteria ABC classification
- Practitioner notes and what advisory work surfaces
- How Commerce Catalyst helps: diagnostics and advisory next steps
- Sources
- FAQ
Why SKU-level granularity changes decisions
Most financial reporting happens at a level too high to be useful. A category or brand-wide margin number can look healthy while individual products quietly bleed cash.
This is where the discipline earns its keep. Once you isolate net-net revenue, which is gross sales minus discounts, returns, and allowances, and subtract direct and allocated costs for a single SKU, you see something a blended number never shows you: contribution margin at the product level, the actual dollars a SKU leaves behind after it has paid for its own existence.
A few concepts carry the weight here:
- Net-net revenue is the honest starting point, not list price or gross sales.
- Direct costs are tied to the unit itself: materials, manufacturing, packaging.
- Indirect costs are shared across SKUs and require an allocation method to assign fairly.
- Contribution margin is what remains after direct and allocated variable costs, before fixed overhead.
Two habits undermine this work before it starts. The first is flat overhead allocation, where every SKU absorbs the same per-unit overhead regardless of how much warehouse space, handling time, or customer service load it actually consumes. The second is chasing vanity metrics like units sold or revenue share, numbers that feel productive but say nothing about whether a SKU makes money.
All costs to include and the reproducible formulas
A SKU profit calculation is only as good as the cost list behind it. Leave something out and you get a number that looks precise and misleads anyway.
- Cost of goods sold (COGS), including materials, labor, and freight-in.
- Channel and payment processing fees, which vary by marketplace or platform.
- Outbound shipping and fulfillment costs, per unit shipped.
- Returns and chargebacks, allocated to the SKU that generated them.
- Advertising spend allocated to that SKU, whether from direct attribution or a reasonable allocation rule.
- Inventory carrying costs, covering storage, insurance, obsolescence risk, and capital tied up in stock.
- Allocated overhead, assigned through an activity-based method rather than a flat per-unit split.
Carrying costs deserve particular attention because they are so often ignored. Inventory management literature commonly estimates carrying costs between 20% and 25% of total inventory value annually, a range that includes storage, insurance, shrinkage, and the opportunity cost of capital tied up in unsold stock.
20 to 25% is the commonly cited range for annual inventory carrying costs as a share of total inventory value, according to cross-sectional inventory research. Applying that range to your average inventory value gives you a realistic carrying cost line instead of ignoring it entirely.
For overhead, activity-based allocation, where costs are assigned based on actual drivers like warehouse space occupied, pick frequency, or handling time, produces far more actionable numbers than a flat per-SKU overhead split. The formula itself is clear once the inputs are honest:
SKU Contribution Profit = Net-Net Revenue − (COGS + Channel Fees + Shipping + Returns + Allocated Ad Spend + Carrying Costs + Allocated Overhead)
Divide that result by units sold for a per-unit figure, or leave it aggregated for a period view. Either way, the formula does not change, only the lens you apply to it.
Step-by-step calculation on one SKU
Say you sell a reusable water bottle at $28 per unit. Here is how the math moves from sale price to contribution profit.
- Start with net-net revenue: after a 5% average discount and return rate, net-net revenue lands at $26.60 per unit.
- Subtract direct costs: COGS of $9.00, channel fees of $2.10, and outbound shipping of $3.50 bring you to $12.00 remaining.
- Subtract allocated ad spend: if this SKU absorbs $2.50 per unit in attributed advertising, you are left with $9.50, which is post-ad gross profit, often shortened to PAG.
- Allocate carrying and overhead costs: applying a carrying cost estimate and an activity-based overhead share might remove another $3.00, leaving $6.50 in final contribution profit per unit.
At $6.50 per unit, this SKU is healthy, assuming volume supports the fixed costs it is not directly carrying. The number only becomes useful once you compare it against other SKUs in the same category, because $6.50 might be excellent for a commodity product and mediocre for a premium one. Context, not the number in isolation, drives the keep, fix, or kill decision.
Ranking SKUs and the decision framework to keep, fix, or kill
Once you have contribution profit for every SKU, the next question is how to rank them. Margin per unit alone is tempting but incomplete, because it rewards high-margin, low-velocity products that tie up shelf space or working capital without moving.
- Rank by margin per unit to establish a baseline view of profitability.
- Layer in margin per inventory dollar, which reveals how efficiently a SKU converts stocked capital into profit.
- Add return rate as a flag, since a high-margin SKU with a high return rate often nets out worse than it first appears.
- Factor in demand stability and lead time, borrowing from ABC classification logic so that a volatile, long-lead-time SKU gets scrutinized differently than a stable, fast-replenishing one.
- Set decision triggers: keep SKUs with strong contribution and stable demand, improve those with fixable cost or pricing issues, and retire SKUs that are structurally unprofitable even after reasonable fixes.
Pro Tip: Run the ranking quarterly, not annually. Seasonal shifts and ad cost volatility can flip a SKU from profitable to underwater in a single cycle.
The judgment call is in the “improve” category, where a SKU is not a clear keep or kill but has an identifiable lever, pricing, packaging, or channel mix, that could move it into clear profitability. Harvard Business Review’s documentation of Clorox’s SKU rationalization program shows how deliberate cuts to underperforming SKUs reduced complexity and improved margins at a corporate scale, a pattern that holds at much smaller revenue bases too. For a structured approach to this process, see our guide on SKU rationalization.
What to use and what data you need
The right tool depends less on brand name and more on whether it can handle SKU-grain data without forcing manual reconciliation every month.
- ERP and inventory systems need to expose SKU-level COGS, unit counts, and carrying cost inputs, not just aggregated inventory value.
- Accounting platforms should support cost allocation rules rather than a single blended COGS line across all products.
- Advertising platforms need to export spend data at a granularity that can be mapped to individual SKUs or close to it.
- BI or reporting layers should let you combine these sources into one profit view instead of reconciling spreadsheets by hand each month.
When selecting a tool, prioritize three things: the grain of data it actually captures, how much of the allocation work it automates versus leaves to you, and whether it supports activity-based allocation logic or forces a flat split.
Before trusting any output, run a validation pass: reconcile total allocated costs against your actual financial statements, confirm SKU mapping is consistent across every data source, and set a review cadence, monthly at minimum, so allocation rules do not drift silently out of date. Unifying SKU, channel, and customer views into one profit system, rather than relying on siloed dashboards, is what actually surfaces money-losing combinations before they compound. Our piece on channel profitability goes deeper on why channel and SKU views need to sit together.
How SKU profitability shapes stocking, reorder, and assortment
Contribution profit numbers are only useful once they change how you buy and stock inventory. A SKU with strong margin but erratic demand needs a different reorder rule than a steady, moderate-margin staple.
- Set reorder points using profit-weighted priority, not just historical sales volume.
- Apply multi-criteria ABC classification, combining sales volume, profit contribution, lead time, and obsolescence risk rather than relying on revenue alone, an approach research on hybrid multi-criteria classification shows produces more interpretable and actionable SKU classes.
- Match control intensity to class: A-class SKUs warrant tight, frequent monitoring, while C-class items can run on lighter, less frequent review.
- Use the carrying cost benchmark, 20 to 25% of inventory value, to decide whether holding deep stock on a slow-moving SKU is actually worth the capital it ties up.
Nearly all documented SKU rationalization programs reduce complexity and improve margin, according to HBR’s account of the Clorox cuts, a result that reflects the structural drag long-tail SKUs place on operations even when each one looks harmless alone.
Executing on this means setting a review cutoff, say, SKUs below a defined contribution threshold for two consecutive quarters, and tracking the impact of each cut on blended margin and working capital over the following quarter.
Commercial levers to improve SKU margins
Once you know which SKUs are underperforming, pricing and packaging are usually the fastest levers available, faster than renegotiating supplier contracts or overhauling fulfillment.
- Test a direct price increase on SKUs with strong demand elasticity signals and compare contribution profit before and after, not just revenue.
- Consider pack-size changes instead of a price increase when the category is price-sensitive but cost-per-unit economics improve at larger sizes.
- Model bundling carefully, since a bundle can lift average order value while quietly dragging a high-margin SKU down if the bundled partner is weak.
- Run promotions through the full net-net revenue and allocated CAC lens, not gross revenue, so a discount that looks like a volume win does not mask a margin loss.
- Flag channel and SKU combinations that lose money structurally, for example a SKU that is profitable on your own site but underwater once marketplace fees and ad costs are layered on.
Our guide on pricing products for sustainable profit walks through how to test these levers without guessing at elasticity.
Activity-based costing and explainable multi-criteria ABC classification
Flat overhead allocation is easy to build and consistently wrong. Activity-based allocation assigns costs using actual drivers, warehouse space occupied, pick frequency, special handling requirements, so a SKU that takes up a pallet and gets picked twice a month carries a different overhead burden than one that moves daily from a small bin.
- Identify causal drivers for each major cost category: space for storage, time for handling, frequency for picking.
- Apply multi-criteria ABC classification, layering profit, demand, lead time, and risk rather than ranking on a single dimension.
- Use explainable outputs, where the model shows managers why a SKU landed in a given class, so the classification becomes a rule rather than a black box.
Explainable multi-criteria ABC classifications let managers convert model assignments directly into operational policy, because the driver explanations behind each class are human-readable rather than opaque. Research on explainable AI for ABC classification
A practical pilot looks like this: pick three to five classification criteria that matter for your catalog, run the model against a recent period of SKU data, generate local explanations for a sample of SKUs in each class, and convert the patterns you see into simple inventory and pricing rules your team can apply without rerunning the model every time. For a partner-built framework on structuring driver-based allocation, the customer profitability driver rate card playbook is worth reviewing alongside your SKU work, since customer and SKU allocation logic often share the same underlying drivers. Our own breakdown of customer profitability analysis covers how the two views reinforce each other.
Practitioner notes and what advisory work surfaces
What moves fastest in this work is not a company-wide cost cut. It is a prioritized roadmap: fix the handful of high-volume, low-margin SKUs first, then address channel-specific losses, then rationalize the long tail. That sequence tends to free up working capital and lift blended margin faster than any broad initiative.
How Commerce Catalyst helps: diagnostics and advisory next steps
Running this analysis internally takes time most founders do not have, and getting the allocation logic wrong produces a number that looks credible but leads to the wrong decision. Commerce Catalyst turns SKU-level findings into a prioritized action plan instead of another spreadsheet nobody revisits.
- If you need a fast read on where your profitability leaks are, consider a one-off diagnostic engagement available on the provider’s site.
- If you have a specific allocation or pricing question and want direct input, advisory sessions at an hourly rate are available.
- If you need ongoing financial leadership to implement and track these changes, fractional CFO services are offered to support consumer brands.
Start with the DTC Operator Diagnostic to get a prioritized view of your own SKU profitability before your next buying cycle.
Sources
- How is Information from ABC–VED–FNS Matrix Analysis Used to Improve Operational Efficiency of Pharmaceuticals Inventory Management? A Cross-Sectional Case Analysis
- A hybrid fuzzy-stochastic multi-criteria ABC inventory classification using possibilistic chance-constrained programming
- Growing by cutting SKUs at Clorox | Harvard Business Review
FAQ
What is SKU profitability analysis?
SKU profitability analysis calculates the true contribution profit of each product after accounting for direct costs, fees, shipping, returns, advertising, and allocated overhead. The goal is a per-SKU profit figure that supports keep, fix, or kill decisions rather than relying on blended, category-level margins.
How do I calculate SKU productivity?
SKU productivity typically combines contribution profit with inventory efficiency, often expressed as margin per inventory dollar or margin per unit of shelf space. Pairing this with multi-criteria ABC classification gives a fuller picture than sales volume alone.
What is SKU-level analysis?
SKU-level analysis means evaluating financial and operational performance for each individual product variant, rather than at the category or brand level. It reveals which specific products drive profit and which are quietly losing money, something aggregate reporting tends to hide.
What is SKU and KPI?
A SKU, or stock keeping unit, is a unique identifier for a specific product variant, down to size, color, or packaging. A SKU-level KPI is any performance metric, such as contribution margin, return rate, or carrying cost, tracked at that individual product level rather than averaged across a category.