A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

Do We Need Chief Excel Officer To Manage BOM?

Do We Need Chief Excel Officer To Manage BOM?
olegshilovitsky
olegshilovitsky
23 February, 2010 | 4 min for reading

I had chance to read yesterday Arena’s whitepaper “Whose BOM is it Anyway?”. You can find the link this whitepaper for free download here.The white paper is written as a Disaster Story from a manufacturing going trough the hassle of BOM management using Microsoft Excel.

In the end of white paper, there are 3 tips how to take control of your BOM.

#1 Provide Multiple Views into a Single Consolidated BOM. Every department needs different information from the BOM, so you need to present your BOM in a format that allows each department to access and incorporate the information that is vital to them, without having to fork off a new version for their own use. Consider using a tool designed for this purpose instead of something like Excel, and keep all departmental information related to the BOM in one centralized location that is accessible by all.

#2 improve Visibility of Changes through redlines and notifications. The ability to redline a BOM is critical. A single change in a BOM of 20 columns and 500 lines is very easy and too costly to miss. Redlines enable someone who isn’t intimately familiar with the BOM to pick it up and know instantly what needs attention.

#3 Establish a review and Approval Process that Everyone Agrees to and Stick to it. By consistently following your process, you can make sure that all your changes are reviewed by the right people across multiple departments. This will help you prevent costly errors that result in scrap and rework and ultimately delay your product getting to market.

In addition to these three tips, there is a very nice picture shows Bill of Material shows how Your Product Data is managed by Arena Solution.


This white paper stroke me to think again about my post related to an idea of single Bill Of Material – Seven Rules Towards Single Bill of Material. The main point of my post was about how we can eliminate multiple Bill of Materials in the enterprise and replace it with single one, that contains all we need from design to manufacturing.

As I can read tip 1 – “Provide Multiple Views into a Single Consolidated BOM” with option to have a multiple set of views into this BOM. This is really good news. However, I found the picture presenting bi-directional data exchange with CAD/PDM and ECAD/Component Library. So data need to be synchronized in two directions. In addition ERP/MRP is presented as Item Master Ref (which I believe a reference) to product data in single BOM and probably mean data never going to be synchronized from ERP back to PLM/PDM. This is something that rarely happen if PLM consider as a Single Consolidated BOM.

At this point, of time, I came with strange feelings, similar to what Carlos had from the same white paper. BOMs are starting to fly all over!  However, now, Bills are flying between Product Data storage and all other systems. All systems mentioned on this picture, need to be somehow synchronized. So, you can see flying gizmos inventing magic vacuum cleaners to suck Bill of Material data from the central place where Product Data is stored and moving it between and around with CAD/PDM, ECAD, ERP/MRP. How we can organize this data exchange? Oh, I’m sure there are magic XML (or maybe Excel) files that can go back and forth and do this work. My hunch is that this work is very complicated and the cost of such integration is not cheap.

Unfortunately, this is a reality of every engineering and manufacturing company. Flying Excels with Bill of Materials, or any other representations of the BOMs in any format, is the ultimate way to do real Bill of Material job in the organization. And, this is very expensive work. There are two alternatives I had chance to see in the organization:

(1) to invest big $$$ to make a comprehensive integration (I’ve seen such companies and they are doing very well);
(2) to hire Chief Excel Officer to take care of all BOM/Excels in the company (this is the mainstream situation).

So, what is my conclusion today? The white paper touched the real problem. There are no magic gizmo that can solve integration problem related to Bill of Materials. To create a single point of product data in the organization is not simple. Period.

Just my thoughts…
Best, Oleg

Share

Recent Posts

Also on BeyondPLM

4 6
26 February, 2009

Since last year, I have seen many discussions on the Web about PLM 2.0. The number of posts is growing…...

21 June, 2010

My post “How To Manage ECO Without Paying $1’500 Per Seat” raised a very interesting discussion on Zero-Waite State blog...

26 October, 2015

Historically, PLM products are well know for being complicated and hard to use. It has deep roots in the way...

30 July, 2010

The following blog article caught my attention last week – “Four recommendations for better Excel BOMs” in Arena Solutions blog...

20 June, 2016

Cloud applications are getting better these days. However, most of existing mainstream engineering applications are still using files to store...

22 February, 2012

I’m just few hours before two-day marathon of PLM Innovation 2012 in Munich. The list of speakers and the agenda...

8 June, 2012

Earlier this week, Kenesto – new outfit of Mike Payne announced about general availability of their cloud based business process...

23 March, 2009

Continuing the cloud-zone discussion I have started for this week, I found this pretty comprehensive technological map for Cloud Computing,...

22 June, 2020

PLM industry has a new marketing darling – SaaS. It was just two weeks ago when I shared news about...

Blogroll

To the top