Days of Inventory on Hand (DOH): Formula, the Lead-Time Threshold, and When to Act

In a closed-loop procurement platform — where demand signals, purchase orders, supplier replies, receiving, and inventory updates all run without retyping between steps — the most useful question is not "how much do I have?" but "how long will it last?" Days of inventory on hand (DOH) answers that second question. It is the number of days current on-hand stock will cover at the current rate of consumption before an item runs out.

Quick answers

What is days of inventory on hand? DOH is the number of days current on-hand inventory is expected to last at the current consumption rate. When DOH reaches zero, the item will stock out.

What is the DOH formula? Two formulas exist. The real-time formula — the one that matters for procurement decisions — is:

Real-time DOH = on-hand quantity ÷ daily consumption rate

The accounting formula (used for financial reporting and capital-efficiency benchmarking) is:

Accounting DOH = (average inventory value ÷ annual COGS) × 365

The two measure different things. Real-time DOH tells you when an item will run out. Accounting DOH tells you how capital-efficient your inventory position was over the past year.

What is the critical DOH threshold? When DOH drops below supplier lead time, the item will run out before the next order can arrive — the stockout window is open. Including a safety buffer, the real alert threshold is DOH < lead time + safety stock days.

How does DOH relate to reorder point? Reorder point (ROP) is an inventory quantity: the on-hand unit count that triggers a new order. DOH is a time duration expressing the same risk. They are two views of the same threshold: ROP ≈ DOH_threshold × daily consumption rate. Both require consumption rate as the shared input.

The two DOH formulas

Real-time DOH (operational)

Real-time DOH = on-hand quantity ÷ daily consumption rate

On-hand quantity is the actual stock count — units physically in possession that have not been committed to open orders or allocated to production.

Daily consumption rate is how fast the item is used per day: sales units per day plus any decay or shrinkage loss. For items with a POS integration, this is computed from a rolling average of actual sales. For recipe ingredients, it is derived from recipe usage multiplied by daily production volume.

Worked example

A specialty retailer carries 80 units of whole-bean coffee. Sales run at 12 units per day.

Real-time DOH = 80 ÷ 12 = 6.7 days

The item will run out in 6.7 days under current conditions. The procurement question is immediate: is 6.7 days enough coverage given this supplier's lead time?

Accounting DOH (financial reporting)

Accounting DOH = (average inventory value ÷ annual COGS) × 365

Average inventory value is typically (beginning-of-year inventory + end-of-year inventory) ÷ 2, at cost.

If average inventory is $45,000 and annual COGS is $360,000:

Accounting DOH = (45,000 ÷ 360,000) × 365 = 45.6 days

This says the business carried about 46 days of inventory value relative to what it sold — a capital-efficiency measure. Useful for investor analysis and year-over-year benchmarking. Not useful for knowing whether any individual item will stock out this week.

The critical threshold: DOH versus lead time

The key operational insight is the comparison:

If DOH < lead time → stockout window is open

If real-time DOH on an item is 6.7 days and the supplier delivers in 4 days, you have 2.7 days of buffer — probably fine. If the supplier takes 8 days, you are already inside the stockout window: an order placed today will not arrive before the item runs out.

The correct alert threshold accounts for lead-time variability and service-level confidence:

Safety DOH threshold = lead time + safety stock days
safety stock days = safety stock units ÷ daily consumption rate

where safety stock in units is z × σ × √(lead time) and z is the z-score for the target service level (1.65 for 95%, 1.28 for 90%, 0.67 for 75%).

Worked example with safety buffer

A retailer: daily consumption 12 units, lead time 4 days, daily-demand σ = 3 units, 95% service level target (z = 1.65).

Safety stock = 1.65 × 3 × √4 = 9.9 units
Safety stock days = 9.9 ÷ 12 = 0.83 days
Safety DOH threshold = 4 + 0.83 = 4.83 days

When DOH falls below 4.83 days, the item is in reorder territory. This is mathematically equivalent to the reorder point: ROP = (12 × 4) + 9.9 = 57.9 units. DOH and ROP are two expressions of the same threshold — DOH in days, ROP in units.

Decay-adjusted DOH for perishables

For perishable items, on-hand quantity degrades over time at the decay rate d — the daily fraction lost to spoilage or shrinkage. The effective on-hand count at day t is:

I(t) = I₀ × (1 − d)^t

This means effective DOH for a perishable is shorter than the raw formula implies. A batch of fresh produce with a 3% daily decay rate has 3% fewer effective units each day beyond consumption alone. Effective DOH is the time t at which I(t) crosses zero accounting for both consumption and decay — earlier than the simple on-hand ÷ consumption rate calculation shows.

Practical rule: for items with d > 1%/day (dairy, fresh produce, cut flowers, baked goods), treat real-time DOH as a conservative upper bound and use decay-adjusted coverage when setting reorder schedules.

DOH and demand variability

For items with high demand volatility, the DOH number is itself uncertain. An item with a coefficient of variation (CV²) above 0.49 has erratic demand: the average consumption rate might be 12 units per day, but realized daily demand fluctuates enough that 6.7 days of DOH could be consumed in 4 days during a spike or stretched to 10 during a slow stretch.

This is why the Syntetos–Boylan Classification (SBC) framework matters: erratic and lumpy items need larger safety buffers (higher z in the safety stock formula) to achieve the same service level as smooth-demand items. Their effective DOH threshold should be wider, not tighter. For smooth-demand items (CV² ≤ 0.49), the DOH number is reliable enough to use directly in reorder logic.

Vertical benchmarks

Target DOH ranges vary by category and are anchored to lead time, not industry norms:

These are planning anchors, not universal targets. The correct DOH threshold for any item is lead time + safety stock days, derived from the specific supplier relationship, observed demand variability, and the operator's service-level confidence target.

Why accounting DOH misleads SMB operators

The accounting DOH formula is often the first version SMB operators encounter — in financial coaching sessions, accounting software dashboards, or industry benchmarking reports. It is useful for capital-efficiency analysis across the full inventory base. It fails in three ways when applied to procurement decisions:

It is backward-looking. It measures the past year, not current stock. A business that built holiday inventory in November and burned it by February will show a reasonable aggregate DOH for the year while specific items run critically low in March.

It aggregates across all SKUs. A 120-day item averaging with a 2-day item produces a 61-day aggregate that hides both the over-stocked slow mover and the stockout risk. Procurement decisions require per-item DOH, not a portfolio average.

It uses cost value, not units. A high-cost, slow-moving item inflates aggregate DOH while a low-cost, high-velocity essential may be simultaneously at risk. Cost-weighted averages do not surface that mismatch.

Real-time, per-item DOH from a live consumption rate resolves all three problems.

How LineNow acts on DOH

LineNow computes real-time DOH per item from POS sales data, recipe usage, and supply chain state. When DOH for an item drops below the lead-time threshold — adjusted for safety stock at the operator's selected service level — the item surfaces in the inventory alerts tab with the estimated revenue at risk if no action is taken over the planning horizon.

The revenue-at-risk figure is the bridge between a time metric and a business metric:

Revenue at risk = daily revenue contribution × max(0, lead time − current DOH)

An item generating $400 in daily revenue with 3 fewer days of coverage than the lead time carries $1,200 of revenue at risk. That is the number an operator can act on — not a raw day count.

From the alert, the operator adds the recommended quantity to a shared cart. The cart becomes a purchase order, dispatched through whichever channel the supplier prefers: email, WhatsApp Business, EDI, or supplier portal. When the supplier replies — with a partial shipment notice, a delivery delay, a substitution — LineNow reads the reply and recalculates DOH forward based on the updated expected receiving date and quantity. Every downstream step (inventory state, capital forecast, next recommendation) updates without the operator retyping anything.

That forward recalculation is what makes DOH actionable rather than descriptive. The number in the alert reflects the current best estimate of when an item runs out — accounting for open orders, supplier replies, receiving events, and POS sales — not a static count from the last manual recount.

Start a 90-day free trial at linenow.co.

Related

• Reorder Point (ROP): Formula and How to Calculate
• PAR Level: Definition, Formula, and How to Calculate It
• Consumption Rate: Definition and How to Measure It
• Lead Time: Definition, Formula, and How to Measure It Accurately
• Inventory Alerts Should Show Revenue at Risk, Not Just Low Stock
• Why Your Best Seller Can Still Stock You Out