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 8: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 1: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

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
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...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC