Days on hand
Classic **average inventory ÷ daily COGS** with floor on denominator—OPS dashboards use the same guardrail.
Example scenario
A mid-market ecommerce operator carries an average on-hand inventory valuation of $118,000 across replenishable SKUs while annual COGS runs at $920,000 from the trailing twelve-month P&L. Converting annual COGS to a daily burn rate yields about $2,520.55 per day, so current stock coverage is roughly 46.82 days on hand. That same input set implies about 7.80 annual inventory turns, which helps planners decide whether working capital is over-tied in slow-moving assortments.
Days on hand
Avg inventory ÷ daily COGS
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
How to use the days on hand
- Input average inventory value ($) using beginning-and-ending inventory averages or monthly average balances from your accounting system.
- Enter annual COGS ($) from the same reporting basis and timeframe so inventory and COGS are comparable on valuation method.
- Review days on hand as average inventory divided by daily COGS to estimate how many days current stock can support demand at current burn.
- Use the annual inventory turns output to compare category efficiency and set reorder or markdown strategies for slow-moving SKUs.
Inventory coverage benchmark context
- DOH variability by product category
- Fast-turn consumables usually target lower days on hand than seasonal or long-lead durable goods, so benchmarking should be done by category, not blended totals.
- Turns vs service-level tradeoff
- Higher turns improve cash efficiency but can increase stockout risk when supplier lead times or forecast error are volatile.
- Finance interpretation of DOH
- CFO teams pair DOH with gross-margin return on inventory and cash-conversion-cycle metrics to evaluate whether inventory supports profitable growth.
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Should I use ending inventory or average inventory for DOH?
Average inventory is generally more reliable because it smooths month-end timing effects, promotional spikes, and inbound shipment clustering.
Can I compare days on hand across all product categories directly?
Only with caution. Different lead times, shelf-life constraints, and demand volatility make category-level DOH comparisons more meaningful than one blended number.
Why can days on hand improve while service levels get worse?
You can reduce inventory broadly but still understock key SKUs. Pair DOH with fill rate and stockout metrics to avoid false confidence from a lower headline ratio.
Does annual COGS include freight and landed-cost adjustments?
Use the COGS definition your finance team reports consistently. If landed costs are excluded in one period and included in another, DOH trends become misleading.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: Inventory management & supply chain financeTopics: Days inventory on hand, Inventory turns, Working capital efficiency
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team