Knowing how to calculate inventory turnover will help ensure that your store has proper controls in place. On this page a basic formula and an advance formula are featured. Also included is a video that walks you through both the basic and advanced versions with real world application examples.
Turnover Ratio Formula (basic)
Inventory Turnover Ratio = Net Sales / Average StockExample:
Net Sales: $220,000
Average Stock: $80,000
or $220,000 / $80,000 = 2.75
What does it mean? This ratio means that inventory is sold almost three times per year.
Here's a great video from About.com on how to calculate inventory turnover.
Alternative way to calculate (more advanced)
- Take Beginning Inventory at Cost
- Add Purchases at Cost
- Subtract Ending Inventory at Cost
- Subtract the Cost of Lost or Scrapped Items
- Divide by the Cost of Sales
For more information on this topic, Wikipedia has some good resources: http://en.wikipedia.org/wiki/Inventory_turnover