ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Q&A: How to Manage Bill of Materials throughout Product Life Cycle

Updated on February 14, 2014

Manage electronics Bill of Materials

Why Microsoft Excel Spreadsheet is not enough to manage my BOMs?

Why it's so difficult to be error free? Check out the common challenges of managing bill of materials using excel spreadsheet:

Problem: Obsolescence and Lifecycle

Why: If you can't source a part, you can't build a product. Just imagine that when you finally finished your product development, one of your key component is reaching end of life. It might cause a disaster to your production plan if the component happened to be hard to find ones in the market.

How: Instantly check obsolescence and availability information in time to make design changes or find alternatives. As an engineer, you should always be alerted to the lifecycle of your components. Excel doesn't help that automatically.

Problem: Availability and Pricing

Why: Time consuming to visit multiple supplier websites, searching part numbers and checking stock. Today, there are more than a dozen of popular online suppliers who offered the most of the components in the market. Are you choosing the most reliable suppliers? with best price on your volume? and best delivery term? Of course you can build an Excel spreadsheet to do the comparison manually. A BOM with 100 components could cost you hours, even days.

How: Instantly compare real-time pricing and stock information from multiple suppliers. Well, obviously you need a piece of dedicated software to do the tedious job.

Problem: Alternatives/Substitutes

Why: Time consuming to identify possible alternative or substitute parts. There is always surprises in your life. Every engineer has bad experience that in the last design stage, your selected component failed, or hard to source. You have to find a good and reliable substitute. Cry for help in forum? Excel is not your saver in this case. Often you need to rely on some professional advises.

How: Instantly find potential alternative/substitute parts from a well established cloud database. Only a professional software solution can help you with it.

Problem: Data Fragmentation

Why: Impossible to get important overviews and see the big picture (i.e. total component quantities across multiple products). You are often working with your colleagues parallel on project. You need to be updated with the resource used in your company. This is not possible with multiple Excel spreadsheet.

How: Single data source, elliminate fragmentation. If everyone is working on the same database, problem solved!

Problem: Where-Used

Why: Time consuming, error prone to get an overview of what component is used on which designs. In case of one failed component was polluted to your whole product lines, you need to dig it out.

How: Instantly see what product and version a component is used on. Again, you need a good overview on each specific component.

Problem: Traceability

Why: Uncontrolled changes can be made to documentation, changes are not correctly recorded. Everyone made mistake, but you need to be able to trace who made the mistake and why. When an Excel sheet has been modified hundred of times, you simply lost your trace.

How: Fully revision controlled, every change to a component or bill of materials is recorded. Like source code control, every change need to be recorded with all details.

Problem: Error Propagation

Why: Information fragmentation causes error propagation and repeated mistakes. One mistake could lead to multiple issues.

How: Central component library, single information source for component data, fragmentation cannot occur.

Problem: Sourcing

Why: Uncommon, non-stock, obsolete parts can be difficult to source. Often it's no longer available on online suppliers, or the lead time is too long to be accepted. You cannot afford the production line stopped because of missing component.

How: RFQ (Request For Quotation) feature submits quotes to all related distributors globally. Obviously you can't send hundreds of RFQ by emails, or fill the RFQ form on those specialized distributor website one by one manually. Here, a professional software with all distributors information can help you out.


    0 of 8192 characters used
    Post Comment

    No comments yet.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)