Inventory Cost Calculator

What Inventory Cost Includes

Most sellers treat the supplier invoice as the cost of inventory. It is the largest piece, but it is not the whole bill. Stock costs money while it sits on the shelf: the cash tied up in it could pay down a credit line, the space rents by the square foot, insurance runs on the average value, and some share of the units will be stolen, damaged, or marked down before they sell.

Split the bill into two buckets. Carrying cost scales with how much you hold. Ordering cost scales with how often you buy. Both belong in the same annual figure.

Total annual inventory cost = carrying cost + ordering cost

Carrying cost = (inventory value x holding rate) + (storage per unit x units on hand)

Ordering cost = purchase orders per year x cost per order

Keep the purchase price out of the annual total. It already sits inside inventory value, and adding it again double counts the same dollars. The invoice price belongs in the valuation; the annual cost is what the stock costs you to own.

Two smaller items get left out of both buckets and should not be. Freight-in and import duty raise the cost basis of the goods, so they belong in inventory value, not in the annual cost line. A duty paid at the border follows the unit until it sells. The IRS Publication 538 treats these costs as part of the cost of goods, which is why a landed cost per unit is the right starting point for the valuation.

Building a Holding Rate You Can Defend

A holding rate is an estimate, and any estimate is arguable. The fix is to build it from named pieces so a reader can challenge one line instead of the whole number. The table below adds up to the 18 percent used in the calculator.

Storage is tracked separately at $4.00 per unit per year, covering rent, shelving, and handling. Splitting it out keeps the rate comparable across product lines: a jeweler might run 14 percent capital and $1.20 of storage, while a furniture seller runs 6 percent capital and $60 of storage. Charging storage per unit also captures what a percentage rate misses. A cheap, bulky item can cost more to hold than an expensive, small one, because it eats shelf space that a percentage of its low value never reflects.

Use last year's actuals for shrink and obsolescence rather than an industry average. Those two lines move the most between businesses, and they are the ones owners tend to underestimate.

Turns, Days on Hand, and What They Hide

Turnover answers how many times the stock is replaced in a year.

Inventory turns = cost of goods sold / average inventory at cost

Days on hand = 365 / turns

Use cost of goods sold, not sales. Dividing retail sales by inventory at cost inflates turns by the markup and makes a sluggish book look fast. In the example below, annual unit sales of 3,480 are exactly four times the 870 units on hand, so the stock turns 4.0 times and sits for 91.3 days.

Average inventory means the average of the monthly balances, not the year-end count. A count taken after a clearance sale can make turns look double what they were for the other eleven months. If you only have two counts, average the opening and closing balances and say so.

Turns hide as much as they show. A 12-turn book can be stocked out half of every month, losing sales that never appear in the ratio. A 2-turn book can be sitting on a genuine bulk buy that saved 15 percent. Pair turns with a fill rate or a count of stockout days before drawing conclusions, and read the trend across four quarters rather than a single month.

Worked Example: Three SKUs on the Shelf

A small seller holds three products: 420 units at $32.50, 260 units at $58.00, and 190 units at $95.00. Annual sales run 3,480 units, the owner places 12 purchase orders a year at $85 each, and the holding rate is 18 percent plus $4.00 per unit of storage.

Run the numbers in order:

1. Value each line: 420 x $32.50 = $13,650.00; 260 x $58.00 = $15,080.00; 190 x $95.00 = $18,050.00.
2. Total the value: $46,780.00 across 870 units.
3. Average unit cost: $46,780.00 / 870 = $53.77.
4. Capital and risk portion: $46,780.00 x 0.18 = $8,420.40.
5. Storage: 870 x $4.00 = $3,480.00.
6. Carrying cost: $8,420.40 + $3,480.00 = $11,900.40.
7. Ordering cost: 12 x $85 = $1,020.00.
8. Total annual inventory cost: $11,900.40 + $1,020.00 = $12,920.40.
9. Turns: $187,120.00 of cost of goods sold / $46,780.00 = 4.0 turns, or 91.3 days on hand.

SKU C is the smallest line by unit count and the largest by value, which is why it carries the biggest share of the bill. That ranking is the practical output of the exercise: the item that deserves the tightest reorder point is not the one with the most units, it is the one holding the most dollars.

Ordering Cost and the Order Size That Balances It

Ordering cost covers the purchase order itself: the buyer's time, receiving, inspection, and the accounting that goes with a bill. It is small per order and large across a year. Twelve orders at $85 cost $1,020; twenty four cost $2,040.

Holding cost moves the other way. Order more often and the average stock left between deliveries falls, so carrying cost falls with it. The economic order quantity is the order size where the two curves meet.

EOQ = square root of (2 x annual demand x cost per order / holding cost per unit per year)

Holding cost per unit here is $53.77 x 0.18 + $4.00 = $13.68 a year. With demand of 3,480 units and an order cost of $85, EOQ is 208 units, which works out to about 17 orders a year.

This table applies the same $13.68 per unit per year to the average stock left by each order size, which is why it differs from the on-hand figure in the first example. The calculator reports the same line as carrying cost at your order cycle, so you can read each row straight off the tool. It is not an argument for 17 orders. The curve is flat near the bottom: 12 orders cost $3,003.40 and 17 cost $2,845.05, a difference of $158 a year. Supplier minimums, freight breaks, and shelf life usually matter more than the last $158, so treat EOQ as a reference point and let the real constraints set the schedule.

FIFO, LIFO, and Weighted Average on the Books

The annual cost above is a management number. The number on the tax return comes from an inventory valuation method, and the choice changes both ending inventory and cost of goods sold. Publication 538 describes FIFO and LIFO for tax purposes and requires Form 970 when a business adopts LIFO. Weighted average is common in book accounting and in inventory software, and it smooths the swings the other two create.

Take a product bought three times in a year of rising prices: 100 units at $10, 100 at $12, 100 at $14, then 150 units sold at $30.

In a year of rising prices, LIFO reports the highest cost of goods sold and the lowest taxable income, because the newest and most expensive units are charged against sales first. FIFO leaves the newest costs on the balance sheet, which reports a higher inventory value and a higher profit. Weighted average lands in the middle at $12.00 a unit. The cash difference is real: at a 21 percent corporate rate, the $400 gap in cost of goods sold between FIFO and LIFO moves the tax bill by $84.

A small business taxpayer that meets the gross receipts test of section 448(c) can skip inventory accounting and treat stock as non-incidental materials and supplies. The threshold is $31,000,000 for tax years beginning in 2025 and $32,000,000 for 2026, per Rev. Proc. 2024-40 and Rev. Proc. 2025-45. Skipping the count does not make the stock free; it changes when the cost hits the return.

Pricing, Dead Stock, and the Cash Behind the Shelves

The carrying cost per unit is the number that belongs in a pricing sheet. Across the example book it is $13.68 per unit per year, or 25.4 percent of the average unit cost of $53.77. A product with a $20 gross margin that sits for 18 months loses money before any markdown.

Slow movers carry a higher rate than the average because storage is charged per unit. SKU C costs $95 and holds at $21.10 a year ($95 x 0.18 + $4.00). Eighteen months on the shelf costs $31.65, a third of its purchase price.

Cash planning follows the same arithmetic. Every dollar moved out of dead stock and into a faster item cuts carrying cost and frees the cash at the same time. Retail benchmarks help set a target: the Census Bureau's Annual Retail Trade Survey publishes inventories and inventory-to-sales ratios by kind of business, which is a better comparison than a rule of thumb borrowed from a blog. The SBA's guidance on managing a business makes the same point about working capital tied up in stock.

Recalculate the number once a quarter, or whenever the holding rate changes. A move in the prime rate, a new insurance premium, or a jump in markdowns all feed straight into the rate, and a stale rate hides the change until the year-end close.