Which top revenue lines fail a product profitability analysis?
The short answer
Your biggest revenue lines can still lose money once discounts, returns and handling come off. A product profitability analysis for the top 20 lines starts from net revenue after discounts and returns, subtracts cost of goods kept and variable costs such as freight and returns handling, and ranks lines by the profit left.
SKU profitability analysis, line by line
Why it matters
Top revenue lines get the most stock, space and promotion, so a loss-making bestseller drains margin at scale. Finding it lets you reprice, cut its discount or fix its returns before another season of volume makes the loss bigger.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Start with net revenue. Take gross sales for each top line, then subtract discounts and the value of returns.
2. Subtract the costs. Take off cost of goods for units kept, freight to customers and the cost of handling each return.
3. Check who buys it. For lines that lose money, see whether their buyers go on to buy profitable lines, since some losses bring in valuable customers.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a home improvement retailer. It takes three top revenue lines and subtracts discounts, returns, cost of goods and freight, in millions of dollars.
- Cordless drill kit: 1.90 gross, profit 0.33
- Patio heater: 1.60 gross, 0.38 discounts, 0.21 returns, 0.24 freight. Profit -0.09
- Vinyl flooring: 1.40 gross, profit 0.29
What the data shows
The patio heater ranks second on revenue but loses about $90,000 after deep promotions and bulky freight.
What it means
Most patio heater buyers bought nothing else that year, so the loss is not buying future customers.
What to do
Cut promotion depth on the heater and price freight into it, or reduce the range.
Freight is allocated by weight, so treat line-level figures as close estimates. Would you like the full top 20 ranked by profit?
Frequently asked questions
How do I find unprofitable products in a large range?
Start with the lines that carry the most revenue, since a loss there is the largest in dollars. Calculate each line's profit after discounts, returns, cost of goods and freight, then sort from lowest. Extend the check down the range once the top lines are clean.
Why can a bestseller lose money?
Volume often comes from heavy promotion, and popular lines attract more returns and more freight as they sell. Each discount, return and delivery takes a slice of the price customers paid. A line can top the revenue report while those costs add up to more than its margin.
How does customer profitability analysis change the verdict on a product?
It shows whether a loss-making line brings in customers who later buy profitable products. If buyers of a loss-making line go on to spend well elsewhere, the line may be worth keeping as an entry point. If they buy nothing else, the loss stands on its own and the line needs fixing.