Syntha Lab RU

Inventory carrying cost rate

Builds a single inventory carrying cost rate from five components (capital, storage, insurance and shrink, obsolescence, handling) and converts it into roubles per unit and per average stock. This rate is used by the order size, carry-over and discount-versus-holding calculations.

Stock and turnover For whom: Finance directors, controllers and buyers who need a single carrying cost rate.

Calculate on your data →

At a glance

What question does it answer?
How much it costs to hold a rouble of stock per year and a unit of goods per month.
What data is needed?
The cost of capital: the key rate plus the spread.
How to read the result?
Look at the shares of capital and obsolescence: they are the main ones. Use one rate in all stock calculations. Example on the default values: Carrying cost rate, % per year: 37.5%; Holding cost of a unit per month: RUB 46.88; Holding cost of a unit per year: RUB 562.5; Holding cost of a unit per day: RUB 1.54. The figures are illustrative: enter your own to see your result.

Why and how to reason

The decision to hold or to sell must be taken by the full carrying rate, not only by the credit interest. In the example capital is 22%, storage 4%, insurance and shrink 1.5%, obsolescence 8%, handling 2%: the rate is 37.5% per year, a unit costing RUB 1,500 costs RUB 46.9 a month and RUB 563 a year, an average stock of 21 m RUB costs 7.88 m RUB a year.

When to use it

Apply once and put into all stock calculations; revise when the key rate changes.

How to read the result

Look at the shares of capital and obsolescence: they are the main ones; a rate above 100% means an input error.

Common mistakes

Only the credit interest is taken, fashion obsolescence is ignored, the rate is not updated.

What data is needed?

  • The cost of capital: the key rate plus the spread.
  • Storage, insurance and shrink, handling.
  • Obsolescence by the share of sales and write-offs.

Inputs

FieldUnitValue in the exampleMeaning
Cost of capital%22The key rate plus the credit spread of your company or the required return. The main component, revise it when the key rate changes. The example value is illustrative.
Storage%4Warehouse rent, warehouse work, utilities for the stock. The example value is illustrative.
Insurance and shrink%1.5Insurance, theft, damage, mis-sorting. The example value is illustrative.
Obsolescence%8Loss of price due to fashion and season: sales below cost, write-off. Not zero for seasonal goods. The example value is illustrative.
Handling%2Receiving, moves, stocktaking, accounting for the stock. The example value is illustrative.
Cost of a unit₽1,500The cost of a unit per month and per year is counted from it. Empty counts as zero. The example value is illustrative.
Average stock at cost (optional)₽21,000,000The average stock for the year (avgstock). If given, the annual holding cost of all stock is shown. Empty: not shown. The example value is illustrative.

How it is calculated

StepFormula
Rate22 + 4 + 1.5 + 8 + 2 = 37.5% per year
Per unit per yearunit cost × rate
Per unit per monthunit cost × rate ÷ 12
On the whole average stockaverage stock × rate

Worked numbers

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

Carrying cost rate, % per year
37.5 %
Holding cost of a unit per month
46.88 ₽
Holding cost of a unit per year
562.5 ₽
Holding cost of a unit per day
1.54 ₽
Annual holding cost of the average stock
7.88 m ₽
Share of capital in the rate, %
58.7 %
Rate components, % per year
Bar chart: Capital 22, Storage 4, Insurance and shrink 1.5, Obsolescence 8, Handling 20510152025CapitalCapital% per year: 2222StorageStorage% per year: 44Insurance and shrinkInsurance and shrink% per year: 1.51.5ObsolescenceObsolescence% per year: 88HandlingHandling% per year: 22
Data as a table
Measure% per year
Capital22
Storage4
Insurance and shrink1.5
Obsolescence8
Handling2

Use one rate in all calculations where stock costs money over time: the order size (eoq), carrying a leftover over, provisions and the comparison of a supplier discount with holding. Document the rate with a date.

What to do with the result: compare the rate with the key rate at the date and update it when it changes; decide to hold or to sell by the rate in roubles per unit.

A typical mistake: taking only the credit interest, ignoring the obsolescence of fashion and not updating the rate when the key rate changes.

Nuances and limits

  • Taking only the credit interest.
  • Ignoring fashion obsolescence.
  • Not updating when the key rate changes.

Terms used

Calculate on your data →