Safety stock

Calculating the required safety stock using a simple probability model can be easily done in Microsoft excel, on a statistics calculator or a cumulative distribution table. The data needed before performing the calculation is:

-The average demand per time period.
-The standard deviation of demand per time period
-The assumption that demand is normally distributed
Calculating the safety stock level:

1-Decide to what level of probability you would like not to run out of stock. For example if it is required that 95% of the time stock doesn’t run out, this also means that only 5% of the time stock will actually run out.

2- Using Microsoft excel enter the following formula into a blank cell:
=normsinv(p)
Where p is the probability of not running out, in this case 95% or 0.95

3- The number of standard deviations will be displayed required to achieve this probability level. In this example this would evaluate to 1.6448 standard deviations

4-Multiply the number obtained in step 4, the number of standard deviations, times the standard deviation of demand obtained during the initial data collection.

This is a simple but effective safety stock calculation model which can also be integrated into other inventory management models such as EOQ or any other multiple order or single osrder inventory models. It can also be found in some inventory software packages.

When safety stock is present in inventory warehouses and it is rarely used or there is an excess safety stock holding, it can incur large inventory and holding costs that can outweigh the advantages of having it in the first place. It is important that most of this stock is also correctly rotated and managed in order to reduce write-offs and obsolesce.