Posts tagged as:

Bill of Materials

excel-multiple-bom

Excel and Bill of Materials. What can be better to start a discussion? One of my favorites blogging buddies and author of eng-eng blog Ed Lopategui hit the button of BOM & Excel discussion in his GrabCAD blog – It’s time to drop Excel BOM. I liked the following passage. It speaks about huge cost involved in management of changes using Excel:

There’s one fundamental constant in all of engineering: change. Aligning with the capability to change quickly and often is crucial in fighting back ever-increasing schedule pressures. Excel BOMs provide no help here. A separate Excel BOM has to be manually synchronized with each design change. It’s usually in this confusion where some of the bigger and most expensive errors tend to happen. Conflicts are common and notoriously difficult to set straight. Recognize that the information in a BOM is every bit as vital as your CAD design, and should be managed accordingly. For the very same reasons you benefit from managing CAD, so should you do the same with a BOM.

Ed’s post took me back five years to my Why do I like my PLM Excel spreadsheets?  Excel is super flexible and powerful. However, it comes with cost. I summarized them here – PLM Excel spreadsheets: from odes to woes. Very recently I put a possible recipe how PLM can compete and take over Excel spreadsheets. These are important 3 ingredients - (1) flexible data model, (2) easy customization and (3) flawless user experience.

One of the topics in Ed’s blog, took me far beyond just usage of Excel to edit BOM. It was about how to manage bill of materials between engineering and manufacturing space. Here is the passage:

So far we’ve been talking about BOMs strictly from a design perspective. But the expectation that there can be only one BOM to rule them all is unrealistic. There are different ways to slice BOMs, different disciplines may have a need for their own specific view or information. How manufacturing looks at a BOM in ERP will be fundamentally quite different from how engineering looks at a BOM.

The topic of multiple BOM management isn’t so new. The truth is every enterprise system wants to manage their portion of BOM. In PLM space BOM management is often comes with the strategy of multiple BOMs or BOM views. Most of PLM systems can support multiple BOMs. The idea of separating BOMs into different slices or views is current answer to how to let every department in the organization to own their portion of BOM.  Most of organizations are doing that because they didn’t find an alternative way to agree how to manage BOM. So, data is split between CAD, PDM, PLM, ERP, MRP, CRM and other domains. Read more about it in my article Why companies are not ready for single BOM? One of the biggest problems in using multiple bill of materials is related to collaboration between people in organization. Multi-BOM leads to huge data synchronization problem. The question “where is my BOM?” is usually the one that kills collaboration.

What is my conclusion? To manage BOM in Excel is a nightmare. So, to bring BOM management tools to replace Excel is a very good idea. However, most of companies are having though time to decide how to manage bill of materials among different systems and environments. In a real world companies are relying on combination of Excel, PDM/PLM and ERP to manage multiple BOMs. Unfortunately, it kills collaboration, productivity and innovation. Just my thoughts…

Best, Oleg

Share

2 comments

BOM-data-lifecycle-process

In my recent post about bill of materials – Bill of Materials (BOM): process or technology challenge? I touched the variety of topics related to BOM organization – multiple BOMs and need to manage BOM located in different systems. My main question at the post was around how to make the work with multiple BOMs easier? The problem is tough and the answer is not easy and straightforward. While I was googling the internet to find what others think about this problem, my attention caught TeamCenter PLM blog post – Bill of Material Lifecycle. This posts presents multiple BOMs as a result of changes in the product lifecycle – design, manufacturing, service. Here is a passage I captured:

It is interesting to discuss on BOM lifecycle and its evolution from conceptual stage to full fledge manufactured product to maintenance. In this blog I will explain through life cycle of BOM across the product life cycle done as in house development. The BOM lifecycle can varies based on overall process of company for example some company might only manufacture as order hence they As Build design BOM and they directly CREATE Manufacturing BOM from it.

All together, it made me think that concepts of data, lifecycle and process is often  can create a confusion and overlap. I want to clarify these concepts and present how they can be combined together to manage single BOM in the organization.

1- Data

Data is the most fundamental part of Bill of Materials. It combined from data about product, assemblies, parts and relationships between them. Fundamentally, assemblies and components are connected together to form the result data set representing a product. This data set can be presented in many ways – tabular, hierarchical and many other forms (eg. graph). Data about parts leads us to the place where information about product, assemblies, components, supplies and manufacturers is managed. This information can reside into one of the following systems – CAD, PDM, PLM, ERP, SCM and others.

2- Lifecycle

Lifecycle defines the difference between bill of materials of the same product, but associated with different product development periods (stages). Here is the example of some typical  stages – concept, design, manufacturing, service. However, these stages are not the same for many companies and can reflect industry, specific business practices, regulation and many other aspects. It is very important to capture relationships between Bill of Materials of the same product (assembly) in different lifecycle stages. Missing lifecycle stage connection can cause a lost of very important product lifecycle information and product development traceability. In some regulated industries such

3- Process

Process is a set of activities that defines Bill of Materials data as well as changes in a lifecycle. Sometimes process can be very informal- save of assembly and parts using design system. It will product design BOM data. However, with the complexity of product development and specific organization, some processes are including changes of data, lifecycle stages as well as people involvement. If you think about ECO process, it might change few bill of materials, lifecycle stages as well as product/part information.

What is my conclusion? The problem of bill of materials management must be separated into three distinct problems: 1/ how to create data with BOM? 2/ how to control product dev stages and differentiate the same BOM across the lifecyle; 3/ how to provide tools to manage process and people to work with data and stages. All together, the problem is complicated. However, separated into these pieces it can help you to build a strategy for your BOM management regardless on tools you are going to use. Just my thoughts…

Best, Oleg

Share

0 comments

bom-google-add-on

For the last few years, I’ve been chatting about the opportunity to use Google infrastructure and tools to innovate in PLM, engineering and manufacturing.  Google enterprise apps influence on PDM/PLM market is still minor these days. However, I believe, Google cloud infrastructure and tools are consistently inspire established vendors and new companies to develop better solutions.

Earlier last week, I was discussing about how PLM can take over Excel spreadsheets. For long time, PLM tools have love and hate relationships with Excel. MS Office applications are very popular  in every organization for collaboration. Think about SharePoint, Word, Excel. Specially Excel spreadsheet is a king tool in everything that related to BOM management. My old article “My Excel Spreadsheets: From Odes to Woes“ speaks about pains related to the use of Excel for collaboration.

Online tools can solve many problems people are facing when use standalone Excel spreadsheets. Earlier today, Google informed about launching so called “add-on store” for Google Docs and Sheets. Read more here. One of the killing aspects related to Google Sheets Add-on is a transparent way to integrated application user experience within spreadsheet. Watch this video to see more.

Several applications were announced together with Google Sheets Add-on. I selected few of them that can make a lot of sense for engineering collaboration – Project Sheet (from forscale.project) and Workflows (from letterfeed.com). The following passage from TechCrunch article is my favorite:

With the help of add-ons, Google is clearly hoping to create a developer ecosystem around Docs. But maybe more importantly, these integrations will also make it more competitive in a landscape where Microsoft is now finally taking the online versions of its Office productivity suite seriously. For many desktop Office users, the ability to bring add-ons to the desktop versions of Word or Excel remains an important selling point

What is my conclusion? Eco-system or how it is now called “community” is an important element of future success. Microsoft relied on openness of Office and ability to develop add-ins very long time. In a modern world, Google Apps is a good infrastructure foundation for collaboration. It is still not clear if manufacturing companies are ready to trust Google as IT provider for their needs. I believe, a critical mass of application can be one of the factors that can influence future CIO and engineering IT managers decisions. Another obvious alternative is Office 365. Just my thoughts…

Best, Oleg

Share

4 comments

Bill of Materials (BOM): process or technology challenge?

March 3, 2014

The importance of Bill of Material in product development and manufacturing hardly can be undervalued. BOM is a cornerstone of almost all processes and activities – from early requirement and design and to manufacturing, services and support. Therefore, efficient BOM management is an absolutely important element of product development processes. PLM vendors are coming with […]

Share
Read the full article →

The Ugly Truth of Multi-BOM Management

December 17, 2013

Bill of Material (BOM) management is always fascinating topic. It sparks so many debates and introduce a large set of diverse opinions. I can even say that I have a special passion to speak about BOM on my blog. If you want to catch up on my recent posts about BOM, you can try these […]

Share
Read the full article →

Will SaaS and Open API solve BOM Management problem?

September 26, 2013

I like the way BOM discussion usually sparks. From my experience, “BOM management” topic has the ability to ignite conversation almost immediately. Therefore, I wasn’t too much surprised when I got blog attention from Hardi Meybaum, CEO of GrabCAD – most buzzed about company in Boston if you trust Venturefizz. Here is the article – Why […]

Share
Read the full article →

Will PLM manage enterprise BOM?

August 26, 2013

Bill of Materials is a huge topic. It is hard to underestimate the importance of BOM management in general as well as specifically for PLM systems. I’ve been blogging about BOM many times. Use this custom Google search to browse my previous beyond PLM articles about BOM. One of the topics I’m debating already long […]

Share
Read the full article →

BOM 101: How to modularize the Bill of Materials

February 14, 2013

I want to get back to my BOM 101. In my view, Bill of Material management is one of the fundamental processes in PDM/PLM and requires lots of attention. I want to take the feedback made by Jos Voskuil and turn the conversation to be more business oriented. One of the trends in manufacturing today […]

Share
Read the full article →

BOM 101: 5 “Don’ts” for Bill of Materials Management

January 21, 2013

BOM is fascinating. After posting 3 Modern BOM Management Challenges a week ago, I keep getting back to Bill of Materials management topic.  If you missed my previous BOM 101 posts, here are links to get up to speed: BOM 101- The four pillars of every BOM management solution, BOM 101- How to optimize Bil […]

Share
Read the full article →

BOM 101: The four pillars of every BOM management solution

January 17, 2013

I suggest you an experiment. Invite two engineers and ask them to provide a definition for some of PDM/PLM related terms. I’d not be surprised if you will get more than two definitions. It is not unusual to spend lots of time during PLM software implementation meetings to define terms, language and meaning of things. […]

Share
Read the full article →