I need help with Inventory Management

Any software suggestions?

Or tips on setting up excel sheets?

 

I am a new Production Supervisor.  I have a lot to learn regarding management.  But first thing is I am trying to create a system to manage/keep track of the 100-1000's of items I need to purchase, where I get them, where they are in the shop, and what they are for.  

I have 40-75 different vendors, most with a few items, others with a few hundred.  The guy that used to do purchasing had all the information in his head and has been helpful, but i'm trying to get things on a spreadsheet or somewhere so that it is easily referenced, and set-up so the next guy can "step-in" and do the job without the steep learning curve I'm experiencing.  

 

Mind you this is a small company that has been running for 50 years by "tribal knowledge". So I'm fighting the battle here just to keep up.

https://blog.capterra.com/the-top-5-free-inventory-software-systems/

Or just fork over the 200 bucks and get quickbooks

We use Dell's KACE appliance to manage all our hardware inventory.

headroll -

We use Dell's KACE appliance to manage all our hardware inventory.

We use Visual.

But our hardware (and most parts under $5) are considered Consumable and we don't track amounts. 

We use a Kanban Card system for ordering.

Sub because I'm in the same boat. Sort of.