A
| 📷 | Date | Style | Colour | Description | Supplier | Origin | Season | Dept. | Cat. | Units | RRP ₽ | FOB R1 | FOB R2 | FOB R3 | FOB Closed | FOB Target | Transport | Duty | LDP | IMU | MU% | Tgt% | Gap | FSD | HOD | Off% | Mkt% | Onl% | ST% | ST Units | Weeks | Units/wk | Cust.Profile | Collection | Fashion. | Cols | Status | Notes |
|---|
Double-click → edit in calculator • Click cell → inline edit
| 📷 | Date | Style | Colour | Description | Supplier | Origin | Dept. | Cat. | Season | Units | RRP ₽ | FOB Closed | Duty | Transport | LDP | IMU | MU% | Gap | FSD | HOD | ST% | ST Units | Weeks | Units/wk | Notes | Cust.Profile | Collection | Fashion. | Cols |
|---|
⚙ Control Panel — Settings
Parameters
| Parámetro | Valor |
|---|
Exchange Rates
| Par | Valor |
|---|
Air Freight $/kg · $/m3
| Country | $/kg | $/m3 |
|---|
Freight Routes
| Origin | Mode | Cost $ | Days |
|---|
Suppliers
| Nombre | Country | Tipo | Scheme |
|---|
🌎 Countries / Origins
Used in all origin dropdowns| Country name (uppercase) |
|---|
Seasons
| Code |
|---|
Departments & Categories
Departamentos
| Nombre |
|---|
Categories
| Name | kg |
|---|
🚢 Freight Routes & Simulator
| Origin | Mode | Cost $ | Days |
|---|
📋 Duties & Tariffs
| Country | Dept. | Cat. | Fixed $ | % | Load norm |
|---|
ðŸ›Âï¸Â
Buying List  User Guide
Everything you need to know to use the buying tool.
🎯
What does this tool do?
This tool helps you negotiate and close fashion purchases by automatically calculating whether the supplier's price meets your margin target. Instead of doing manual Excel calculations, you enter the article data and the tool instantly tells you whether the price works.
1. Enter the article
Fill in the product details: FOB, RRP, origin, weight, category...
2. The tool calculates
Automatically calculates the total landed cost (LDP) and margin (IMU) using real freight and customs rates.
3. Negotiate with confidence
See the maximum FOB you can pay and how much you need to negotiate down to hit your margin target.
📦
Landed Cost (LDP)  What does it cost to get the goods to Russia?
In plain terms: LDP is the total cost of one unit already in the warehouse. Not just what you pay the supplier (FOB), but also insurance, freight to Russia, and customs duties.
LDP = FOB × 1.003 + Freight/unit + MAX(Fixed duty, % of FOB)
â‘ FOB + Insurance
FOB × 1.003
The price you pay the supplier at the factory gate. The × 1.003 is cargo insurance: 0.3% of FOB covering damage in transit.
Example: FOB = $5.90 → Insured FOB = $5.92
Example: FOB = $5.90 → Insured FOB = $5.92
â‘¡ Freight / unit
Route cost ÷ Units per container
The freight cost split across all units that fit in a container. More units = cheaper per unit.
Transit days and route cost are configured in Settings → Freight. Load norms (units per container) are set in Settings → Duties.
Transit days and route cost are configured in Settings → Freight. Load norms (units per container) are set in Settings → Duties.
â‘¢ Russian Customs Duty
MAX(€ fixed × kg, % × FOB)
Russia applies whichever is higher: a fixed rate (€/kg of garment) or a percentage of FOB. This is exactly the formula from the Excel Control Panel GJ.
Jeans example: fixed=1.9€/kg, weight=0.71kg → €1.35/unit | 13%×$5.90 → $0.77 → fixed wins → duty=$1.57
Jeans example: fixed=1.9€/kg, weight=0.71kg → €1.35/unit | 13%×$5.90 → $0.77 → fixed wins → duty=$1.57
📊Real example: Bangladesh Jeans Commercial
| FOB | $5.90 | factory gate price |
| Insurance (×1.003) | +$0.018 | 0.3% of FOB |
| Freight SEA-TRUCK | +$0.557 | freight prorated per unit |
| Duty MAX(1.9€×0.71, 13%×5.90) | +$1.569 | fixed EUR rate wins |
| TOTAL LDP | = $8.04 | ✅ matches Excel GJ |
📈
IMU  What is your margin?
In plain terms: IMU (Initial Mark-Up) is the margin percentage on the retail selling price. An IMU of 72% means that for every ₽100 the customer pays, ₽72 is margin and ₽28 is cost. The target is 72%.
The formula, step by step:
Step 1  Tax-net RRP (in USD):
pU = RRP_rub ÷ (1 + Tax%) ÷ USD/RUB
The RRP in rubles is converted to USD after first stripping out VAT (default 20%). This puts cost and price on the same currency and tax basis.
Step 2  IMU:
IMU = (pU − LDP) ÷ pU
Margin is the gap between net price and cost, expressed as a % of price.
Example with real numbers:
FOB Target: if IMU is low, the tool calculates the maximum FOB you need to negotiate to hit 72% IMU.
IMU ≥ 72% → Green ✅ OK
IMU 65–71% → Amber ⚠︠Review
IMU < 65% → Red âÂÅ’ Negotiate
📋
Form fields  explained one by one
ðŸâ€â€ž
Step by step  How to use the tool
1
Select supplier and origin
In the left sidebar, choose the Supplier and Origin. The tool automatically filters the available transport modes for that route.
2
Enter RRP and FOB R1
As soon as you enter the RRP (retail price in rubles) and FOB R1 (supplier's opening offer), the preview box shows IMU, LDP and FOB Target calculated instantly.
3
Negotiate with the supplier
If IMU is red, the "FOB Target" tells you what price you need to reach. Save R2 and R3 as negotiation progresses to keep a history.
4
Close the article
When the price is acceptable, fill in FOB Closed with the agreed price and set the status to CLOSED. The article moves automatically to the Closed tab.
5
Generate PDF product sheets
In the Closed tab, select articles using the checkboxes and click Product Sheets PDF. A product sheet is generated per article with photo, prices and logistics data.
6
Export to Excel
The ↓ XLS button in Closed exports all closed articles to an Excel file with all fields and calculated metrics.
🗂ï¸Â
Tool tabs
NegotiationMain pricing table where you enter and negotiate articles. All cells are directly editable. Double-click a row to load it in the sidebar calculator.
ClosedConfirmed orders. Filter by department, supplier, origin or category. Export to XLS or generate PDF product sheets.
DashboardVisual summary grouped by origin, supplier, department and sales channel. Shows overall buying KPIs.
SettingsExchange rates, freight routes (cost + days), duties by country/category, suppliers and departments. All editable. Saved to the cloud (Supabase).
HelpThis page.
Buying List • v2.0