This calculator gives estimates for education and planning. It is not investment, tax or legal advice; for decisions about your own situation, talk to a qualified financial professional.
Why inventory turnover matters
Inventory ties up cash. Every product sitting on a shelf or in a warehouse has been paid for but not yet sold, and it costs money to store, insure and finance, with the risk of becoming obsolete. Inventory turnover measures how quickly a business sells and replaces its stock, and is one of the key ratios of working capital management.
The formulas
- Average inventory = (opening inventory + closing inventory) ÷ 2
- Inventory turnover = cost of goods sold ÷ average inventory
- Days inventory outstanding (DIO) = days in the period ÷ inventory turnover
Using cost of goods sold rather than sales compares like with like, since inventory is recorded at cost. For a business with seasonal swings, averaging monthly inventory gives a more accurate picture than the two year-end figures.
Example
A retailer with $1,200,000 of cost of goods sold, $180,000 of inventory at the start of the year and $220,000 at the end:
- Average inventory: $200,000
- Inventory turnover: 1,200,000 ÷ 200,000 = 6 times a year
- Days inventory outstanding: 365 ÷ 6 = 61 days
- Average stock equals about 2 months of sales at cost
Interpreting the result
A higher turnover generally means less cash tied up and fresher stock, but too high a turnover can signal frequent stockouts and lost sales. A low turnover may point to overstocking, slow-moving or obsolete items, or weak sales. What counts as good depends heavily on the industry: grocery stores and restaurants may turn inventory 15 to 30 times a year, while furniture, jewelry and machinery businesses may turn it only 2 to 4 times.
Improving turnover
- Review slow-moving items regularly and discount or discontinue them.
- Order more often in smaller quantities, using the economic order quantity as a guide.
- Improve demand forecasting and agree shorter lead times with suppliers.
- Track DIO together with receivable and payable days: together, they make up the cash conversion cycle.