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
Calculator
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
- Average inventory value at cost. Use the average of month-end balances if you have them.
- Capital cost. Your cost of capital or borrowing rate. Ask finance which rate they use to judge investments.
- 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.
- Insurance, taxes and systems. Insurance on stock, any tax assessed on inventory, and the systems used to manage it.
- 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.