logo

Making processes and organizations more effective

  • Home
  • Mission
  • Blog
  • Archives
    • Archive – Strategic Management
    • Archive – Inventory Management
    • Archive – Supply Chain Concepts
    • Archive – Tools
    • Archive – Lean Six Sigma/Theory of Constraints/Forecast
  • Facility Layout Posts
  • Helping You
  • Presentations
  • Case Studies
    • Lean Six Sigma
    • Logistics and Customer Service
    • Education and Training
    • Culture Change
  • Links
  • Biography
  • Contact Us

Category Archives: Tools

Inventory Drivers – Safety Stock

Inventory driverOne of the biggest Inventory Drivers is Safety Stock.  Safety Stock is, by definition, excess stock that you deliberately keep in order to insure higher Customer Service levels.  (We will talk about Customer Service in a later posting.)  There are many ways of calculating how much safety stock you need but the easiest is by calculating it based on the desired service level.  The formula for this is:

 Safety Stock = Standard Deviation X Service Level Safety Factor

 The problem with this is that as the desired service level goes up so does the required inventory but not in a linear form but rather as exponential growth.  What this means is that, as a rule of thumb, for the last couple of percent increases in service level the required inventory will double.  Specifically, if you need 1 million dollars’ worth of inventory for 97% service level, you will need about 2 million for 98%, 4 million for 99% and infinite inventory for 100%.  So when upper management says you are never allowed to stock out, it is statistically impossible (no such thing as 100% only 99 with a whole bunch of 9’s after the decimal). The more important point is that no organization can afford to carry enough inventory to ensure they never stock out. Fortunately theory and reality rarely match exactly and there are a number of controls and expedite tools to get better service levels than mathematically projected.  The larger point here is that most people (and ERP systems) just do the calculations and never question the answer.  This can lead to much higher inventory levels than necessary.  We need to control the inventory levels which means controlling the drivers (such as Safety Stock).

Regardless of the calculated number, one of the easiest ways to reduce it is to investigate the standard deviation of the demand and find ways to reduce it.  This will automatically reduce the calculated safety stock levels.  If your organization is already invested in Lean Six Sigma, this is a prime area for waste reduction and deviation control.  Some of the other areas that will affect safety stock are:

  • Inventory Accuracy levelsInventory Driver Safety Stock
  • Lead Time
  • Demand Inconsistency
  • Warehouse Capacity
  • Production Capacity
  • Service part commitments
  • Shelf life
  • Logistics (Inbound and Outbound)
  • Government regulations

Another issue with safety stock is that once it has been set, many organizations fail to review the number on a regular basis (at least annually).  For anyone using MRP this is critical because the system will automatically use the safety stock level quantity in the order point calculation.  Let’s say that a material has been discontinued and all the stock sold off.  If the safety stock level has not been reduced to zero then the system will automatically generate a new requisition to bring stock back up to at least the safety stock level.  If there is a standard lot size embedded in the system then the generated requisition will be for that lot size.  Unless someone notices that this is an obsoleted part it WILL be ordered and brought in, thereby creating excess / obsolete inventory.  How good is your system and could this happen to you?  Using Safety Time rather than safety stock will help avoid this problem because the level is set by the forecast rather than a fixed number.  If there is no forecast in the system than the quantity will auto set to zero.  This is also useful if you have a highly seasonal product as the safety stock quantity goes up and down in response to the forecast.  Of course that solution does assume a relatively accurate and up to date forecast which is a whole different topic.  (See my previous blog on Forecast Accuracy.)

The critical thing to remember in all this is that Safety Stock is all about balanced risk.  You are balancing the cost and risk of obsolete or slow moving stock against the risk of shorting a customer order.  Given the costs and repercussions of shorting a customer, most organizations will tend to keep a little more stock than necessary to ensure fewer stock outs.  While not necessarily a bad thing it should not be carte blanche to let the inventory run wild.  In the end inventory is just money in another form and no company can let their costs get out of control.

Enjoy thinking about this topic.  Talk to your friends and co-workers about their experience and thoughts on this topic, especially what it means for your organization.   I would love to hear back on your (and their) thoughts.flag

Inventory Drivers – Order Quantity

Inventory driverWelcome back to the ongoing series about Inventory Drivers.  Changing gears slightly I would like to move from accuracy to Order Quantity.   There are two aspects to Order Quantity – Minimum and Maximum.  There are also two different operational groups involved – Purchasing and Production.  All of these affect inventory levels both directly and indirectly plus you also need to consider whether you are looking at individual materials or aggregate levels.  The primary effect of order quantity on inventory levels is reflected in the standard formula for Average Inventory levels of individual items which is:

Average Inventory = ½ the lot size + safety stockInventory Driver Order Qty

The immediate and direct effect of this is that the larger the lot size the larger the average inventory.  Thus it would appear to make sense to reduce lot sizes as this would automatically reduce average inventory levels.  The problem, of course, is that there may be downsides to reducing the lot size.  If reducing the lot size increases your cost by more than the value saved by reducing inventory then this is a bad idea.  An easy example of this would be if you were receiving a liquid product by tank truck.  Reducing the lot size of each order will reduce the average inventory but the cost of shipping will be the same for both lot sizes.  Since the cost of transportation per unit is simple the cost divided by the number of units (let’s say Kilograms in this case) then the cost per kilogram goes up as the number of kilograms per load is reduced.  (I specified a tank trailer as you probably cannot replace the reduced material quantity with a second material which you could do if the material was in drums in a standard truck.)  The point is that the minimum and maximum levels you currently use are probably a reflection of some other constraining factors.  Even if you originally calculated the ideal quantity using the Economic Order Quantity (EOQ) formula it was then rounded to reflect some other factor or factors such as truck size, packaging quantity, takt time…  Does that mean that EOQ is a waste of time?  Absolutely not, but you must recognize that it is only a starting point.  Rounding from the EOQ is easy because when you graph the cost pattern you get a “bathtub” pattern not a bell curve.  In a bathtub pattern (or curve) you have high points at either end with a long flat lower area in the middle. (It looks like a cut-out of a bathtub silhouette, hence the name.)  Since the EOQ point will be in the middle of this flat zone, rounding the number has very little effect on the ultimate cost per unit.  What we need to do in order to reduce inventory levels is to slide the whole curve down.  In order to do that effectively you must first understand what other factors affect the size.  If it is an internal quantity it may not be that difficult to determine what other factors are driving the lot size (mixer size, takt time,,,).  By modifying the appropriate factors you then modify the EOQ which gives you a different range for rounding.  For purchased material this may be a little more difficult as you may not have access to understand, or the ability to change, the cost structure at your suppliers organization.  In addition you also have a set of logistics based cost factors that may also be affecting the final order quantity.

One important consideration about order quantity is that you may not have to order in multiples of the order quantity.  It is possible that the quantity represents a minimum and that once you pass that quantity you can move to a smaller multiplier or even to a lot size of 1 (order exactly what you need).  Again, understanding the drivers that affect the lot size will define the flexibility in the lot size

Bottom line, this is an exercise in strategy versus tactics.  Management instructions (strategy) for inventory reductions will probably be expressed as an aggregate (eg: reduce inventory by 20%) but proper inventory management (tactics) will require you to plan your reductions at the individual material level.  You need to identify those materials that can be reduced, that have a large enough quantity to achieve your aggregate goals and the drivers that affect the inventory levels (in this case, order quantities) before you create a plan to satisfy the strategy.  Failure to do this will almost certainly result in the inventory quickly growing back to its original quantity.  There are reasons for the inventory on hand and if you do not understand and control those reasons you cannot control the inventory levels properly.

Enjoy thinking about this topic.  Talk to your friends and co-workers about their experience and thoughts on this topic, especially what it means for your organization.   I would love to hear back on your (and their) thoughts.flag

Previous Entries
Next Entries

RSS Feed

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Recent Posts

  • Forecasting your MRO stock
  • Segmenting your MRO stock
  • 10 RULES TO IMPROVE COMMUNICATIONS
  • COMMUNICATIONS: YOUR NUMBER ONE FORECASTING TOOL
  • What is ”Operational Excellence”?

Categories

  • Forecast (3)
  • Inventory Management (19)
  • Lean 6 Sigma (12)
  • Strategic Management (21)
  • Supply Chain Concepts (33)
  • Theory of Contraints (6)
  • Tools (27)
  • Value (6)

Pages

  • Home
  • Mission
  • Blog
  • Archives
  • Helping You
  • Presentations
  • Case Studies
    • Lean Six Sigma
    • Logistics and Customer Service
    • Education and Training
    • Culture Change
  • Links
  • Biography
  • Contact Us

Log In

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Copyright Jade Trillium Consulting 2013