BOM configurator using DriveWorks for aircraft seating area, US
Aircraft Interior Manufacturer
Design Inputs & ERP Data
Seating arrangement BOM Configurator
SolidWorks & DriveWorks
Data stored on server in excel file allows access to a single user
Generating BOM is difficult when there is manual data fetching
Manually configured BOMs will always have inaccuracies and is time consuming
Our detailed engineering solution to client:
Manufacturer shared the inaccuracies caused in their current practices of using excel files on server and manual methods to fetch the data from ERP systems. Our design automation experts suggested implementing DriveWorks and integrating it with ERP systems that can fetch data automatically with SQL database.
The major challenge at client’s end was to sort and filter data without errors from ERP and Excel spreadsheets manually
Design automation experts understood the design needs and individual part and component data to develop architecture for storing information SQL database – high storage data sets – which can be read by DriveWorks
It led to automatic information fetching by integrating with ERP for creating BOMs, quotes and sharing with inter-divisions including shop floor for internal flow requests
We also created dashboards for different teams to work on Top Down approach as well as to see visibility of order status or progress in different departments including sales, planning, engineering and manufacturing shops
By automating the entire process using SQL and DriveWorks, human intervention were eliminated which lead to higher consistencies and more configuration for large seating area. The client could manufacture through a streamlined process for any configured custom request with higher security and reduced time.