Product Line Margin in Specialty Retail: What Each Line Earns for the Floor It Takes

The problem: Revenue by product line is on every report, but nothing accounts for the floor space a line occupies or how long its stock sits before it sells.

The solution: Set each line's gross margin against the occupancy and carrying cost it consumes, so the ranking reflects what a line earns for the space it takes rather than what it rings up.

Every specialty retailer can tell you revenue by line. The point of sale system produces it without being asked, and most owners could recite the top five from memory. Gross margin percentage by line is usually available too, one report deeper, and it is the number the buyer works from at market.

Neither of those tells you what a line earns. A product line does not just generate margin, it consumes two things on the way: a piece of the floor, which you pay rent, light, and staff to operate, and a pile of cash sitting in stock that has not sold yet. Both costs are real, both are paid every month, and neither one appears anywhere near the line in the reports the business runs on.

Two costs that never make it onto the line

The first is space. A retailer at $9 million across three stores is paying occupancy on every square foot whether it turns or not. Rent, common area charges, utilities, and the payroll to keep the floor staffed do not care which line is standing there. But the reports allocate none of it, so a line that sprawls across an entire wall and a line that lives on one endcap are compared as if they cost the same to carry. They do not.

The second is time. A line that turns six times a year and a line that turns twice can post the same gross margin percentage and be completely different businesses. The slow one has your cash tied up for six months per unit, needs markdowns to clear the tail, and takes back-room space you also pay for. That cost is not imaginary just because it never gets an invoice.

Put together, they explain something owners notice and cannot resolve: the store is busy, the gross margin percentage looks healthy, and there is never any money.

Why the popular line and the earning line come apart

The line that generates the most revenue tends to get more space, because that is the sensible-looking response to a sales report, and more space generates more revenue, which justifies more space. The loop is self-reinforcing and it never checks itself against margin, because margin per square foot is not a number anyone is producing.

Meanwhile the line that turns fast on a small footprint stays small. Nobody argues for it. It does not show up in the top five by revenue, the buyer does not fight for it at market, and it never gets the front table. It may be the most profitable thing in the building per foot of floor and per dollar of working capital, and there is no report on which that would ever be visible.

The result is a floor plan built around one question, what sells the most, when the owner's actual question is a different one: what earns the most for what it costs to carry.

What you need connected to answer it

Nothing here requires new data collection. It requires connecting things the business already has, which currently sit in separate places:

• Sales and gross margin by line, which the point of sale already knows.
• Square footage assigned to each line by store, which exists on a planogram or in somebody's head.
• Total occupancy cost per store, which is in the accounting file as rent, utilities, and store payroll.
• Average inventory value by line, which the inventory system knows but does not report over time.
• Markdowns taken, which usually get recorded as a total rather than tracked back to the line that required them.

The moment those five sit together in one connected picture, margin per square foot and margin after carrying cost stop being a quarterly project someone builds by hand and become numbers the business simply has. And because the upkeep is automated, the ranking is current in November when you are placing spring orders, not assembled in March when the decision is already made.

A look at a specialty retailer

Take a specialty retailer doing about $9 million a year across three stores, eight product lines, a buyer who has been there a decade, and no controller. The owner knows the top line by revenue does about $600k a year at roughly 42 percent gross margin, which is $252k of gross profit and comfortably the best number on the report. It occupies close to a fifth of the selling floor across the three stores, which felt earned.

Now cost the space and the time. If total occupancy across the three stores runs about $540k a year, that line's share of the floor is roughly $97k. It turns about twice a year on an average inventory of $250k, and carrying that stock, cash, insurance, shrink, and back-room space, at a conservative 20 percent runs another $50k. The line is earning closer to $105k, not $252k.

Then look at a line the owner barely thinks about. It does $300k at 38 percent, which is $114k of gross profit, less than half the headline number. But it sits on about 5 percent of the floor, so roughly $27k of occupancy, and it turns six times a year on $50k of average inventory, so about $10k of carrying cost. It is earning close to $77k on a quarter of the space and a fifth of the cash.

Ranked by gross profit, the first line wins by more than two to one. Ranked by what it earns per square foot of floor and per dollar tied up, the second line is roughly three times better. The owner would likely not delete anything. What would probably change is the floor plan and the open-to-buy: the small line gets more space and a deeper assortment, the big line keeps its position but stops growing into more of the wall, and the slowest tail gets a hard look at whether it is a business or a habit. You would expect the effect to show up in cash before it shows up in revenue.

How to start

You can do the first pass in an afternoon with numbers you already have.

1. Measure the floor. Assign every square foot of selling space to a line, by store. Rough is fine, precise is not required.
2. Divide occupancy by the foot. Take total rent, utilities, and store payroll, divide by selling square footage, and you have a cost per foot to apply.
3. Add a carrying cost for time. Multiply each line's average inventory by a single rate you can defend, and subtract it. The point is to make slow stock cost something.
4. Rank by margin per foot, then act on the ends. The middle of the ranking rarely tells you anything. The top and the bottom tell you where the space should move.
5. Let it stay current on its own. Set the ranking to rebuild itself as sales and inventory move, so it is on the screen when the buying decision happens rather than after it.

The takeaway

A specialty retailer at this size does not have a sales problem, it has a ranking problem. Revenue by line is visible and margin percentage by line is visible, but the two costs that separate a good line from a great one, the floor it occupies and the months its cash sits still, are never brought anywhere near it. So the floor gets designed around the line that rings the most, which is not the same as the line that earns the most. Assign the space, price the time, and rank the lines by what they return for both. The first honest ranking is likely to change the floor plan, the open-to-buy, and how much cash the business has in February.