From forecast to purchase: safety stock, reorder point and lead time.

A forecast does not tell anyone what to buy. This chapter explains how StockAI turns expected sales, their uncertainty and the lead time of your supplier into a signal and a quantity.

The real question

To decide whether to buy today, the question is not how much I will sell tomorrow, but: will what I have last until what I order today arrives? That depends on three things: the expected sales, how much they can vary, and how long the supplier takes.

The service level

No one can guarantee never running out: keeping warehouses full would be too costly. What you can choose is how often you accept the risk. The service level is that choice: a 95% means the cushion covers the variation in 95 out of every 100 purchase cycles.

StockAI uses 95% by default, and you can change it by product, supplier or category. Raising it from 95% to 99% does not cost 4% more: the cushion grows considerably more, because covering rare cases is expensive. The simulator shows this.

Calculate a cushion

Simulator

Move the service level and the variation, and watch how the cushion and the reorder point change.

StockReorder pointCushion
1.64z
40 unitsCushion
160 unitsReorder point

Simulation with invented numbers and the same formula StockAI uses when it has not yet measured the errors of your forecast.

The cushion (safety stock)

The cushion covers two surprises at once: that more is sold than expected while you wait, and that the supplier takes longer than promised. The two are combined like the sides of a triangle, not added: it is rare for both to happen at the same time.

Once StockAI has measured the errors of your forecast on the hidden dates, it uses those real errors at the distance of your lead time instead of the bell-curve formula. It is the same idea as chapter 5, applied to buying.

The reorder point and the signal

The reorder point is what will sell during the lead time plus the cushion. When your stock (plus what is on the way) falls below that, it is time to order.

The signal translates this into days of coverage: ORDER NOW if what you have does not last even half the lead time; ORDER SOON if you have already crossed the reorder point; OK if you are fine; OVERSTOCK if you have more than you need for a good while. The thresholds can be adjusted.

The lead time that is learned

At first StockAI uses the lead time you enter for each supplier (or 15 days if there is none). Each time you record a receipt, it stores how many days it actually took. From the third receipt on it uses the real average, and the variation between deliveries feeds the part of the cushion that covers the supplier.

The suggested quantity

If the signal is ORDER NOW or ORDER SOON, the quantity is what will sell during the lead time plus the cushion, minus what you have and what is already on the way. If the supplier has a minimum order, the quantity never falls below it. For any other signal, the suggestion is zero.

What you take away

  • The service level is how much risk you accept; 95% by default.
  • The cushion combines the variation in sales and in the supplier, and grows fast near 100%.
  • Reorder point = sales during the lead time + cushion.
  • The lead time of each supplier is learned from your receipts, starting with the third one.

Where you see it in StockAI

In Inventory, each product shows its signal, its reorder point, its cushion and where the lead time came from (yours or learned). The suggested quantity arrives ready in the Purchasing cart.

Put your own AI to work forecasting your sales. Today.

Three ways to start, depending on how much you want to commit right now. All three lead to the same product.

Create your account

With the whole engine. Upload your sales file and see your first forecast, and with it your first list of what to order.

Create my account

Look before giving your email

An instant trial account with sample data. It lasts 24 hours and is then erased.

Try it without signing up

Talk to us

For the corporate plan, the source code, or to see it with your data and someone beside you. We answer within 24 hours.

Sales and contact: contacto@stockai.es. Phone: +506 7186 2820.

Sales forecasting made in Costa Rica, for companies across Latin America.