
This behavior extends into the design and engineering office as well, perhaps moreso than other parts of an average organization. It’s in their nature to solve problems; it’s kind of the key attribute of an engineering job description! I can understand why – engineers live and breathe efficiency, and being over-encumbered by poorly designed systems is not efficient at all.
Case in point: the Bill of Materials (BOM). How many systems are controlling it? ERP? The design tool? PDM? Some home-grown custom system? By and large…no. Most work-in-process BOMs are done in spreadsheets. And why not? Spreadsheet applications are easy to use and share, don’t require much training, and don’t require six levels of approval to implement. Spreadsheets can even be automated with macros, making BOMs configurable and intelligent. Eventually all items do end up in the ERP, though typically not until late in a product’s/project’s/program’s lifecycle.
Just as when the market moved from pencil drawings, french curves, vellums, and other manual drafting techniques to 2D CAD tools, and similarly 2D design to 3D modeling: Change. Yes, sketching a part is faster than creating the lines and circles – but CAD technology enables updates caused by change much faster than a manual process. The gains of going from 2D designs to 3D models are more staggering. “You mean one edit and it updates everywhere? Even the drawing?” Anecdotally, I had a customer say “With 2D, whenever the shop called, I was worried about what we messed up. Now, with 3D models, when the shop calls, I worry about what they messed up.”
Again, it’s about rate of change, propagation and validation of the change. Spreadsheets cannot do that (unless you have some really wicked cool macros).
With our PLM Analytics Benchmark, we can help your company to assess the nature of your BOM needs, as well as the 16 pillars of PLM. Let us know if we can be of service!