Inventory management

[jdot2016]

I am looking to use Excel as an inventory management tool. I have about 100 items that I need to track. Anybody using anything creative in Excel to accomplish this? I want to keep track of physical counts (done 2-3 times per week), usage (how many to where on what date), and orders coming in to replenish the stock. It would also be a bonus if there was some sort of process to let me know a part needs ordered when I do the physical counts based and pre-established min max levels. I have seen something similar to this done on Access using a lot of tables and stuff...just wondering if anyone uses something similar in Excel and would be willing to share them with someone with mid-range Excel skills!! Thanks for your time!

 

[jdot2016]

just to expand on my idea a little bit...I would like each item to have a separate tab with some sort of ledger that shows all activity for an item so that everything is in one place for that item if I have to do a usage history or month-end reconciliation or anything of that sort. Yes...I know there are any number of software packs I could buy that would do this for me (SAP, etc.) but I was looking for a down and dirty version I could control.