Safety stock, also called buffer stock, is the extra stock you keep on top of what you expect to sell while you wait for a delivery, so that you do not run out when demand is higher than usual or a delivery is late. Enter your average demand and lead time and choose a method: you get the safety stock in units, the reorder point at which to place your next order, and every step of the working. Add a unit cost to see how much money the safety stock ties up.
Choose a method
‘Service level’ is the statistical method, based on the normal distribution: it needs the average and standard deviation of your demand, those of your lead time if deliveries vary, and the service level you want. ‘Maximum minus average’ needs no statistics: give the highest demand and the longest lead time you have seen. The reorder level then covers that worst case, highest demand × longest lead time, and the safety stock is the amount by which it exceeds average demand over the average lead time, which is how ACCA defines buffer inventory. It is quicker, but it can hold more stock than you need, because it assumes both bad cases at once.
Keep every figure in the same time unit
Choose days, weeks or months and stick to it: demand per week goes with a lead time in weeks and the standard deviation of weekly demand. Work out the standard deviation from your own sales history, with STDEV in a spreadsheet, over several months at least, leaving out one-off events such as a single bulk order.
Choose the service level
The service level here is the cycle service level: the chance of not running out while you wait for a delivery. At 95%, expect a stock-out in about one replenishment cycle in twenty. It is not the share of demand you meet from the shelf (the fill rate), which is usually higher for the same stock. Each step up costs more: going from 95% to 99% raises z from 1.645 to 2.326, about 41% more safety stock.
Rounding and using the result
The safety stock is worked out to two decimal places, halves rounded away from zero, then rounded up to a whole unit, so you do not hold less than the formula asks for. The reorder point, average demand over the lead time plus that safety stock, is rounded up too. z is taken to three decimal places, the precision of printed tables, and that is the z used. The cover is rounded down to a hundredth. Copy the workings, export them as a CSV file or save them to Priostack.
Service level: safety stock = z × √(L × σd² + d² × σL²).
Maximum minus average: safety stock = maximum demand × maximum lead time − average demand × average lead time.
Reorder point = d × L + safety stock.
d and σd are the average and standard deviation of demand per period; L and σL those of the lead time, in the same periods; z is the standard normal value for the service level (1.645 at 95%).
Example: 40 units a day, delivered in 9 days on average
A shop sells 40 units a day of a product on average, with a standard deviation of 12 units. Its supplier takes 9 days on average to deliver, with a standard deviation of 2 days. At a 95% service level, z = 1.645, and the standard deviation of demand over the lead time is √(9 × 12² + 40² × 2²) = √7,696 = 87.727. The safety stock is 1.645 × 87.727 = 144.31, so 145 units. Average demand over the lead time is 40 × 9 = 360 units, so the shop reorders when its stock falls to 360 + 145 = 505 units. The safety stock covers 3.62 days of average sales; at £4.20 a unit, it ties up £609.00.