← Back to Stories

Story · Solution

The roastery sees a stockout coming and orders the right amount

I find out a coffee has sold out when the shelf is empty, and by then the next roast is weeks away.

Sound familiar?

I find out a product has sold out when the shelf is empty, and one big order makes the reorder wrong.

Why it hurts

I run the roastery and fulfilment for a small coffee roaster. I find out a coffee has sold out when the shelf is empty, and by then the next roast is weeks away. When I do reorder, one big wholesale order makes a coffee look busier than it is, and I order too much of one thing and not enough of another.

How it is solved

Know which coffees will run out before a new order could arrive, and order the right amount of each, so the owner can approve the orders in time.

  1. The roastery lead sees the items that run out too soon. For each item, the app compares the days of stock left with how long a new order takes to arrive, and marks the item too late when it will run out first.
  2. The roastery lead sees a sales spike checked against the order behind it. When the recent sales rate and the longer one disagree sharply, the app shows the single order behind the spike, and sizes the reorder on the steadier rate, so one large order does not inflate it.
  3. The roastery lead sees sold-out days and stock on order counted right. Days when an item was out of stock are left out of its sales rate, so a sell-out does not make it look slow. Stock already on order is taken off the reorder. Every figure is a quantity, never revenue.
  4. The owner decides a supplier's minimum. When an order falls below a supplier's minimum, the owner sees what reaching it would cost and how many more days of stock it would buy, and decides. Nothing is padded to reach the minimum on its own.
  5. The roastery lead gets the buy list and the orders drafted. The roastery lead keeps, drops or changes each line of the buy list. The app then drafts one purchase order and one supplier email per supplier. Nothing is sent and nothing reaches QuickBooks.
  6. The owner approves each order. Each supplier's order has its own approval, and approving one never approves another. Only the approved orders are recorded.

Works with

QuickBooks

The result

A restock plan that names each item that will run out before a new order could arrive. Each reorder is sized on the right sales rate and takes off what is already on order. A supplier's minimum is left to the owner's decision. Purchase orders are drafted per supplier, and the owner approves each one on its own.

  • If a coffee will run out before a new order could arrive, it is caught now, with the reorder sized.
  • If one large order inflates the recent rate, the reorder is sized on the steadier rate instead.
  • If an order falls below a supplier's minimum, the owner sees what reaching it costs and decides.
  • If stock is already on order, it is counted, so the business does not order twice.

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