Inventory turnover ratio: how to calculate and improve it

The number that tells you whether your inventory is an asset or a parking lot

There is a single metric that separates retailers who make money from retailers who tie up money, and most small business owners either do not track it or track it incorrectly. It is called inventory turnover ratio, and what it measures is deceptively simple: how many times per year you sell and replace your entire stock. A turnover ratio of 12 means you sell through your inventory once a month. A turnover ratio of 4 means your average product sits on your shelf for three months before someone buys it. A turnover ratio of 1 means you are, on average, looking at the same products you were looking at a year ago, which is less a retail operation and more a warehouse with a cash register.

The reason this number matters more than gross margin, more than revenue growth, more than most of the metrics that business owners obsess over, is that it directly measures capital efficiency. Every rupee or dollar sitting in unsold inventory on your shelf is a rupee or dollar that is not earning interest, not paying down debt, not funding marketing, not doing anything except slowly depreciating. And for perishable inventory, that depreciation is not slow at all — it is a countdown clock that ends in a write-off.

How to calculate it (and the mistake almost everyone makes)

The formula is straightforward: Cost of Goods Sold divided by Average Inventory Value. Not revenue — cost. This is the mistake. If you use revenue instead of COGS, you inflate your turnover ratio by your margin, which makes you feel better without making you more informed.

Average Inventory is typically (Beginning Inventory + Ending Inventory) / 2, using the same period as your COGS. If your COGS for the year was $600,000 and your average inventory value was $100,000, your turnover ratio is 6. You sold through your inventory six times during the year. Each unit sat on your shelf for an average of about 61 days (365 / 6).

That 61-day number — days inventory outstanding, or DIO — is often more useful than the ratio itself, because it maps directly to operational reality. When someone tells you their turnover ratio is 8, you have to do mental math. When someone tells you their average product sits on the shelf for 46 days, you immediately understand what that means for cash flow, for perishable risk, and for warehouse space.

What good looks like (it depends on what you sell)

A grocery store should be turning inventory 14-20 times per year. The produce department might turn 50+ times. The canned goods aisle might turn 8 times. The blended average should land somewhere around 15 for a well-run store, which means average shelf time of about 24 days. If your grocery store has a turnover ratio of 6, you have a serious problem — either you are carrying far too much stock, or significant portions of your inventory are not selling.

A pharmacy typically turns 8-12 times per year. Prescription medications move faster (high turnover, predictable demand). OTC supplements and cosmetics move slower. The blended average for a well-managed pharmacy is around 10, or about 37 days on the shelf. Below 8 and you are tying up too much capital in slow movers. Above 14 and you might be running too lean — stockouts in pharmacy are not just lost sales, they are lost patients.

A general retail store lands between 4 and 8, depending on the product mix. Electronics retailers often run 6-8. Apparel runs 4-6 (seasonal inventory drags the number down). Specialty retail varies wildly — a pet store might turn 8 times while a furniture store turns 3 times.

The critical insight is that a single turnover number for your entire store is almost useless for decision-making. You need turnover by category, and ideally by product. Your store-wide turnover might be a healthy 12, but that might be masking a produce department turning at 40 and a specialty section turning at 2. The specialty section is where your capital is trapped, and the store-wide number hides it.

The five levers that actually improve turnover

Lever 1: Stop ordering what does not sell

This sounds painfully obvious, and yet the number one reason for low turnover in retail is carrying products that do not move. Somewhere in your store, right now, there are products that have been sitting for 90+ days. You ordered them because a sales rep was persuasive, or because a customer asked for them once, or because they seemed like a good idea at the time. They are now depreciating on your shelf, and every day they sit there, they are costing you the opportunity cost of the capital they represent plus the shelf space they occupy.

Pull a report of everything with zero or near-zero sales in the last 90 days. For perishable products, make that 30 days. Now make a decision for each item: discount it, return it to the supplier, donate it, or accept the write-off. Do not leave it on the shelf hoping someone will buy it. Hope is not an inventory strategy.

Lever 2: Order smaller quantities more frequently

The traditional approach to purchasing — large orders placed infrequently to maximize supplier discounts — is a turnover killer for perishable businesses. If you order 200 units of a product that sells 50 per week, you have a month of supply on your shelf. Your turnover for that product is 12-13. If you order 60 units twice a week, you have 4-5 days of supply, your turnover for that product is 50+, and your expiry risk drops dramatically. Yes, you lose the volume discount. But the volume discount is typically 2-5%, and your holding cost — especially for perishables that might expire — is 10-30%. The math is not close.

Lever 3: Reduce lead times

Every day between placing an order and receiving it is a day you need to carry safety stock. If your supplier delivers in 2 days, you need 2 days of safety stock. If your supplier delivers in 7 days, you need 7 days. That safety stock sits on your shelf, doing nothing except lowering your turnover ratio and increasing your expiry risk. Negotiate faster delivery. Switch to suppliers who deliver more frequently. For perishable categories, the difference between a 2-day lead time and a 5-day lead time is the difference between fresh product and expiry-risk product.

Lever 4: Fix your demand forecasting

Over-ordering is the most common cause of low turnover, and over-ordering is almost always a forecasting failure. If you are ordering based on gut feeling, you are ordering wrong — not because your gut is bad, but because human intuition systematically overestimates demand for products we like and underestimates demand for products we do not think about. Data-driven reorder points — based on actual sales velocity, actual lead times, and actual seasonality patterns — eliminate the bias and bring your order quantities in line with reality.

Lever 5: Markdown before it is too late

For perishable inventory, turnover and expiry management are the same discipline viewed from different angles. A product approaching expiry with healthy turnover will sell before it expires. A product approaching expiry with low turnover will become a write-off. Dynamic markdown pricing — reducing the price as the expiry date approaches — converts potential write-offs into revenue. The revenue is lower than full price, but it is infinitely higher than zero, which is what you get from a write-off.

The perishable problem: why turnover ratios lie about fresh departments

Standard inventory turnover calculations assume that unsold inventory retains its value. For canned goods and electronics, this is roughly true — a can of beans sitting on your shelf for six months is worth the same as the day you bought it. For perishable inventory, this assumption is catastrophically wrong. A yoghurt that has been on your shelf for 20 of its 25-day shelf life is not worth the same as the day you received it. It is worth less — potentially much less if it passes the sell-by date and becomes unsaleable. And if it expires, it is worth nothing while still showing up in your inventory valuation at full cost.

This means that for perishable businesses, inventory turnover needs a companion metric: waste percentage. A grocery store with a turnover ratio of 15 and a waste rate of 8% is actually performing worse, from a capital efficiency standpoint, than a store with a turnover ratio of 12 and a waste rate of 2%. The first store is cycling inventory faster but destroying more value in the process.

Related reading

• Physical inventory count guide — the process that validates your turnover calculations
• Complete guide to FEFO for supermarket chains — rotation methods that directly improve turnover
• Dead stock liquidation: the 90-day playbook — what to do with the products dragging your turnover down

ShelfLifePro calculates inventory turnover at the category and product level, flags slow-moving stock before it becomes dead stock, and automates the markdown pricing that converts low-turnover perishables into revenue. [Start your free 14-day trial](/get-started).