Skip to content
Sign inStart free

Free tool · Inventory

Inventory turnover calculator
How often your stock sells through.

Enter the cost of goods sold for a period and your beginning and ending inventory to get the inventory turnover ratio, the average inventory and the days an item sits in stock.

You also see how many days your ending stock lasts at the past rate of sales. Works in any currency.

Inventory turnover

At cost, not sales

365 for a year, 90 for a quarter

Stock value at cost

Stock value at cost

Inventory turnover ratio

6 times

Inventory figures
Average inventory20,000.00
Days in inventory (DSI)60.8 days
Days of supply (ending stock)45.6 days

Works in any currency. Calculated in your browser, nothing is sent.

How it is calculated

Inventory turnover formula

Average inventory = (beginning inventory + ending inventory) / 2
Inventory turnover = cost of goods sold / average inventory
Days in inventory (DSI) = days in period / inventory turnover
Days of supply = ending inventory / (cost of goods sold / days in period)

Example
Cost of goods sold 120,000 in 365 days, beginning inventory 25,000, ending inventory 15,000
(25,000 + 15,000) / 2 = 20,000 average inventory
120,000 / 20,000 = turnover of 6
365 / 6 = 60.8 days in inventory
15,000 / (120,000 / 365) = 45.6 days of supply

All values at cost. If you do not have cost of goods sold yet, the COGS calculator works it out from inventory and purchases. A low turnover on single products often shows up as stock that is not selling; the safety stock calculator and the EOQ calculator help set when and how much to reorder.

Inventory turnover FAQ

How do I calculate inventory turnover?

Divide the cost of goods sold for a period by the average inventory, both at cost. With 120,000 cost of goods sold in a year and 20,000 average inventory, the inventory turnover ratio is 6: the stock was sold and replaced six times in the year.

How do I calculate average inventory?

The simple formula is (beginning inventory + ending inventory) / 2, in the example (25,000 + 15,000) / 2 = 20,000. With monthly figures it gets more accurate: opening stock plus the twelve month-end values, divided by 13. That evens out seasonal peaks.

What are days in inventory (DSI)?

Days sales of inventory, or days in inventory, is the number of days in the period divided by the turnover ratio. With 365 days and a turnover of 6, an item sits in stock for about 60.8 days on average. Some businesses calculate with 360 days, which gives 60 days.

What is days of supply?

It shows how many days the current stock lasts at the past rate of sales: ending inventory divided by cost of goods sold per day. 15,000 ending inventory at 120,000 cost of goods sold over 365 days lasts about 45.6 days. It helps plan the next order.

Why use cost of goods sold instead of sales?

Because inventory is valued at cost. With sales, selling prices would be in the numerator and purchase prices in the denominator, so the ratio would be too high by your markup. If you only know sales, convert them to cost of goods sold with your gross margin first.

What is a good inventory turnover ratio?

It depends heavily on the range: fresh food turns over far more often than spare parts or furniture. Compare mainly with your own previous years and between your product groups. If turnover rises at the same revenue, less cash is tied up in stock.

For online stores

Slow stock is sometimes just hard to find

Grumeria is a typo-tolerant site search for online stores. When the store search finds nothing for a misspelled word, the product sits in stock while the visitor leaves. The free feed check shows on your own products what Grumeria finds for such searches; it reads WooCommerce, Shopify, Magento and PrestaShop stores straight from the store address.

  • 14-day free trial, no payment method needed
  • Then from €29 a month (excl. VAT)
  • Free feed check, no account needed