Syntha Lab RU

Pipeline inventory and tied-up cash

Counts how much money is tied up while the goods are on the way and in production: payments to the supplier go before the receipt, and the weighted time from payment to receipt is longer than the physical transit. Shows the annual cost of capital and the saving from cutting the term.

Stock and turnover For whom: Buyers and finance people of brands with imports and prepayment.

Calculate on your data →

At a glance

What question does it answer?
How much money is tied up in production and transit and how much the capital in this stock costs.
What data is needed?
The cost of purchases per year.
How to read the result?
Compare the weighted term with the physical one: the difference shows the price of prepayment. Compare the saving with the price of speeding up. Example on the default values: Weighted term from payment to receipt, days: 53.5; Money tied up in transit and production: RUB 17.6 million; Annual cost of capital in transit: RUB 3.87 million; Saving from the term reduction: RUB 723,288. The figures are illustrative: enter your own to see your result.

Why and how to reason

Money goes to the supplier before receipt, and the cost of capital in transit is counted from the weighted term of payments. In the example purchases are 120 m RUB a year, an advance of 30% 85 days and the balance of 70% 40 days before receipt, rate 22%: the term is 53.5 days, 17.59 m RUB is tied up, that is 3.87 m RUB a year; a term shorter by 10 days saves 0.72 m RUB.

When to use it

Apply when choosing payment terms and the delivery method. The cash cycle is counted by ccc and gapdays, here the explicit cost of stock in transit.

How to read the result

Compare the weighted term with the physical transit term: the difference is the price of prepayment.

Common mistakes

Only the transit days are counted without production, payments for samples and tests are not included.

What data is needed?

  • The cost of purchases per year.
  • The payment schedule: shares and days before receipt.
  • The cost of capital.

Inputs

FieldUnitValue in the exampleMeaning
Cost of purchases per year₽120,000,000The annual cost of goods through this supply channel at purchase prices excl. VAT. The example value is illustrative.
Cost of capital%22The annual rate (the key rate plus the spread), as in the carrying cost rate calculation (carrycost). The example value is illustrative.
Term reduction to estimate, daysdays10By how many days you want to shorten the term from payment to receipt: the saving is shown. The example value is illustrative.
Physical term of production and transit, days (optional)days—For comparison: how many days the goods are physically made and travel. Empty: no comparison. The example value is illustrative.
Payment 1: share, %%30For example an advance at the order. The shares of the three payments together must give 100%. The example value is illustrative.
Payment 1: days before receiptdays85How many days pass from the payment to the receipt of the goods at the warehouse. A negative number: payment after receipt (a deferral). The example value is illustrative.
Payment 2: share, %%70For example the balance before shipment. The example value is illustrative.
Payment 2: days before receiptdays40Days from the second payment to receipt. The example value is illustrative.
Payment 3: share, % (optional)%0The third payment, if any. Empty counts as zero. The example value is illustrative.
Payment 3: days before receipt (optional)days0Days from the third payment to receipt. The example value is illustrative. Optional. Empty: the field is ignored (counted as zero in sums).

How it is calculated

StepFormula
Weighted termsum(payment share × days before receipt) = 53.5 days
Purchases per day120 m ₽ ÷ 365 = 328,767 ₽
Tied-up moneypurchases per day × the weighted term
Cost of capital per yeartied-up money × 22%
Savingpurchases per day × 10 days × rate

Worked numbers

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

Weighted term from payment to receipt, days
53.5
Money tied up in transit and production
17.6 m ₽The cost of purchases per day × the weighted term.
Annual cost of capital in transit
3.87 m ₽
Saving from the term reduction
723,288 ₽
Cost of purchases per day
328,767 ₽
Physical stock in transit (by the transit term)
term not given
Money leaves earlier than the physical journey by, days
term not given
Contribution of payments to the weighted term, days
Bar chart: Payment 1 25.5, Payment 2 28, Payment 3 00102030Payment 1Payment 1Days: 25.525.5Payment 2Payment 2Days: 2828Payment 3Payment 3Days: 00
Data as a table
MeasureDays
Payment 125.5
Payment 228
Payment 30

The cost of capital comes from your calculation (carrycost); the term and the payment shares from the contract and the schedule. Include payments for samples and tests in the schedule as a separate line.

What to do with the result: compare the cost of capital in transit with the benefit of prepayment (a discount, a priority in the queue), with the price of faster delivery and with the terms from airsea; a shorter payment term is money, not only days.

A typical mistake: counting only the transit days, forgetting production, and not including the payment for samples and tests.

Nuances and limits

  • Counting only the transit days.
  • Forgetting payments for samples.
  • Taking a rate without a date.

Terms used

Calculate on your data →