Which Product Lines Actually Earn? A Simple Per-Line Margin Check for Shops That Sell Many Things
A shop selling forty product lines can look busy while half of them quietly lose money. A product line profit margin check small business owners can run on one page separates the lines that earn from the lines that merely turn over — using each line’s sales, its direct costs, and the shelf or counter space it occupies.
You need no accounting software for this. One worksheet, one ordinary month of records, and an honest look at which lines deserve their space. Run it once and you will start seeing your shop the way your bank balance already does.
The Product Line Profit Margin Check Small Business Owners Run on One Page
Per-line margin is simple: for each product line, take its sales for the month, subtract the direct costs of selling it — what you paid for the goods, delivery in, packaging, and any commission — and divide what remains by the sales. Do this separately for every line on one page, and the shop stops looking like a single business and starts looking like the collection of small businesses it really is.
If margin terms are new to you, this plain-language guide to gross and net profit margin explains the building blocks first. Return to the worksheet once the terms feel familiar — the exercise is far more useful when you trust the numbers you are writing down.
Sales, Direct Costs and Space: The Three Columns
A product line profit margin check small business owners repeat each season starts with three columns. Column one: each line’s sales for a normal month, from till or sales records. Column two: direct costs — the goods themselves plus anything spent specifically to sell that line. Column three: the share of shelf, counter, or storage space the line occupies, roughly measured. Space matters because a thin-margin line on your best display costs you twice: once in profit, once in opportunity.
Worked Example: Three Lines Compared
The product line profit margin check small business example below uses a gift shop with three lines. Greeting cards sell well, cost little to buy in, and leave a strong margin from a small wall display. Candles sell moderately, cost more to stock, and sit on the prime counter — a middling margin on premium space. Gift wrapping sells poorly, consumes staff time with every order, and fills a drawer of supplies — a weak margin on real space and real labour.
None of these lines is bad; the worksheet simply shows which earn their keep and which borrow from the others. Your numbers will differ, but the classic find is the same everywhere: a high-sales line hiding behind a small high-margin one.
Why High-Sales Lines Can Hide Low Margins
Busy lines feel successful. The till rings often, stock turns over, staff stay occupied — and all that activity masks a margin of almost nothing. Meanwhile a quiet line with strong margins sits in the corner, funding the busy one’s shortfall. Total shop profit tells you nothing about which line to expand and which to fix; reading the lines together is the entire point.
When the worksheet exposes a line working hard for little return, you have three honest options: raise its price, cut its direct costs, or shrink the space and effort it receives. Doing nothing is also a choice — but now it would be an informed one.
Deciding What to Fix, Raise or Drop
When a product line profit margin check small business worksheet flags the weakest line on the most space, start there. Can the price rise without losing the customers who matter? Can a cheaper supplier or simpler packaging lift the margin? If neither works, shrink the line and hand the space to a stronger one. Retired lines need not become dead money: this guide to turning slow stock back into cash shows how to recover money from stock you no longer want.
One caution: never drop a line that pulls customers through the door for other purchases. If the worksheet flags your most famous product, treat it as marketing that happens to break even — and confirm it truly drives footfall before touching it. The IRS Tax Guide for Small Business covers how business income and expenses are recorded, worth a look before reorganising your lines.
Repeat the Check Once a Season
A quarterly product line profit margin check small business routine keeps margins honest as conditions change. Suppliers raise prices, trends fade, and a line that earned well in spring may sag by autumn. Re-run the one-page worksheet every three months on a normal month’s figures and keep the old sheets — the trend across seasons beats any single snapshot. A line sliding two seasons running is telling you something; listen before it becomes a loss.
Frequently Asked Questions
What counts as a direct cost?
Costs that exist because that line sold: the goods, inbound delivery, packaging, and any sales commission. Leave out shared costs like rent and utilities at this stage — the worksheet compares lines on direct margin first, and shared costs are handled separately.
How do I split shared costs like rent between lines?
You don’t, not in this exercise. Allocating rent across lines adds guesswork that hides the signal. Compare direct margins first; once the weak lines are fixed or gone, the remaining shared costs sit across a healthier business.
How many product lines is too many?
There is no fixed number. A practical test: if you cannot cost a line in under an hour, group the smallest ones into an “other” row. The worksheet serves decisions — lines too small to decide about can share a row.
Should I drop a line my customers love?
Not automatically. Beloved lines can drive footfall that feeds every other line, which the worksheet does not measure. Check whether the line truly pulls visitors — ask new customers what brought them in — before deciding its fate.
Know Each Line, Then Back the Winners
A product line profit margin check small business owners can run in an afternoon turns a busy shop into a readable one. Fix the weak lines, feed the strong ones, and let the shelf space follow the money. For more practical ways to make every part of the business earn, explore BCC Financial’s financial planning guides.
This article is general information for education only and is not financial, tax, or legal advice. Margins and tax treatment vary by business — consider speaking with a qualified professional about your own situation.
