Syntha Lab RU

Supplier terms comparison

One row per supplier and SKU: price, rate, delivery, MOQ, lead time, prepayment, credit, defects and the cost of money. The output is the unit cost with financing and defects.

Layouts for documents 17 columns 3 example rows

Download CSV ↓

What the template is for

Choosing a supplier by total cost, not by list price.

What one row is
one row = supplier × SKU

Columns

ColumnCodeTypeRequiredValidation rule
Supplier codesupplierTextyesa value from the supplier reference
Style SKUarticleTextyesa value from the product reference
Delivery terms (Incoterms)incotermList valueyesEXW, FOB, CIF, DAP or DDP
Price per unit (in currency)priceNumberyesa number not below 0
CurrencycurList valueyesan ISO 4217 currency code
Rate to the roublefxNumberyesa number not below 0
Delivery to the warehouse per unit, RUBdeliverNumberyesa number not below 0
MOQ, unitsmoqIntegeryesan integer not below 1
Production and delivery lead time, daysleadIntegeryesan integer not below 0
Prepayment, %prepayNumberyesfrom 0 to 100
Credit days after deliverycreditIntegeryesan integer not below 0
Expected defects, %defectNumberyesfrom 0 to 100
Cost of money, % a yearrateNumberyesfrom 0 to 100
Price in roubles with deliveryrubNumberyescalculated: price × rate + delivery
Financing cost per unitfinNumberyescalculated: price in roubles × (prepayment × lead time − (100 − prepayment) × credit days) ÷ (100 × 365) × rate ÷ 100
Defect loss per unitlossNumberyescalculated: price in roubles × defects ÷ 100
Total unit costtotalNumberyescalculated: price in roubles + financing cost + defect loss

Example rows

Supplier codeStyle SKUDelivery terms (Incoterms)Price per unit (in currency)CurrencyRate to the roubleDelivery to the warehouse per unit, RUBMOQ, unitsProduction and delivery lead time, daysPrepayment, %Credit days after deliveryExpected defects, %Cost of money, % a yearPrice in roubles with deliveryFinancing cost per unitDefect loss per unitTotal unit cost
S01A100FOB28.5CNY12.636300753030220395.10.327.9403.33
S02A100EXW31CNY12.674150605001.220464.67.645.58477.81
S03A100DDP5.1USD91.501003510000.820466.658.953.73479.33

The example data is illustrative: an exercise, replace it with your own.

Note

Use your own cost of money (the loan rate or the return on idle cash); the example uses 20% a year for illustration. Delivery terms set who pays freight and insurance: compare suppliers on one base. The example data is illustrative: an exercise, not a norm or an industry benchmark.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →