Inventory Turnover Calculator

What is inventory turnover?

The inventory turnover ratio shows how often your business sells through its average inventory during a period. This inventory turnover calculator uses your cost of goods sold and average inventory to calculate the ratio, then estimates days inventory outstanding, or DIO.

A higher ratio means your stock is moving faster relative to its average value. DIO expresses the same general idea as time: it estimates how many days inventory remains on hand before it sells. Neither figure tells the whole story. A product that sells slowly may be essential to your customers, while selling too quickly can leave you short of stock.

Why inventory turnover matters

Inventory ties up cash that could otherwise cover payroll, supplier bills, loan payments, or planned purchases. If stock sits too long, you may also face storage costs, damage, spoilage, or markdowns. Turnover and DIO help you spot whether purchasing and sales are keeping pace with each other.

Use the ratio when reviewing purchase orders, pricing, and cash-flow plans. If inventory is moving slowly, consider reducing future orders, negotiating smaller or more frequent deliveries, or discounting products that are taking up space. If it is moving quickly, check whether customers are waiting for restocks or whether you are missing sales.

The right result depends on your products, sales patterns, and suppliers. Compare your own results over consistent periods and with published data for your industry. A single company-wide ratio can also hide differences between products, so review important product groups separately when you can.

How to use this inventory turnover calculator

1. Enter cost of goods sold for the period. Use the cost assigned to the goods sold during that same period, not sales revenue.
2. Enter beginning inventory and ending inventory for the period. Use inventory values prepared on a consistent basis.
3. Enter the number of days in the period. The sample uses 365 days for a year; for another period, use the matching number of days.
4. Review the inventory turnover ratio and DIO. The calculator also shows average inventory and an estimate of inventory freed per day of DIO reduced.
5. Compare the result with an equivalent period in your records. If your business has seasonal sales, compare like periods where possible and review inventory changes during the period, not just the endpoints.

Inventory turnover calculator example

How to read your inventory turnover results

Inventory turnover is cost of goods sold divided by average inventory. Average inventory is beginning inventory plus ending inventory, divided by two. DIO is the days in the period divided by inventory turnover. A larger turnover ratio generally corresponds to fewer days on hand.

Treat the figures as a starting point for decisions, not a target to maximize. A falling ratio or rising DIO can prompt a review of purchasing, demand, product mix, and pricing. A rising ratio or falling DIO can be a good sign, but check for stockouts, delayed deliveries, or customers who cannot find what they want.

How to improve inventory turnover

1. 01

   Match orders to actual demand

   Review sales by product and adjust purchase orders for items that repeatedly sit unsold. Ask suppliers about smaller or more frequent deliveries so you can replenish without holding as much stock.

2. 02

   Act on slow-moving stock

   Identify products with weak sales and test a targeted promotion, bundle, or price change. Before discounting, check the effect on your margin and whether the product supports sales of other items.

3. 03

   Reduce avoidable delays

   Check how long it takes to place orders, receive deliveries, and get stock ready to sell. Renegotiate supplier terms or delivery schedules when delays force you to order more inventory than you need.

4. 04

   Protect availability on fast sellers

   Track products that sell quickly and plan restocking before shelves run empty. Faster turnover is not an improvement if it causes missed sales or pushes customers to another supplier.

5. 05

   Review purchasing and cash together

   Use the ratio alongside cash-flow forecasts and supplier payment dates. Avoid tying up cash in a large order unless the expected demand, storage needs, and payment terms make sense for your business.

Common inventory turnover mistakes

• Using sales instead of cost of goods sold

  The formula uses cost of goods sold, not revenue. Revenue includes the selling price and can make the ratio misleading.

• Mixing periods or valuation methods

  Use beginning inventory, ending inventory, and cost of goods sold from the same period. Keep the way you value inventory consistent when comparing results.

• Relying only on beginning and ending balances

  The average uses those two balances, but it may miss large swings during the period. If your business is seasonal or makes large purchases, review balances throughout the period as well.

• Treating a higher ratio as automatically better

  Fast movement can mean strong sales, but it can also mean understocking. Check service levels, backorders, and lost sales before changing your buying plan.

The inventory turnover formula

Key terms

Cost of goods sold

The cost assigned to the goods your business sold during the period.

Average inventory

Beginning inventory plus ending inventory, divided by two.

Inventory turnover ratio

Cost of goods sold divided by average inventory. It indicates how often inventory sells through during the period.

Days inventory outstanding

The number of days in the period divided by inventory turnover. It estimates how long inventory stays on hand before selling.