Inventory and Working Capital for Consumer Brands: Cash Conversion Cycle

Most operations teams manage inventory to avoid stockouts. Most finance teams should manage inventory to minimize cash needs.

For consumer brands selling across channels (DTC, Amazon, Wholesale), inventory gets complicated: different channels have different velocities, lead times from suppliers are 60-90 days, and dead stock can silently drain working capital.

Cash vs. Inventory Timing

Notice: You lose $100k of cash on day 30 (payment due), but don't get it back until day 90 (after sales). That's a 60-day float.

The Working Capital Equation

Working Capital = Inventory + Accounts Receivable - Accounts Payable

Higher inventory = more working capital needed = more cash locked up.

Example: A brand with $500k inventory, $300k AR, $200k AP needs $600k working capital to operate. If they grow inventory to $700k, working capital needs jump to $800k-$200k more cash required.

Understanding Lead Time

Lead time is the number of days from when you place a PO until inventory arrives at your warehouse and is ready to sell.

Consumer-Brand Specific: China Is Standard

• Lead time: 60-90 days (often longer during peak season)
• Payment: 50% deposit at order, 50% before shipping (typical)
• Cash commitment timeline: Week 1 (pay deposit), week 8 (pay balance), week 13 (inventory arrives)
• The problem: You commit $100k in week 1, but don't have inventory to sell until week 13. That's 13 weeks of cash tied up before any revenue.

Why Lead Time Matters for Cash

If you grow 30% (add $100k of new SKUs), you need to commit that $100k in cash 3 months in advance of revenue. If you're not prepared, growth stops because you run out of cash.

This is why many consumer brands hit a growth ceiling: not because demand is limited, but because working capital is. You need more cash to fund the inventory.

Formula

DIO = Average Inventory Balance ÷ (Annual COGS ÷ 365)

Example

• Average inventory balance: $500k
• Annual COGS: $2M
• DIO = $500k ÷ ($2M ÷ 365) = $500k ÷ $5,479 = 91 days

Your inventory takes 91 days to turn. In other words, you have 91 days' worth of COGS sitting in your warehouse.

What DIO Means

If you have 91 days of inventory, and your suppliers have net-30 terms, your cash-conversion-cycle for inventory is approximately 91 - 30 = 61 days of float (ignoring AR).

DIO by Channel (Consumer Brands)

Calculating DIO by Channel (Better Visibility)

Notice: DTC looks slower than expected (152 days) because $100k of DTC inventory is actually slow-moving SKUs. This is the dead-stock problem.

The Principle

Forecast sales by channel, then work backward to inventory need.

Formula: Inventory on Hand = (Forecasted COGS for Next X Days) + (Safety Stock) - (Inventory in Transit)

Example: DTC Channel

• Forecasted weekly sales (DTC): $15k revenue, $7.5k COGS
• Days of supply to keep on hand: 30 days (allows for demand variation)
• Needed inventory: $7.5k × 4 weeks = $30k
• Plus safety stock (10%): $30k × 1.1 = $33k
• Minus inventory in transit (2 weeks): $7.5k × 2 = $15k
• Target inventory on hand (DTC): $33k - $15k = $18k

Inventory by Channel (Multi-Channel Example)

How to Build the Forecast

• Step 1: Forecast weekly/monthly sales by channel (use last 12 weeks of history)
• Step 2: Calculate COGS for each forecast
• Step 3: Set target inventory level (30-45 days supply for DTC, 45-90 days for wholesale)
• Step 4: Add safety stock buffer (5-15% depending on demand predictability)
• Step 5: Subtract inventory in transit (on order but not yet arrived)
• Step 6: Target = (Forecast × Days / 30) + Safety Stock - In Transit
• Step 7: Update weekly as actual sales land

SKU-Level Inventory Tracking (For Large Catalogs)

If you have 50+ SKUs, track separately. Group SKUs by:

• Velocity (fast/medium/slow): Fast movers get 20-30 days inventory. Slow movers get 60-90 days or less.
• Supplier/Lead time: Products from China need bigger buffers. Domestic suppliers can be leaner.
• Seasonality: Winter items ramp up Sept: Nov. Summer items ramp June: Aug. Plan accordingly.

Use this to avoid the trap: some SKUs move fast and don't need inventory. Others move slow and tie up cash.

What Is Dead Stock?

Inventory that hasn't sold in 90+ days and is unlikely to sell. It ties up cash and warehouse space with zero return.

How Dead Stock Forms

• Demand forecasting miss: You ordered 500 units based on a forecast that didn't materialize.
• Failed product launch: You invested in a new SKU; it didn't resonate. Now you have 200 units.
• Seasonal transition: Winter items don't sell in summer. Inventory sits.
• Supplier overstock: You negotiated bulk discounts and overbought on a whim.
• Channel shift: A wholesale customer stopped buying a product; inventory was destined for them.

The Cash Impact

How to Identify Dead Stock

• Monthly: Run an inventory aging report. Flag units not sold in 90+ days.
• By channel: Some SKUs are dead in one channel (wholesale) but healthy in another (DTC).
• By velocity: Compare to benchmark. If median DIO is 45 days, anything 90+ days is suspect.

How to Fix It

• Clear immediately (first 90 days): Run a promotion. Deep discount (20-40% off). Goal: convert to cash in 2-4 weeks.
• Donate (if tax benefit): Write off as a loss; at least you get tax value.
• Liquidate to third parties: Sell to discount retailers or online discount marketplaces (Overstock, ASOS Outlet, etc.). Accept 30-50% loss.
• Last resort: Write off to scrap. At least you free up warehouse space.

Policy: Any SKU that hasn't sold in 90 days should be on a clearance plan within 30 days. Don't let it sit.

What Is Open-to-Buy?

Open-to-Buy is the budget you have left to order new inventory. It prevents over-ordering and keeps working capital healthy.

Formula

Open-to-Buy = Planned Sales - Current Inventory - On-Order Inventory

Example

• Planned sales for next 90 days (COGS): $50k
• Current inventory on hand: $30k
• On order (not yet arrived): $20k
• Open-to-Buy = $50k - $30k - $20k = $0
• Interpretation: You don't need to order anything yet. Current + on-order covers your planned sales.

Another Example (With Need)

• Planned sales for next 90 days (COGS): $60k
• Current inventory on hand: $15k
• On order (not yet arrived): $25k
• Open-to-Buy = $60k - $15k - $25k = $20k
• Interpretation: You can safely order $20k more. That plus current + on-order gets you to $60k coverage.

How to Use OTB

• Monthly: Calculate OTB for each major supplier or product line.
• Govern purchases: Don't order more than your OTB. It's your spending limit.
• Watch lead times: If lead time is 60 days, calculate OTB for the next 90 days (60-day lead + 30-day buffer).
• Adjust for seasonality: In Q4, OTB might be higher (need more inventory for holiday). In Q2, lower (slower season).

OTB Prevents Two Problems

• Over-ordering: You order too much, thinking you need it. OTB shows you don't. You save cash.
• Under-ordering: You don't order enough and miss sales. OTB ensures you order to plan, not emotion.

Practice 1: Separate Inventory Forecasts by Channel

DTC moves faster than wholesale. Amazon FBA has velocity rules. Track separately so you can see which channel is cash-healthy and which is draining.

Practice 2: Plan Lead Time as Part of Cash Planning

If lead time is 60 days and you place a PO today, you won't see cash for 60+ days. Build this into your 13-week cash forecast. Don't order without asking: "Can we float this cash for 90 days?"

Practice 3: Track DIO and Benchmark Against Industry

Calculate DIO monthly. Apparel brands often run 60-90 days. Beauty brands 30-60 days. If you're higher, that's a signal: excess inventory or slow movers.

Practice 4: Monthly Dead-Stock Review

Flag any SKU in inventory 90+ days. Immediately plan a clearance. Don't wait 6 months.

Practice 5: Use Open-to-Buy to Govern Ordering

Tie OTB to purchase authority. No one can order more than their OTB without approval from finance.

Practice 6: Account for Obsolescence & Shrink

Budget 2-5% for dead stock, returns, and shrink (theft, damage). Don't assume 100% turns to revenue.

Practice 7: Tie Inventory Plan to Cash Forecast

Every inventory decision is a working capital decision. Build a 13-week cash forecast. When inventory go up, cash position changes. Model it.

Inventory management isn't just an operations problem. It's a cash management problem.

A consumer brand with $500k inventory that takes 120 days to turn needs working capital to carry 4+ months of COGS. If they tighten DIO to 60 days (better forecasting, less dead stock), they cut working capital needs in half: freeing up $250k cash for growth.

Niblin connects your inventory system (Shopify, Amazon, WMS, accounting software) to show DIO, dead stock, and lead-time impact on working capital in real time. Build a channel-by-SKU inventory forecast. Open-to-Buy is automated. Dead stock is flagged monthly. And the whole thing ties to your 13-week cash forecast.