Inventory Turnover Calculator
Calculate Inventory Turnover step by step: cost of goods sold ÷ average inventory.
In short
Formula: Inventory turnover = cost of goods sold ÷ average inventory, where average = (beginning + ending) ÷ 2.
What this calculator does
Calculate Inventory Turnover step by step: cost of goods sold ÷ average inventory. Worked example, questions and limitations included.
Use it to turn Currency (symbol only, never converted), Cost of goods sold for the period, Beginning inventory value, Ending inventory value into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this inventory calculation.
Inputs and what they mean
- Currency (symbol only, never converted)
- — choice value.
- Cost of goods sold for the period
- — number value.
- Beginning inventory value
- — number value.
- Ending inventory value
- — number value.
How to use it
- Enter each value in the unit shown next to the box (use the unit converter first if your numbers are in other units).
- Check the breakdown to see every intermediate step.
- Read the limitations before relying on the result.
Formula
Standard accounting ratio (OpenStax Principles of Accounting).
Uses cost, not selling price, on both sides.
Turnover depends on the period: an annual COGS gives turns per year.
Inventory turnover = cost of goods sold ÷ average inventory, where average = (beginning + ending) ÷ 2.
Inputs used: Currency (symbol only, never converted), Cost of goods sold for the period, Beginning inventory value, Ending inventory value.
Worked example
Annual turns
- Average = 100,000.
- 600,000 ÷ 100,000 = 6 turns.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Two-point average can hide seasonal peaks.
- Single period.
- Values must use the same costing method.
- Results are planning estimates built only from the figures you enter. No prices, rates, demand patterns or service levels are built in, and the results are not supplier quotes or carrier rates.
- The result depends on the values you enter for this inventory turnover calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Common questions
What is a good turnover?
It varies widely by industry and product. Compare against your own history or peers in the same business.
Can I use sales instead of COGS?
Some use sales, but it overstates turnover because sales include margin. Stay consistent.
How do I convert to days?
Use the inventory days calculator: days in period ÷ turnover. Check the formula, example, and limitations on this page before using the result for a real inventory decision.
How do I use the Inventory Turnover Calculator?
Enter the required values for Currency (symbol only, never converted), Cost of goods sold for the period, Beginning inventory value, Ending inventory value. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Inventory Turnover Calculator use?
Inventory turnover = cost of goods sold ÷ average inventory, where average = (beginning + ending) ÷ 2. The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone.
Can the Inventory Turnover Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Related tools
Calculate EOQ step by step: EOQ = √(2 × annual demand × cost per order ÷ holding cost per unit per year).
Calculate Reorder Point step by step: reorder point = average daily demand × lead time + safety stock.
Calculate Safety Stock with your chosen method: fixed days of cover, z × σd × √L, or combined demand and lead-time variability.
Calculate Inventory Days step by step: average inventory ÷ cost of goods sold × days in period.
Calculate Carrying Cost step by step: capital cost + storage + insurance and taxes + obsolescence and shrinkage.
Calculate Stock Coverage step by step: (on hand + on order) ÷ expected daily demand.