The Time Reduction in the Borrowing-Returning Process of Project Books with Google Applications

Abstract

This research aimed to study the process of borrowing and returning project books and provide guidelines for improving them. This study was conducted at Kalasin University's logistics engineering and transportation technology department, which is part of the engineering and industrial technology faculty. An information technology system consisting of a Google form, a Google sheet, an Apps script, and Google Data Studio is proposed to improve the procedure and reduction time. The usage of information technology systems combined with the visual control concept can significantly reduce time. Techniques from work studies are utilized to analyze issues. As a result of the work improvement, the new process steps were reduced from 6 steps to 4 steps. Operating time was reduced from 221.24 seconds to 135.85 seconds or 85.39 seconds; the reduction in operation time is 38.60%. It can be concluded that the process of borrowing and returning project books can be improved with the new system.