Development of Real-Time Quality Feedback System Using Web-Based Software for an Automotive Parts Factory

• Published in: Lecture Notes in Mechanical Engineering
• Main Author: Rusli M.H.M.; Kayat S.B.; Sohaimi M.A.T.B.M.; Hassan M.K.B.
• Format: Conference paper
• Language: English
• Published: Springer Science and Business Media Deutschland GmbH 2024
• Online Access: https://www.scopus.com/inward/record.uri?eid=2-s2.0-85213336982&doi=10.1007%2f978-3-031-74485-3_45&partnerID=40&md5=efb0f0aab6dca08a74fa668959fc0604

This paper introduces an advanced data collection and analysis system tailored for quality assurance management, leveraging the combined power of AppSheet, Google Sheets, and Looker Studio done at an automotive parts factory. This integration streamlines the process of data collection and ongoing analysis, ultimately enhancing operational performance. Notably, the system monitors quality control data and supplier information in real-time while accommodating user-defined criteria. A user-friendly mobile app built with AppSheet also allows for the simultaneous addition, editing, and removal of master list data, ensuring a hassle-free experience. Looker Studio’s seamless integration with Google Sheets fosters smooth cooperation and quick updates, while the configurable reports and analytics provide vital insights into product rejection and cost analysis. Furthermore, this adaptable system is scalable and applicable to diverse industries, promising early issue detection, heightened productivity, and improved efficiency in data collection. By embracing digital transformation, this system fosters a streamlined, data-driven approach to quality control management, empowering quality assurance departments to excel in the rapidly evolving digital landscape. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.