The implementation of over 20 scripts has been carried out to streamline and accelerate processes across various departments within the company. These solutions include tools for obsolete management, an SMT line changeover program, an MRP material calculation script, optimization of spare parts management, support for planning in closing work orders (WO), and a transport scheduling program. Data for these processes was sourced from various platforms, including SQL databases, CSV/Excel/TXT/XML files, SharePoint files, and SAP BW4.
Several projects have been successfully implemented to optimize production processes and enhance efficiency:
A functional MRP dashboard in Excel was developed, utilizing a Python script for data processing. The dashboard supports the management of components for the production of PCBA boards for the Volkswagen Group, handling over 360,000 units per month. Input data was sourced from a CSV file containing over 200,000 BOM lines across approximately 700 models. The system automatically retrieves daily component consumption data from the Bartector system via SQL queries, and additional data is imported directly from emails using a script. This dashboard ensured a smooth and uninterrupted production process.
A script was developed to analyze the possibility of using non-rotating components as substitutes in production. The script processed variable input data, including the production plan (COOIS SAP), BOM lists to identify substitutes (SAP BW4), and a yearly shortage report (annual component demand with deliveries) in Excel. The script performed the analysis and output data such as a list of work orders (WO) where component substitution was necessary to optimize consumption. This process led to savings of approximately $500,000 on components that were potential obsolescences.