About the Inventory Turnover
This calculator shows how many times a business sells through and replaces its entire inventory over the course of a year, using cost of goods sold and average inventory value. It is a standard financial ratio used by retailers, distributors, and manufacturers to judge whether stock is moving at a healthy pace or sitting idle on shelves.
How It Works
You enter your Cost of Goods Sold (COGS) for the period and your Average Inventory Value on hand during that same period. The calculator divides COGS by average inventory to get the turnover ratio, then divides 365 by that ratio to show the average number of days a unit sits in inventory before it sells.
Formula & Methodology
Start with your COGS figure for the period you are measuring, typically a fiscal year. Average inventory should reflect a representative value over that same period, often calculated as (beginning inventory + ending inventory) / 2, rather than a single snapshot that could be skewed by a seasonal high or low. Divide COGS by that average inventory figure to get turns per year, then divide 365 by the turns figure to translate the ratio into a days-on-hand number that is easier to compare against supplier lead times or shelf life.
Examples
Mid-size apparel retailer
A retailer reports $480,000 in annual COGS and $80,000 in average inventory value. Dividing gives a turnover ratio of 6.0x per year, meaning inventory turns over six times annually, or about 61 days on hand (365 / 6.0).
Slow-moving specialty goods
A specialty furniture seller has $150,000 in COGS and carries $100,000 in average inventory. That works out to a turnover ratio of 1.5x, or roughly 243 days to sell through a given batch of stock, reflecting the naturally slower pace of big-ticket, low-frequency purchases.
Advantages
- Converts two accounting figures already tracked by most businesses into a single, comparable efficiency metric.
- Translates the abstract turnover ratio into a concrete days-on-hand figure that is easier to weigh against supplier lead times.
- Provides a consistent way to track inventory efficiency over multiple periods to catch a slowdown before it becomes a cash problem.
Common Mistakes
- Using ending inventory instead of a true period average, which overstates or understates turnover depending on when the snapshot was taken.
- Comparing the resulting ratio directly against a different industry's benchmark without accounting for how inventory type affects normal turnover speed.
- Treating a rising ratio as automatically good without checking whether it is being driven by stockouts and lost sales rather than genuine demand.
Edge Cases to Watch For
- If average inventory is entered as zero, the calculator blocks the calculation and returns an error, since dividing by zero is undefined.
- Using an ending-inventory-only figure instead of a true period average can distort the ratio if inventory levels fluctuate seasonally.
- A very high turnover paired with frequent stockouts may signal understocking rather than genuine sales efficiency, something this ratio alone cannot distinguish.
- Comparing turnover ratios across industries with very different inventory types, such as perishables versus durable goods, is not meaningful without adjusting expectations for each category.
Common Use Cases
- Retail and e-commerce operators checking whether merchandise is moving fast enough to justify current stocking levels.
- Wholesale and distribution businesses monitoring how efficiently warehoused goods convert into sales over time.
- Lenders and investors reviewing a company's inventory management as part of assessing operational efficiency.