GenFrontier homeScope a project
Menu
Filed under
Deliver toFinance, operations and supply chain leads weighing inventory decisions

Inventory carrying cost calculator

Build an annual inventory carrying cost rate from capital, storage, service and risk costs, and see what holding your average inventory costs each year.

Plan an inventory project
resources / carrying-cost-calculator
A closed cardboard box with a small brass tap fitted to its side, dripping red drops into a saucer below

Calculator

Example values are filled in. Replace them with your own; results update as you type. Nothing you enter leaves your browser.

Your cost of capital or borrowing rate.

Results

Capital cost
$180,000
Storage space cost
$80,000
Inventory service cost (insurance, taxes, systems)
$60,000
Inventory risk cost (shrink, damage, obsolescence)
$120,000
Carrying cost rate
22.0%
Annual carrying cost
$440,000

The four components follow the common capital, storage, service and risk breakdown. Replace the example percentages with your own finance figures.

Carrying cost is what it costs to hold inventory for a year, on top of what you paid for it. ASCM says it is “usually defined as a percentage of the dollar value of inventory per unit of time” and that “such costs vary from 10 percent to 35 percent annually.” This calculator builds that percentage from four parts and applies it to your average inventory.

How to use the calculator

  1. Average inventory value at cost. Use the average of month-end balances if you have them.
  2. Capital cost. Your cost of capital or borrowing rate. Ask finance which rate they use to judge investments.
  3. Storage space cost. The cost of the space inventory occupies, as a percentage of inventory value: rent or depreciation, utilities and upkeep of the storage area.
  4. Insurance, taxes and systems. Insurance on stock, any tax assessed on inventory, and the systems used to manage it.
  5. Shrink, damage and obsolescence. Last year’s write-offs for loss, damage and expired or obsolete stock, divided by average inventory.

The formula

Carrying cost rate = capital % + storage % + service % + risk %

Annual carrying cost = average inventory value × carrying cost rate

Component What it covers Example rate
Capital Money tied up in stock 9%
Storage Space, utilities and storage equipment 4%
Service Insurance, taxes and systems 3%
Risk Shrink, damage and obsolescence 6%

Example (fictional). A distributor carries an average of $2,000,000 of inventory at cost. Finance uses 9% for capital. Storage is estimated at 4% and insurance, taxes and systems at 3%. Last year’s write-offs were $120,000, or 6% of average inventory.

  • Capital: $2,000,000 × 9% = $180,000
  • Storage: $2,000,000 × 4% = $80,000
  • Service: $2,000,000 × 3% = $60,000
  • Risk: $2,000,000 × 6% = $120,000
  • Carrying cost rate: 9 + 4 + 3 + 6 = 22.0%
  • Annual carrying cost: $2,000,000 × 22% = $440,000

Reading the result

At 22%, every dollar of inventory held for a year costs 22 cents. A $100,000 reduction in average inventory saves about $22,000 a year, before counting the cash it releases. The rate is the i in the EOQ calculator, and it is the cost side of every service level decision in the safety stock calculator.

The example sits inside ASCM’s 10% to 35% range. A result well below 10% usually means a component is missing. A result near the top of the range can be realistic for perishable, seasonal or fast-changing technical goods, where obsolescence dominates.

Look at the components as well as the total. In the example, risk is the second-largest part at $120,000. If most of that is obsolescence in one product family, a separate, higher rate for that family will give better decisions than one blended number.

Common mistakes

  • Capital cost only. The interest rate is the easiest number to find, but on its own it leaves out space, insurance, shrink and obsolescence.
  • Fixed costs counted as variable. If the building and its staff cost the same whether you hold $1.5 million or $2 million of stock, most of that cost does not belong in a rate used for day-to-day ordering decisions.
  • Retail value instead of cost. Apply the rate to inventory at cost.
  • One rate for every item. A slow item with a short shelf life has a far higher risk cost than a steady, durable one.
  • Counting the same cost twice. Receiving labor already included in the order cost used for EOQ should not appear again in storage.

When the simple model stops working

  • Step costs. Space is cheap until the building is full, and then the next pallet costs a new lease or an outside warehouse. Average rates miss that.
  • Perishable and seasonal stock, where the risk cost depends on time in stock, not just value.
  • Tax treatment of inventory, which differs by state. Ask your tax advisor what applies.
  • One large purchase decision, such as a forward buy before a price increase, where the marginal cost matters more than the average rate.

A reliable carrying cost rate depends on knowing what is in stock, where, and how old it is. When that information sits in several systems, an inventory management software project can bring it together. To see how fast the stock is moving, use the inventory turnover calculator.

Scope your project.

Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.