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

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.