Pengembangan Sistem Persediaan Barang Berbasis AppSheet pada PT XYZ

Abstract

Pengelolaan persediaan barang di PT XYZ masih menghadapi kendala karena proses pencatatan barang masuk dan barang keluar masih dilakukan menggunakan Spreadsheet serta belum didukung dashboard interaktif untuk monitoring persediaan secara real-time. Penelitian ini bertujuan mengetahui proses pencatatan persediaan barang yang berjalan, mengembangkan sistem persediaan barang berbasis AppSheet , serta mengevaluasi tingkat penerimaan pengguna terhadap sistem yang dikembangkan. Penelitian ini menggunakan metode penelitian terapan dengan pendekatan kualitatif. Data dikumpulkan melalui observasi, wawancara, dokumentasi, dan studi pustaka, sedangkan pengembangan sistem dilakukan menggunakan metode Agile. Hasil penelitian menunjukkan bahwa sistem yang dikembangkan berhasil mengintegrasikan proses pengelolaan persediaan, menyediakan dashboard monitoring berbasis Looker Studio, serta menerapkan pengaturan hak akses pengguna sesuai perannya. Hasil User Acceptance Testing (UAT) menunjukkan bahwa seluruh skenario bisnis memperoleh status diterima. Dengan demikian, sistem persediaan barang berbasis AppSheet yang dikembangkan mampu meningkatkan efektivitas pengelolaan persediaan dan layak diterapkan di PT XYZ.

Inventory management at PT XYZ still faces challenges because the processes for recording incoming and outgoing goods are still conducted using spreadsheets and are not yet supported by an interactive dashboard for real-time inventory monitoring. This study aims to identify the current inventory recording processes, develop an AppSheet -based inventory system, and evaluate user acceptance of the developed system. This study employs an applied research method with a qualitative approach. Data were collected through observation, interviews, documentation, and literature review, while system development was conducted using the Agile methodology. The results indicate that the developed system successfully integrates inventory management processes, provides a monitoring dashboard based on Looker Studio, and implements user access controls tailored to each role. The results of the User Acceptance Testing (UAT) showed that all business scenarios were accepted. Thus, the AppSheet -based inventory management system developed in this study is capable of improving the effectiveness of inventory management and is suitable for implementation at PT XYZ.