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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Cost of purchases per year | ₽ | 120,000,000 | The annual cost of goods through this supply channel at purchase prices excl. VAT. The example value is illustrative. |
| Cost of capital | % | 22 | The 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, days | days | 10 | By 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, % | % | 30 | For 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 receipt | days | 85 | How 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, % | % | 70 | For example the balance before shipment. The example value is illustrative. |
| Payment 2: days before receipt | days | 40 | Days from the second payment to receipt. The example value is illustrative. |
| Payment 3: share, % (optional) | % | 0 | The third payment, if any. Empty counts as zero. The example value is illustrative. |
| Payment 3: days before receipt (optional) | days | 0 | Days 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
| Step | Formula |
|---|---|
| Weighted term | sum(payment share × days before receipt) = 53.5 days |
| Purchases per day | 120 m ₽ ÷ 365 = 328,767 ₽ |
| Tied-up money | purchases per day × the weighted term |
| Cost of capital per year | tied-up money × 22% |
| Saving | purchases 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
Data as a table
| Measure | Days |
|---|---|
| Payment 1 | 25.5 |
| Payment 2 | 28 |
| Payment 3 | 0 |
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.