Per-Unit Inventory Turnover Formula
Learn how to calculate unit-based inventory turnover, average inventory units, and average days in inventory.
Per-unit inventory turnover estimates how many times average stock was sold during a reporting period. It helps show stock movement using physical unit counts rather than inventory cost, while average days in inventory translates the ratio into an estimated holding time.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Inventory Turnover Ratio
Where:
First calculate the average number of units held during the period. Then divide total units sold by that average stock level.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| unitsSold - Units sold | Total saleable units sold during the reporting period. | units |
| beginningInventoryUnits - Beginning inventory units | Saleable units in inventory at the beginning of the period. | units |
| endingInventoryUnits - Ending inventory units | Saleable units remaining in inventory at the end of the period. | units |
| periodDays - Period length | Number of days covered by the sales and inventory data. | days |
| averageInventoryUnits - Average inventory units | The simple average of beginning and ending inventory unit counts. | units |
| inventoryTurnover - Inventory turnover ratio | Estimated number of times average inventory was sold during the period. | times |
| daysInventoryOutstanding - Average days in inventory | Estimated average number of days units are held before sale. | days |
Step-by-Step Calculation
Record matching-period unit counts
Use beginning inventory, ending inventory, and units sold that relate to the same product group and reporting period.
beginningInventoryUnits, endingInventoryUnits, unitsSold
Calculate average inventory
A simple average smooths the opening and closing stock counts into one estimated inventory level for the period.
averageInventoryUnits = (beginningInventoryUnits + endingInventoryUnits) / 2
Calculate inventory turnover
Divide units sold by average inventory units to estimate how often the average stock level moved.
inventoryTurnover = unitsSold / averageInventoryUnits
Calculate average days in inventory
Divide the period length by turnover to express stock movement as an estimated average number of days held.
daysInventoryOutstanding = periodDays / inventoryTurnover
Annual per-unit inventory turnover example
Calculate average inventory
(1,000 + 800) / 2
900 units
Calculate inventory turnover
3,600 / 900
4.00 times
Calculate average days in inventory
365 / 4.00
91.25 days
Final Result
Inventory turnover is 4.00 times, and average days in inventory are about 91.3 days.
Assumptions
- ✓Beginning inventory, ending inventory, and units sold cover the same period and product group.
- ✓Beginning and ending unit counts represent saleable inventory measured consistently.
- ✓Average inventory is estimated using a simple average of the opening and closing balances.
- ✓Each unit is treated as comparable for movement purposes, which is most useful for a consistent item or product group.
Limitations
- !A simple beginning-and-ending average may not capture large seasonal swings in inventory.
- !Returns, damaged goods, obsolete stock, transfers, and shrinkage can affect actual stock movement.
- !Unit-based turnover may be less informative when products have substantially different unit costs or margins.
- !The result does not show whether inventory availability was sufficient to meet demand.
Common Mistakes to Avoid
Using units sold from one period with inventory balances from another period.
Entering purchase units or units received instead of units sold.
Combining unrelated products with very different sales patterns into one unit count.
Treating a high turnover ratio as automatically positive without checking for stockouts.
Using zero average inventory, which makes the turnover calculation undefined.
Comparing annual turnover directly with monthly turnover without adjusting for the period length.
Related Formulas
Frequently Asked Questions
What is the formula for per-unit inventory turnover?
Per-unit inventory turnover equals units sold divided by average inventory units. Average inventory units equal beginning inventory units plus ending inventory units, divided by two.
How are average inventory units calculated?
Add beginning inventory units and ending inventory units, then divide by two. For example, 1,000 opening units and 800 closing units produce average inventory of 900 units.
How do you calculate average days in inventory from turnover?
Divide the number of days in the reporting period by the inventory turnover ratio. A 365-day period with turnover of 4 produces about 91.3 days in inventory.
Can inventory turnover be calculated using units sold?
Yes. Unit-based turnover uses units sold and average units held. It is especially useful for a single product or a group of broadly comparable products.
Why might a unit-based turnover ratio differ from a cost-based ratio?
A cost-based ratio uses cost of goods sold and inventory value, while this method uses physical unit counts. The measures can differ when unit costs vary across products or change over time.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.