Inventory Turnover Calculator Formula

Understand the math behind the inventory turnover calculator. Each variable explained with a worked example.

Use the Inventory Turnover Calculator

Formulas Used

Inventory Turnover

inventory_turnover = (inventory_start + inventory_end) > 0 ? cogs / ((inventory_start + inventory_end) / 2) : 0

Days to Sell Inventory

days_to_sell = (inventory_start + inventory_end) > 0 ? 365 / (cogs / ((inventory_start + inventory_end) / 2)) : 0

Average Inventory

avg_inventory = (inventory_start + inventory_end) / 2

Variables

VariableDescriptionDefault
cogsCost of Goods Sold (COGS)(USD)600000
inventory_startInventory (Beginning)(USD)80000
inventory_endInventory (End)(USD)120000

How It Works

How to Calculate Inventory Turnover

Formula

Inventory Turnover = Cost of Goods Sold / Average Inventory Days to Sell Inventory = 365 / Inventory Turnover

Inventory turnover tells you how many times you cycle through your entire stock during a year. Higher turnover means products sell quickly, tying up less cash in warehoused goods. The days-to-sell metric converts this into a more intuitive timeframe showing how long the average item sits before being sold.

Worked Example

A retailer has $600,000 in COGS. Inventory was $80,000 at the start of the year and $120,000 at the end.

cogs = 600000inventory_start = 80000inventory_end = 120000
  1. 01Average Inventory = ($80,000 + $120,000) / 2 = $100,000
  2. 02Inventory Turnover = $600,000 / $100,000 = 6.0
  3. 03Days to Sell = 365 / 6.0 = 60.8 days
  4. 04Inventory cycles through about 6 times per year.

When to Use This Formula

  • Evaluating how efficiently a business is managing its inventory — a higher turnover ratio means products are selling quickly rather than sitting on shelves tying up capital.
  • Comparing inventory management performance across competitors or industry benchmarks to identify whether you are overstocking or understocking relative to peers.
  • Identifying slow-moving inventory that may need markdowns, promotions, or discontinuation by calculating turnover ratios at the product or category level.
  • Making purchasing and production planning decisions — if turnover is high, you may need to increase order frequency or safety stock to avoid stockouts.
  • Calculating days sales of inventory (365 / turnover ratio) to express the result as the average number of days it takes to sell through inventory, which is often more intuitive for operational planning.
  • Assessing the impact of supply chain changes — after switching suppliers or adjusting lead times, tracking turnover reveals whether the change improved or worsened inventory efficiency.

Common Mistakes to Avoid

  • Using ending inventory instead of average inventory — COGS / ending inventory overstates turnover if inventory was unusually low at period-end (e.g., after a seasonal sale). Average inventory ((beginning + ending) / 2) smooths out fluctuations.
  • Using revenue instead of COGS in the numerator — revenue includes the markup, which inflates the turnover ratio. COGS represents the actual cost of the goods that moved, making it the correct numerator for a meaningful ratio.
  • Comparing turnover ratios across industries without context — a grocery store might turn inventory 15-20 times per year while a jewelry store turns it 1-2 times. Neither is inherently better; the appropriate ratio depends on the industry.
  • Ignoring seasonality — calculating turnover over a period that includes a holiday sales spike but using year-round average inventory gives a misleadingly high ratio. Match the time period of COGS to the corresponding average inventory.
  • Assuming higher turnover is always better — extremely high turnover can indicate chronic understocking, leading to stockouts, lost sales, and unhappy customers. The goal is the right balance, not the highest possible number.

Frequently Asked Questions

Is higher inventory turnover always better?

Generally yes, but extremely high turnover might signal understocking, which leads to stockouts and lost sales. The ideal rate balances efficient stock management with meeting customer demand.

Why use COGS instead of revenue?

COGS measures inventory at cost, which aligns with how inventory is valued on the balance sheet. Using revenue would inflate the ratio because it includes profit margin.

Learn More

Guide

Understanding Financial Ratios

Learn the most important financial ratios for evaluating business health. Covers liquidity, profitability, efficiency, and leverage ratios with formulas and benchmarks.

Ready to run the numbers?

Open Inventory Turnover Calculator