Syntha Lab RU

Supplier terms: total cost of buying per unit of demand

Compares 2-4 suppliers not by list price but by total cost: minimum order and excess, a discount or retro bonus, prepayment and credit (cost of money), defects and returns, shortfall, consignment. Ranks with a risk premium.

Cost and price For whom: Buyers, purchasing managers and heads of production when choosing a supplier and revising terms.

Calculate on your data →

At a glance

What question does it answer?
Which supplier is cheaper by total cost rather than list price and what its terms cost.
What data is needed?
Demand for the season, the cost of money, lost margin per unit not delivered.
How to read the result?
On the default data (demand 5,000 pcs, rate 17%, an order with a margin for defects and shortfall) the best with risk is Supplier C: 965.59 per unit of demand against 1,000.90 for Supplier A and 1,044.66 for Supplier B. B is lowest on list price (900), but the minimum order of 6,000 pcs, 4% defects and 50% prepayment with a 75-day lead time give 949.69 before risk. The best by total cost without the risk premium is also C: 919.61, which is 96.8% of its list price (950). The cost of money for C is minus 100,068: a 45-day credit pays better than prepayment. The gap between best and worst for the season is 395,354. Example on the default values: Best with risk: cost per unit of demand: RUB 965.59 · Supplier C; Best by list price: RUB 900 · Supplier B; Without the risk premium: best by total cost: RUB 919.61 · Supplier C; Total cost to the list price for the best: 96.8%. The figures are illustrative: enter your own to see your result.

Why and how to reason

The price in the list is not the buying price: the total is affected by minimum order, discounts, payment terms, defects and short delivery. So suppliers are compared on full cost per unit of demand. The calculation models each order: how much must be ordered so that after short delivery and defects you receive the need (and at least the minimum lot), how much really arrives, how much surplus and shortfall there will be. It then adds money: a prepayment freezes cash, a credit period releases it. A minus subtracts the refund for defects, a plus adds defect handling, a minus takes the revenue from surplus and a plus adds the lost margin on the shortfall. The result at the defaults: supplier B is cheapest in the list (900), but the best by full cost is supplier C: 919.6 per unit of demand, and 965.6 with a 5% risk premium.

When to use it

It comes in handy when choosing a supplier for the season, reviewing contract terms and preparing negotiations: the calculation shows which parameter really moves the cost (discount, credit, consignment, lead time). Do not use it for a one-off purchase of a small amount. Assumptions: two to four suppliers are compared, the need is the same, the price of surplus is set as a share of price, defects are refunded within the given share.

How to read the result

Compare two columns: by list and by full cost with risk. The gap between the best and worst over the season (395 thousand) is money that can be lost by choosing on the list. “Cost of money at the best” is negative (minus 100 thousand): credit and consignment bring a gain, not a cost. The risk premium sets your distrust of the supplier: if without it another wins, discuss the risk terms, not only the price. It is worth keeping the calculation for negotiations and change one parameter at a time to see what to ask for.

Common mistakes

Entering a discount as a price, not entering the minimum lot and short delivery, treating consignment as free (there is return risk), taking the defect share from the supplier’s list rather than from your own receiving. A 100% defect rate makes the order undefined: enter the real share. Check that prices and terms are comparable by basis: a price at the supplier warehouse and a price delivered to you are not comparable.

What data is needed?

  • Demand for the season, the cost of money, lost margin per unit not delivered.
  • For each supplier: price, MOQ, discount, prepayment, credit days, lead time.
  • Defects, defect refund, order fill, consignment, risk premium.

Inputs

FieldUnitValue in the exampleMeaning
Demand for the seasonpcs5,000How many good units you need to sell in the season. The example value is illustrative.
Cost of money%17Annual rate: your loan or required return. Take the Bank of Russia key rate on the calculation date; your own spread is yours. The example value is illustrative.
Lost margin per unit not delivered₽1,200What you lose when a unit is missing: margin excl. VAT. The example value is illustrative.
Share of the price recovered on excess%35Excess good units beyond demand are sold at a discount or carried to the next season: what share of the price you recover. The example value is illustrative.
Order with a margin for defects and shortfallYes: order = demand ÷ (fill × (1 − defects))Yes: you raise the order in advance so that after defects and shortfall you get the demand; the minimum order stays the lower bound. No: the order equals demand.
Handling of one defective unit₽150Sorting, recount, return shipping, excl. VAT. The example value is illustrative.

How it is calculated

StepFormula
Order and deliveryorder = max(demand ÷ (fill × (1 − defects)), rounded up; MOQ); delivered = order × fill
Moneypurchase × rate ÷ 365 × (prepayment × lead time − (1 − prepayment) × credit days)
Defects and excessgood = delivered − defects; excess beyond demand sells at a share of the price, the returnable consignment part is not paid
Totalpurchase + money − defect refund + handling − excess credit + lost margin on shortfall
Ranktotal × (1 + risk premium) ÷ demand, ascending

Worked numbers

Default values from the app; in the interactive version you enter your own.

Best with risk: cost per unit of demand
965.59 ₽ · Supplier CTotal cost with the risk premium ÷ demand.
Best by list price
900 ₽ · Supplier B
Without the risk premium: best by total cost
919.61 ₽ · Supplier C
Total cost to the list price for the best
96.8 %Below 100% means credit, defect refunds and consignment outweigh the losses; above 100% means the terms cost more than the list price.
Gap between best and worst, whole season
395,354 ₽ · Supplier B
Cost of money for the best
−100,068 ₽Plus means prepayment costs more than credit; minus means credit gives a gain.

Suppliers by total cost

SupplierOrder, pcsPurchaseMoneyDefect handling minus refundShortfall minus excess creditPer unit of demandWith riskRank
Supplier A5,1805.08 m ₽−7,093 ₽−64,724 ₽−89 ₽1,000.9 ₽1,000.9 ₽2
Supplier B6,0004.82 m ₽84,167 ₽−63,259 ₽−91,421 ₽949.69 ₽1,044.66 ₽3
Supplier C5,3424.77 m ₽−100,068 ₽−76,258 ₽−104 ₽919.61 ₽965.59 ₽1

The supplier with the lowest list price (“Supplier B”) is not the best by total cost: “Supplier C” wins. The difference comes from the minimum order and excess, defects, shortfall and the cost of money.

Fix the terms in the contract: price, bonus threshold, returns, lead time, quality tolerance. The cost of money and the risk premium are yours; there are no single Russian standards. Take the Bank of Russia key rate on the calculation date. Amounts excl. VAT.

Nuances and limits

  • Enter a discount or retro bonus only if the threshold is reached at your volume.
  • Take defects and fill from the delivery history: the supplier’s promises give an optimistic picture.
  • The risk premium is your estimate: write down what it consists of.
  • Use your own cost of money; take the Bank of Russia key rate on the calculation date.

Terms used

Calculate on your data →