Free tool
Inventory turnover and days on hand calculator
Inventory turnover is how many times a business uses up and replaces its inventory in a period: cost of goods sold divided by average inventory at cost. Days on hand is the days in the period divided by turnover, which is how long the stock would last at the current rate of use. Fewer days on hand means less cash tied up in stock.
Average inventoryequalsStart inventory + End inventory divided by 2
Inventory turnoverequalsCost of goods sold divided by Average inventory
Days on handequalsDays in the period divided by Inventory turnover
For the period, from the income statement
365 for a year, 90 for a quarter
Value at cost
Value at cost
Pre-filled with the worked example. Use inventory and cost of goods sold at cost, not at selling price.
Inventory turnover
6 times
Stock was used up and replaced 6 times in 365 days.
Days on hand
60.8 days
Days in the period ÷ turnover
Average inventory
$2,000,000
(Start + end) ÷ 2
Turns per year
6
Scaled to 365 days
Next step
Want to track this every week?
Bring this result to a 45-minute demo and we will show where it fits in LeanSuite's Loss & Cost Management.
How to calculate it
Four numbers from the balance sheet and income statement
Cost of goods sold is what the products you sold in the period cost to make or buy, from the income statement. Use the same period as the days below.
Inventory at the start and at the end are the inventory values on the balance sheet at those two dates. Raw material, work in process and finished goods can be added together, or calculated one at a time to see where the stock sits.
Days in the period is 365 for a year. For a quarter use 90 or 91; the calculator scales the turns to a year for you.
Turnover only helps if the stock figure is right. Count errors move it, so check that your records match the shelf with cycle counting, and see which items to hold least with ABC analysis. The levers that raise turnover safely are kanban loops sized from demand and lead time, and the right safety stock for each item.
Worked example
Illustrative numbers, not a benchmarkA plant with 12,000,000 of cost of goods sold in a year, 2,100,000 of inventory at the start of the year and 1,900,000 at the end.
Step 1
Average inventory = (2,100,000 + 1,900,000) ÷ 2 = 2,000,000.Step 2
Inventory turnover = 12,000,000 ÷ 2,000,000 = 6.0 times.Step 3
Days on hand = 365 ÷ 6.0 = 60.8 days.
Embed this calculator
Teaching this, or writing about it? Paste this code into your site, course page or intranet and the calculator works right there. It is free, with no sign-up.
<iframe src="https://www.theleansuite.com/tools/inventory-turnover-calculator/embed" title="Inventory turnover and days on hand calculator by LeanSuite" width="100%" height="970" style="border:0;max-width:1000px" loading="lazy" allow="clipboard-write"></iframe>
<p style="font:13px/1.4 sans-serif"><a href="https://www.theleansuite.com/tools/inventory-turnover-calculator">Inventory turnover and days on hand calculator</a> by LeanSuite</p>How LeanSuite helps
LeanSuite is not an inventory or planning system, so keep stock figures in your ERP. LeanSuite's Loss & Cost Management puts a cost on each loss, and its Loss Prioritization Matrix turns that data into an action plan ranked by cost.
See Loss & Cost ManagementRead more
- Free template: Inventory cycle count sheet
- Free template: Kanban sizing calculator
- Free template: Plan for every part (PFEP) template
- Inventory turnover in the lean glossary
- Safety stock calculator
- Inventory turnover in the lean glossary
- Inventory record accuracy in the lean glossary
- Pull Systems in Lean Manufacturing: How They Work and Why
- Supermarket Pull Systems in Lean Manufacturing
FAQ
Inventory turnover and days on hand calculator: common questions
Divide cost of goods sold for the period by the average inventory value at cost, where average inventory is the start and end values added and divided by 2. With 12,000,000 of cost of goods sold and an average inventory of 2,000,000, turnover is 6 times a year.
Divide the days in the period by inventory turnover. At 6 turns a year, days on hand is 365 ÷ 6 = 60.8 days: at the current rate of use, the stock on hand would last about 61 days. You can also divide average inventory by cost of goods sold per day and get the same number.
Use cost of goods sold. Inventory is valued at cost, so dividing sales by it mixes cost and selling price and overstates turnover by the margin. If you only have sales, the result is a rough figure; say so when you compare it.
It depends on the product and the business: a plant making perishable goods turns stock far faster than one making large engineered equipment. Compare your own figure by product family over time. A rising turnover with stable service means less cash is tied up; a rising turnover with more shortages and expediting means stock has been cut too far.
Yes. A two-point average of the start and end values hides what happened in between, for example a seasonal build. If you have month-end values, average all of them instead and enter that average as both start and end. The calculator warns you when the stock changed by more than half its average.
Lean aims at less stock waiting between steps and shorter lead times, which raises turnover. The usual levers are smaller batches, pull systems with sized kanban loops and more reliable suppliers, which also lets you hold less safety stock for the same service.
More free lean tools
All tools- OEE calculatorOverall equipment effectiveness from shift time, downtime, ideal cycle time and part counts.
- Downtime cost calculatorWhat an hour, an event and a year of unplanned downtime cost, from lost output, idle labour, scrap and overtime.
- SMED changeover calculatorTime saved by moving changeover steps from internal to external, capacity freed per week and the smaller batch it allows.
- Takt time calculatorThe pace a line must hit to meet customer demand, from shift time, breaks and daily demand.
- Cycle time calculatorCycle time against takt, units per hour, capacity per shift and the gap to daily demand.
- Line balancing calculatorLine efficiency, balance delay and the minimum number of stations from station times and takt.
- Bottleneck calculatorThe step that limits your line, from each step's cycle time, machines and uptime, with daily capacity and the gap to demand.
- First pass yield (FPY) calculatorFirst pass yield at each step and rolled throughput yield (RTY) across the whole process.
- Cost of poor quality (COPQ) calculatorTotal COPQ and cost of quality, and each as a share of revenue, from the four quality cost categories.
- Process capability (Cp, Cpk) calculatorCp and Cpk against your specification limits, plus Pp and Ppk from pasted measurements, with a distribution chart.
- DPMO and sigma level calculatorDPMO, defects per unit, yield and sigma level from the defects found, units checked and opportunities per unit.
- MTBF and MTTR calculatorMean time between failures, mean time to repair and availability from operating time, failures and repair time.
- Lead time calculatorManufacturing lead time from WIP and throughput (Little's Law), and the share of it that adds value.
- Throughput time calculatorThroughput time from process, inspection, move and wait time, the share of it that adds value, and units per hour.
- Kaizen savings calculatorYearly savings, payback in months and first-year ROI of an improvement, from time saved, scrap avoided and its costs.
- TEEP calculatorTotal effective equipment performance: OEE multiplied by how much of all calendar time you plan to run.
- Overall labor effectiveness (OLE) calculatorHow well paid labor hours turn into good output: availability, performance and quality of the crew.
- Safety stock calculatorSafety stock and reorder point from the service level you want, average demand and lead time, and how much each varies.
- Scrap rate calculatorScrap rate, the cost of scrap per period and per year, and what reaching a target rate would save.
- TRIR and DART rate calculatorOSHA recordable and DART incident rates from your 300A case counts and hours, and what one more case does to them.
- NIOSH lifting equation calculatorRecommended weight limit and lifting index for a two-handed lift, with every multiplier shown so you can see what to redesign.
- Time study sample size calculatorHow many cycles of an element to time, from your first readings, with the t formula, the ILO formula and the range method.
- Maintenance strategy selectorAnswer the RCM questions for one failure mode and get the maintenance strategy, the reasoning and the check or test interval.
- Noise dose and TWA calculatorDose and 8-hour TWA for a shift of noise levels under OSHA and NIOSH, which limits are reached and how much loud time to cut.
- Risk matrix calculatorSeverity times likelihood on a 3 x 3, 4 x 4 or 5 x 5 risk matrix, the band and its action, editable banding, and the score after further controls.
- Repair or replace calculatorEquivalent annual cost of keeping and repairing an old machine against buying a new one, with each one's economic life and the break-even figures.
- Compressed air leak cost calculatorAir lost, kW and cost a year for each tagged leak from its size and the pressure, ranked so the biggest gets fixed first.
- Machine hour rate calculatorWhat one productive hour of a machine costs, with and without the operator, the cost per part and how utilisation moves the rate.
- Total manufacturing cost calculatorTotal manufacturing cost, cost of goods manufactured, cost per unit and the overhead rate from materials, labor and overhead.
- Acceptance sampling calculatorRead the OC curve and the real risks of a sampling plan, find the plan for your AQL and LTPD, or size a zero-defect test.
- Shift schedule plannerTen shift patterns on real dates: calendar for each crew, hours a week, weekends off, coverage and the weeks over 40 hours.
- Pareto chart makerPaste categories and counts: sorted bars, cumulative percentage line and the vital few at the 80% line, as a PNG or SVG.
- Histogram makerPaste measurements: the histogram with automatic or chosen bins, plus mean, median and standard deviation, as a PNG or SVG.
- Box plot makerPaste one or more groups of numbers: box plots with quartiles, IQR, whiskers and outliers by the 1.5 IQR rule, as a PNG or SVG.
- Fishbone diagram makerName the problem, list causes under the 6M bones, and download the Ishikawa diagram as a PNG or SVG.
- 5 Whys canvasWrite the problem, answer up to five whys, state the root cause and countermeasure, then print the one-page canvas.
- Lean maturity self-assessmentScore 27 statements across nine dimensions and get a band for each, an overall band, where to start and the guides to read.
- Lean method navigatorSix questions about one problem, then the lean method to start with, the two that follow, why each fits, five steps for Monday and what it will not solve.
- Manufacturing ROI calculatorAnswer a few questions about your shop floor, shifts and downtime to estimate your potential ROI with LeanSuite.

