Numerical Insights
Turn Data into Improved Business Results
letter-447577_1920.jpg

Analytics Articles for Business, Supply Chain and HR

Analytics Articles: Human Resources, Supply Chain, Diversity and Business Analysis

Numerical Insights publishes articles on a variety of topics including business analytics, data analysis, data visualizations tools, improving business results, supply chain analytics, HR Analytics, strategic workforce planning, and improving profitability. We aim to make our articles informative and educational.

 

How to Reduce Excess and Obsolete Inventory

You’ve been summoned to a meeting with your CEO and CFO. They are furious. The CFO has discovered that you have over $1,000,000 tied up in inventory and it’s been that way for the last six months. They want to know what’s going on.

“We need you to free up cash flow from our inventory so we can use it to fund new product development. What’s the problem? Why do we have so much inventory?”

How You Got There

“We’re sitting on a large inventory of parts that were purchased to make products we don’t sell anymore. Our suppliers don’t offer returns so we’re trying to find a distributor that might want to sell these parts for us. If no-one wants them, we’re stuck and will have to write them off as a loss.”

Your CEO and CFO don’t want to hear this.

"Writing it off as a loss will not fund our product development project. Are you telling me all of this inventory is obsolete?”

You continue your explanation.

“Not exactly. We also have excess inventory from overseas suppliers. We purchased high levels of inventory to cover long lead times of overseas shipments and to leverage quantity discounts. We wanted to provide customers with high service levels by always having parts in-stock… but then market forces drove the monthly demand of some products down substantially. We’re now sitting on, in some cases, more than a year’s worth of inventory.”

The Double Impact of Excess and Obsolete Inventory

You worked hard, you wrote great contracts and you negotiated excellent payment terms. You realize at that moment that there is a double punishment associated with obsolete and excess inventory. 

  • Punishment #1: You can’t access the cash tied up in inventory.

  • Punishment #2: You’re going to spend a lot of time, resources and money trying to determine the best way to get rid of it.

High Rates of Excess and Obsolete Inventory for Manufacturers

spare-parts-2774041_1920.jpg

Excess and obsolete inventory for manufacturers can be 15-20% of stock. Warehouses often expect 15% of products to be returned, rejected or become obsolete. The total cost of this inventory can be as high as 25% when considering the cost of the storage, shrinkage, damage and the time value of money. 

The impact of excess and obsolete inventory is felt the greatest when thinking about the amount of cash that is tied up in product that can’t be sold to customers. In many cases, this inventory sits tucked away in a dusty corner of the factory or warehouse for extended periods of time. It rarely becomes supply chain’s top priority to relieve the company of this burden. 

5 Ways to Dispose of Inventory 

First and foremost, ensure your inventory is safe for disposal. If it can pose a liability in any way, seek expert advice before proceeding. 

  1. Find a customer or distributor who may want it. Sometimes when products become obsolete, there are companies that wish to run their old equipment for as many years as possible. If you’re carrying obsolete parts for their old equipment, they may be a possible buyer for those parts.

  2. Modify the parts to make them usable for something else. Sometimes a fitting or internal component change can make the parts useful for another product or a new product. For this option, weigh the cost of the modifications against the value of the obsolete parts. If it’s going to cost $25,000 to modify $5,000 worth of obsolete inventory to be able to sell it for $10,000, then…

  3. Auction off the parts. If you need to dispose of the inventory quickly or the cost of modifications doesn’t make sense, you may be able to hire an auction service. Again, weigh the cost of this action against the value of the obsolete parts.

  4. If your inventory is a multi-part unit, can the unit be taken apart to salvage any useful parts from it? Does the value of the salvaged parts make it worth the cost of the labour to conduct this action?

  5. Donate to a charity to obtain a tax credit. This option is more applicable to people with finished goods inventory. It is far less likely to be an option for a manufacturer carrying parts inventory. Check out EAL Green as one example that has been used by manufacturers. They use the money they generate to create student scholarships.

  6. I’ve listed 5 ways above. If you’ve exhausted the options above and you’re reading #6, it means you may need to walk into your accountant’s office and ask, “How do we write off scrap?”


How to Minimize Excess and Obsolete Inventory

As you head back to your office you begin to think about how you to avoid this situation in the future.

First, you will pay more attention to product demand data. Neither you nor your team was looking at the demand numbers and the decreasing patterns. Every product has a life cycle and you keep ending up with excess inventory every time you come to the end of production for a product. No-one on your team is mathematical, so you’re paying the price for not obtaining analytical expertise.

Numbers Do Matter

Next, because you’re “not into numbers,” you and your team failed to calculate the levels of inventory you should carry based on your desired service levels and demand volatility. You realize now that numbers do matter. You commit to researching forecasting methods and inventory level calculations or at least locating the expertise for these activities.

Finally, you realize that no-one was really keeping an eye on the accuracy of your inventory. You only cycle count once per year before year end so the numbers are accurate for the balance sheet. Throughout the year, you’re just not quite sure how accurate the inventory levels are inside your inventory management system. You commit to reading up on the ABC method of inventory.

With your new found commitment to supply chain analytics, you commit to creating an inventory and product demand dashboard to keep these important numbers in front of you at all times.

Bio 

Tracey Smith is a recognized analytics expert. She is the President of Numerical Insights LLC, a boutique analytics firm addressing the needs of businesses. If you would like to learn more about using data for better decision-making, please Contact us.