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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Demand for the season | pcs | 5,000 | How many good units you need to sell in the season. The example value is illustrative. |
| Cost of money | % | 17 | Annual 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,200 | What you lose when a unit is missing: margin excl. VAT. The example value is illustrative. |
| Share of the price recovered on excess | % | 35 | Excess 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 shortfall | Yes: 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 | ₽ | 150 | Sorting, recount, return shipping, excl. VAT. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Order and delivery | order = max(demand ÷ (fill × (1 − defects)), rounded up; MOQ); delivered = order × fill |
| Money | purchase × rate ÷ 365 × (prepayment × lead time − (1 − prepayment) × credit days) |
| Defects and excess | good = delivered − defects; excess beyond demand sells at a share of the price, the returnable consignment part is not paid |
| Total | purchase + money − defect refund + handling − excess credit + lost margin on shortfall |
| Rank | total × (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
| Supplier | Order, pcs | Purchase | Money | Defect handling minus refund | Shortfall minus excess credit | Per unit of demand | With risk | Rank |
|---|---|---|---|---|---|---|---|---|
| Supplier A | 5,180 | 5.08 m ₽ | −7,093 ₽ | −64,724 ₽ | −89 ₽ | 1,000.9 ₽ | 1,000.9 ₽ | 2 |
| Supplier B | 6,000 | 4.82 m ₽ | 84,167 ₽ | −63,259 ₽ | −91,421 ₽ | 949.69 ₽ | 1,044.66 ₽ | 3 |
| Supplier C | 5,342 | 4.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.