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

As Business Analysts in Agile teams, we often hear about Definition of Ready (DOR) and Definition of Done (DOD). But beyond the buzzwords, these two concepts are powerful tools to drive clarity, consistency, and quality in our work. Definition of Ready ensures a user story is truly ready for development. It answers: Is this story clear, feasible...
In today's fast-paced digital world, successful projects aren't just built on great code—they're built on clarity. And that clarity often comes from one key player: the Business Analyst. At the heart of every great product or system is a need—a business goal, a customer pain point, or a regulatory requirement. But busines...
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...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC