Is your MIN a guess or a calculation? |
by Alan Skedd - February 2013 The most misunderstood - and often times most destructive - variable in managing inventories is the minimum stocking level or MIN. It is usually a guess by a well meaning inventory manager. It is usually updated once every few years. It is usually overstated. It is usually wrong. Current Stock Status systems use this variable as a key component of replenishment planning. These systems process instantaneously as transactions occur. They trip a new order as soon as the level drops to this MIN value. Sounds like a great solution - maybe like a lawn sprinkler set on a timer. Set it and forget it. Therein lies the problem with MIN values. Set them and forget them. They are usually set by a guess and are usually wrong. Over time, they are forgotten. As stocking conditions change, these MIN values don't change. They usually become more and more distant from the proper value. What should comprise a MIN value? This should include a lead time forecast as well as a safety stock buffer. There are several components which include:
For example, a part may have a MIN set at 100 pieces. If it is a $500 part then the MIN translates into a $50,000 investment. As long as the MIN is not tripped, the Stock Status system thinks all is well. If this MIN was a guess - and annual usage is only 10 pieces - then no orders are placed. Still, the Stock Status system thinks everything is fine. The problem here is that Stock Status systems do not concern themselves with overstock conditions - as long as the MIN has not been tripped everything is fine. In this case, a bad MIN guess has cost the company carrying cost on $46,000 - each year - because it has caused excessive over ordering. An initial MIN has an impact on Distribution operations. It has an impact on manufacturing operations. It has an impact on active (fast moving) parts. It has an impact on spare (slow moving) parts. Yet most operations have no tool to determine the proper MIN. They simply render a guess and forget about it. Experience has shown that a high percentage of obsolete inventory became obsolete due to excessive MIN values. Consider the following:
The phrase "think outside the box" is appropriate here. Stock Status systems are not designed to calculate the proper MIN value. The inventory operation relies on a proper MIN value. There are usually far too many items to calculate this MIN value for each part. A wide variety of "add on" software exists to address MIN values. This "add on" software is inexpensive and easy to use. The reduction in inventory investment - due to lower and more appropriate MIN values - often helps pay for the Stock Status system. It always pays for the "add on" software that corrected these values. The Decision Associates' solution is the Min Management System (MMS), the perfect way to set MIN, MAX, EOQ, and Safety Stock. The simplified user interface makes the task a breeze. You can learn more about the MMS by clicking MMSREF . |