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.
Articles for you
September 26, 2020
When Can Employers Submit PPP Loan Forgiveness Application?
When the Coronavirus Aid, Relief, and Economic Security Act (also known as the CARES Act) was passed in late March...
Read more
September 25, 2020
How to Make Social Distancing Work For Your Business
Since March, the COVID-19 pandemic has completely changed the way we do business. Implementing social distancing...
Read more
August 24, 2020
Everything To Know About National Small Business Week This September
Renewed federal assistance to people and businesses hurt by the Coronavirus Pandemic is bogged down in the U.S. Congress...
Read more