Search

Featured Application: The methodology described in this paper was implemented in an automotive manufacturing facility that operates under a just-in-time manufacturing scheme. The methodology greatly improved the efficiency of day-to-day operations at the facility. This study addresses sustainability challenges in automotive packaging by introducing a novel data-driven approach to audit and improve packaging quality. Traditional manual auditing processes are both time-consuming and prone to errors. To counter these inefficiencies, we developed an automated system utilizing Microsoft Power Apps and SQL databases to streamline data collection and processing. The automated tools facilitate real-time data capture and visualization through Microsoft Power BI, enabling precise tracking and management of returnable and expendable packaging materials. Our results show that our approach offers a significant enhancement in the accuracy and speed of data analysis, leading to more informed decision-making. Our methodology supports sustainability by reducing waste and reliance on expendable packaging and improving the economic and operational efficiency of automotive packaging systems. [ABSTRACT FROM AUTHOR]