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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Inventory management
- Thread starter jdot2016
- Start date
Excel Facts
Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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.
Upvote
0
Similar threads
- Question
- Replies
- 3
- Views
- 399
- Replies
- 0
- Views
- 703
