Retail Margin Squeeze & Price Simulator
Explain profit pressure from vendor cost, freight, fees, discounts, markdowns, returns, and price mix, then test recovery scenarios.
Loading interactive exampleWhat you get
A useful first version with the main workflow already mapped out.
- Margin leakage bridge
- SKU and vendor squeeze ranking
- Target-margin price solver
- Base, best, and worst scenarios
Sample data
Eighteen synthetic months of SKU sales, vendor invoices, purchase costs, freight, duty, handling, prices, payment fees, markdowns, discounts, and returns.
Measures included
- Contribution margin
- Margin leakage
- Landed unit cost
- Markdown rate
- Return cost
Connect your data
Start with the sample rows, then replace them with the systems you already use.
CSV
File import
Vendor invoice, order-line, discount, markdown, fee, and refund exports
Google Sheets
Direct connector
SKU costs, freight allocation, target margin, and price scenarios
Stripe
Direct connector
Payment fees, transaction values, refunds, and channel receipts
Postgres
Direct connector
Normalized SKU, vendor, purchase, sale, fee, and return facts
Make it yours
Describe a change in plain English and keep adapting the tool as the work changes.
- 01Use category-specific price elasticity
- 02Add competitor reference-price guardrails
- 03Create a vendor renegotiation shortlist
Related templates
See all 65Boutique Open-to-Buy & Reorder Planner
Reorder winners without trapping cash in slow inventory.
Multi-Location Store Performance
Compare stores fairly and align labor, inventory, and goals to local demand.
Ecommerce Conversion & Merchandising
Find checkout and merchandising friction that costs orders and margin.