Inventory turnover and days on hand calculator
Calculate inventory turnover and days of inventory on hand from cost of goods sold and average inventory at cost, with the formula and a worked example.
Plan an inventory project
Calculator
Inventory turnover measures how many times your average inventory is sold and replaced in a period. ASCM’s method is to “divide the annual cost of sales by the average inventory level.” Days on hand turns the same result into a figure that is easier to picture: how long, on average, a unit sits before it ships.
How to use the calculator
- Cost of goods sold for the period, from your income statement or ERP.
- Inventory at cost at the start and at the end of the same period.
- Days in the period: 365 for a year, 90 to 92 for a quarter, 28 to 31 for a month.
Use cost on both sides. Dividing sales revenue by inventory at cost inflates turns by the margin.
The formula
Average inventory = (beginning inventory + ending inventory) ÷ 2
Inventory turnover = cost of goods sold ÷ average inventory
Days on hand = days in the period ÷ inventory turnover
| Input | Example value |
|---|---|
| Cost of goods sold for the year | $8,400,000 |
| Inventory at cost, start of year | $1,500,000 |
| Inventory at cost, end of year | $1,300,000 |
| Days in the period | 365 |
Turns are for the period you enter. For a quarter, the calculator gives quarterly turns; multiply by 365 and divide by the days in the quarter to compare with an annual figure. Days on hand compares across period lengths without conversion.
Example (fictional). A distributor’s cost of goods sold for the year is $8.4 million. Inventory at cost was $1.5 million on January 1 and $1.3 million on December 31.
- Average inventory: ($1,500,000 + $1,300,000) ÷ 2 = $1,400,000
- Inventory turnover: $8,400,000 ÷ $1,400,000 = 6.00 turns
- Days on hand: 365 ÷ 6 = 60.8 days
Reading the result
Six turns means the average unit sits about two months. Whether that is good depends on the business. A distributor of fast-moving consumables and a distributor of spare parts will never post the same number, and neither should be judged against a published average without knowing what is inside it.
The more useful comparisons are with yourself, over time and by segment. In the example, eight turns at the same cost of goods sold would need an average inventory of $8,400,000 ÷ 8 = $1,050,000, which is $350,000 less stock. At the 22% rate used in the carrying cost calculator example, that is about $77,000 a year in holding cost, plus the cash released.
Common mistakes
- Revenue instead of cost. Turns calculated on sales look better than they are.
- A two-point average. If inventory is low at year end because of a count, write-downs or a seasonal trough, the average is too low and turns look too high. Average twelve month-end balances if you have them.
- One number for the whole business. A healthy overall rate can hide a block of stock that has not moved in a year behind a few very fast items.
- Turns bought with stockouts. Turnover rises when you run out. Read it next to fill rate, for example with the OTIF and fill rate calculator.
- Inconsistent scope. Decide whether consignment stock, goods in transit and stock at third-party warehouses are in or out, and keep the choice the same every period.
When the simple model stops working
- Seasonal businesses, where any single average hides the peak build. Use monthly averages and compare the same season year over year.
- Fast-growing businesses, where ending inventory is built for next year’s sales and this year’s cost of goods sold understates the need.
- Item-level decisions. Turnover is a summary. Decisions about what to stock need item-level velocity, ABC class and the age of each lot or receipt.
- Mixed costing methods, such as standard cost in one plant and average cost in another.
If turnover is hard to calculate because inventory values in different systems disagree, the issue is the records rather than the metric. An inventory management software project would start by reconciling them, and the inventory accuracy calculator is a quick way to measure the gap on the floor.
Scope your project.
Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.