Carrying cost calculator: what your stock costs you to hold.
Enter the value of the stock you hold and what holding it costs you a year: the money tied up, the space, insurance, handling, and what is lost or goes out of date. The page adds it up in dollars and as a rate, and shows what holding less would save. It runs in your browser: nothing is uploaded.
- A month
- $1,666.67
- Per $1 held, a year
- $0.25
- Moves with the value (17%)
- $13,600
- Fixed amounts
- $6,400
The lines entered as a % of value fall with what you hold. The $6,400 a year entered in dollars stays the same until you give up the space or the time.
| Hold less by | Value held | Carrying cost a year | Saves a year |
|---|---|---|---|
| 10% | $72,000 | $18,640 | $1,360 |
| 20% | $64,000 | $17,280 | $2,720 |
| 30% | $56,000 | $15,920 | $4,080 |
| 50% | $40,000 | $13,200 | $6,800 |
What goes into carrying cost
Carrying cost, also called holding cost or inventory carrying cost, is what it costs to keep stock on hand for a year, on top of what you paid for it. It usually has five parts:
- Money tied up. Cash in stock is not paying down a loan or earning anything. Use the interest rate you pay, or what the money would earn elsewhere. It is often the biggest part.
- Storage and space. Rent, heat, light and racking for the space the stock takes. If the building is also your workshop or your shop, count only the share used for stock.
- Insurance and taxes. Insurance on the stock, and any tax on stock you hold, where one is charged.
- Handling. The time spent moving, counting and looking after stock.
- Lost, damaged or out of date. Stock that is lost, stolen or broken, and stock that expires or that nobody wants any more.
Two costs are left out on purpose: the price of the goods themselves, and the cost of placing and receiving an order, which includes receiving a delivery and putting it away. The EOQ calculator weighs that cost of an order against the carrying cost.
How it is worked out
- each line = its % x the value held, or a fixed $ a year
- carrying cost a year = the five lines added up
- carrying cost rate = carrying cost a year / the value held
- a month = carrying cost a year / 12
Worked example, with the figures the page loads. The stock is worth $80,000 at cost. The money tied up, at 10%, is $8,000 a year. The space costs $400 a month, which is $4,800 a year. Insurance and taxes at 2% are $1,600, handling is $1,600 a year, and 5% lost, damaged or out of date is $4,000. Together that is $20,000 a year, or $1,666.67 a month: a carrying cost rate of 25%. Every dollar of stock costs 25 cents a year to hold.
Use the value at cost, what you paid, not what you would sell it for. If it rises and falls through the year, use the average: the value at the start plus the value at the end, divided by 2.
The rate is the holding cost the EOQ calculator asks for when you give it as a % of the unit cost: at 25%, an item that costs $12 costs $3 a year to hold. Each line can be entered as a % of the value or as dollars a year, whichever you know. Switching a line between the two keeps its dollars a year the same.
Holding less saves less than you might think
Only the parts that move with the value fall when you hold less. In the example, the lines entered as a % add up to 17% of the value: 10% for the money, 2% for insurance and taxes and 5% lost or out of date. The $4,800 of space and the $1,600 of handling are fixed amounts, and they stay until you give up the space or the time.
So holding 20% less, $64,000 instead of $80,000, takes the carrying cost from $20,000 to $17,280 a year. That saves $2,720, not 20% of $20,000, which would be $4,000. The table under the calculator shows 10%, 20%, 30% and 50% less for your own figures.
If a cost really would shrink with the stock, such as pallet spaces you rent by the month, enter it as a % of the value so the table counts it. The stock to look at first is the stock that has not moved: it still costs the money, the space and what goes out of date, and it earns nothing back. The turnover calculator shows how many times a year your stock sells through.
Carrying cost and InventoryQuick
InventoryQuick does not work out a carrying cost. It holds the value to start from, and on Business and Enterprise it finds the stock that has not moved.
- The value at cost: on the Items screen, open Import/Export, go to the Export tab and click Export Items to CSV. The file has each item's Quantity, Price and Cost. Multiply Quantity by Cost on each row and add them up. Exporting is on every plan.
- Where Cost comes from: receiving stock on a purchase order with a price sets the item's Cost to that price, so it is what you last paid. You can also type it in, and the next receipt replaces it. An item with no Cost is blank in the file, so fill those in or the total will come out low. Purchase orders are included from Starter up.
- Not the dashboard figure: Total Inventory Value on the dashboard is each item's quantity times its Unit Price, the price a sales order uses unless you type another. That is a selling value, so it is not the one to enter here.
- Stock that has not moved: on Business and Enterprise, the dead stock finder lists items with no sale or use for 90 days, or a period you set from 30 to 365, ranked by quantity times Unit Price.
Flat monthly plans from $19/mo, with no per-user fees. The dead stock finder starts on Business, at $149/mo. Every plan starts with a 7-day free trial, and you won't be charged for 7 days. On the web you pick a plan and enter a card.
Frequently asked questions
Is the carrying cost calculator free?
Yes. There is no sign-up and no email is asked for. The sums are done in your browser. What you type is not sent to InventoryQuick and it is not stored.
What is a normal carrying cost?
A common estimate is 20% to 30% of the value of the stock, a year. Your own figure depends on what money costs you, what you pay for space, and how fast your stock is lost, damaged or goes out of date, so it is worth working out. The example on this page comes to 25%.
Should I use the cost of the stock or its selling price?
The cost: what you paid for it. Carrying cost is about money you have already spent and cannot use for anything else. At selling prices the stock looks bigger than the money in it, so every line entered as a % of the value comes out too high.
What is the difference between carrying cost and ordering cost?
Carrying cost is what it costs to keep stock for a year. Ordering cost is what it costs to place and receive one order: raising it, a flat delivery charge, and receiving and putting it away. Ordering less often means bigger orders and more stock on the shelf, so as one goes down the other goes up. The EOQ calculator finds the order size where the two together are lowest.
How do I use the rate in the EOQ calculator?
In the EOQ calculator, set the holding cost to % of unit cost and enter your rate. At 25%, an item that costs $12 costs $3 a year to hold, which is the example the EOQ calculator loads.
Why does holding 20% less not save 20% of the carrying cost?
Because some of the cost does not move with the stock. Rent and handling time stay the same until you give up the space or the time. In the example only the lines entered as a %, 17% of the value, fall with the stock, so holding 20% less saves $2,720 a year, not $4,000.
Does InventoryQuick work out carrying cost?
No. It holds the figure to start from. On the Items screen, open Import/Export, go to the Export tab and click Export Items to CSV. The file has each item’s Quantity and Cost, which is the price last paid on a received purchase order, or one you typed in. Multiply the two on each row and add them up for the value at cost. The dashboard’s Total Inventory Value uses each item’s Unit Price, a selling price, so it is not the figure to use here.
More free tools: EOQ calculator, turnover calculator, safety stock calculator, reorder point calculator.