Which top revenue lines fail a product profitability analysis?
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?
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.
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.