Times in Yasni Exposé of Vijay S. Sonawane

TOI Election Special offers latest news and videos on Lok Sabha Elections 2009, poll campaign coverage, Indian Parliament Election and latest updates on India 09 polls

Safety Stock First of all, here's the formula so you don't have to dig through my well-written article for it.Safety Stock:  {Z*SQRT(Avg. Lead Time*Standard Deviation of Demand^2 + Avg. Demand^2*Standard Deviation of Lead Time^2} If that wasn't clear to you, I suggest reading on.  This article will explain in detail what safety is used for, and how to use it. Inventory management is about two things: not running out, and not having too much. Our desire to not run out, along with uncertainties in demand and supplier lead times are why we have inventory in the first place. Essentially, inventory is a reserve system to prevent a stock out. However, as important as it is to prevent such a stock out, we also don't want to hold onto too much inventory because of holding costs. So how do you balance the two and what is the right amount? More importantly, when should you re-order in order to prevent a stock out? The answer to this can be determined by obtaining and applying the following information about the inventory you wish to manage. Re-order Point (ROP)1. What is the average lead time for the part/finished good that you need? 2. What is the standard deviation of that lead time? It is very important to track how long shipments take from you suppliers. If you are not doing this, start. It should be your top priority. Assuming you have tracked the data, excel can very easily help you determine your standard deviation. In excel, go to the toolbar and click on Insert, then click on Function, and choose STDEV and click ok. Then, enter in as much lead time data you have and presto, you have your standard deviation. 3. What is the expected demand you are working with? 4. What is the standard deviation on this demand?  Perhaps this is something you will be familiar with from experience, however, if not, this is something you should be able to squeeze out of Ted from the marketing department.  One way to find it is to look at historical demand and use the STDEV function in excel to determine it. 5. How sure do you want to be that you aren't going to run out? 90%, 95%, 98%, 99%? Whatever you decide, this will become your service level. Using this percentage, a statistical z-table should be used to get the corresponding «z-value.» A good z-value webpage can be found at http://www.inventoryops.com/safety_stock.htm. So, for example, if you want a 98% service level, you would use 2.05 as your z-value. Ok, so you've gathered this data, now here's what you do with it. (Underlined section is safety stock) Re-order point=Average Lead Time*Average Demand + Z*SQRT(Avg. Lead Time*Standard Deviation of Demand^2 + Avg. Demand^2*Standard Deviation of Lead Time^2) In this formula, the first term (Average Lead Time*Average Demand) is the average demand. The second term {Z*SQRT(Avg. Lead Time*Standard Deviation of Demand^2 + Avg. Demand^2*Standard Deviation of Lead Time^2} is the term that allows for the safety stock. In other words, the second term is the optimal safety stock level. It is not simple to gather all the data that is needed for the calculations. For a product with multiple parts, each part needs to have its own re-order point calculations and its own safety stock calculation. This can all become very confusing if proper computer modeling is not employed. Although I mentioned excel earlier, excel is probably not sufficient for your company's software needs. If you have not already done so, it is very important to look into an integrated software package for these calculations and many others.

Terminology and calculations   The following is a  list of the variables and the terminology used in this safety stock model: Normal distribution.  Term used in statistical analysis to describe a distribution of numbers in which the probability of an occurrence, if graphed, would follow the form of a bell shaped curve.  This is the most popular distribution model for determining probability and has been found to work well in predicting demand variability based upon historical data. Standard deviation.  Used to describe the spread of the distribution of numbers.  Standard deviation is calculated by the following steps: determine the mean (average) of a set of numbers. determine the difference of each number and the mean square each difference calculate the average of the squares calculate the square root of the average. You can also use Excel function STDEVPA to calculate standard deviation.  In safety stock calculations, the forecast quantity is often used instead of the mean in determining standard deviation. Lead time.  Highly accurate lead times are essential in the safety stock/reorder point calculation.  Lead time is the amount of time from the point at which you determine the need to order to the point at which the inventory is on hand and available for use.  It should include supplier or manufacturing lead time, time to initiate the purchase order or work order including approval steps, time to notify the supplier, and the time to process through receiving and any inspection operations.  Lead-time demand.  Forecasted demand during the lead-time period.  For example, if your forecasted demand is 3 units per day and your lead time is 12 days your lead time demand would be 36 units.  Forecast.  Consistent forecasts are also an essential part of the safety stock calculation.  If you don't use a formal forecast, you can use average demand instead. Forecast period.  The period of time over which a forecast is based.  The forecast period used in the safety stock calculation may differ from your formal forecast periods.  For example, you may have a formal forecast period of four weeks while the forecast period you use for the safety stock calculation may be one week. Demand history.  A history of demand broken down into forecast periods. The amount of history needed depends on the nature of your business.  Businesses with a lot of slower moving items will need to use more demand history to get an accurate model of the demand.  Generally, the more history the better, as long as sales pattern remains the same.  Order cycle.  Also called replenishment cycle, order cycle refers to the time between orders of a specific item. Most easily calculated by dividing the order quantity by the annual demand and multiplying by the number of days in the year. Reorder point.  Inventory level which initiates an order.  Reorder Point = Lead Time Demand + Safety Stock. Service level.  Desired service level expressed as a percentage. Service factor.  Factor used as a multiplier with the Standard Deviation to calculate a specific quantity to meet the specified service level. I have included a service factor table below or you can use Excel function NORMSINV to convert service level percentage to service factor.   Service Level Service Factor Service Level Service Factor 50.00% 0.00 90.00% 1.28 55.00% 0.13 91.00% 1.34 60.0 0% 0.25 92.00% 1.41 65.00% 0.39 93.00% 1.48 70.00% 0.52 94.00% 1.55 75.00% 0.67 95.00% 1.64 80.00% 0.84 96.00% 1.75 81.0 0% 0.88 97.00% 1.88 82.00% 0.92 98.00% 2.05 83.00% 0.95 99.00% 2.33 84.00% 0.99 99.50% 2.58 85.00% 1.04 99.60% 2.65 86.0 0% 1.08 99.70% 2.75 87.00% 1.13 99.80% 2.88 88.00% 1.17 99.90% 3.09 89.00% 1.23 99.99% 3.72     Understanding the statistical model and factoring in additional variables.   As mentioned previously, an understanding of the statistical theory behind this formula is necessary to ensure optimal results.  The statistical model uses the standard deviation calculation to describe the probability of a number occurring in reference to the mean in a normal distribution.  A table is then used to determine a multiplier to use along with the standard deviation to determine ranges of numbers which would account for a specified percentage of the occurrences. The multiplier is referred to as the number of standard deviations required to meet the percentage. The theory states that zero standard deviations added to the mean will result in a number in which 50% of the occurrences will occur below, one standard deviation added to the mean will result in a number in which 84% of the occurrences will  occur below, 2 standard deviations added to the mean will result in a number in which 98% of the occurrences will occur below, and 3 standard deviations added to the mean will result in a number in which 99.85% of the occurrences will occur below. In the safety stock calculation we will refer to the multiplier as the service factor and use the demand history to calculate standard deviation. In its simplest form this would yield a safety stock calculation of :  safety stock = (standard deviation) * (service factor).  If your lead time, order cycle time, and forecast period were all the same and if your forecast was the same for each period and equaled the mean of the actual demand for those periods, this simple formula would work great. Since this situation is highly unlikely to occur you must add factors to the formula to compensate for these variations.  This is where the trouble lies. You must add factors to adapt this theory to work with your inventory, however, each factor you add compromises the integrity of the original theory. This isn't quite as bad as it sounds. While the factoring can get complicated you can keep tweaking it until you find an effective solution.  Your final formula will look like:  safety stock = (standard deviation)*(service factor)*(lead-time factor)*(order cycle factor)*(forecast-to-mean-demand factor). There is not a general consensus on the formulas for these factors; in fact, many calculations do not even acknowledge the need for them.  I will give some recommendations for these factors, however, I strongly suggest you test and tweak them with your numbers to arrive at something that works for you. Lead-time factor.  This is necessary to compensate for the differences between lead time and forecast period.  The standard deviation was based on the forecast period, a factor is necessary to increase or decrease the safety stock to allow for this variance.  A formula you can try is lead time factor = square root (lead time/forecast period). Order cycle factor.  Since longer order cycles result in an inherent higher service level you will need to use a factor to compensate for this.  A formula you can try is Order cycle factor = square root (forecast period/order cycle). Forecast-to-mean-demand factor.  Remember that the original statistical model was based upon the mean of the distribution. Substituting a forecast for the mean in the calculation of standard deviation creates a problem if the forecast mean and the actual demand mean are not close and also if the forecast varies between forecast periods (seasonality, sales growth).  Sorry but I don't have a canned formula for this one that I feel confident enough with to publish.  The actual formula used will vary based upon the types of variances and the method for standard deviation calculation used. Minimum Reorder Point.  For slow moving products and especially if the lead time is short, you may want to program in a minimum reorder point which is the equivalent of one average sale. Lead-time Variances.  You may have noticed that I have only discussed demand variations in this model. While you can use this model for predicting variations in supply, I have found that supply variations tend to be far too random and unpredictable.  Supply problems tend to be related more to a vendor than an item and the severity of the variations do not fall into the pattern of a normal distribution. The safety stock calculated for demand variation will also cover for some supply variations, however, the best way to deal with variable supply is to have a high level of communication with the vendor and not to count on safety stock.  You may find that certain items which are critical to your operation may require a safety stock calculation based upon the nature of the supply chain of the specific item. While all of these factors and their potentially detrimental effect upon the integrity of the original formula may leave you feeling less than confident with the results of this model, you should realize that these factors would be necessary in any method of calculating safety stock which takes a scientific approach to meeting service levels  while maintaining minimal inventory levels. It is very important to thoroughly test the model prior to final implementation to ensure it is working correctly and to determine impact on inventory levels and cash flow.  It's also a good idea to start with a higher service factor initially and gradually reduce it until your actual service levels meet your objectives. You will never find perfection in determining probability, however this type of formula is certainly more effective than the previously mentioned keep it simple approaches.

Times of India brings the Latest & Top Breaking News on Politics and Current Affairs in India & around the World, Cricket, Sports, Business, Bollywood News and Entertainment, Science, Technology, Health & Fitness news & opinions from leading columnists.

Economic Times India's Leading Business Newspaper offers Business News, Financial news, Stock/Share Market News, Economy News, Loans & Banking News, Live Stock Quotes and News & Investment analysis on Mutual Funds, Gold, Forex and Real Estate.