Managing BOM and component availability

[engr_joni_ee]

A hardware design having more then 100 different components in the schematic and PCB design, how can we manage the bill of material (BOM) and the component availability in efficient manner. The cost of components can be changed, the lead time can be changed. Is there any tool that can help in managing the BOM ?

 

[D.A.(Tony)Stewart]

Solutions range from simple spreadsheets to complex databases to MRP systems or choosing a Distributor or prototype shop to build it who has all the parts.

 

[engr_joni_ee]

The PCB deign tool which I am using has the possibility to generate BOM in which part numbers, quantities, part name and description are shown in addition to supplier part name.

How do we check in efficient way if the parts in BOM still available in enough quantity and the total price of all the parts ? One option is to check manually. This may take several hours. Do we have any quick mechanism ?