Inventory sucks. Trying to figure out what you have, where it is, and when you need to buy more is a pain. Any pure software solution is only as good as the diligence of those entering in the data. I wanted something automatic where I could find what components I have available to use in a design, allow whoever is purchasing items to be able to know when they actually need to make purchases, and keep the manufacturing floor running smoothly.
COVID shortages made it impossible to plan designs, let alone having insane amounts of storage of unknown parts that I had to dig through to see if we even had something.
A linear encoder went obsolete for a robotics product at my former employer, and I had 2 weeks to try and find a replacement. There was no drop in replacement, resulting in a 6 month delay. This could have been resolved if we had accurate logs of production and known quantities of the encoders to plan out properly.
Dylan