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 10: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 3: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

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...
In today's ever-evolving market, businesses must adapt swiftly to remain competitive and meet the needs of a fast-paced digital economy. Among the various business strategies available, digital transformation, customer-centricity, and sustainability have emerged as top priorities. Let’s explore why these strategies are critical for busine...
The Cisco Certified Network Associate (CCNA) certification is a pivotal credential for networking professionals, validating your skills in networking fundamentals, security, automation, and programmability. Preparing for the CCNA exam can be challenging, but with the right strategy, resources, and mindset, you can successfully achieve this certific...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC