Inventory turnover formula
Divide cost of goods sold by average inventory. Average inventory is beginning inventory plus ending inventory divided by two.
Calculate inventory turnover and estimated days on hand from COGS and average inventory for a defined reporting period.
Inventory turnover
4.00×91.3 estimated days on hand.THE PACE OF WORKING CAPITAL
Turnover connects the cost of what sold with the average inventory investment that supported those sales.

THE FIELD NOTES
Use the result now, then read the practical notes for assumptions, examples, limitations, and the choices behind it.
$240k COGS · $60k average inventory · 91.3 days on hand
Divide cost of goods sold by average inventory. Average inventory is beginning inventory plus ending inventory divided by two.
Divide the days in the reporting period by turnover. Four annual turns correspond to about 91.3 days on hand.
Use values from the same entity, locations, category, currency, and period. Do not compare annual COGS with one month of inventory or retail-value inventory with cost-basis COGS.
Higher turnover can indicate efficient stock use, but it can also signal understocking. Lower turnover can mean excess or aging stock, but deliberate safety stock and seasonal builds may be rational.
THE PRODUCT IS NEXT
Divide cost of goods sold by average inventory. Average inventory is beginning inventory plus ending inventory divided by two.
If COGS is $240,000 and average inventory is $60,000, turnover is 4.0 times during the stated period.
Divide the days in the reporting period by turnover. Four annual turns correspond to about 91.3 days on hand.
The estimate describes an average. Individual SKUs can move far faster or slower than the blended portfolio.
Use values from the same entity, locations, category, currency, and period. Do not compare annual COGS with one month of inventory or retail-value inventory with cost-basis COGS.
A two-point average is simple but can hide large seasonal swings. Monthly or more frequent averages can better represent a volatile business.
Higher turnover can indicate efficient stock use, but it can also signal understocking. Lower turnover can mean excess or aging stock, but deliberate safety stock and seasonal builds may be rational.
Compare the result with service levels, stockouts, gross margin, lead times, and category benchmarks before changing purchasing policy.
Inventory turnover estimates how many times average inventory is sold or used during the selected reporting period.
Use inventory at cost when the numerator is cost of goods sold. Mixing cost and retail values makes the ratio inconsistent.
There is no universal target. Healthy turnover depends on category, margin, seasonality, lead time, service goals, and stockout risk.
BUILT BY LOOK ATLAS
Turn a simple product photo into polished, campaign-ready creative for your store, ads, and social channels. No studio. No reshoots.
Create your first shoot free, then keep going when you’re ready.