Planning calculator

Inventory Turns Calculator

Find how many times your inventory turns a year and how many days of COGS it holds. You need 12 months of COGS, inventory at cost at both ends, your target turns and carrying rate.

What this calculator does

  • Annual inventory turns and days of supply, checked against your target, with the cash and carrying cost above it.

Formula used

  • Average inventory = (beginning inventory + ending inventory) ÷ 2
  • Inventory turns = annual COGS ÷ average inventory
  • Days of supply = 365 ÷ inventory turns
  • Inventory at target = annual COGS ÷ target turns; inventory above target = MAX(0, average inventory − inventory at target)
  • Annual carrying cost of the excess = inventory above target × carrying cost rate ÷ 100; COGS per day = annual COGS ÷ 365

Inputs explained

  • Annual Cost of Goods Sold: Trailing 12 months from the income statement, at cost.
  • Beginning Inventory: Total inventory at cost on the balance sheet 12 months ago.
  • Ending Inventory: Total inventory at cost on the latest balance sheet.
  • Target Turns: The turns goal in your budget or operating plan.
  • Carrying Cost Rate: Finance's annual holding cost as a percent of inventory value.

How to use the result

  • Best suited to setting an inventory reduction target for the budget, sizing the cash a turns program releases.
  • A blended figure hides slow items: a plant can meet its turns target while dead stock sits in one class. Carrying cost is treated as proportional to value; rent and staff costs fall only when space or people are freed.

Current U.S. benchmarks

  • U.S. manufacturing runs at 75.7% of capacity (Federal Reserve, Aug 2026). New factory orders are up 8.5% year over year (Census).

Common questions

  • Should I use sales or COGS for inventory turns? Use COGS, because inventory is carried at cost. Sales include margin, so sales divided by inventory at cost overstates turns. Some industry data compilers use sales; match their basis only when you benchmark against them.
  • What turns target should a manufacturer set? Set it from your own trend and plan, not a universal number. Turns depend on product variety, supply chain structure and whether you build to stock or to order, so compare only with plants like yours.
  • Can inventory turns be too high? Yes, when stockouts, expediting or missed shipments come with them. Turns bought with a starved line can cost more than the carrying cost they save. Check line-down events and premium freight before you raise the target again.
  • Why 365 days and not working days for days of supply? Because annual COGS accrues over the calendar year, so 365 keeps both terms on one basis. For production days, multiply days of supply by your production days per year ÷ 365: at 250, 60.8 calendar days is about 41.7.
  • What is a good inventory turns? Typical Inventory turns runs 4-6 (turns per year); 6-10 is good, and 12+ is world-class. Highly sector-dependent: high-volume consumer goods run far higher, heavy equipment and aerospace far lower. Compare against your own sector before acting.

Related guides

Last reviewed 2026-10-01.