Why is "Treating retailer pass-through as automatic at 100%" a common mistake when using the Retailer P&L Simulator?

Symptom: The annual plan promised a 5% list price increase and assumed the retailer would pass it through 1:1 to shelf. The buyer instead held their cash margin per pack: the shelf moved 3%, and the other two points came out of their front margin for two quarters. The next category review opened with the compression and a demand for 2pp of trade terms to close the gap. Fix: **Model the pass-through you actually negotiated**, and work it out from the buyer's own rule rather than from a borrowed rate. A buyer holding cash margin per pack passes through one minus their margin share, so 70% on a 30% margin share and 60% on a 40% one; a buyer holding their margin percentage passes through 100%. Set the Shelf Pass-Through field in the Retailer Economics panel to that number, then drag List Price Change: at 60% a 5% list move puts the ticket up 3% and takes front margin from 27.6% to 26.2%, and at 100% it leaves the ratio at 27.6%. The **/concepts/price-pass-through-rate** page covers the mechanics. Bring the modeled pass-through to the JBP as part of the recommendation. Walk in with: 'We are taking 5% list, we are recommending you pass it through in full, and we are moving two points of your rebate onto the invoice so your front margin goes up rather than down.'

Why is "Funding a buyer ask with trade terms without checking front/back balance" a common mistake when using the Retailer P&L Simulator?

Symptom: The retailer asked for 3pp more trade terms to keep the brand on shelf for another year. The plan agreed, the buyer signed, and Total Margin Quality lifted. Two years later the company restructured trade terms across all customers (a -2pp move). On this customer the retailer's Net Margin Resilience collapsed from HEALTHY to TIGHT in one quarter, and the category-review meeting opened with a delist threat. Fix: **Read Front/Back Balance every time you fund a buyer ask with back-margin uplift.** The simulator's Front/Back Balance tile is the fragility marker. 75% front share and above is SHELF-LED; 55 to 75% is BALANCED; below 55% is BACK-LEANING and exposed; below 40% is BACK-DEPENDENT and one renegotiation away from collapse. If a buyer ask pushes the balance below 55%, either restructure the ask (move some to on-invoice, which goes through front margin) or lock the trade terms in a multi-year agreement that the next CFO cannot easily unwind.

Why is "Reading Total Gross Margin without reading Front Margin separately" a common mistake when using the Retailer P&L Simulator?

Symptom: The plan landed Total Margin Quality in the ATTRACTIVE band and the team called it a successful JBP. Three months later the buyer flagged Front Margin Health was in the COMPRESSED band on three of the top SKUs because the trade-term funding flowed entirely to back margin while shelf price was held flat. The buyer's bonus was paid on front margin %; the Total Gross Margin lift was invisible to the person sitting across the table. Fix: **Front margin is the buyer's headline. Total margin is the retailer's accounting truth. Both matter, but the buyer reacts to front margin first.** Always read Front Margin Health and Total Margin Quality together. A scenario that lifts Total Margin Quality while compressing Front Margin Health will get pushed back at the buyer level even when corporate would approve it. When front margin compression is the binding constraint, structure the trade-term funding through on-invoice (which flows to front margin) rather than off-invoice or promotional investment (which flow to back margin).

Why is "Modeling promo depth and frequency separately when they compound" a common mistake when using the Retailer P&L Simulator?

Symptom: The promo plan deepened a key TPR by 5pp (from 20% to 25% off) and increased frequency by 10pp (from 30% to 40% of volume). Each move was modeled on its own and looked manageable: front margin 26.4% on the depth alone, 26.0% on the frequency alone, both still ADEQUATE. Nobody ran them together, and the combined plan took front margin to 24.4% and the split from 75.1 to 65.7, one more deal-funding cycle from BACK-LEANING. Fix: **Always model promo depth and frequency together as a single combined scenario.** The simulator handles this if you drag both sliders. +5pp depth alone takes front margin from 27.6% to 26.4%, and +10pp frequency alone takes it to 26.0%. Together they take it to 24.4% and the split to 65.7, because deeper deals on more units both lower what the retailer realizes per unit AND push your promo funding into their back margin. That funding is volume x frequency x depth x list price. Their net margin percentage barely moves through all of that (24.8% to 25.1%), which is why the split is the tile to watch rather than the bottom line. Reference-price erosion is the longer-run risk the simulator does not model at all, and one more reason to model the two sliders jointly before the JBP rather than each in isolation.

Why is "Forgetting that operating costs scale with Consumer Sales, not with the store" a common mistake when using the Retailer P&L Simulator?

Symptom: The simulator showed a -10% Volume Adjustment scenario with consumer sales down 10%, to $10.14M, and operating costs down 10% in step, to $1.22M, so the net margin percentage did not move from 24.8%. The team read that as the retailer being indifferent to the volume loss. In reality the retailer's store costs are largely fixed in the medium term, and the buyer's category P&L showed net margin compression that the simulator's percentage-of-sales cost line had hidden. Fix: **The operating cost field is a percentage of Consumer Sales, not an absolute cost per unit.** A 12% operating cost on $11.26M of consumer sales is $1.35M; on $9.5M it is $1.14M. But the retailer's actual operating cost is largely fixed in the medium term (rent, labor, shrinkage, energy), so a Consumer Sales drop without a proportional Operating Cost % adjustment understates the real Net Margin compression. When modeling sharp volume scenarios, manually raise the Operating Cost % field in the Retailer Economics panel to reflect the temporary deleverage. A 10% Consumer Sales drop usually translates to a 1 to 2pp temporary lift in Operating Cost %.

Free tool · no login required

Retailer P&L Simulator

Model 7 RGM levers against a single FMCG SKU's retailer P&L, watch the 4 retailer health bands (Front Margin Health, Front/Back Balance, Total Margin Quality, Net Margin Resilience), and find the configurations where both the manufacturer's contribution and the retailer's headline KPIs hold up. The same interactive model the full RGM Academy course uses for Integrated RGM Lesson 2, no auth, no paywall.

Updated 5 September 2026Extracted from the Integrated RGM module, lesson 2: Retailer P&L Mirror

Loading calculator...

Guided walkthrough

Explore the tool, from setup to common mistakes

Five short sections explain the scenario, what each control does, how to read the output, and the mistakes to avoid. Open whichever helps. The tool above works without them.

5.1Scenario setup

The starting SKU, market, and assumptions the model makes.

You are the Key Account Manager at a mainstream FMCG biscuit manufacturer, preparing for the spring joint business plan review with a top‑10 retailer. The product is CrunchField Original 300g. Shelf ticket $5.99, your list price $4.29, 2 million units a year. Trade terms total 17% of gross sales: three structural lines you negotiate once a year, 5 points on‑invoice, 3.5 off‑invoice rebate and 2.5 other terms, plus the 6 points the promotional plan itself costs. Thirty percent of units sell on deal at 20% off, so the retailer does not collect the ticket price on every one. Their direct store cost runs 12% of consumer sales, and the elasticity is -1.8.

This is the retailer's board today. $3.11M front margin (27.6%), which is what they earn by selling your product. $1.03M back margin (9.1%), which is money you pay them. $4.14M total gross margin (36.8%) and $2.79M net margin (24.8%), on a 75.1 / 24.9 split. So 24.9% of the margin they make on your brand is your money, and their buyer is graded on the other 75.1%.

Now procurement is warning of 5% cost inflation, your commercial director wants a 5% price rise, and the buyer is asking for 3 more points of trade terms in exchange. Before you walk into that room you need to know which of those moves the retailer can actually absorb, and which of them creates value rather than just moving it from one side of the table to the other.

Your objective

Use the simulator to model the retailer P&L outcome of each pricing, trade, and promotional move you are likely to propose, then identify the configuration where both the retailer's headline (front margin) and the retailer's underlying health (front/back balance, net margin) stay defensible. The Margin Mirror Principle is the underlying lesson: every manufacturer move has a retailer reflection, but the reflection is asymmetric, and a move that helps the manufacturer's contribution can compress the retailer's most visible KPI.

Key assumptions

The simulator models a single SKU at a single retailer in isolation. No portfolio cannibalization across pack sizes, no competitor pricing response, no halo across the rest of the manufacturer's range. Cross‑SKU effects sit in PPA Lesson 2 Pack Roles and TPO Lesson 2 Source‑of‑Volume.
Price elasticity is fixed at -1.8 for the default scenario. That is a planning placeholder rather than a finding about any brand. Elasticity differs hugely by market, category, shopper, product and occasion, so adjust the field in the Retailer Economics panel to whatever your own brand measured. Demand answers to the shelf price the shopper actually sees: your list move as far as the retailer passes it through, plus any extra move on the Retailer Shelf Price slider. So a 5% list rise at full pass‑through costs 9% of units, and a 3% extra shelf move on its own costs 5.4%, whichever side of the table caused it.
Pass‑through is set in the base case, and the shelf slider sits on top of it. The Shelf Pass‑Through field in the Retailer Economics panel decides how much of a list move reaches the ticket. At the default of 100% the shelf follows your list one for one, so a +5% list move is a +5% ticket before you touch anything else. The Retailer Shelf Price slider is then an EXTRA move by the retailer on top of that, which is how you model a buyer who adds their own increase to yours, or who cuts the shelf and asks you to fund it. Do not borrow a pass‑through number, because there is no market rate: pass‑through is decided by which margin the buyer is guarding. A buyer holding cash margin per pack adds your cents to the shelf and stops, so they pass through one minus their margin share (70% on a 30% margin share, 60% on a 40% one). A buyer holding their margin percentage re‑marks the item on its new cost and passes through 100%. The solid published evidence is about funded DISCOUNTS, where more than 60 cents of a dollar reached the shopper in nine categories out of eleven, more than manufacturers generally assume, and about one measured rate in seven exceeded 100% [Besanko and Dube]. A price rise does not behave like a discount running backwards. Ask which rule this buyer works to, set the field to it, and model the scenario you actually negotiated.
The four retailer diagnostics use fixed bands: Front Margin Health at 12, 20 and 30 percent of consumer sales; Front/Back Balance at 40, 55 and 75 percent front share; Total Margin Quality at 15, 25 and 35 percent; Net Margin Resilience at 0, 8 and 25 percent. They are the bands the lesson teaches, a shared vocabulary for the four questions under Reading the output, and they are not a measurement of any market. A buyer works to a target they were given in January, so a number can lose ground inside a band without any band changing.
Future levers are deltas from the base case, not absolute values. A +5% List Price Change means the new list is 5% above the editable base, not 5% in absolute terms. Trade Terms changes apply proportionally across the three structural lines (on‑invoice, off‑invoice, other) preserving their relative shape. Promotional money is not a rate you set: it is whatever the deal plan costs, so it answers to the depth and frequency controls instead. The base case itself is editable in the three collapsible panels above the lever sliders.

5.2Controls & toggles

Every input the calculator exposes, its range, and what it changes.

Control	Range	Default	What it changes
List Price Change	-20% to +20% in 0.5% steps	0% (base $4.29)	Your list price. It sets the invoice the retailer pays (list less only the on-invoice discount). At the base case's 100% pass-through it reaches the ticket in full, so front margin per unit rises while front margin percentage does not move, and the elasticity takes its volume off both P&Ls. Drop the Shelf Pass-Through field below 100 and the retailer holds part of your move out of their own front margin, which is the version of a price rise the buyer fights.
COGS Change	-10% to +15% in 0.5% steps	0% (base $1.72)	Manufacturer input-cost change (cocoa, packaging, energy). It never reaches the retailer's board; it drives the manufacturer's willingness to hold price or seek pass-through. Useful when modeling the retailer's exposure to a manufacturer cost shock that may or may not get passed through to list.
Retailer Shelf Price	-15% to +15% in 0.5% steps	0% (base ticket $5.99)	An EXTRA shelf move by the retailer, on top of the pass-through the base case already applies. With the field at 100%, a +5% list move has already lifted the ticket 5% before you touch this, so +3% here leaves the ticket 8.15% up and +5% leaves it 10.25% up. Use it for a retailer who adds their own increase to yours, or who cuts the shelf and asks you to pay for it. It moves demand exactly as a shelf price should, at the elasticity in the base case.
Trade Terms Change	-5pp to +5pp in 0.5pp steps	0pp (base 17.0%)	Change in the structural trade rate. Applied proportionally across the three structural lines (on-invoice, off-invoice rebate, other), so part of every point lowers the invoice and lands in FRONT margin while the rest lands in back margin. Promotional money answers to the deal-plan controls, never to this slider. More terms tilt Front/Back Balance from SHELF-LED toward BALANCED and, because the money holds distribution and support up in this model, buy volume; fewer terms take it away.
Promo Depth Change	-15pp to +15pp in 1pp steps	0pp (base 20%)	Discount on promoted volume. Deeper deals hand shoppers more of each ticket, so the retailer realizes less per unit and front margin falls, while your promo funding rises on its own and lands in their back margin. Reference-price erosion, shoppers anchoring on the deal price as the regular one, is the longer-run risk the simulator does not model, so treat a depth that runs consistently above 25 to 30% as a judgment the numbers cannot make for you.
Promo Frequency Change	-20pp to +20pp in 1pp steps	0pp (base 30%)	Share of volume sold on deal. Above 50% (a +20pp shift from base), promo becomes the new baseline price and both sides' economics reset to the promoted state. Combined with depth, it drives the promo funding on the retailer's back margin line, with no rate having changed.
Volume Adjustment	-20% to +20% in 1% steps	0%	Non-price volume effects: distribution gains, range expansion, competitive entry or exit, category growth or decline. Captures everything elasticity does not. Multiplies on top of the post-elasticity volume on both sides of the P&L proportionally, so every margin percentage stays where it was and every dollar line scales with it.

5.3Step-by-step exploration

7-step guided exploration of the scenario.

Read the default state, and notice who earned it
All seven levers start at zero. Read the retailer's board: the seven tiles, and the comparison table under them. Consumer Sales $11.26M, which is the $5.99 ticket on 2M units less the $0.72M shoppers keep on the 30% of units that sell on deal. Cost of Goods $8.15M at the invoice price of $4.0755 per unit, which is your list price less only the 5‑point on‑invoice discount. That leaves Front Margin $3.11M (27.6%). Then add every dollar you pay off the invoice, the rebate, the other terms and the promotional funding, each landing once, for Back Margin $1.03M (9.1%). Total Gross Margin $4.14M (36.8%), less 12% of consumer sales in direct store cost, gives Net Margin $2.79M (24.8%). The four diagnostics read ADEQUATE / SHELF‑LED / PROFIT‑GENERATOR / HEALTHY.
Now look at the split: 75.1 / 24.9. Of everything this retailer makes on your brand, 24.9% is your money, and 75.1 is the bottom edge of SHELF‑LED. That is the number the rest of this walkthrough is really about.
Expected outcome: Consumer Sales **$11.26M**, Front Margin **27.6% (ADEQUATE)**, Back Margin **9.1%**, Total Gross Margin **36.8% (PROFIT-GENERATOR)**, Net Margin **24.8% (HEALTHY)**, split **75.1 / 24.9 (SHELF-LED)**. The per-unit card reads Shelf Price **$5.99**, Invoice Price **$4.0755**, Front Margin **$1.5551** a unit. The waterfall steps down from Consumer Sales through Cost of Goods, up through Back Margin, then down through Store Operating Costs. This is your reference state. In the full lesson a Joint Pool tile sits beside this board and reads **$7,821,200**, your gross profit added to their front plus back margin, of which you keep **47.1%**.
Watch a trade term move the money, and watch where it lands
Reset. Drag Trade Terms Change from -5pp to +5pp, slowly, and watch the Front Margin % and Back Margin tiles together.
Both of them move. The slider scales the on‑invoice line with the other two, so as you give, the invoice price on the per‑unit card falls (from $4.0755 to $3.978 at +5pp) and part of every point arrives in their front margin, the number the buyer is graded on. The rest arrives as back margin. With volume held where it is, the model's manufacturer side gives up exactly what their total gross margin gains, to the cent: a trade term is a transfer.
The volume does not hold still, though, and that is what makes the pool the two of you share move. In this model the structural money holds distribution and support up, so taking it away takes units with it. At -5pp, 195,000 units stop selling, Consumer Sales fall to $10.16M, and the pool the full lesson shows falls $762,567 to $7,058,633, while the manufacturer's own gross profit rises only about $28,000. At +5pp the pool grows just $227,304, to $8,048,504, and the manufacturer's share of it swings from about 53% down to about 42% across the slider. The share moves a lot. The total moves too, by less than the money you handed over when you give and by more than it when you take back, and it does not always move the way you would like.
So when a buyer asks for another point, two questions decide whether it was worth giving: which line of their P&L it lands on, and what volume it is holding up.
Expected outcome: At **-5pp** the invoice rises to **$4.173**, Front Margin Health reads **25.9%**, Back Margin drops to **$0.72M**, and Total Margin Quality slips out of PROFIT-GENERATOR into **ATTRACTIVE (33.0%)**. At **+5pp** Front Margin Health reads **29.4%**, Back Margin is **$1.30M**, Total Margin Quality is **40.6%**, Net Margin Resilience climbs to **EXCEPTIONAL (28.6%)**, and Front/Back Balance slides from SHELF-LED into **BALANCED (72.3%)**. That last move is the real cost of a giveaway: the dependency, which the diagnostics show before the money does.
The fold: buy 1.5 points of the buyer's headline number for nothing
Reset. Open the Trade Terms (GTN Breakdown) panel in the base case and make two changes. Set On‑Invoice to 7.0 and Off‑Invoice to 1.5. You have moved 2 points from a term settled after the invoice to a term that comes off the invoice itself. Your total trade rate is still 17%.
Read what happened. The invoice price drops from $4.0755 to $3.9897, so Front Margin climbs from 27.6% to 29.1%. Back margin falls by exactly the same $171,600, which is two points of your $8,580,000 of gross sales. Total Gross Margin does not change by a dollar. Neither does the manufacturer's gross profit, or the pool.
You have given up nothing at all, and the number the buyer is graded on just went up 1.5 points. Fold all 3.5 points of the off‑invoice rebate and it reaches 30.3%, which clears a buyer asking for 30. This is the first thing to reach for when a buyer demands front margin and you have no budget, and it is almost always the last thing anyone actually reaches for.
Expected outcome: Front Margin Health support number moves **27.6% to 29.1%**, still ADEQUATE but visibly stronger. Total Margin Quality does not move from **36.8%**. Back Margin falls to **$0.86M**, and the F/B Split tile climbs from 75.1 to **79.3**. The Front-vs-Back Composition chart shows the front bar growing and the back bar shrinking by the same amount, which is exactly what a fold looks like.
The price rise the buyer absorbs: +5% list at 60% pass-through
Reset. In the Retailer Economics panel, set Shelf Pass‑Through to 60. Sixty is the figure the lesson's own worked example uses: it is what a buyer holding cash margin per pack produces on a line where they take about 40% of the shelf price. (On this pack they take 32% of the ticket, so the same rule would give 68; set the field to whatever this buyer's rule gives.) Now drag List Price Change to +5% and leave the Retailer Shelf Price slider at zero.
Their invoice cost went from $4.0755 to $4.2793, up 5%. The ticket went up only 3%, to $6.17, and they still realize 94% of it after the deal plan, $5.7995 a unit. They ate the other two points, and it came out of front margin: 27.6% down to 26.2%, which is 1.4 points off the one number the person across the table is measured on.
The band did not change, and do not wait for one that does. 26.2% is still ADEQUATE, because ADEQUATE runs all the way from 20 to 30. The buyer is not managing a band. They are managing a number against a target they were given in January, and they will defend it long before anything turns a different color. This is the anatomy of a rejected price increase: your case was sound, your costs were real, and you still lost, and the reason they give you will be about category competitiveness rather than the number that actually moved.
Expected outcome: Shelf Price **$6.17**, Invoice Price **$4.2793**, Front Margin **$1.5202** a unit on the per-unit card. Front Margin Health support number **27.6% to 26.2%**, band unchanged at ADEQUATE. Front/Back Balance slips from SHELF-LED to **BALANCED (73.8%)** because the front margin they earn shrank while your funding did not. Consumer Sales **$10.97M**: the shopper saw a 3% rise, so 5.4% of units went, and that is the volume line of the buyer's objection as well as yours.
The same price rise, accepted: +5% list at full pass-through
Reset, which puts Shelf Pass‑Through back to 100. Now List Price Change +5%, with the shelf slider still at zero. This retailer passes your move straight through, agreed before the letter went out.
Front margin percentage does not move at all. It sits at 27.6%, exactly where it started. Their cost went up 5%, to $4.2793, and the ticket went up 5%, to $6.29, so both sides of the ratio scaled together and the ratio is untouched. Front margin per unit actually rises, from $1.5551 to $1.6328.
The increase was the same 5% both times, and so was the cost inflation behind it. Yet one version takes 1.4 points off the buyer's headline number and the other leaves it perfectly alone. What decided that was the pass‑through, which is something you negotiate rather than something you forecast. Sequence it that way: agree the shelf price first, send the price letter second.
One more thing to try before you reset. Push the Retailer Shelf Price slider to +5% as well. The two stack rather than cancel: the ticket ends 10.25% up at $6.60 and front margin climbs to 31.1%, out of ADEQUATE and into ROBUST. That is a buyer using your increase as cover for one of their own, and you only spot it by watching the shelf price rather than your own.
Expected outcome: Front Margin Health stays **ADEQUATE** with the support number **unchanged at 27.6%**. Shelf Price **$6.29**, Front Margin **$1.6328** a unit. Consumer Sales fall to **$10.76M** on the elasticity response, so both P&Ls are smaller, but nothing on the buyer's scorecard has deteriorated and there is nothing for them to push back on. With the shelf slider at +5% too: Shelf Price **$6.60**, Front Margin Health **ROBUST (31.1%)**, and 369,000 fewer units sell, which is the shopper paying for the buyer's extra margin.
The generosity that is really a dependency: +15pp promo frequency
Reset. Drag Promo Frequency Change to +15pp, so 45% of your volume now sells on deal. Change nothing else. In particular, change no trade‑term rate at all.
Back margin rises anyway, from $1.03M to $1.31M. Nobody negotiated that. Your promo funding is computed from how much you promote, volume x frequency x depth x list price, so pushing frequency pushed your own money out of the door on its own: $514,800 became $783,872. And because more units sell at a discount, the retailer collects less per unit, so their front margin falls at the same time, from $3.11M to $2.79M.
Both effects push the same way. The split slides from 75.1 to 68.1, out of SHELF‑LED and into BALANCED.
So you are paying more, they are earning less of their own margin, and the share of their profit that depends on your checks has grown. Your buyer will thank you for the support. That is the part that should worry you.
Expected outcome: Back Margin rises to **$1.31M (11.8%)** with no rate change. Front Margin falls to **$2.79M (25.2%)**, still ADEQUATE. Front/Back Balance slides **SHELF-LED to BALANCED (75.1 to 68.1)**. Net Margin Resilience even ticks up, to **EXCEPTIONAL (25.0%)**, because more units sell and your funding arrives with them, and that is precisely the trap: nothing on the retailer's headline tiles says anything went wrong. The split is the only tile that does. Whenever back margin grows and you cannot name the rate that changed, a volume changed instead.
Build the package that actually survives the room
Reset, and put it together. List Price +3% with Shelf Pass‑Through at its default 100 and the shelf slider at zero (full pass‑through, agreed in advance), and then fold 2 points from off‑invoice into on‑invoice: On‑Invoice 7.0, Off‑Invoice 1.5.
The price rise costs the buyer nothing, because full pass‑through leaves their front margin percentage where it was. The fold then gives them 1.5 points more of it, for free: Front Margin Health reads 29.1%, up from 27.6, on an invoice of $4.1094 against a ticket of $6.17. Total Margin Quality holds at 36.8%, Net Margin Resilience at 24.8%, and Front/Back Balance stays SHELF‑LED at 79.3. You recovered your cost inflation and the buyer's headline number went UP.
The volume the shopper takes is the only thing the package costs. 108,000 fewer units sell at the higher ticket, so their total gross margin is $4,033,738 against $4,139,800 at the start, and on the manufacturer's side the model shows gross profit holding at $3,684,710 and contribution up $40,030, because each of the units that still sells carries more.
Compare that with step 4: the same commercial ambition, executed without negotiating the shelf and without moving a dollar you were already spending, and the buyer's number went down 1.4 points and the proposal died. It is the same money and the same intent. The only thing that changed is where you let it land.
Expected outcome: Front Margin Health **ADEQUATE at 29.1%, up 1.5 points**. Front/Back Balance **SHELF-LED (79.3)**. Total Margin Quality **PROFIT-GENERATOR (36.8%)**. Net Margin Resilience **HEALTHY (24.8%)**. Consumer Sales **$10.97M**. The sentence to walk in with: 'We are taking 3% to cover input costs, we are recommending you pass it through in full, and we are moving two points of your rebate onto the invoice so your front margin goes up rather than down.'

5.4Reading the output

Every KPI, the formula behind it, and how to interpret a positive or negative value.

KPI	Formula	How to read it
Front Margin %	(Consumer Sales minus Cost of Goods) / Consumer Sales x 100	The number the buyer is graded on. Most retail buying teams are measured on front margin, not on total margin, which is why this is the first number to watch on any move you make. At default it reads 27.6%, in the ADEQUATE band. Below 12% is UNVIABLE and the delist conversation starts; 12 to 20% is COMPRESSED and you will meet resistance; 20 to 30% is ADEQUATE; 30% and above is ROBUST. Front-margin compression is the single biggest cause of a well-argued proposal dying in a category review, and it happens inside a band far more often than across one.
Front/Back Balance	Front Margin / (Front Margin + Back Margin) x 100	How much of their margin you are paying for. At default the split reads 75.1 / 24.9, so the retailer earns 75.1% of their margin on your brand and you fund the other 24.9%. That is SHELF-LED, the healthy end, and 75.1 is its bottom edge: one more deal-funding cycle and it is BALANCED. Between 55 and 75% front they are BALANCED. Below 55% they are BACK-LEANING and your money has become their buffer. Below 40% they are BACK-DEPENDENT, and restructuring your terms would take a real bite out of their category profit, which means they will fight it, which means the money has bought you less freedom rather than more. If the shelf price ever falls below the invoice price this reads n/a, because a share computed against a negative front margin is noise.
Total Gross Margin %	(Front Margin + Back Margin) / Consumer Sales x 100	What your SKU is really worth to them. At default 36.8%, it reads PROFIT-GENERATOR (35% and above), which is preferred-supplier territory. ATTRACTIVE is 25 to 35%. BORDERLINE (15 to 25%) starts a renegotiation. DILUTIVE (below 15%) means you are dragging the category average down and they are already planning your exit. Worth holding next to Front Margin Health: a SKU can be a profit generator for the retailer and a disappointment to the buyer at the same time, and that is where your trade money is going to waste.
Net Margin %	(Total Gross Margin minus Operating Costs) / Consumer Sales x 100	What is left after the shelf pays for itself. At default 24.8%, which is HEALTHY (8 to 25%). Be precise about what this is: a four-wall, SKU-level figure, total gross margin less the DIRECT cost of shelving the product, before the retailer's central logistics and head office. It is not comparable to the net margin a grocer publishes for its whole business, which is far smaller. Claim it as one in a buyer meeting and you will be corrected in front of the room. TIGHT (0 to 8%) means the shelf is barely paying for itself. LOSS-MAKING (below 0%) means the next range review, the meeting where the buyer decides which products keep their shelf space, ends the listing.
Banded Diagnostics	4 string-banded composites: Front Margin Health (front margin %), Front/Back Balance (front share), Total Margin Quality (total gross margin %), Net Margin Resilience (net margin %)	Read all four together. The buyer-bonus test: would you accept this scenario if your bonus was paid only on Front Margin Health? If no, the buyer will not accept it either. The fragility test: would you accept this scenario if the manufacturer renegotiated trade terms back down next year? If no, the Front/Back Balance is too back-leaning. The total-economics test: does Total Margin Quality justify the shelf space? If marginal, the SKU is at risk on the next assortment review. The bottom-line test: does Net Margin Resilience stay HEALTHY after operating costs? If TIGHT, the SKU is one promo escalation away from LOSS-MAKING.

Read the right side of the simulator as a stack of four layers. Headline KPIs at the top tell you whether the scenario lifted or compressed each margin line, in dollars and in percentage points against the base case. Banded Diagnostics tell you whether the move passes the four underlying tests (buyer bonus, fragility, total economics, bottom line). Retailer P&L Comparison Table lets you walk every line of the cascade from Consumer Sales to Net Margin, base versus future. Retailer Per‑Unit Economics at the bottom strips away the volume effect and shows the unit‑level math the buyer reads on their daily dashboard: the shelf price, the invoice price they pay, and the front and total margin on one unit.

The four charts each surface a different angle. Retailer P&L Waterfall shows the cascade from Consumer Sales through cost of goods, front margin, back margin and operating costs to net margin: the same shape the retailer's category P&L report uses. Front vs Back Margin Composition stacks base and future side by side so you can see whether the move shifted the front/back balance. Front/Back Margin Split shows the same split as a single‑scenario ratio. Retailer Margin Sensitivity to Shelf Price sweeps the shelf‑price slider from -10% to +10% holding every other lever at your current settings, so you can read how much total gross margin and net margin a shelf move buys or costs in dollars.

Use the simulator before you walk into a JBP, an annual joint‑business plan review, or a category‑review escalation. Anchor every move proposed to a diagnostic reading and an absolute‑dollar margin delta. The buyer will challenge the assumption (your pass‑through intent, your promo support, the operating cost share) far more than the math, which is what the editable base case is for.

5.55 common mistakes to avoid

Diagnostic patterns that catch the most common misuse of this calculator.

Mistake 1Treating retailer pass-through as automatic at 100%
Symptom: The annual plan promised a 5% list price increase and assumed the retailer would pass it through 1:1 to shelf. The buyer instead held their cash margin per pack: the shelf moved 3%, and the other two points came out of their front margin for two quarters. The next category review opened with the compression and a demand for 2pp of trade terms to close the gap.
Fix: **Model the pass-through you actually negotiated**, and work it out from the buyer's own rule rather than from a borrowed rate. A buyer holding cash margin per pack passes through one minus their margin share, so 70% on a 30% margin share and 60% on a 40% one; a buyer holding their margin percentage passes through 100%. Set the Shelf Pass-Through field in the Retailer Economics panel to that number, then drag List Price Change: at 60% a 5% list move puts the ticket up 3% and takes front margin from 27.6% to 26.2%, and at 100% it leaves the ratio at 27.6%. The **/concepts/price-pass-through-rate** page covers the mechanics. Bring the modeled pass-through to the JBP as part of the recommendation. Walk in with: 'We are taking 5% list, we are recommending you pass it through in full, and we are moving two points of your rebate onto the invoice so your front margin goes up rather than down.'
Mistake 2Funding a buyer ask with trade terms without checking front/back balance
Symptom: The retailer asked for 3pp more trade terms to keep the brand on shelf for another year. The plan agreed, the buyer signed, and Total Margin Quality lifted. Two years later the company restructured trade terms across all customers (a -2pp move). On this customer the retailer's Net Margin Resilience collapsed from HEALTHY to TIGHT in one quarter, and the category-review meeting opened with a delist threat.
Fix: **Read Front/Back Balance every time you fund a buyer ask with back-margin uplift.** The simulator's Front/Back Balance tile is the fragility marker. 75% front share and above is SHELF-LED; 55 to 75% is BALANCED; below 55% is BACK-LEANING and exposed; below 40% is BACK-DEPENDENT and one renegotiation away from collapse. If a buyer ask pushes the balance below 55%, either restructure the ask (move some to on-invoice, which goes through front margin) or lock the trade terms in a multi-year agreement that the next CFO cannot easily unwind.
Mistake 3Reading Total Gross Margin without reading Front Margin separately
Symptom: The plan landed Total Margin Quality in the ATTRACTIVE band and the team called it a successful JBP. Three months later the buyer flagged Front Margin Health was in the COMPRESSED band on three of the top SKUs because the trade-term funding flowed entirely to back margin while shelf price was held flat. The buyer's bonus was paid on front margin %; the Total Gross Margin lift was invisible to the person sitting across the table.
Fix: **Front margin is the buyer's headline. Total margin is the retailer's accounting truth. Both matter, but the buyer reacts to front margin first.** Always read Front Margin Health and Total Margin Quality together. A scenario that lifts Total Margin Quality while compressing Front Margin Health will get pushed back at the buyer level even when corporate would approve it. When front margin compression is the binding constraint, structure the trade-term funding through on-invoice (which flows to front margin) rather than off-invoice or promotional investment (which flow to back margin).
Mistake 4Modeling promo depth and frequency separately when they compound
Symptom: The promo plan deepened a key TPR by 5pp (from 20% to 25% off) and increased frequency by 10pp (from 30% to 40% of volume). Each move was modeled on its own and looked manageable: front margin 26.4% on the depth alone, 26.0% on the frequency alone, both still ADEQUATE. Nobody ran them together, and the combined plan took front margin to 24.4% and the split from 75.1 to 65.7, one more deal-funding cycle from BACK-LEANING.
Fix: **Always model promo depth and frequency together as a single combined scenario.** The simulator handles this if you drag both sliders. +5pp depth alone takes front margin from 27.6% to 26.4%, and +10pp frequency alone takes it to 26.0%. Together they take it to 24.4% and the split to 65.7, because deeper deals on more units both lower what the retailer realizes per unit AND push your promo funding into their back margin. That funding is volume x frequency x depth x list price. Their net margin percentage barely moves through all of that (24.8% to 25.1%), which is why the split is the tile to watch rather than the bottom line. Reference-price erosion is the longer-run risk the simulator does not model at all, and one more reason to model the two sliders jointly before the JBP rather than each in isolation.
Mistake 5Forgetting that operating costs scale with Consumer Sales, not with the store
Symptom: The simulator showed a -10% Volume Adjustment scenario with consumer sales down 10%, to $10.14M, and operating costs down 10% in step, to $1.22M, so the net margin percentage did not move from 24.8%. The team read that as the retailer being indifferent to the volume loss. In reality the retailer's store costs are largely fixed in the medium term, and the buyer's category P&L showed net margin compression that the simulator's percentage-of-sales cost line had hidden.
Fix: **The operating cost field is a percentage of Consumer Sales, not an absolute cost per unit.** A 12% operating cost on $11.26M of consumer sales is $1.35M; on $9.5M it is $1.14M. But the retailer's actual operating cost is largely fixed in the medium term (rent, labor, shrinkage, energy), so a Consumer Sales drop without a proportional Operating Cost % adjustment understates the real Net Margin compression. When modeling sharp volume scenarios, manually raise the Operating Cost % field in the Retailer Economics panel to reflect the temporary deleverage. A 10% Consumer Sales drop usually translates to a 1 to 2pp temporary lift in Operating Cost %.

Related concepts

Go deeper on the theory

Continue with the lessons

Go further inside Integrated RGM

This calculator is the sandbox slice of Lesson 2: Retailer P&L Mirror. Each of the other 5 Integrated RGM lessons teaches a complementary concept that sharpens how you read the output above.

See Retailer P&L Simulator inside the full lesson

RGM Academy lets you pull every commercial lever yourself inside a senior-practitioner simulator, with the AI RGM Strategist coaching every decision you make.

Unlock the full Retailer P&L Mirror lesson

Or see what a team rollout includes