SKU-Level Profitability: How Retailers Find Hidden Losers
Reviewed by Scott Nielson, CPA, Partner, Director of Tax on
A retailer with 800 SKUs and a healthy blended gross margin often has 100 SKUs quietly losing money and does not know it. Blended margins average the winners with the losers, and unless someone has done the allocation work, the losers stay on the shelf, absorb inventory dollars, and drag on cash flow. For an Idaho outdoor retailer, a Utah e-commerce brand, or a specialty grocer working with distributor lines, SKU-level profitability is one of the highest-leverage analyses on the finance side of the business.
The math is not complicated. The discipline is.
Why Blended Margins Hide Money-Losing SKUs
A gross margin figure at the category or department level obscures three things. It hides SKUs where actual landed cost has drifted higher than the last review. It masks SKUs that carry disproportionate handling, freight, or shrinkage cost. And it fails to reflect the true cost of holding an item in inventory for six or twelve months when a comparable item turns four times as fast.
The result is a portfolio in which a handful of hero SKUs subsidize a long tail of items that would fail a proper margin test if they were evaluated on their own.
The Four-Step Allocation That Reveals True SKU Cost
Real SKU profitability requires pulling apart the cost line into pieces that can be allocated per unit. A working four-step model:
- Landed cost per unit: supplier cost, inbound freight, duty, currency conversion, tariff. Update at least twice a year, or every time a supplier price change lands.
- Direct handling cost: receiving, put-away, pick, pack, and outbound freight per unit. Small items in high volume can carry disproportionate handling cost as a share of price.
- Inventory carrying cost: capital cost of inventory times average days on hand, plus warehouse space, insurance, and obsolescence reserve. Slow SKUs get penalized here.
- Category overhead allocation: merchandising, marketing, and store or platform operating costs allocated by revenue share or slot count.
Contribution margin per unit equals selling price minus the first three items. Fully allocated profit adds the fourth. Both figures matter, but contribution margin is the more actionable number for pruning decisions.
The 80/20 Trap: Long-Tail SKUs and Carrying Cost
Pareto’s rule almost always shows up in a SKU analysis: 20 percent of SKUs generate 80 percent of revenue. The other 80 percent of SKUs are the long tail. In some retailers, the long tail is a real strategic asset because it broadens the assortment and drives basket size. In others, it is a slow-moving inventory anchor absorbing carrying cost with no reciprocal revenue lift.
The tell is turnover. Fast-turning long-tail SKUs earn their space. Slow-turning long-tail SKUs, especially those with a full year of dust on the shelf, rarely do.
How Often to Rerun the Analysis
Twice a year is usually enough for most retailers, with a lightweight monthly check on the fastest-changing categories. Cost changes on inbound goods, tariff shifts, and shipping cost volatility can all move a SKU from margin-positive to margin-negative in a single quarter. Set a threshold (for example, any SKU whose contribution margin falls below a set floor for two consecutive months) and flag those for pricing action or delisting.
What to Do With Losing SKUs Before Killing Them
Four options before a delist decision:
- Raise price. Test elasticity on categories where the SKU is not a signpost item.
- Negotiate cost. Volume commitments, container-load orders, or an alternate supplier can pull landed cost down 5 to 15 percent.
- Reduce handling cost. Case-pack ordering, pre-labeling from the supplier, or slotting near pick paths can pull handling per unit down.
- Shrink the buy. Some SKUs are worth keeping on the shelf at a lower stocking level; they just do not deserve the depth they currently have.
Delist is the last option, not the first, because delist can shrink assortment perception and drive cross-selling losses.
Communicating SKU Cuts to Buyers and Vendors
Buyers frequently disagree with delist recommendations because they weight assortment and vendor relationships alongside pure margin math. That disagreement is healthy. The right process brings buyer, finance, and category management together with the same SKU-level profit report and negotiates the cuts in the open.
Vendors respond better to a data-driven conversation than a surprise letter. Sharing the SKU-level margin numbers before the cut is announced often surfaces cost concessions or promotional support that saves the SKU.
Cleaning up a SKU portfolio is one of the fastest ways to free working capital in a retail business. The retail advisory team at Cooper Norman has run this analysis for Idaho and Utah retailers across grocery, specialty, and e-commerce. If your blended margin looks fine but cash is tight, our fractional CFO group can help you find where it went.