Home › Solutions › Merchandising › Margin analysis
Merchandising · Margin analysis
How to find where category margin is leaking
Category margin usually leaks through small things like promotions that don’t pay back, mix shifting toward low-margin lines, markdowns, waste and stock imbalance. 11Ants finds the leak by comparing gross profit against last year and budget, then drilling down to the line and store. Ask Ant why margin fell and it names the drivers.
THE CHALLENGE
Why is margin leakage so hard to spot?
Margin rarely drops because of one big mistake, but because of hundreds of small ones spread across lines, stores and weeks. A category can hit its sales target while gross profit (GP) quietly falls.
Standard reports show the GP% total, not the reasons behind it. Finding the cause means pulling pricing, promotion and waste data together by hand, which takes days most category managers don’t have.
THE SOLUTION
How does 11Ants find margin leakage?
11Ants compares margin across every line and store, then explains what moved it.
Ant names the margin drivers when you ask in plain English. For deeper, repeatable analysis, the Key Measures, Performance, SKU KPIs, Pricing and Promotion Evaluation modules let you drill into margin by line, store and period.
Compare against last year and budget
Ant shows sales and gross margin against last year and against budget, down to department, category and SKU.
Identify the drivers
Ant separates the effect of price, promotions, mix and markdowns on GP%.
Rank the problem lines
Ant lists the SKUs, brands and stores dragging margin down, largest first.
Suggest the fix
Ant recommends actions to recover margin, such as pricing, promotion or range changes.
EXAMPLE QUESTION TO ASK ANT
QUESTION
Why does this department have negative margin?
WHAT ANT RETURNS
[Insert a real Ant answer from demo data: the GP% movement, the top drivers ranked by impact, the lines responsible and suggested actions.]
See Ant diagnose a margin problem
Demonstration data; brand names are illustrative and findings do not describe the real brands.
What results do retailers see?
CASE STUDY
IDEA, Serbia: promotion margin measured across the whole basket.
IDEA's category analytics team automated its reporting and now tracks the halo effect of promotions, seeing the final margin from customers who buy the whole basket, not just the promoted items.
11Ants allows us to get information from our data almost immediately.
Trisha Franklyn
Retail Analyst, Category Strategy, Farm Source
Jobs that took the whole day now only take a few minutes and a few clicks in 11Ants.
Luka Jalšovec
BI Project Manager, Mercator
Margin analysis FAQ
What causes margin leakage in retail?
The most common causes are promotions that don’t generate enough incremental profit, sales mix shifting toward lower-margin lines, markdowns, waste and shrink, and pricing that falls behind cost increases. Each is small on its own but adds up across a category.
How do you calculate category GP%?
Category gross profit percentage (GP%) is gross profit divided by net sales for the category, multiplied by 100. Gross profit is sales minus the cost of goods sold. 11Ants calculates it for any category, store or period on request.
Can 11Ants show margin by store and SKU?
Yes. 11Ants reports sales and gross margin at department, category, SKU and store level, compared with last year and budget, with drill-down from total to individual line.
