Calculate Inventory Turnover Ratio and Days to Sell Through

Enter cost of goods sold, average inventory, and the number of days in the period to calculate both the turnover ratio and estimated days to sell through. The result helps retailers, wholesalers, and ecommerce operators compare inventory efficiency across products or reporting periods without mixing revenue, units, or mismatched time windows.

Prepare matching figures for a meaningful ratio

Start with cost of goods sold for one clearly defined reporting period, not sales revenue. Cost of goods sold reflects the recorded cost of inventory that actually left the business, while revenue includes markup and therefore produces a different and usually inflated ratio. Next, calculate average inventory value for that same period. A common method is to add beginning inventory and ending inventory and divide by two, although a monthly or weekly average can be more representative when stock levels fluctuate sharply. Both values must use the same currency and the same valuation basis. If cost of goods sold covers a quarter, average inventory must describe that quarter rather than the full year. Enter the actual length of the reporting period in days; use 365 for a full non-leap year, 90 or 91 for many quarters, or the exact count used internally. Consistent inputs matter more than choosing a particular reporting frequency because the ratio is only comparable when its numerator and denominator describe the same operating window.

Understand the turnover and sell-through calculations

The inventory turnover ratio is cost of goods sold divided by average inventory value. For example, a ratio of four means the business moved inventory equal to four times its average inventory investment during the measured period. Days to sell through translates that ratio into time by dividing the number of days in the period by the turnover ratio. A four-times annual turnover therefore corresponds to 91.25 days. The calculator keeps the entered period visible in the output and rounds calculated figures to six decimal places for stable reporting. Average inventory cannot be zero because division by zero has no defined business meaning, and negative inventory values are also rejected. Cost of goods sold must be positive because a zero or negative value cannot produce a useful finite selling-duration estimate. These results describe aggregate flow, not the exact age of an individual item. They should be interpreted as operating indicators derived from accounting values rather than as a promise that every unit will sell within the displayed number of days.

Use the result in operational decisions

Compare turnover over time, against a planned target, or among categories with similar economics. A rising ratio and falling days-to-sell figure may indicate better purchasing discipline, stronger demand, fewer slow-moving products, or stock shortages; the calculator alone cannot identify which explanation applies. A low ratio can point to excess stock, weak sales, obsolete items, seasonal buildup, or a deliberate availability strategy. Always pair the result with stockout rates, gross margin, lead time, demand variability, and markdown activity before changing replenishment rules. Comparisons across unrelated industries can be misleading because grocery, apparel, luxury goods, and industrial parts naturally operate at different speeds. For seasonal businesses, compare equivalent periods year over year instead of treating one peak quarter as representative of an entire year. When automating the calculation, preserve the source period and valuation method with each result so reviewers can reproduce it. The browser calculation is convenient for individual checks, while API requests cost $0.002 each and support repeatable dashboards, scheduled reporting, and category-level monitoring.