Analysis Of The Design And Implementation Of The Use Of Google Spreadsheet For Daily Reports Of Incoming Goods At Pt. Putra Kelana Makmur Uses The Six Sigma Method (DMAIC)

Abstract

This study designed and implemented a Google Sheets-based daily incoming goods reporting system to address reporting challenges at PT. Putra Kelana Makmur. The main problem was not with the Sunfish ERP system, but rather with human factors, such as multi-level approval processes and a lack of transparency between departments. A Six Sigma approach with the DMAIC framework was used to create a more responsive, flexible, and collaborative system. The implementation showed a significant increase in reporting time efficiency, from 1-2 days to less than 1 minute. The user acceptance rate reached 87.18%, indicating high satisfaction with ease of use, real-time access, transparency, and cross-departmental collaboration. It is important to note that Google Sheets serves as an alternative tool to complement the Sunfish ERP, providing faster, more flexible, and mobile data access. This study contributes practically to the company's logistics operational efficiency and theoretically to the development of cloud-based management information systems in the logistics and distribution sector.