Re: [CAD_CAM_EDM_DRO] Re: Parts Inventory Control Software (OT)

Based on years of experience in machinery maintenance I have to
respectfully disagree with one of Marv's points. Attemp and
agreessively try to organize like materials. Especially the very
common things such as fuses, switches and the like. That is put each
series of parts into a common location, such as your ABC fuses in one
drawer and the 5mm fuses in another. Further keep them organzed and
in order. This is even more important when an item you may need is
made up of several parts such as switches.

The primary reason for this approach, which by the way is not likely to
jive with common inventory management practices is to save on leg
work. There is nothing worst than having to go clear across a stock
room to find the lever arm for the switch you just grabed for a
machine. This also makes it much easier to retrive hardware without
having to reference an inventory system. Then you have to consider
the benefit it provides to innovation and development.

Of course you do have to know when to stop. For some things it is not
worth the effort, based on frequency of access. Plus you have to
consider space utilization.

Thanks
Dave


Marv Frankel wrote:

>Bruce,
> It should be fairly easy to set up an inventory control system
>using Excel, or a similar spreadsheet. First, you have to create
>labels for your shelves, by level and location, such as: A-1..2..3
>etc.. which would be the lowest level, and B-1..2..3, which would be
>the next level up, etc.. When you put an item in a shelf location,
>enter the item description and location on a file card, and once a day
>enter the data into your spreadsheet, from these cards. Don't try to
>keep similar items together. You'll be able to do that, using the sort
>function of your spreadsheet.
> This is a simplified version of systems that I've used in
>Distribution Centers as large as 1.4 million Sq. ft., with as many as
>114,000 shelf locations.
>
>Marv Frankel
>Los Angeles
>
>--- In CAD_CAM_EDM_DRO@yahoogroups.com, Bruce Craig <docsys@a...> wrote:
>
>
>>Parts Inventory Control Software
>>
>>Hope this is on subject, but I am looking for some type of software to
>>manage the large qty of parts and hardware that I have aquired.
>>
>>I am thinking about a program that would keep track of bolts and nuts
>>along with custom parts I have made.
>>
>>If there is a easy to use, low cost database program would be best.
>>Cost would be under $100, that would pay for itself when I spend a
>>couple of hours looking for things.
>>
>>Any ideas?
>>Bruce
>>
>>
>>
>
>
>
>
>
>
>Addresses:
>FAQ: http://www.ktmarketing.com/faq.html
>FILES: http://groups.yahoo.com/group/CAD_CAM_EDM_DRO/files/
>Post Messages: CAD_CAM_EDM_DRO@yahoogroups.com
>
>Subscribe: CAD_CAM_EDM_DRO-subscribe@yahoogroups.com
>Unsubscribe: CAD_CAM_EDM_DRO-unsubscribe@yahoogroups.com
>List owner: CAD_CAM_EDM_DRO-owner@yahoogroups.com, wanliker@..., timg@...
>Moderator: pentam@... indigo_red@... davemucha@... [Moderators]
>URL to this group: http://groups.yahoo.com/group/CAD_CAM_EDM_DRO
>
>OFF Topic POSTS: General Machining
>If you wish to post on unlimited OT subjects goto: aol://5863:126/rec.crafts.metalworking or go thru Google.com to reach it if you have trouble.
>http://www.metalworking.com/news_servers.html
>
>http://groups.yahoo.com/group/jobshophomeshop I consider this to be a sister site to the CCED group, as many of the same members are there, for OT subjects, that are not allowed on the CCED list.
>
>NOTICE: ALL POSTINGS TO THIS GROUP BECOME PUBLIC DOMAIN BY POSTING THEM. DON'T POST IF YOU CAN NOT ACCEPT THIS.....NO EXCEPTIONS........
>bill
>List Mom
>List Owner
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>