Managing Inventory in These Times: Don't Trust the System

He wanted to find out why his expensive, relatively new ERP system had allowed inventory to balloon even though sales had plummeted. And he wanted to know how to use his system to prevent the level of inventory from growing any more. I asked him if in mid to late '08 inventory management and purchasing users made any changes in the way the system was set up or being used. His response was something like "of course not, the system runs by itself." In "normal times" he would be correct. But in these times, he and every other distributor should take the following system-related actions.

When Customers Vanish
When sizeable customers go out of business, the most sophisticated forecasting formulas available will not avoid purchasing too much. The same can be true when sizeable customers stop buying certain items completely. That's because the historical data used in forecasting incorporates sales that will not recur, and if the ex-customers do not all fold in the same month, a formula will react too slowly to the sales decline. The best way to address this situation is to enter manual adjustments to the sales data for the items involved; don't touch the real sales data. This way, if some customers form new businesses (or start buying items they had stopped buying), selected manual adjustments can be undone.

If the ex-customers accounted for a major portion of the sales of the items they had been buying, and those items were fast movers, they may now be slow movers. So if those items had been manually classified as fast movers for inventory management purposes, they might need to be re-classified as slow movers, and related parameters re-set.

If safety stock was kept to provide great service to the ex-customers, reexamine it and any other customer-specific inventory controls.

Sales Are Way Down

Even if no customers cease operating, when sales drop 15% or 20% over a short period of time, the computer system should not be allowed to function as usual. If it is, inventory will not decrease fast enough, or may grow.

Because a sales decrease usually impacts some items more than others, the historical data used in forecasting should be reviewed for those items for which unit sales have substantially decreased. The manual adjustments mentioned earlier might be needed, as might a re-classification of the method of inventory management; and related parameters might have to be changed.   

Lead times have always been difficult to accurately estimate, but they still need to be reviewed. For some items, lead times are actually growing as manufacturers scale back production in the face of declining sales. And even though some manufacturers have decreased their minimums, now is the time for a careful consideration of whether to buy items not yet needed, in order to meet a vendor's minimum; judge whether to wait on all the items in question, and run the risk of stocking out.

A final comment about manufacturers and inventory. When banks didn't worry about the value of inventory they were financing, manufacturer's deals involving dating and free goods were usually too good to pass up. But after several months of sharp declines in the cost of items, buying more than is really needed can create a problem if the bank refuses to provide the money needed to finance the extra quantities. Let the buyers know that, and give them guidelines for judging deals that are offered.

©2009 General Business Consultants, Inc.
About the Author
Dick Friedman is a recognized expert on inventory management for foodservice distributors, but does Not Sell systems or software. Based on more than 30 years of inventory management experience, he has developed unique techniques for reducing inventory without hurting customer service. Dick is a contributing author to ID Report, and consults with readers. Call 847 256-3260 for a FREE inventory management consultation, or visit www.GenBusCon.com for more information about inventory management, or to send e-mail.


More from our partners