Your inventory is cash. How fast are you converting it back?
You have $50K in inventory sitting in a warehouse. You sell $500K/year, which means you turn inventory 10x annually (inventory turnover ratio of 10). But a competitor with the same inventory only does $300K/year (turnover of 6). Their capital is stuck longer, earning them less. Your inventory turns 66% faster, meaning you convert cash back to cash faster, giving you a competitive advantage. This calculator measures and compares your inventory efficiency.
What This Calculator Does
This tool calculates inventory turnover ratio and days inventory outstanding (DIO)-two key metrics for understanding how efficiently you're selling through inventory. Feed in your cost of goods sold (annual), average inventory balance, and the calculator shows turnover ratio, days to sell inventory, and benchmarks against industry averages. It also forecasts cash impact of inventory velocity changes so you can see the value of faster-turning inventory.
How to Use This Calculator
Step 1: Calculate your cost of goods sold (COGS) for the past 12 months. This is the cost to you (not retail price) of items sold. If you sold 10,000 widgets at $5 COGS each, your COGS is $50,000.
Step 2: Find your average inventory balance. Look at your inventory at the beginning and end of the year, then average them. If inventory was $8,000 on January 1 and $12,000 on December 31, average is $10,000. If you have monthly inventory counts, average all 12 months.
Step 3: Enter both numbers into the calculator.
Step 4: The calculator shows your inventory turnover ratio (how many times you sold through your inventory in a year), days inventory outstanding (how many days inventory sits before selling), and whether you're above or below industry benchmarks.
Step 5: Use this to compare across your own products (which SKUs turn fast vs. slow?), across your own years (are you improving?), and against competitors (are you more efficient?).
The Formula Behind the Math
Inventory Turnover Ratio
Inventory Turnover = Cost of Goods Sold / Average Inventory
Example:
Inventory Turnover = $500,000 / $50,000 = 10x
You sold through your entire inventory 10 times in the year.
Days Inventory Outstanding (DIO)
DIO = 365 / Inventory Turnover
Or: DIO = (Average Inventory / COGS) × 365
Example:
DIO = 365 / 10 = 36.5 days
On average, inventory sits for about 37 days before being sold.
Cash Impact of Inventory Velocity:
If you improve turnover from 10x to 12x (faster selling), you can reduce average inventory while maintaining the same COGS:
New Average Inventory = COGS / New Turnover = $500,000 / 12 = $41,667
Cash Freed Up = $50,000 - $41,667 = $8,333
Faster inventory velocity freed up $8,333 in cash-essentially a free loan to yourself.
Inventory-to-Sales Ratio (inverse of turnover):
Inventory-to-Sales = Average Inventory / (COGS / 365)
Example: $50,000 / ($500,000 / 365) = 36.5 days (same as DIO).
Our calculator does all of this instantly-but now you understand exactly what it's computing.
Retail Business Optimizing Store Inventory
You're a clothing retailer. COGS (last year): $200,000. Average inventory: $40,000. Turnover: 5x. DIO: 73 days. Your competitor turns inventory 7x with the same revenue. They have better inventory management or a faster fashion cycle. To match them, you'd need to reduce average inventory to $28,571 while maintaining $200K sales. Can you? Maybe reduce SKU count, improve markdown velocity, or increase turn-and-burn marketing. If you can achieve 7x turnover, you free up $11,429 in cash that you can use for marketing or more inventory in faster-selling categories.
E-commerce Company Managing SKUs
You sell 50 different products. Product A (top seller): COGS $100K, average inventory $5K, turnover 20x. Product B (slow seller): COGS $50K, average inventory $8K, turnover 6.25x. Product B is tying up capital inefficiently. You have options: discontinue it, run a promotion to accelerate sales, drop inventory levels, or reposition it. This calculator shows you which products are cash hogs and which are cash efficient.
Wholesale Distribution Company
You distribute products to retailers. COGS (last year): $2M. Average inventory: $300K. Turnover: 6.67x. DIO: 55 days. This is reasonable for wholesale (typically 4-8x turnover). But if you can improve supplier lead times (reduce how much safety stock you need) or improve demand forecasting, you might push to 8x turnover, freeing up $50K in cash. In a capital-intensive business like wholesale, inventory velocity drives profitability.
SaaS Company with Physical Products
You sell a hardware product plus subscription. Hardware COGS: $200K. Average hardware inventory: $30K. Turnover: 6.67x. DIO: 55 days. You'd like to move to made-to-order (zero inventory, infinite turnover) but your lead time is 60 days. Switching to made-to-order would tie up cash in payables/deposits instead of inventory, changing working capital dynamics. This calculator helps you model the financial impact of different fulfillment models.
Tips and Things to Watch Out For
Use COGS, not revenue. Turnover is calculated on cost of goods sold, not retail price. If you sell $500K in items but COGS is $200K (because you have 60% margin), your turnover is based on $200K, not $500K. Using revenue overstate turnover and makes comparisons misleading.
Average inventory matters. If you have inventory of $10K on January 1, $50K on June 30, and $20K on December 31, average is ($10K + $50K + $20K) / 3 = $26,667. Don't use year-end inventory alone; it might not be representative. Use monthly averages if possible.
Seasonal businesses have volatile inventory. A toy retailer has massive inventory in October, minimal in February. Using year-end inventory makes turnover seem worse in January (high DIO). Calculate turnover for the full year, not a single season. Or calculate by season separately.
Fast turnover is good, but not always. A turnover of 50x sounds amazing but might indicate you're under-stocked and losing sales. A turnover of 2x might be strategic (you're holding inventory to guarantee availability). The right turnover depends on your strategy and industry. Benchmark against competitors and your past performance, not a universal "best" rate.
Different product categories turn at different rates. Perishables turn very fast (groceries: 10-20x per year). Fashion turns slower (4-8x per year). Capital equipment turns very slowly (1-2x per year). Don't compare your grocery turnover to your equipment turnover; they're incomparable. Segment by product category.
Inventory velocity has working capital implications. Slow inventory ties up cash. But fast inventory might require frequent reorders and higher order fees. There's an optimal inventory level that minimizes total cost (storage + ordering + stockout risk). Calculate the full working capital impact, not just turnover.
Clearance sales distort turnover. If you discount inventory heavily at year-end to clear stock, COGS spikes and turnover appears to improve. But you're destroying margin. For accurate turnover analysis, exclude clearance sales or account for margin impact separately.
*This inventory turnover calculator measures the efficiency of your inventory conversion to sales. Actual turnover optimization requires analyzing demand forecasting, supplier lead times, order quantities, storage costs, and stockout risks. This calculator measures; optimization requires deeper supply chain analysis. Consult a supply chain professional for inventory optimization strategies.*
Frequently Asked Questions
What's a good inventory turnover ratio?
Depends entirely on your industry. Grocery stores: 10-15x per year. Retail clothing: 3-6x per year. Auto dealers: 4-8x per year. Industrial manufacturing: 2-4x per year. Higher turnover generally means more efficient capital use, but very high turnover might indicate under-stocking. Know your industry benchmark and trend your own performance year-over-year.
How do I improve inventory turnover?
1) Demand forecasting: stock what sells, not what you predict. 2) Reduce lead times: negotiate faster supplier delivery or keep safety stock lower. 3) Pricing: mark down slow-moving items to accelerate sales. 4) Marketing: promote inventory to move it faster. 5) Product mix: discontinue slow sellers, double down on fast sellers.
Should I use COGS at cost or retail price?
Always use COGS (at cost). Retail price inflates the numerator and distorts the ratio. Inventory is valued at cost (what you paid), not retail price (what you're selling for). This ensures true apples-to-apples comparison across companies and years.
How does inventory turnover relate to profitability?
Faster turnover ties up less capital, freeing cash for operations, debt repayment, or marketing. But turnover alone doesn't determine profitability-margin does. You could have a 10x turnover on 10% margin (less profitable) or 5x turnover on 40% margin (more profitable). Both metrics matter.
What if my inventory increased year-over-year but revenue stayed flat?
Your turnover dropped, which is a red flag. You're holding more inventory but selling the same amount-cash is tied up. Investigate: Did you over-purchase? Did demand drop? Did a product line underperform? Address the root cause by adjusting purchasing or clearing slow-moving inventory.
How does inventory turnover affect cash flow?
Slower turnover means cash is locked up in inventory longer. If you buy inventory on credit but sell it slowly, you pay suppliers before you get customer cash, creating a cash flow gap. Faster turnover closes that gap. Improving turnover by 10% can free up 10% of inventory value in cash.
Should I measure turnover by week, month, or year?
Year is standard for annual comparison. But measure monthly or by season to catch trends early. If turnover has been 6x for three years but drops to 5x this year, something changed. Monthly tracking lets you spot and fix issues before they compound.
What's the relationship between DIO and working capital?
Days Inventory Outstanding is one component of the cash conversion cycle (along with days sales outstanding and days payable outstanding). Faster DIO (fewer days inventory outstanding) improves cash conversion and working capital efficiency. Reducing DIO from 40 to 30 days can have a significant cash flow impact.
Related Calculators
Use the working capital calculator to see how inventory efficiency affects your overall working capital needs. Check the profit margin calculator to see the relationship between turnover and margin. The pricing calculator helps you understand how pricing affects inventory velocity (discounts accelerate turnover).