How Much Time Do Engineers Spend Managing BOM in Excel?

Oleg Shilovitsky
Oleg Shilovitsky
26 May, 2022 | 3 min for reading
How Much Time Do Engineers Spend Managing BOM in Excel?

In any business, time is money. The more time an organization spends on tasks that don’t generate revenue, the less money they have to invest in growing its business. Engineers like to get engaged in the design and actual engineering jobs rather than manage data and organize Excels. From my experience of working with many engineers, managing data will be the least favorite activity for engineers. No one really likes to manage data. BOM in Excel is one of these activities. Managing BOMs in Excel is one of the most time-consuming non-design tasks. 

Poll: How much time is wasted managing BOM in Excel

We wanted to learn more about how much time engineers spend managing BOM in Excel. Without any chance to provide a systematic answer, we decided to create a LinkedIn poll and publish it in a large Solidworks LinkedIn user group with more than 100K members. We’ve got pretty interesting results. With more than 60K impressions and more than 400 votes, it can give you an idea of how much time is spent and what engineers actually think about it. In the picture below you can see the results of the voting. 

Roughly half of the respondents said that they spent less than an hour and it is not a big deal. That was not a surprise. SolidWorks is known for a very nice BOM to Excel export and I know, from experience, that for many engineers exporting BOM to Excel is the end goal. Then they pass it to other people in their organization that need to take care of managing these BOMs and this amount of work is not counted by engineers. 

It was very interesting to learn that 38% of respondents are spending 1-5 hours every week in Excel and this is messy and disturbing. The last 10% spend more than 5 hours a week and this is a total waste

What did we learn from comments and conversations? 

I’ve been talking to many engineers during this poll online and offline to understand where the time is spent and how to help engineers to streamline their work. Here are the top three things where we believe companies are failing and, as a result, wasting time and money using Excel as a data management tool. 

  1. Many engineers are not aware that there is a better way to manage BOMs rather than export files from SolidWorks to Excel and send them downstream using emails. 
  2. Export data actually takes very little time, but processing data is where real waste is happening. 
  3. Updates are very painful and once data is exported, it is very difficult to manage updates. 
  4. Engineers prefer to keep all information in Solidworks (including non-CAD items), which can simplify merges, but bring a lot of unnecessary data to the CAD system. 
  5. Managing non-CAD business data using CAD storage (eg. SolidWorks) can make purchasing decisions very hard. 
  6. There is no good visibility of the data managed using Excel, which is a big downside for all companies. 

Conclusion

The amount of time engineers spent in Excel is gigantic. However, the problem is much bigger and deeper. While the visible time engineers spend managing BOM in Excel is between 1-5 hours per week, companies are losing money on mistakes, wrong Excel file sharing, wrong data used by different departments, and many other problems that are caused by using Excel as a data management tool.

How we can help? OpenBOM provides out-of-the-box, simple, and easy cloud-based tools that can simplify the work of every engineer and help organizations to get aligned and streamline data management including parts, BOMs, documents, and purchasing process. 

REGISTER FOR FREE and check out how OpenBOM can help you today. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
27 January, 2023

As the demands of consumers change, so does the environment around them. We now live in a world where customers…

27 January, 2023

Data organization is key for any successful Product Lifecycle Management (PLM) program. The ability to manage, organize, search, and quickly…

26 January, 2023

Managing CAD files is an important part of the data management systems and product lifecycle management (PLM) process. CAD files…

25 January, 2023

The last decade of engineering and manufacturing business development demonstrated that data is increasingly important for modern manufacturing businesses as…

23 January, 2023

I’m excited to bring a sneak peek of OpenBOM user-defined commands. These commands will allow you to easily define specific…

20 January, 2023

It is clear that in this day of age, manufacturers need to collaborate with their partners to improve their business….

20 January, 2023

Manufacturing is transforming. It is not a single company that builds everything in one place. It is more reminding a…

19 January, 2023

Today I’m excited to share some news about the upcoming OpenBOM Customer Forum. Thanks to all customers that asked us…

18 January, 2023

In a world where manufacturing businesses are becoming increasingly global and complex, it is essential to have a data and…

To the top