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
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.
brought to you by enabling practitioners & organizations to achieve their goals using: