Retailer Margin Calculator

P23-EDUby TWENTY3 Intelligence Retailer Margin Calculator
Library
v1.0
Channel Tool 14
Retailer
Margin
Calculator
See the math from your retail buyer's side: gross margin, GMROI, and planned vs realized margin after markdowns and shrink. Helps you understand how your WS pricing affects their business case.
1Pricing Setup
-
Standard gift/home: 50–65%
2Sales & Markdown
% sold at $MSRP
Avg markdown taken
% of remaining that sell
Theft, damage, admin
3Inventory & Turns
-
Target: ≥ 2.0 for specialty retail
-
-
-
Retailer Realized Gross Margin - after markdowns and shrink
Retailer Margin Waterfall
Units purchased -
WS cost total -
Units sold @ full price -
Revenue @ full price -
Units sold @ markdown -
Revenue @ markdown -
Units unsold / returned -
Total revenue -
Gross margin $ -
Realized margin % -
GMROI -
Margin at Different WS Prices
WS PriceIMURealized GMGMROI
P23-EDU · TWENTY3 IntelligenceChannel Tool 14· Retailer Margin Calculator· GMROI · Markdown Recovery · Realized Margin· Build a Better Buyer Business Case· P23-EDU · TWENTY3 IntelligenceChannel Tool 14· Retailer Margin Calculator·