Ecommerce operators

Inventory-to-Cash

How much cash is trapped in excess inventory?

Settings

Inventory Targets

Target weeks of cover assumption

weeks

Replace with your reorder lead time + safety weeks.

Lookback windowVelocity is computed from this window.

SKU Data

Paste a CSV with columns: SKU, Units on hand, Units inbound, Landed cost/unit, Units sold in window.

Action Plan

Target weeks to clear excess

weeks

How quickly you want to liquidate overstock.

Trapped Cash$151,68761.6% of your total inventory value is sitting beyond 12 weeks of cover.

Top 3 SKUs account for 95.3% of the excess.

SKU	Status	Cover (wks)	Excess Units	Excess Cash	Req. Lift
B-200	Overstock	56.2	9280	$103,936	+552%
D-400	Dead stock	∞	3100	$20,925	-
E-500	Overstock	27.4	1377	$19,686	+192%
A-100	Overstock	15.0	840	$7,140	+38%
C-300	OK	4.2	0	$0	-
F-600	OK	8.8	0	$0	-

Illustrative analysis from the numbers you entered. Not accounting, tax, or investment advice.

A calculator can flag the question. A CFO model can account for the timing, risks, and decisions unique to your business.