RSNeely Posted July 16, 2015 Report Share Posted July 16, 2015 How does everyone keep a count on how many tabs you have? I keep material in a rack of small drawers but was wondering if it would help if had some type of excel inventory sheet. Anyone? Quote Link to comment Share on other sites More sharing options...
smalljaw Posted July 16, 2015 Report Share Posted July 16, 2015 I'm old school, I use a binder with zip lock bags with the name of color, the place I got it from, the number of tabs and the item number. Then I have an old clip board with the name of each color and how many tabs I have and then if I make a single spinnerbait and use 2 tabs of pearl, then I'll subtract that number from what I have and that will be the new number, very easy and keeps track really well. I also reorganized for my half tabs and extras, I still mark down a full tab even if I use 4 strands off of it but then I would put in a scrap bin but now I have 2 zip locks for every color, the one zip lock if full of whole tabs and the other is where I keep the half tabs and extra strands, that way I don't have to search a big bin of scraps to get the half of a certain color tab, I just look in my binder and see what I have in my scrap bag. 1 Quote Link to comment Share on other sites More sharing options...
cadman Posted July 16, 2015 Report Share Posted July 16, 2015 (edited) I don't actually keep track of each tab. I always keep minimum of 50 to 100 tabs on hand. I keep all my skirts in Plano boxes marked with the color and number in each compartment, so I can easily see if I am getting low. If I start getting low (about 50 tabs), I write it down on my" To Order" list. I try not to keep track of every tab or a matter of fact each hook. Too much like work and too time consuming to add and deduct quantities on a spread sheet on a daily basis. My counts would always be off. On popular colors I always have an additional 100 pack in my overflow box. I rarely ever run out. this is the way I handle my madness. Probably not the answer you're looking for. Edited July 16, 2015 by cadman Quote Link to comment Share on other sites More sharing options...
RSNeely Posted July 16, 2015 Author Report Share Posted July 16, 2015 Thanks for the quick responses. Yes i am Cadman! I was also thinking id get lazy with the excel sheet and forget to update it. But may be worth it once its all put together. Seems like a good winter project. Quote Link to comment Share on other sites More sharing options...
Basseducer Posted July 16, 2015 Report Share Posted July 16, 2015 My business program does all that for me. Like Cadman I keep tabs in Plano boxes. As I buy new ones I add the amount to the appropriate item number in the program. Then as I sell a jig or spinnerbait/buzzbait the program subtracts all the components from inventory. I set the reminders to alert me when a components falls below the desired onhand level. 1 Quote Link to comment Share on other sites More sharing options...
RSNeely Posted July 16, 2015 Author Report Share Posted July 16, 2015 What program is that? Quote Link to comment Share on other sites More sharing options...
Basseducer Posted July 16, 2015 Report Share Posted July 16, 2015 Quickbooks PRO Quote Link to comment Share on other sites More sharing options...
smalljaw Posted July 16, 2015 Report Share Posted July 16, 2015 I'm far from organized but the accordion folders make it easy to keep my stuff in one spot and then the clipboard and pen are right there, every time I take material out, I mark it down, it takes 5 extra seconds. Quote Link to comment Share on other sites More sharing options...
JSC Posted July 17, 2015 Report Share Posted July 17, 2015 I think what ever method works the best for you .. Fortunately I have in the past worked a lot with FileMaker Pro and I have created a data base thru PO, Work Order and invoices that is pretty well automatic .. Still gotta enter the data ... I am not a spread sheet person .. If I had to build this for some one it would cost a bundle as I have worked on it and tweaked it for over 15 years. ... Depends on how much information you need .... Quote Link to comment Share on other sites More sharing options...
Vodkaman Posted July 17, 2015 Report Share Posted July 17, 2015 A simple spreadsheet is what I would be using. You can easily get the sheet to do any adding or subtracting automatically. I can build you something simple, just write down what you want the sheet to do. DAve Quote Link to comment Share on other sites More sharing options...
joelhains Posted August 7, 2015 Report Share Posted August 7, 2015 Wow am I ever lazy! I just have bags of tabs thrown in boxes LOL! I fish through the boxes untill I find what I'm looking for. If I can't find it I'll order more. Quote Link to comment Share on other sites More sharing options...
