Skip to content
Peak Atlas

Problem · Capital tied up in inventory

The warehouse is full. The account doesn't.

Every item on the shelf is paid money that hasn't come back yet. Work out how long your stock lasts and how much capital sits above your target.

Quick calculator

How many months are sitting in the warehouse?

Inventory value at cost, monthly cost of goods and the coverage you want to hold on purpose.

At cost price, not at selling price.

€

Cost of goods sold, monthly average.

€

How many months of stock you want to hold on purpose.

Mon.

Inventory coverage

6 Months

about 182 days in stock

Lie above your target coverage 90.000 € capital. Check the items with the longest days of supply first.

Coverage = inventory value ÷ cost of goods per month

Assumptions and limits

  • The calculation covers the whole warehouse. A good average can hide individual slow movers.
  • Seasonal goods skew the monthly average. High stock before the season is intended.
  • The right target coverage depends on lead times and minimum quantities; it is your decision.

Your entries stay in this browser. Nothing is saved or sent.

How you'll notice

The goods are here. The money for it is missing.

  • There's no money for the next order, even though the warehouse is full.
  • Some items have sat for months while bestsellers are sold out.
  • Minimum quantities at the supplier lead to orders that last much longer than planned.

Understand the causes

Like money ends up on the shelf.

  1. 01

    Purchasing by minimum quantity

    How you'll notice
    Orders last half a year, although three months were planned.
    Why it happens
    Tiered prices and minimum quantities make large orders cheaper per unit, but expensive in capital.
    What helps
    Weigh the volume discount against the months of tied-up capital before you order the larger quantity.
    Limit
    With long lead times, higher stock is unavoidable.
  2. 02

    Slow movers go unnoticed

    How you'll notice
    Total stock looks normal, while individual items last for years.
    Why it happens
    Stock is only viewed in total, not per item.
    What helps
    Calculate coverage per item and tackle the ten with the highest first.
    Limit
    Spare parts or accessories can deliberately sit for a long time.
  3. 03

    Forecast by gut feeling

    How you'll notice
    Reorders happen when the shelf looks empty.
    Why it happens
    Without weekly sales numbers, caution turns into over-ordering.
    What helps
    Take the last weeks' sales per item as the basis for every reorder.
    Limit
    New products have no sales history yet.

Ways to solve it

Reduce stock, without risking stockouts.

Ways to fix too much capital tied up in stock, compared
WayEnough ifLimit
Coverage per item in a spreadsheetYou have a manageable number of items and regularly export stock and sales.Work with every export, quickly outdated.
Clearance of slow moversA few items tie up most of the overstock.Discounts lower the margin; calculate them beforehand.
Inventory management with stock reportingYou need stock by location and bookings.Shows quantities, rarely capital and margin together.
Peak OneYou want to see overstock, days of supply, and tied-up capital together.Valuation of stock is planned; cost prices must be maintained.

Peak One in action

From the full warehouse back to the account.

  1. TriggerWhere is cash stuck?
  2. 01 · CapitalSignalWorking Capital shows where cash is tied up.
  3. 02 · ItemUnderstandingDays of Inventory shows how many days your stock lasts; Sell-Through shows how fast purchased goods sell.
  4. 03 · InventoryDecisionOverstock shows where too much inventory sits, and so where reorders pause.
  5. 04 · TaskActionClearance or order stop become tasks in Peak Board, with an owner.
Result: Capital flows into items that move, instead of shelves that sit.

The apps for it

In Peak One.

Three steps

Free up capital. Without a stockout.

  1. 01 / 03

    Calculate coverage

    Divide inventory value by monthly cost of goods, as in the calculator above.

  2. 02 / 03

    Find the outliers

    List the ten items with the highest coverage and the highest stock value.

  3. 03 / 03

    Pause reordering

    Stop reordering these items until the days of supply fall below your target.

Frequently asked questions

Briefly answered.

How many months of stock are normal?

That depends on lead time, season, and minimum quantities. Coverage well above lead time plus a safety buffer is usually capital that's missing elsewhere.

Why landed cost and not sales price?

Tied-up money is what you've paid, not what you hope to earn. At sale prices, stock looks more valuable and days of supply look wrong.

And what if the problem is more about missing stock?

Then the reorder point is the better question. There is a separate page on sold-out items for that.

Keep exploring

Welt Control

✦ A Peak principle

Cash is time. Whoever sees them decides more calmly.

Overview first, then action

More problems

Typical bottlenecks in growing companies, each with a tool you can try right away, the causes, and the path Peak One provides for it.

Solve it once. The rest follows.

The warehouse is full, the account is empty, and nobody knows how much stock is too much. Sign in with Google and see your company in one place.

Free plan · Sign in with Google · set up in about two minutes