Inventory Turnover Calculator (2026)
An inventory turnover calculator measures how many times you sell and replace your inventory in a given period. Inventory turnover ratio is cost of goods sold divided by average inventory value. A higher ratio means stock moves faster, which usually signals strong demand and less capital tied up in unsold goods.
Track turnover by product, category, or entire store.
100% client-side. Inventory and COGS figures never leave this browser.
Turnover, days on hand, holding cost, and cash you might free by hitting a higher target turnover rate.
Inventory turnover
4.0x| 91 days on hand
Industry guide: E-commerce 6-12x (benchmarks vary by sub-category).
Turnover ratio
4.00x
Days on hand
91.3 days
Annual holding cost
$15,000
Holding cost per day
$41.10
Cash flow impact (what-if)
Reaching 9x turnover frees about $33,333 in cash and saves about $8,333/year in holding costs.
Cash freed (one-time)
$33,333.33
Annual holding savings
$8,333.33
Inventory at target
$26,666.67
Current vs target inventory (cash tied up)
Total inventory cost sold in the period.
(Beginning + ending inventory) / 2.
Storage, insurance, obsolescence, financing; often 20-30%.
How does the Inventory Turnover Calculator work step by step?
Inventory turnover shows how efficiently you convert stock into sales.
The turnover ratio tells you how many times per year you sell through your average inventory. If your ratio is 6, you sell and replenish your stock six times per year, or roughly every two months. If your ratio is 2, inventory sits for about six months before selling.
The formula is:
Inventory Turnover Ratio = Cost of Goods Sold (COGS) ÷ Average Inventory Value
Where:
- Cost of Goods Sold is the total cost of products you sold during the period, not the retail price
- Average Inventory Value is (Beginning Inventory + Ending Inventory) ÷ 2
For example, if your COGS for the year is $120,000 and your average inventory value is $20,000, your turnover ratio is:
$120,000 ÷ $20,000 = 6
That means you turned over your inventory 6 times during the year.
You can also calculate Days to Sell Inventory (DSI), which is how long it takes on average to sell through your stock:
Days to Sell Inventory = 365 ÷ Inventory Turnover Ratio
Using the example above:
365 ÷ 6 = 60.8 days
It takes about 61 days to sell through your inventory. Lower DSI means faster turnover.
When should you use the Inventory Turnover Calculator?
Use this calculator when planning inventory purchases, evaluating product performance, or diagnosing cash flow problems.
Before placing a restock order
If your turnover ratio is low, you may already have too much inventory. Ordering more stock before you sell what you have ties up more cash and increases storage costs. Check turnover first to see if you need to reorder now or wait another month.
When comparing product categories
Some products naturally turn over faster than others. Groceries and consumables turn over quickly. Furniture and seasonal items turn over slowly. Compare turnover across categories to see where your capital is working hardest and where it is sitting idle.
When diagnosing cash flow issues
Low turnover means cash is locked in unsold inventory. If you are running out of cash despite decent sales, check if slow-moving inventory is draining your working capital. Liquidating slow movers frees up cash you can use to buy faster-turning products or cover operating expenses.
When evaluating supplier terms
Suppliers often offer volume discounts for larger orders. But buying in bulk only makes sense if you can sell through the inventory before the next order cycle. Calculate turnover to see if the discount is worth the extra holding time and storage cost.
How do you read Inventory Turnover Calculator results?
The calculator returns your turnover ratio, days to sell inventory, and benchmarks for comparison.
Turnover ratio
A higher ratio means inventory moves faster. Retail apparel often sees turnover ratios between 4 and 6. Grocery stores can exceed 12. Specialty or high-ticket items may have ratios under 3. Compare your ratio to your own historical data and to industry benchmarks, not to unrelated sectors.
Days to sell inventory
This is the average number of days an item sits in stock before selling. If DSI is 90 days and your supplier lead time is 60 days, you should reorder when you have about 30 days of stock left to avoid a stockout. If DSI is climbing, demand is slowing or you overstocked.
High turnover risks
Very high turnover can signal stockouts and lost sales. If your ratio is 15 but you frequently run out of stock, you may be turning inventory too fast and missing revenue opportunities. Track out-of-stock days alongside turnover to get the full picture.
Low turnover risks
Low turnover means capital is tied up in slow-moving inventory. Products sitting for 180+ days often become obsolete, go out of season, or lose margin to clearance discounts. If turnover is below 2, review your product mix and consider markdowns to free up cash.
Seasonal adjustments
Turnover ratios can shift by season. Holiday inventory may turn 3x faster in November and December than in February. Measure turnover quarterly or monthly to catch seasonal patterns instead of only looking at annual averages.
What does a typical Inventory Turnover Calculator result look like?
Here are three scenarios with different turnover profiles.
Example 1: Fast-moving apparel store
- Annual COGS: $240,000
- Beginning inventory: $35,000
- Ending inventory: $45,000
- Average inventory: ($35,000 + $45,000) ÷ 2 = $40,000
Turnover ratio: $240,000 ÷ $40,000 = 6
Days to sell inventory: 365 ÷ 6 = 60.8 days
This store replenishes stock about every 2 months. The ratio is healthy for apparel, signaling steady demand and manageable stock levels.
Example 2: Slow-moving specialty furniture
- Annual COGS: $180,000
- Beginning inventory: $90,000
- Ending inventory: $110,000
- Average inventory: ($90,000 + $110,000) ÷ 2 = $100,000
Turnover ratio: $180,000 ÷ $100,000 = 1.8
Days to sell inventory: 365 ÷ 1.8 = 202.8 days
Inventory sits for over 6 months before selling. This is typical for high-ticket specialty items but signals heavy capital requirements. If cash flow is tight, this store may need to reduce inventory depth or shift toward faster-turning products.
Example 3: Seasonal outdoor gear
- Q4 COGS: $80,000
- Q4 beginning inventory: $50,000
- Q4 ending inventory: $20,000
- Q4 average inventory: ($50,000 + $20,000) ÷ 2 = $35,000
Q4 turnover ratio: $80,000 ÷ $35,000 = 2.3
Q4 days to sell inventory: 365 ÷ 2.3 = 158.7 days (annualized)
In Q4, the store moved inventory faster due to seasonal demand. If you measure annual turnover, the ratio would be lower because Q1-Q3 sales are slower. Track turnover by quarter to see which periods drive the most efficient stock movement.
Related tools
For pricing decisions that affect inventory velocity, use the OnSumo Wholesale Markup Calculator to set retail prices based on cost and target margin. If you run promotions to clear slow-moving inventory, the OnSumo AOV Optimizer helps you bundle slow movers with fast sellers to improve turnover while protecting average order value.
Frequently asked questions
What is a good inventory turnover ratio?
A good ratio depends on your industry. Grocery and consumables often exceed 10. Apparel typically ranges from 4 to 6. Furniture and luxury goods may be under 3. Compare your ratio to industry benchmarks and your own historical data. If your ratio is trending down, investigate why demand is slowing or why you are holding more stock.
How often should I calculate inventory turnover?
Calculate it monthly or quarterly to catch trends early. Annual turnover averages can hide seasonal shifts and slow-moving product issues. If you see turnover dropping for two consecutive months, you can adjust purchasing or run promotions before cash flow becomes a problem.
What causes low inventory turnover?
Low turnover happens when demand is weak, you overstocked, prices are too high, or products are out of season. It can also signal poor product-market fit or heavy competition. Review sales velocity by SKU to see which items are dragging down the overall ratio, then decide whether to discount, bundle, or discontinue those products.
What causes high inventory turnover?
High turnover means demand is strong or you are understocking. If turnover is high but you frequently run out of stock, you are missing sales. If turnover is high and stockouts are rare, your inventory planning is efficient. Track both turnover and out-of-stock rate together to see the full picture.
How do I improve inventory turnover?
To increase turnover, you can raise sales through marketing and promotions, lower prices to move stock faster, reduce order quantities to hold less inventory, or cut slow-moving SKUs from your catalog. The fastest path is usually to run targeted discounts on slow movers and reinvest the freed-up cash in faster-turning products.
Should I use COGS or sales revenue for the turnover formula?
Use COGS, not sales revenue. COGS measures the cost of inventory sold, which matches the cost-based valuation of inventory on hand. Using sales revenue inflates the ratio and makes comparison difficult. Most accounting standards and industry benchmarks use COGS for inventory turnover.