Retailer P&L Mirror
See your pricing decisions through the retailer's eyes, and discover why what's good for your P&L might destroy theirs.
In heavily promoted FMCG categories, the retailer's back margin, the trade income you fund, can run 60 to 65% of their total margin on your brand. Change your trade terms, and you don't just affect your P&L. You reshape theirs.
Most manufacturers think about their own gross-to-net waterfall. The best ones model the retailer's P&L in parallel, because every trade term you negotiate, every promo you fund, and every price you set has a mirror image on the other side of the table. Understanding that mirror image is the difference between a negotiation and a partnership.
The Margin Mirror Principle
Every manufacturer pricing decision has a mirror image in the retailer's P&L, but the reflection is not symmetrical. It is distorted by the front/back margin structure. A manufacturer price increase can improve the retailer's total gross margin in absolute terms while compressing their front margin percentage. The retailer's buyer sees front margin erosion and pushes back, even though total economics have improved.
The most sophisticated joint business planning starts with both P&Ls side by side. The question is never 'does this help my P&L?' but 'does this create a configuration where both P&Ls can work?' When only one side wins, the 'win' is temporary.
Master these concepts before diving into the simulator
5 concepts- Purpose
- See the same scenario through the retailer's eyes: their front margin, back margin, and net profit, so you can negotiate with their economics in mind.
- How to use
- Set the same 8 levers as the manufacturer view. The retailer P&L renders below with 4 retailer-specific sentinels and 7 KPI tiles spanning consumer sales to net margin.
- What to watch
- Front Margin Health (the buyer's headline KPI), Front/Back Balance for resilience, and Net Margin Resilience for P&L viability. Hover any sentinel for thresholds.
Retailer P&L Mirror
Adjust manufacturer pricing, trade terms, and retailer shelf price to see how each decision flows through the retailer's P&L. Watch the front/back margin split. It reveals who really controls the economics.
Base Case (Editable)
Units/year
% of consumer sales (store costs, shrinkage)
Manufacturer's cost (affects net price)
Future State Levers
Manufacturer Pricing
Manufacturer list price adjustment. Raises the retailer's cost of goods, compressing front margin unless they pass through.
Raw material and input cost change. Affects the manufacturer's cost base, not directly the retailer's margin.
Trade & Shelf Price
Change in total GTN rate. Increasing terms boosts the retailer's back margin but erodes manufacturer net revenue.
Consumer-facing price change. Directly drives front margin, the retailer's most visible profitability metric.
Promo & Volume
Discount depth on promoted volume. Deeper promos erode reference prices and train shoppers to wait for deals.
% of volume sold on deal. Higher frequency lifts volume modestly but increases total promotional cost for both parties.
Non-price volume effects: distribution gains, competitive entry/exit, category growth. Affects both P&Ls proportionally.
Retailer diagnostics
Four banded health checks on the retailer's view of this scenario
Retailer KPIs
Retailer P&L Comparison
| Line Item | Base | Future | Δ $ | Δ % |
|---|---|---|---|---|
| Consumer Sales | $9,980,000 | $9,980,000 | $0 | 0.0% |
| Cost of Goods | -$7,833,540 | -$7,833,540 | $0 | 0.0% |
| Front Margin | $2,146,460 | $2,146,460 | $0 | 0.0% |
| Back Margin (Trade Income) | $896,610 | $896,610 | $0 | 0.0% |
| Total Gross Margin | $3,043,070 | $3,043,070 | $0 | 0.0% |
| Operating Costs | -$1,197,600 | -$1,197,600 | $0 | 0.0% |
| Net Margin | $1,845,470 | $1,845,470 | $0 | 0.0% |
Retailer P&L Waterfall ($K): Consumer Sales to Net Margin
Front vs Back Margin Composition: Base vs Future
Front/Back Margin Split: Future Scenario
Retailer Margin Sensitivity to Shelf Price
Retailer Per-Unit Economics
A senior RGM director's read on every move you make. Toggle off any time.
AI RGM Strategist
Senior-RGM-director coaching on your simulator moves
The AI Strategist reads your simulator state and replies in four parts: interpretation, commercial implications, cross-lever effects, and one specific recommendation. Free signup unlocks 20 lifetime insights.
Sign up free to unlockAlready a member? Sign in
The Retailer's Ultimatum
You are the Key Account Manager for CrunchField at a major grocery retailer. The retailer's buyer has told you that CrunchField's front margin of 21.5% is 'below category average' for branded biscuits, and they need it above 25% within the next negotiation cycle. Your current list price is $4.29, weighted price (with premium mix) is $4.72, the retailer's landed net cost is $3.92 per unit, shelf price is $4.99, and total GTN is 17%. You need to find a solution that improves the retailer's front margin without destroying your own P&L. Every numeric answer in this Challenge reconciles with what the Sandbox computes at default settings. Check the diagnostics panel before answering.
What is the retailer's current front margin per unit, given a shelf price of $4.99 and a manufacturer net price of $3.92 per unit?
What happens when you put both P&Ls side by side?
You now have the retailer's view of the same scenario P&L Impact Lab Lesson 1 modelled from the manufacturer side. The four retailer sentinels (Front Margin Health, Front/Back Balance, Total Margin Quality, Net Margin Resilience) read the same lever changes through the buyer's eyes. The question the next lesson answers is the one every commercial leader eventually faces: which configurations work for both sides simultaneously?The Strategic Pricing Lesson 2 +8.7%-per-1%-price hurdle still applies on the manufacturer side, but it must clear without forcing the retailer's Front Margin Health below ADEQUATE or Net Margin Resilience below HEALTHY. The Trade Terms Lesson 6 customer-profit-pool view comes online in P&L Impact Lab Lesson 3, where both sets of eight sentinel bands sit on a single canvas.
Continue to Dual P&L ViewEvery preview is free and crawlable. Interactive simulators and challenges unlock with a free signup.