Back to Templates
ACCOUNTING
Margin & Markup Master Sheet
The ultimate calculator for Landed Cost, Wholesale Price, and Retail Margin calculations.
LIVE PREVIEW
| SKU | FOB Cost | Duty % | Freight | Landed Cost | Wholesale Price | Retail Price | Wholesale Margin | Retail Margin |
|---|---|---|---|---|---|---|---|---|
| TSHIRT-001 | $5.00 | 10% | $0.50 | $6.00 | $12.00 | $24.00 | 50% | 75% |
| JEAN-002 | $15.00 | 15% | $1.00 | $18.25 | $40.00 | $90.00 | 54% | 80% |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Landed Cost: The true floor.
- 2Formulas: Preset margin calcs.
- 3Updates: Review quarterly.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Stop confusing markup and margin. Calculate your true profitability per SKU.
Key Features
Landed Cost Build-up: Duty/Freight.
Dual Channel: Wholesale & Retail.
Common Use Cases
Inventory Planning: Budgeting.
Catalog Review: Kill unprofitable SKUs.
Frequently Asked Questions
What about packaging?
Include it in FOB Cost.