This inventory turnover calculator measures how efficiently a business converts inventory into cost of goods sold. Choose beginning and ending inventory or enter average inventory directly, then calculate turnover, days inventory outstanding, monthly turnover, daily COGS, inventory-to-sales percentage, and target gaps.
Inventory turnover = Cost of goods sold (COGS) ÷ Average inventory. Days in inventory = Days in period ÷ Inventory turnover.
Inventory efficiency results
Inventory turnover calculator formulas and symbols
EI = Ending inventory
AI = Average inventory = (BI + EI) ÷ 2
COGS = Cost of goods sold for the analysis period
ITR = Inventory turnover ratio = COGS ÷ AI
DIO = Days inventory outstanding = Days in period ÷ ITR
Inventory-to-sales % = AI ÷ Net sales × 100
Target inventory = COGS ÷ Target turnover
The inventory turnover calculator uses COGS rather than revenue because inventory is normally carried at cost. If detailed monthly inventory balances are available, their average can be more representative than a simple beginning-and-ending average, especially for seasonal businesses.
Worked inventory turnover example
Assume annual COGS is $600,000, beginning inventory is $100,000, and ending inventory is $140,000. Average inventory is ($100,000 + $140,000) ÷ 2 = $120,000.
Inventory turnover is $600,000 ÷ $120,000 = 5.00 times. Days in inventory is 365 ÷ 5 = 73 days. If management targets 6 turns, target average inventory is $600,000 ÷ 6 = $100,000, which is $20,000 below the calculated average.
How to interpret inventory turnover
| Result | Possible meaning | What to check |
|---|---|---|
| Higher turnover | Inventory is converted into sales more frequently. | Confirm stockouts, lost sales, expedited freight, and supplier risk are controlled. |
| Lower turnover | More capital is tied up in inventory for longer. | Review slow-moving, obsolete, seasonal, or safety stock. |
| Fewer days in inventory | Shorter average holding period. | Compare against lead times and required service levels. |
| More days in inventory | Longer cash commitment before sale. | Check forecasts, product mix, purchasing quantities, and markdown risk. |
There is no universal good inventory turnover ratio. Grocery retailers, machinery manufacturers, luxury sellers, and seasonal businesses have very different economics. Compare the same company across equivalent periods and use industry peers with similar products, accounting methods, and supply-chain constraints.
How to improve the inventory turnover calculator result responsibly
- Segment stock with ABC analysis and focus controls on high-value or high-risk items.
- Improve demand forecasts with recent sales, promotions, seasonality, and lead-time data.
- Set reorder points and safety stock from actual variability instead of one fixed percentage.
- Negotiate smaller, more frequent replenishment orders where total cost supports it.
- Identify obsolete and slow-moving products early and create a documented disposition plan.
- Coordinate sales, purchasing, production, and finance through a regular planning cycle.
Do not chase a higher inventory turnover calculator result in isolation. Inventory that is too lean can create stockouts, production interruptions, poor customer service, and higher rush-order costs. The best level balances working capital, margin, supply reliability, and customer demand.
Using the inventory turnover calculator correctly
Use values from the same accounting period and on the same valuation basis. Match annual COGS with annual average inventory; do not divide annual COGS by a single monthly figure unless that month reasonably represents the year. For quarterly analysis, use quarterly COGS and the number of days in that quarter.
The inventory turnover calculator is useful during monthly close, budget reviews, purchasing decisions, lender reporting, and operational planning. Run separate scenarios for product groups or locations when consolidated totals hide important differences. A trend is usually more informative than one isolated result.
Inventory turnover calculator assumptions and limitations
This inventory turnover calculator assumes non-negative inputs and a positive average inventory. It does not adjust for FIFO, LIFO, weighted-average costing, write-downs, consignment stock, acquisitions, discontinued products, foreign-exchange changes, or differences in gross margin. A zero or negative average inventory makes turnover mathematically undefined.
For formal reporting, reconcile every input to the ledger and applicable accounting policies. Inventory classifications and valuation requirements may differ by jurisdiction and contract. Results are educational planning estimates, not accounting, tax, investment, lending, or legal advice. See the inventory turnover overview for additional background.
Inventory turnover calculator FAQs
What is inventory turnover?
Inventory turnover is COGS divided by average inventory. It estimates how many times the average inventory balance is sold or used during the period.
Should I use sales or COGS?
Use COGS for the standard ratio because both COGS and inventory are measured at cost. A sales-based ratio can be distorted by gross margin.
Why use average inventory?
Inventory changes during the period. An average reduces the distortion that can occur when only the ending balance is used.
How do I calculate days in inventory?
Divide the number of days in the analysis period by inventory turnover. For an annual period, businesses commonly use 365 days.
Is higher inventory turnover always better?
No. Higher turnover may reflect efficiency, but turnover that is too high can indicate insufficient safety stock or recurring stockouts.
Can I compare two companies?
Yes, but compare similar companies using consistent periods and inventory accounting methods. Product mix and supply-chain structure can materially affect the ratio.