MS Excel may do a good job for a system described below by
Philip.
Regards,
Ramon
> -----Original Message-----
> From: Philip M. Yates [SMTP:[log in to unmask]]
> Sent: Tuesday, October 07, 2003 9:12 PM
> To: [log in to unmask]
> Subject: Re: [TN] Component Inventory/Storage
>
> Jim,
>
> At my previous EMS employer, we used an alphanumeric prefix and suffix
> system. We used the customer's part number, then added a prefix to
> identify the customer/contract, etc., and a suffix to indicate whether the
> components were purchased by us or consigned by the customer. The
> prefix/suffix length would be a function of your MRP system. It was easy
> to perform searches by the root part number if part swapping/sharing
> across contracts was required. Except for an in-house stores of common
> passives and logic provided by a major component distributor (common
> stock), inventory was organized by the customer related prefix. This
> worked well for the low to mid volume, high mix contract environment at
> the facility. Our inventory accuracy was essentially 100%.
>
> Thanks,
>
> Philip M. Yates (Phil)
>
> 256-679-6749
> [log in to unmask]
>
> -----Original Message-----
> From: TechNet [mailto:[log in to unmask]]On Behalf Of West, Jim
> Sent: Tuesday, October 07, 2003 1:17 PM
> To: [log in to unmask]
> Subject: [TN] Component Inventory/Storage
>
>
> Hi folks,
>
> We are in the process of re-defining our inventory/storage of
> components. We currently utilize the manufacturer part number as
> identification, and we store the components on the shelf under a customer
> name or a specific PCB part number. This has worked well for us for quite
> sometime, but we are finding more and more common components between
> customers and the boards we populate. This makes things difficult with
> determining a location for a particular component. My question is now
> that we have the opportunity to set up a better component
> Inventory/storage system, I was wanting to get a feel for what others are
> currently doing. I would like to understand what system is in place that
> works well. For example, how do you store components on a shelf,
> alphabetical, numerical? Do you use the manufacturers part number, or
> determine a custom number? How easy is it for others to locate a reel of
> components with your system? What type of shelving or racks works best
> with your system, particularly reeled components?
>
> Thanks,
> Jim
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV
> 1.8e
> To unsubscribe, send a message to [log in to unmask] with following
> text in the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at:
> http://listserv.ipc.org/archives
> Please visit IPC web site
> http://www.ipc.org/contentpage.asp?Pageid=4.3.16 for additional
> information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700
> ext.5315
> -----------------------------------------------------
>
>
> ---------------------------------------------------
> Technet Mail List provided as a free service by IPC using LISTSERV 1.8e
> To unsubscribe, send a message to [log in to unmask] with following text in
> the BODY (NOT the subject field): SIGNOFF Technet
> To temporarily halt or (re-start) delivery of Technet send e-mail to
> [log in to unmask]: SET Technet NOMAIL or (MAIL)
> To receive ONE mailing per day of all the posts: send e-mail to
> [log in to unmask]: SET Technet Digest
> Search the archives of previous posts at: http://listserv.ipc.org/archives
> Please visit IPC web site http://www.ipc.org/contentpage.asp?Pageid=4.3.16
> for additional information, or contact Keach Sasamori at [log in to unmask] or
> 847-509-9700 ext.5315
> -----------------------------------------------------
>
---------------------------------------------------
Technet Mail List provided as a service by IPC using LISTSERV 1.8e
To unsubscribe, send a message to [log in to unmask] with following text in
the BODY (NOT the subject field): SIGNOFF Technet
To temporarily halt or (re-start) delivery of Technet send e-mail to [log in to unmask]: SET Technet NOMAIL or (MAIL)
To receive ONE mailing per day of all the posts: send e-mail to [log in to unmask]: SET Technet Digest
Search the archives of previous posts at: http://listserv.ipc.org/archives
Please visit IPC web site http://www.ipc.org/contentpage.asp?Pageid=4.3.16 for additional information, or contact Keach Sasamori at [log in to unmask] or 847-509-9700 ext.5315
-----------------------------------------------------
|