Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Analysing common sets of items in Bill of Materials
Previous Previous
 
Next Next
New Post 6/10/2014 9:11 PM
User is offline DHB21899
1 posts
No Ranking


Analysing common sets of items in Bill of Materials 

Hi,

 

I'm currently working on a project that seeks to identify sets items that are common throughout a wide range of differing Bills of Materials (BOMs)

What would be the best method to do this? Preferrably on excel as my company uses this the most for this kind of work.

My end goal is to produce 10-15 sets of items common in many BOMs which will then be kitted to save time when assembling the BOM.

Any help is welcome

 

Thanks

 
New Post 6/18/2014 2:41 PM
User is offline Chris Adams
323 posts
5th Level Poster






Re: Analysing common sets of items in Bill of Materials 
Modified By Chris Adams  on 6/18/2014 4:42:19 PM)

The problem you describe is most common within manufacturing and assembly facilities.

You can put a bunch of BOMs with each item as a line in an excel spreadsheet and then find what parts have the highest counts. This may help you elicit some helpful or interesting information.  But this can also be misleading. 

Most manufacturing is component based.  So a large product is made of of many components which are each made up of a series of individual parts.  You want to create kits that easily roll up to components.

So each kit would build a component.  Of course you may be able to take this a step further and find a common combination of parts that are used in multiple components. That way kitting the components will be even quicker since it's a kit of a kit. IKEA does this.  When you get a bunch of piece of hardware for your furniture, usually you open one plastic bag to find 10 other smaller plastic bags.

 


Chris Adams
Core Member – ModernAnalyst.com
LinkedIn Profile
 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Analysing common sets of items in Bill of Materials

Community Blog - Latest Posts

Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...
Building software products that solve actual customer concerns and generate business success is not an easy fit. Product executives battle strong competition, tight timelines, and high expectations, all while seeking to offer value. While success gives the opportunity to showcase approaches and frameworks, the reality is that building excellent pro...
Business Impact Analysis(BIA): Assessing the Potential Impact of a Cybersecurity Incident on Business Operations
In today’s highly interconnected society, businesses depend on technology even more than before. While offering opportunities for innovation and creativity, businesses are exposed to various cybersecurity threats that can disrupt operations, damage reputation, and result in substantial financial losses. It is crucial to carry out a comprehens...

 



Upcoming Live Webinars




 

Copyright 2006-2025 by Modern Analyst Media LLC