Inventory Turnover Calculator
Calculates how many times a company sells and replaces its inventory over a period, using cost of goods sold and average inventory. Use it to evaluate stock management efficiency and identify excess or insufficient inventory.
About this calculator
The inventory turnover ratio measures how frequently a business cycles through its entire inventory stock within a given period, usually one year. The formula is: Inventory Turnover = cogs / averageInventory, where COGS is the cost of goods sold and average inventory equals (beginning inventory + ending inventory) / 2. A higher ratio generally means the company sells goods quickly and holds little dead stock, which reduces storage costs and spoilage risk. A lower ratio may signal overstocking, weak demand, or poor purchasing decisions. However, an extremely high ratio could indicate insufficient stock levels that lead to lost sales. Industry context is critical — a grocery chain might turn inventory 20+ times per year, while a furniture retailer might turn it only 4–6 times. Pairing inventory turnover with Days Inventory Outstanding (DIO = 365 / turnover) translates the ratio into the average number of days inventory is held.
How to use
A sporting goods store reports Cost of Goods Sold of $480,000 for the year. Inventory was $60,000 at the start of the year and $80,000 at the end, so Average Inventory = ($60,000 + $80,000) / 2 = $70,000. Apply the formula: Inventory Turnover = $480,000 / $70,000 ≈ 6.86. This means the store cycled through its entire inventory about 6.86 times during the year, or roughly every 53 days (365 / 6.86 ≈ 53). Compared to an industry average of 8.0, this result suggests there may be room to improve stock management.
Frequently asked questions
What is a good inventory turnover ratio for retail or manufacturing businesses?
A good inventory turnover ratio varies widely by industry. Grocery and food retailers may turn inventory 15–30 times per year due to perishability and high volume. Clothing retailers typically aim for 4–6 turns per year, while manufacturers often target 6–12. A ratio that is too low suggests excess stock tying up working capital, while a ratio that is extremely high may mean the company is understocked and risking lost sales. Benchmarking against direct competitors and tracking the trend over time provides much more insight than any single benchmark number.
How does inventory turnover ratio relate to days inventory outstanding?
Days Inventory Outstanding (DIO), also called days sales of inventory, is simply the inverse of inventory turnover expressed in days: DIO = 365 / Inventory Turnover. If a company has an inventory turnover of 6.86, its DIO is approximately 53 days, meaning it takes about 53 days on average to sell through its stock. DIO is often easier to communicate to operations teams because it maps directly to calendar time. Together, these two metrics appear in cash conversion cycle analysis, which measures how long cash is tied up in the production and sales process.
Why is using average inventory better than ending inventory in the turnover formula?
Using only ending inventory can distort the ratio if inventory levels changed significantly during the year due to seasonal demand, a large purchase, or a sell-off. For instance, if a retailer runs heavy promotions at year-end and depletes its stock, the ending inventory would be unusually low, making turnover appear artificially high. Averaging beginning and ending inventory smooths out these fluctuations and gives a more representative picture of the inventory level maintained throughout the period. For businesses with strong seasonality, some analysts average inventory across all four quarterly balance sheet dates for even greater accuracy.