RGMAcademy
Talk to us
Free tool · no login required

Retailer P&L Simulator

See how 8 levers change the retailer's P&L on a single consumer goods product. Watch what each move does to the four numbers a buyer is judged on: the margin they make selling your product, how much of their margin you pay for, their total margin, and what is left after their own costs. Then find the plans where your contribution and their targets both hold up. It is the same interactive model the full RGM Academy course uses in Integrated RGM Lesson 2, with no sign-in and 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 meeting you need to know which of those moves the retailer can actually absorb, and which of them creates value rather than just moving it between you and the retailer.

Your objective

Use the simulator to see what each pricing, trade and promotion move you are likely to propose does to the retailer's P&L. Then find the plan where both the retailer's headline number (front margin) and their underlying health (Front/Back Balance and net margin) stay at levels you can defend. Each of those moves shows up in the retailer's P&L, but not by the same amount it shows up in yours, and a move that raises your contribution can lower their front margin, the number the buyer is graded on.

Key assumptions

  • The simulator models one SKU at one retailer, on its own. It leaves out three things: sales that one pack size takes from another, any price response from competitors, and any lift this product gives the rest of the manufacturer's range. Effects between products are covered 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 change the Price Elasticity field in the Retailer Economics panel to whatever your own brand has 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 price rise at full pass‑through costs 9% of units, and an extra 3% on the shelf price on its own costs 5.4%, whether you or the retailer 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 sets how much of a list price change reaches the shelf price. At the default of 100% the shelf follows your list one for one, so a +5% list price change is a +5% shelf price change 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 who protects the cash they make on each pack adds your extra cents to the shelf price and stops there. They pass through one minus their share of the shelf price: 70% if that share is 30%, 60% if it is 40%. A buyer who protects their margin percentage reprices the item on its new cost and passes through 100%. The solid published evidence is about DISCOUNTS a manufacturer pays for. In nine categories out of eleven, more than 60 cents of each dollar reached the shopper, which is more than manufacturers generally assume, and about one measured pass‑through rate in seven was above 100% [Besanko and Dube]. A price rise does not behave like a discount running backwards. Ask which rule this buyer works to, set the Shelf Pass‑Through field to match it, and run 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.

  • Each Future State Lever is a change from the base case, not a new absolute value. A +5% List Price Change means the new list is 5% above the editable base, not 5% in absolute terms. A Trade Terms Change is spread across the three structural lines (on‑invoice, off‑invoice and other) in proportion, so their sizes relative to each other stay the same. Promotional money is not a rate you set: it is whatever the promotion plan costs, so it moves with the Promo Depth Change and Promo Frequency Change sliders 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.

ControlRangeDefaultWhat it changes
List Price Change-20% to +20% in 0.5% steps0% (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 shelf price 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 pays for part of your increase out of their own front margin, which is the kind of price rise the buyer fights.
COGS Change-10% to +15% in 0.5% steps0% (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. Use it to test how exposed the retailer is to a sudden rise in the manufacturer's costs that may or may not be passed through to the list price.
Retailer Shelf Price-15% to +15% in 0.5% steps0% (base shelf price $5.99)An EXTRA shelf move by the retailer, on top of the pass-through the base case already applies. With the Shelf Pass-Through field at 100%, a +5% list price increase has already lifted the shelf price 5% before you touch this, so +3% here leaves the shelf price 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 steps0pp (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 steps0pp (base 20%)Discount on promoted volume. Deeper discounts give shoppers more off every promoted unit, so the retailer collects less per unit and front margin falls, while your promotional funding rises on its own and lands in their back margin. The longer-run risk the simulator does not model is reference-price erosion, where shoppers start to treat the promotional price as the regular one. So when the discount runs consistently above 25 to 30%, treat it as a judgment the numbers cannot make for you.
Promo Frequency Change-20pp to +20pp in 1pp steps0pp (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% steps0%Non-price volume effects: distribution gains, range expansion, competitive entry or exit, category growth or decline. Captures everything elasticity does not. It is applied on top of the volume after the price effect, in proportion on both P&Ls, so every margin percentage stays where it was and every dollar figure grows or shrinks with it.
Your Brand Investment$0 to $500,000 in $10,000 steps$0The one control here that is not a discount. Advertising, display and in-store activation the manufacturer funds itself, so no part of it lands on either of their margin lines and no rate of theirs changes. What it does is sell more units, on which the retailer earns their normal front margin rate having negotiated nothing, which is why a buyer asking for points will often take this instead. The cost is charged to the manufacturer's brand contribution, which sits below gross profit. So as you drag it, the joint pool (what the manufacturer and the retailer make between them) and the manufacturer's gross profit both RISE, while its brand contribution can fall. The first $100,000 earns $5,049 more than it costs, $200,000 ends $42,426 behind, and $500,000 ends $296,468 behind.
5.3Step-by-step exploration

7-step guided exploration of the scenario.

  1. Read the default state, and notice who earned it

    All eight 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 shelf price on 2M units, less the $0.72M shoppers save on the 30% of units that sell on promotion. 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 them outside the invoice, which is the rebate, the other terms and the promotional funding, each counted 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%**.
  2. 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.

    One of them moves and one of them does not, and the one that sits still is the more useful lesson. The slider scales the on‑invoice line, so as you give, the invoice price on the per‑unit card falls (from $4.0755 to $3.978 at +5pp). This base case passes any change in the retailer's invoice price through to the shelf in full, so the shelf price falls in step, and the buyer's front margin percentage stays at 27.6% the whole way across the slider. The money that does arrive in their front margin arrives in dollars rather than in rate, because there is more volume at a lower price: front margin goes from $2,750,342 at -5pp to $3,258,548 at +5pp without the percentage twitching. Back margin moves the way you would expect, $0.69M to $1.36M.

    Hold the volume still AND hold the shelf price still and the transfer is exact: the manufacturer gives up $429,000 and the buyer's total gross margin gains $429,000, to the cent, with the pool unmoved. That is the clean mental model, and the sandbox will not let you keep it, because neither of those two things holds in the real account.

    At -5pp both of them move against you at once. The structural trade money was paying for distribution and support, so taking it away costs units. Part of it was also on the invoice, keeping the shelf price lower, so the shelf price goes up to $6.13 and costs more units. 272,727 units stop selling, Consumer Sales fall to $9.96M, the pool falls $833,858 to $6,987,342, and your own gross profit falls $131,509. Nobody collects the money. At +5pp the pool grows $284,715 to $8,105,915 while you give up $190,351, so the pool grows by more than you handed over. Your share of the pool runs from 50.8% when you take five points back down to 43.1% when you give five points.

    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**, the shelf price follows it up to **$6.13**, Front Margin Health holds at **ADEQUATE (27.6%)**, Back Margin drops to **$0.69M**, and Total Margin Quality slips out of PROFIT-GENERATOR into **ATTRACTIVE (34.5%)**. At **+5pp** Front Margin Health still reads **27.6%**, Back Margin is **$1.36M**, Total Margin Quality is **39.1%**, Net Margin Resilience climbs to **EXCEPTIONAL (27.1%)**, and Front/Back Balance slides from SHELF-LED into **BALANCED (70.6%)**. Two things to take away. The Trade Terms Change slider is the wrong tool for raising the buyer's front margin percentage, because the shelf price moves with the invoice price and the percentage stays the same. The next step moves part of your off-invoice money onto the invoice, and that adds 1.5 points to the same percentage for nothing. That is the move to bring into the meeting. And the slide in Front/Back Balance is the real cost of giving terms away: the retailer comes to depend on your money, and the diagnostics show that before the dollars do.
  3. Move off-invoice money onto the invoice: 1.5 points of front margin 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 rebate paid after the invoice to a discount taken 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.
  4. 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 shelf price, 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 shelf price went up only 3%, to $6.17, and after the promotion plan they still collect 94% of it, $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 how a price increase gets rejected: your case was sound, your costs were real, and you still lost, and the reason the buyer gives will be about keeping the category competitive 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.
  5. 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 increase 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 shelf price 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 shelf price 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.
  6. 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.
  7. Build the package the buyer can actually accept

    Reset, and put it together. Set List Price +3% and leave Shelf Pass‑Through at its default 100 and the Retailer Shelf Price slider at zero, so the whole increase reaches the shelf, as agreed in advance. Then move 2 points from off‑invoice onto the 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. Moving that money onto the invoice 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 shelf price 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 took a price rise and the buyer's headline number went UP, which is the part they will remember.

    The volume the shopper takes is the only thing the package costs. 108,000 fewer units sell at the higher shelf price, 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.

    What the package does not do is cover the sudden rise in your costs, and that is the part to be clear about in the meeting. Procurement warned of 5%. Put that into COGS Change and the same package lands at contribution down $122,682: the 3% claws back about $49,000 of the $172,000 the shock takes off you, under a third of it. A bigger number does not rescue it either. Run the same cost rise against every list rise the slider allows and the best available is +8%, still $91,760 short, because past that point the volume leaves faster than the price arrives. At an elasticity of -1.8, recovering higher input costs through the list price alone does not work, and any plan that promises otherwise will be proven wrong by the second quarter.

    Compare that with step 4: the same goal, carried out without agreeing the shelf price and without moving a dollar you were already spending, and the buyer's front margin 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% toward 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.' Note the word toward. It covers under a third of a 5% rise in costs, and if you claim it covers more, the second quarter's numbers will test that claim.
5.4Reading the output

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

KPIFormulaHow 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 BalanceFront 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: cutting back your terms would badly hurt their category profit, so they will fight it, and 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 **store-level figure for this one product**, total gross margin less the DIRECT cost of putting it on the shelf, 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 Diagnostics4 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. The Retailer KPIs tiles at the top tell you whether the scenario raised or lowered each margin, in dollars and in percentage points against the base case. The Retailer diagnostics panel tells you whether the move passes the four tests explained under Banded Diagnostics: the buyer‑bonus, fragility, total‑economics and bottom‑line tests. The Retailer P&L Comparison table lets you check every line from Consumer Sales down to Net Margin, in Base and Future columns side by side. The Retailer Per‑Unit Economics card at the bottom leaves volume out and shows what 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 that same split for the future scenario on its own. Retailer Margin Sensitivity to Shelf Price runs the shelf price from -10% to +10% with every other lever at your current settings. It shows, in dollars, how much total gross margin and net margin each shelf price change gains or costs.

Use the simulator before you walk into a JBP, an annual joint‑business plan review, or a category‑review escalation. Back every move you propose with a band reading from the diagnostics and the change in margin in dollars. The buyer will challenge your assumptions (how much of the increase you expect them to pass through, your promotional support, the operating cost share) far more than the math, which is why the base case is editable.

5.55 common mistakes to avoid

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

  1. 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 guarding the cents they keep on each pack passes on one minus their share of the shelf price, so 70% if they keep 30% and 60% if they keep 40%. A buyer guarding their margin percentage passes on 100% of the increase, because keeping the same percentage means the shelf price has to move in step with the invoice price. Set the Shelf Pass-Through field in the Retailer Economics panel to that number, then drag List Price Change: at 60% a 5% list price change puts the shelf price 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.'
  2. 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 what was left after the retailer's own costs to stock and sell the brand fell from HEALTHY to TIGHT in one quarter, and the category-review meeting opened with a delist threat.
    Fix: **Check Front/Back Balance whenever you meet a buyer's request by adding to their back margin.** The simulator's Front/Back Balance tile shows how fragile the retailer's position is. 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's request would push the balance below 55%, either reshape the request (move some of it on-invoice, where it lands in front margin) or lock the trade terms into a multi-year agreement that the next CFO cannot easily undo.
  3. 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 plan that lifts Total Margin Quality while squeezing Front Margin Health will get pushed back by the buyer, even when the retailer's head office would approve it. When the squeeze on front margin is what blocks the deal, put the trade-term money on the invoice, where it lands in front margin, rather than off the invoice or into promotions, where it lands in back margin.
  4. Mistake 4Testing promo depth and frequency one at a time when their effects combine
    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. The combined plan took front margin to 24.4% and dropped the share of margin the retailer earns at the shelf from 75.1 to 65.7. That leaves them one more round of deal funding away from BACK-LEANING, the band where most of what they make on your brand comes from you rather than from selling it.
    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 Front/Back Balance tile is the one to watch, rather than net margin. Reference-price erosion, where shoppers come to see the promotional price as the normal one, is the longer-run risk the simulator does not model at all. That is one more reason to test the two sliders together before the JBP rather than one at a time.
  5. 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 a fall in net margin that the simulator had hidden, because it counts store cost as a percentage of sales.
    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 you model a sharp fall in volume, raise the Retailer Operating Cost field in the Retailer Economics panel by hand, because for a while store costs do not fall as fast as sales. 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