This is what happens in the video
Setting the right values for safety stock, reorder point, and reorder quantity on the item card in Business Central does not require advanced calculations to get started. The most practical approach is to think of the item as if it were something in your own kitchen, or simply to ask your purchasers what they actually do when they handle the item.
Safety stock quantity is interpreted by the system as your zero level. If you set it to five, the system assumes you should always have at least five units on inventory and plans backwards to cover any breach. Set this value based on the service level you want and how expensive the item is to keep in stock.
Reorder quantity is how much you normally buy or produce in one go. It is usually the easiest value to define. Reorder point is determined by lead time: how long it takes to replenish the item compared to how quickly demand consumes it.
Fill in the values in this order: safety stock first, then reorder quantity, then reorder point.
Where to set safety stock, reorder point, and reorder quantity
On the Planning tab on the item card you find the field for safety stock quantity. If you plan with fixed reorder quantity or maximum quantity as the reordering policy, you also need to enter the reorder point and the reorder quantity.
Rather than starting with theory, start with the item itself. Ask: when I want to handle this item, how do I actually want to react in real life? That question gives you better answers than any formula when you are first setting things up.
How to set the safety stock quantity
The system treats the safety stock quantity as your zero level. If you say you always want five units on inventory, the planning will assume you should always have at least five. If an upcoming demand pushes you below that level, you have a safety breach. The system then plans backwards and makes the planning lines more urgent so the buffer is restored.
Think of it as a secure inventory. The question to ask is simple: how much would I always like to have on inventory for this specific item?
The answer relates to two things. First, the service level you want to offer. The higher the safety stock quantity, the better you can provide the item for your customers. Second, the inventory binding, meaning how expensive the item is to keep on the shelf. A high service level for an expensive item ties up more capital, so you balance the two.
How to set the reorder quantity
The reorder quantity is how many units you normally buy in one go from the specific vendor, or how many you produce at a time if it is a manufactured item. For flour in your kitchen, it is simply how many kilos you usually buy at a time.
This is often easier to answer than the reorder point, which is why you start here. The reorder quantity determines how often you replenish and in what quantities. Larger quantities mean more inventory but fewer orders. Smaller quantities mean less inventory but more frequent ordering.
How to set the reorder point using lead time
Once you have decided your reorder quantity, the reorder point follows naturally. Take the kitchen example: you decide to buy 2 kilos of flour at a time. Then you ask yourself how long those two kilos actually last, and how long it takes to replenish the flour once you order it.
If replenishment takes one or two days, and you know how fast you use the flour, you can calculate the point at which you need to reorder so you do not run out. That is your reorder point.
Picture the item on the shelf. Demand takes items away, and when the inventory reaches a certain point, you need to order more, either by producing it or purchasing it, depending on the replenishment system. The lead time determines the reorder point.
When to use ABC analysis and Wilson’s formula
There is plenty of theory on how to calculate the reorder point more precisely. You can use double ABC analysis, multiple ABC analysis, Wilson’s formula, and others. These methods are worth digging into when you want to optimise inventory across a large item portfolio.
For getting started, though, the practical advice holds: ask yourself what you would normally do with this item. Set the safety stock first, then the reorder quantity, and finally the reorder point.
Q&A
What does the safety stock quantity mean in Business Central planning?
The system interprets the safety stock quantity as your zero level. If you set it to five, planning assumes you should always have at least five units on inventory. If demand pushes you below that level, the system registers a safety breach and plans backwards to make the planning lines more urgent.
In what order should I fill in safety stock, reorder point, and reorder quantity?
Start with the safety stock quantity, then set the reorder quantity, and finally the reorder point. The reorder quantity is usually the easiest to define, and once you know it, the reorder point follows from the lead time and how fast you consume the item.
What determines the reorder point?
The lead time determines the reorder point. You compare how long it takes to replenish the item with how quickly demand consumes it, then set the point at which you need to order so you do not run out before the new stock arrives.
How does the reorder quantity affect inventory levels?
The reorder quantity determines how often you replenish and in what quantities. Larger quantities mean more inventory on the shelf but fewer orders to place. Smaller quantities mean less inventory but more frequent ordering.
When should I use ABC analysis or Wilson’s formula instead of the practical approach?
The practical approach, asking what you would normally do with the item, works well for getting started. Methods like double ABC analysis, multiple ABC analysis, and Wilson’s formula are useful when you want to optimise the reorder point more precisely across a larger item portfolio.