← Back to Stories

Story · Solution

The operations lead stops tying up cash in stock that does not sell

Running out is loud, but overstock is silent.

Sound familiar?

Stock that has stopped selling sits on the shelf, tying up cash until the end-of-season count.

Why it hurts

I run the roastery and fulfilment for a small coffee roaster. Running out is loud, but overstock is silent. Bags that are not selling sit on the shelf, tying up cash, and nobody notices until a count at the end of the season. I need to know which products have stopped moving while there is still time to do something about them.

How it is solved

Get a weekly list of the products that are not selling or that the business holds too much of, with a clear recommendation for each, so that the operations lead and the owner can act before the cash is lost.

  1. The operations lead sees the days of cover for every product. The app divides what is on hand by the current selling rate, giving the number of days the stock would last. A product with far more cover than its lead time needs is marked as overstock, and nothing more of it is ordered. Every figure here is a quantity, never revenue.
  2. The owner sees the products with no recent sales. The app lists every stocked product that has not moved in four weeks, with its quantity on hand and the cash it ties up, and marks a product idle far longer as dead stock. A slow mover is never reordered. The operations lead sees the same list without the cash.
  3. The owner sees each product classified by how it is selling. The app compares each product's recent sales with the period before, and marks each product to push or to clear.
  4. The owner decides. The list only shows and changes nothing. The owner decides what to discount, bundle or stop reordering.

Works with

QuickBooks

The result

A short list with a recommendation beside each product: overstock with its days of cover; products with no recent sales, with the quantity and cash on hand; and each product marked to push or to clear.

  • If a product holds far more cover than it needs, it is flagged as overstock, and nothing more is ordered.
  • If a product has stopped selling, it is listed with the cash it ties up, never reordered, and marked to clear.
  • If a product's sales are rising, it is marked to push.

Try it

The demo runs on WidgetCo Coffee Roasters, an example business: a coffee roaster with an online store and a wholesale side. You will see it as Jonah, who runs the roastery and fulfilment.

Connected to this story