Inventory turnover and days calculator
Enter the cost of goods sold for a period and your stock value at the start and the end. See your average stock, how many times it turned over and how many days it sat.
How inventory turnover is worked out
- Average inventory
- Average inventory = (opening stock + closing stock) ÷ 2.
- Turnover
- Inventory turnover = cost of goods sold ÷ average inventory.
- Days of inventory
- Days = days in the period ÷ turnover.
Worked example. Example: cost of goods sold of 60,00,000 in a year with stock of 8,00,000 at the start and 12,00,000 at the end gives average stock of 10,00,000, a turnover of 6 times and about 61 days of stock.
Questions
What is a good inventory turnover ratio?
It depends on the trade. Grocery and fast-moving goods turn over many times a year; machinery and spare parts much fewer. Compare yourself with your own past years and with similar businesses.
Why use cost of goods sold and not sales?
Stock is valued at cost, so dividing cost of goods sold by stock at cost compares like with like. Using sales would inflate the ratio by your margin.
How can I improve inventory turnover?
Stop over-buying slow items, reorder from real usage, clear dead stock and watch item-wise movement. Reports that show slow and non-moving items make this easier.
These calculators are for quick checks and planning. For tax filing, follow the rules for your business or ask your accountant.
Doing these sums every day?
Sense Softech builds ERP, POS and business software that does them for you, on every invoice, purchase and stock movement.
