Skip to main content
KnowYourNut. Know your nut. Run your business.
Back to Calculators
Free forever. Built by small business consultants. No signup required.

Inventory Turnover Calculator

What is a good inventory turnover ratio? Inventory turnover measures how many times your business sells and replaces its stock in a given period. The formula is: Inventory Turnover = Cost of Goods Sold / Average Inventory Value. A higher ratio means you are selling inventory quickly; a lower ratio means stock is sitting on shelves and tying up cash.

A related metric is Days Sales of Inventory (DSI), which tells you how many days it takes to sell your average inventory: DSI = 365 / Turnover Ratio. The ideal ratio varies significantly by industry, which is why benchmarking matters.

What this means for your business

Good inventory turnover benchmarks by industry: grocery stores target 14-20x, restaurants 12-16x, e-commerce 6-10x, general retail 4-6x, and manufacturing 4-8x. Carrying inventory costs roughly 25% of its value per year in storage, insurance, depreciation, and opportunity cost. If your ratio is below your industry benchmark, you may be overstocking or carrying dead inventory.

Inventory Turnover Calculator

See how fast your inventory sells and what it costs to hold.

$
$

What Is Inventory Turnover and How Do You Calculate It?

Inventory turnover measures how many times your business sells and replaces its entire inventory over a period, usually a year. If your turnover is 6, you sell through your full stock six times annually. A higher ratio means products move quickly and cash is not trapped on shelves. A lower ratio may signal overstocking, weak demand, or pricing problems. For most retail and ecommerce businesses, inventory turnover is one of the most important metrics to track because it directly determines how much working capital you need.

Key Terms Defined

  • Inventory Turnover Ratio: The number of times your inventory is sold and replaced in a given period. Higher is generally better, though it depends on your industry.
  • Days Sales of Inventory (DSI): The average number of days it takes to sell your entire inventory. Lower DSI means faster sales. Formula: DSI = 365 / Inventory Turnover Ratio.
  • Cost of Goods Sold (COGS): The direct cost of producing or purchasing the products you sell, including materials, manufacturing, and freight.
  • Average Inventory Value: The average dollar value of inventory you hold over the period. Calculate as: (Beginning Inventory + Ending Inventory) / 2.
  • Carrying Cost: The total annual expense of storing unsold inventory, including warehousing, insurance, depreciation, and the opportunity cost of tied-up capital. This typically runs 20-30% of your average inventory value per year.

The Formula

Inventory Turnover = Cost of Goods Sold / Average Inventory Value

For example, if your annual COGS is $240,000 and your average inventory value is $40,000, your turnover is 6.0. That means you sell through your stock every 61 days (365 / 6).

How to Use This Calculator

  1. Enter your annual Cost of Goods Sold. Pull this from your profit and loss statement or accounting software.
  2. Enter your average inventory value. If you do not know the average, use the value from your most recent balance sheet.
  3. Review your turnover ratio. The calculator shows how many times you turn inventory annually and your DSI.
  4. Check your carrying cost estimate. See how much your unsold inventory is costing you each year.
  5. Compare to industry benchmarks. Use the table below to see where you stand.

Industry Benchmarks

| Industry | Typical Turnover | Target DSI | |----------|-----------------|-----------| | Grocery / Perishables | 14-20x | 18-26 days | | Restaurant / Food Service | 12-16x | 23-30 days | | E-commerce (general) | 6-10x | 37-61 days | | Retail (general) | 4-6x | 61-91 days | | Specialty / Luxury Retail | 2-4x | 91-182 days |

A Real-World Example

A retail boutique has $180,000 in annual COGS. Beginning inventory was $50,000 and ending inventory was $40,000, so average inventory is $45,000. Turnover = $180,000 / $45,000 = 4.0, with a DSI of 91 days.

That is on the lower end for retail. At a 25% carrying cost, the boutique is spending $11,250 per year just to hold inventory. If the owner can reduce average inventory to $30,000 (turnover of 6.0, DSI of 61 days), carrying cost drops to $7,500, freeing $15,000 in working capital and saving $3,750 annually.

How to Improve Inventory Turnover

  1. Identify dead stock. Run reports to find items that have not sold in 90+ days. Discount or liquidate them to free up cash.
  2. Order smaller quantities more frequently. This reduces the capital sitting on your shelves and lowers carrying costs.
  3. Negotiate shorter supplier lead times. Faster delivery means you can carry less safety stock.
  4. Use demand forecasting. Track seasonal patterns and adjust orders before slow periods hit. Do not restock winter items in March.
  5. Test price points. Items priced too high sit on shelves. Sometimes a small price reduction dramatically increases velocity.
  6. Drop underperforming SKUs. Focus your shelf space and cash on products that actually move.

When High Turnover Is a Problem

Very high turnover can mean you are running too lean. If you frequently stock out, you lose sales and frustrate customers. The goal is a healthy balance between efficiency and availability. Track your stockout rate alongside turnover to find the right balance for your business.

What This Means for Your Business

Inventory is cash sitting on a shelf. Every dollar in unsold product is a dollar that cannot cover payroll, rent, or growth. Improving your turnover from 4x to 6x on $45,000 of average inventory frees up $15,000 in working capital without increasing revenue.

Your inventory turnover directly affects your cash flow. Use the Cash Flow Forecast to see how improving turnover frees up working capital across the year. If your margins feel thin despite decent revenue, check your COGS and then your turnover. The problem may not be pricing: it may be what is sitting on your shelves.

Related Calculators

Frequently Asked Questions

Inventory Turnover Calculator by Industry

Pre-filled with real industry benchmarks โ€“ pick your industry to get started faster.

๐Ÿฝ๏ธ
RestaurantReal restaurant benchmarks
๐Ÿช
RetailReal retail benchmarks
๐Ÿ”จ
ConstructionReal construction benchmarks
๐ŸŒฟ
LandscapingReal landscaping benchmarks
๐Ÿ›’
E-commerceReal e-commerce benchmarks
๐Ÿ’ผ
ConsultingReal consulting benchmarks
โœ‚๏ธ
SalonReal salon benchmarks
๐Ÿงน
Cleaning ServiceReal cleaning service benchmarks
๐Ÿšš
Food TruckReal food truck benchmarks
๐Ÿข
FranchiseReal franchise benchmarks
๐Ÿก
Single-FamilyReal single-family benchmarks
๐Ÿ˜๏ธ
DuplexReal duplex benchmarks
๐Ÿข
Multi-FamilyReal multi-family benchmarks
๐Ÿ›๏ธ
Airbnb / Short-Term RentalReal airbnb / short-term rental benchmarks
๐Ÿ‹๏ธ
Fitness / GymReal fitness / gym benchmarks
๐Ÿพ
Pet ServicesReal pet services benchmarks
๐Ÿ‘ถ
ChildcareReal childcare benchmarks
๐Ÿฑ
CateringReal catering benchmarks
๐Ÿ”ง
Auto RepairReal auto repair benchmarks
Real EstateReal real estate benchmarks
๐Ÿ 
Real Estate InvestingReal real estate investing benchmarks
ManufacturingReal manufacturing benchmarks
Professional ServicesReal professional services benchmarks
๐Ÿ”ง
Home ServicesReal home services benchmarks
SaaSReal saas benchmarks
HealthcareReal healthcare benchmarks
DentalReal dental benchmarks
โ„๏ธ
HVACReal hvac benchmarks
๐Ÿš›
TruckingReal trucking benchmarks
๐Ÿ”ง
PlumbingReal plumbing benchmarks
โšก
ElectricalReal electrical benchmarks
๐Ÿ›
Pest ControlReal pest control benchmarks
๐Ÿ—๏ธ
RoofingReal roofing benchmarks
๐ŸŽจ
PaintingReal painting benchmarks
๐Ÿ“Š
Accounting FirmReal accounting firm benchmarks
โš–๏ธ
Law FirmReal law firm benchmarks
๐Ÿ“ฃ
Marketing AgencyReal marketing agency benchmarks
๐Ÿ›ก๏ธ
Insurance AgencyReal insurance agency benchmarks
๐Ÿง
BakeryReal bakery benchmarks
โ˜•
Coffee ShopReal coffee shop benchmarks
๐Ÿบ
Bar / BreweryReal bar / brewery benchmarks
๐Ÿ‘ถ
DaycareReal daycare benchmarks
๐Ÿฆท
Dental PracticeReal dental practice benchmarks
๐Ÿฅ
Medical PracticeReal medical practice benchmarks
๐Ÿ•
Veterinary PracticeReal veterinary practice benchmarks
๐Ÿ“ธ
PhotographyReal photography benchmarks
๐Ÿ’
Wedding & EventsReal wedding & events benchmarks
๐Ÿš—
Car WashReal car wash benchmarks
๐Ÿ‘•
LaundromatReal laundromat benchmarks
๐Ÿ“š
TutoringReal tutoring benchmarks
๐Ÿ“ฆ
Moving CompanyReal moving company benchmarks
๐ŸŒธ
FloristReal florist benchmarks
โœ’๏ธ
Tattoo StudioReal tattoo studio benchmarks
๐Ÿ’ˆ
BarbershopReal barbershop benchmarks
๐Ÿ’ฆ
Pressure WashingReal pressure washing benchmarks
๐ŸŒณ
Tree ServiceReal tree service benchmarks
ConsultingReal consulting benchmarks
ConsultingReal consulting benchmarks

Related Articles