Gross margin analysis: finding the product that’s losing you money

Almost every business we look at has at least one line that is busy, respected internally, and quietly losing money once its costs are loaded properly. Nobody knows, because nobody has split the margin. The loss simply disappears into a company-wide average that looks perfectly fine.

Gross margin analysis is how you find it.

Why blended margin lies

Suppose your business runs at a 30% gross margin overall. That sounds healthy. But it might be three lines at 45%, 38% and minus 4% — with the negative line being the one your sales team is proudest of, because it is the one that grows.

A blended margin averages your best work with your worst. The number you most need is the one it hides.

Worse, blended margin moves when the mix changes, even if nothing about individual products has. Sell more of the weak line and margin falls; sell more of the strong one and it rises. Without the split you cannot tell a pricing problem from a mix shift — and they need opposite responses.

How to split margin properly

Split by the dimension that actually drives your decisions. Usually one, sometimes two:

Business	Split margin by
Manufacturing	Product or product family
Trading / distribution	SKU, brand or supplier
Professional services	Client and project
Multi-location retail	Branch
Omnichannel	Channel — direct, marketplace, distributor

The prerequisite is that your books can actually produce the split. That means tagging revenue and direct costs to the right segment as they are recorded, through cost centres or categories in Tally or Zoho Books. Trying to reconstruct it from a year of untagged entries is miserable and never quite accurate.

Getting direct costs right

This is where most margin analysis goes wrong, and it goes wrong in a flattering direction.

Direct costs move with the volume of a specific product or service: materials, direct labour, freight, packaging, commissions, payment gateway fees, subcontractors. Overheads do not: rent, admin salaries, software, marketing.

The common misclassifications, all of which inflate margin:

• Freight in overheads. Inbound freight is part of the cost of the goods.
• Production labour in “salaries”. People who make the product are a direct cost.
• Sales commission in overheads. It varies directly with each sale.
• Marketplace and gateway fees in overheads. They are a cost of that specific sale, and often vary by channel — which is exactly what you are trying to see.

Get this wrong and every product looks better than it is. You then price off those inflated margins, and the error compounds into every quote.

A worked example

A manufacturer with three product lines and ₹6 crore of annual revenue:

Line	Revenue	Direct cost	Gross margin
Line A	₹2.4 cr	₹1.32 cr	45%
Line B	₹2.1 cr	₹1.30 cr	38%
Line C	₹1.5 cr	₹1.56 cr	−4%
Total	₹6.0 cr	₹4.18 cr	30%

At the company level: a respectable 30%. At the line level: Line C loses ₹6 lakh a year before it carries a single rupee of overhead. Every unit sold makes the business slightly poorer.

And Line C is often the one growing fastest, because it is underpriced — which is precisely why customers like it.

When you find the loss-maker

Dropping it is the last option, not the first. Work through these in order:

1. Reprice. Often the whole problem. Price was set years ago and costs have moved. Our margin and markup calculator gives the price a target margin requires — and shows the common error of multiplying cost instead of dividing.
2. Re-cost. Cheaper inputs, a different supplier, less waste, better yield.
3. Restructure. Minimum order quantities, a surcharge for small orders, or bundling with higher-margin products.
4. Reconsider its role. Does it bring in customers who buy your profitable lines? Then it may be a legitimate loss-leader — but decide that deliberately, and cap it.
5. Exit. Only once the above have failed. And check first what fixed costs it currently absorbs, because they will not disappear with it.

That last point matters. A line with negative gross margin loses money on every unit and should be fixed urgently. A line with positive gross margin but a low one may still be covering overheads you would carry anyway — see our break-even calculator for how contribution covers fixed costs.

Making it a monthly habit

Margin analysis done once is interesting. Done monthly, it is a management system. Margin erosion is gradual — an input cost rises three percent, prices stay put, and nobody notices for three quarters.

The segment margin table belongs in your monthly MIS pack, with the trailing three-month trend beside each line. It is the most valuable page in the pack and the one most often missing.

Producing it every month is part of our MIS and performance reporting service, delivered within 24 working hours of complete data. Acting on what it shows is what the VCFO engagement is for.