13th Annual International Conference on Industrial Engineering and Operations Management

Streamlining Data Preparation for Discrete Event Simulations in Automobile Manufacturing: A Python-based Automation Tool

IKA SARAN KUMAR & V. Madhusudanan Pillai
Publisher: IEOM Society International
0 Paper Citations
1 Views
1 Downloads
Track: Simulation Competition
Abstract

Discrete event simulations are becoming increasingly important in the management of complex manufacturing systems, however, the raw data collection and processing from various physical systems is laborious and time consuming with current methods. This data is often of poor quality and incomplete, making it difficult to produce accurate results. To address this problem, a Python-based automation tool was created to collect, analyse, and store data from Manufacturing Execution Systems (MES) using a multi-step data preparation algorithm and a dedicated simulation database. This tool is more efficient than using tools such as Microsoft Excel based macro and includes a user-friendly interface for data entry and visualization. This automation tool is expected to improve the quality and accuracy of simulation results, while reducing the time and effort required for data preparation in the automobile manufacturing production line.

Keywords:

Discrete Event Simulation, Data Preparation, Data Processing, Manufacturing Execution Systems, Python-based Automation tool.

Published in: 13th Annual International Conference on Industrial Engineering and Operations Management, Manila, Philipines

Publisher: IEOM Society International
Date of Conference: March 7-9, 2023

ISBN: 979-8-3507-0543-0
ISSN/E-ISSN: 2169-8767