Inventory Turnover Calculator
Calculate inventory turnover ratio, days sales of inventory, and get an efficiency rating for your inventory management.
Results
Visualization
How It Works
The Inventory Turnover Calculator measures how efficiently your business sells and replaces its inventory by calculating how many times you've sold through your average stock in a given period. This metric is crucial for business owners and managers because it reveals whether you're holding too much dead stock, moving inventory too slowly, or optimizing your supply chain effectively. This tool is designed for both quick estimates and detailed planning scenarios. Results update instantly as you adjust inputs, making it easy to compare different approaches and understand how each variable affects the outcome. For best accuracy, use precise measurements rather than rough estimates, and consider running multiple scenarios to establish a realistic range of expected results.
The Formula
Variables
- COGS — Cost of Goods Sold — the total cost of producing or purchasing the goods that were actually sold during the period (excludes operating expenses like salaries and rent)
- Average Inventory — The mean value of your inventory at the beginning and end of a period, calculated as (Beginning Inventory + Ending Inventory) / 2
- Inventory Turnover Ratio — The number of times your business completely sold and replaced its inventory during a specific period—higher numbers generally indicate faster-moving inventory
- Days Sales of Inventory (DSI) — The average number of days it takes to sell through your entire inventory stock, also called inventory conversion period
- Efficiency Rating — A qualitative assessment of your inventory turnover performance relative to typical benchmarks for your industry, ranging from poor to excellent
Worked Example
Let's say you run a mid-sized electronics retailer. During 2023, your Cost of Goods Sold was $480,000. At the beginning of the year, your inventory was valued at $65,000, and at year-end it was $75,000, making your average inventory $70,000. Your Inventory Turnover Ratio is $480,000 ÷ $70,000 = 6.86, meaning you completely sold and replaced your inventory nearly 7 times that year. To find how many days this represents, you calculate 365 ÷ 6.86 = 53.2 days—meaning it takes about 53 days on average to sell through your entire stock. Based on industry standards for electronics retail (typically 4-8 times annually), your efficiency rating would be good, indicating healthy inventory management without excess holding costs.
Practical Tips
- Compare your inventory turnover ratio to your specific industry benchmark, not to other industries—a grocery store turning inventory 12 times yearly is normal, but a furniture store turning it 2 times yearly is also healthy. Use resources like your industry association or financial databases to find your sector's average.
- Watch for seasonality in your numbers; if your business has peak seasons (like retail at Christmas), calculate turnover for each quarter separately rather than just annually to catch slow-moving inventory during off-peak months.
- A very high inventory turnover ratio isn't always good—it might indicate you're holding too little inventory and losing sales to stockouts. Balance efficiency with customer availability to ensure you're meeting demand without constant back orders.
- Use Days Sales of Inventory to plan cash flow; if your DSI is 45 days, you need enough working capital to fund inventory for 45 days before you recoup that investment through sales.
- Track your turnover ratio monthly or quarterly rather than just annually. This helps you identify inventory problems (like slow-selling SKUs) quickly enough to take corrective action before the products become obsolete or spoil.
Frequently Asked Questions
What is a good inventory turnover ratio for my business?
The ideal ratio varies significantly by industry. Grocery stores typically range from 8-12 times per year, electronics retailers 4-8 times, furniture stores 2-4 times, and pharmaceutical distributors 4-6 times. Check industry reports specific to your sector and compare your ratio to competitors' publicly available data. Generally, a ratio that's higher than your industry average suggests strong sales efficiency, while one that's lower might indicate overstocking or declining demand.
Why is Days Sales of Inventory important for cash flow?
DSI tells you how long your cash is tied up in inventory before you sell it and collect payment. If your DSI is 60 days, you need sufficient working capital to purchase or manufacture inventory for 60 days of operations before that inventory generates revenue. This is especially critical for businesses with thin margins or seasonal patterns, as miscalculating DSI can lead to cash flow crises.
How do I calculate average inventory if I don't have inventory at the beginning and end?
If you have monthly inventory values, add them all together and divide by 12 to get a more accurate average. For example, if you have inventory counts for each month of the year, sum all 12 values and divide by 12 rather than using just beginning and ending values. This smooths out temporary spikes or dips from seasonal buying or large orders.
Should I use COGS or revenue for the inventory turnover calculation?
Always use Cost of Goods Sold (COGS), not revenue or sales. COGS and inventory are both valued at cost, so they're comparable on the same basis. Using revenue (which includes markup) would inflate your turnover ratio artificially and make your inventory management appear more efficient than it actually is.
What does a low inventory turnover ratio tell me about my business?
A low ratio can signal several issues: slow-moving or obsolete products that aren't selling, overstocking relative to demand, poor sales and marketing efforts, or increased competition taking your market share. It can also indicate high carrying costs (storage, insurance, handling) and increased risk of inventory shrinkage, spoilage, or obsolescence. Investigate which products are slow-moving and consider discounting, donating, or discontinuing them.
Sources
- U.S. Small Business Administration — Inventory Management Guide
- Financial Accounting Standards Board (FASB) — Inventory Valuation Standards
- Investopedia — Inventory Turnover Ratio Definition and Uses
- SCORE — Free Business Mentoring on Working Capital and Inventory
- Journal of Accountancy — Working Capital Management and Inventory Efficiency