Days of Inventory on Hand Calculator

Calculate how many days your current inventory will last. Check lead time coverage, cash conversion cycle, and how sales velocity changes affect your runway.

Current Inventory

$
units
$

Sales Velocity

$
units
$

Supply Chain & Costs

days
days
days
% / yr

Days of Inventory

49 days

7.0 weeks

Lead Time Coverage

352%

35 days excess

Cash Conversion Cycle

25 days

Days cash is tied up

Holding Cost

$986/mo

$32.88/day

49 days on hand exceeds the optimal range (21-42 days) — excess inventory is tying up $6,508 in capital

Velocity Sensitivity

ScenarioDaily UnitsDays on HandWeeksCovers Lead Time?
50% slower32.598 days14.1YES
75% slower48.866 days9.4YES
CurrentCurrent65.049 days7.0YES
25% faster81.339 days5.6YES
50% faster97.533 days4.7YES
100% faster130.025 days3.5YES

Cash Conversion Cycle

Days inventory (DSI)53 days
+ Days receivables (DSO)+2 days
- Days payables (DPO)-30 days

Cash conversion cycle25 days

Cash is tied up for a month — typical for e-commerce

Inventory Value

Cost value (on hand)$48,000
Retail value$134,400
Potential profit$86,400

Holding cost until sold$1,753
Net profit after holding$84,647

Related Tools