Inventory Turn Time Calculator
Inventory turnover
Inventory Turn Time Calculator
Turn time refers to the period of time it takes a business to sell a product. The inventory turnover rate measures the number of times we have turned our inventory during the past 12 months.
The following formula determines the inventory turn time:
Inventory Turn Time = Cost of Goods Sold from Stock Sales during the Past 12 Months/ Average Inventory Investment during the Past 12 Months
Formula Notes:
- Cost of Goods Sold only includes orders shipped from a warehouse inventory. Direct shipments or special orders are not included because they are never "inventoried".
- Inventory turnover is based on what you pay for an item (acquisition cost), not the selling price.
To determine your average inventory investment:
- Calculate the total value of every product in inventory (quantity on-hand times cost) every month, on the same day of the month. Use consistent costing methods for COGS and average inventory investment.
- If your inventory levels fluctuate over a month time horizon, calculate your total inventory value on the first and fifteenth of every month.