IMPLEMENTASI MICROSOFT EXCEL UNTUK MENINGKATKAN EFEKTIVITAS PROSES STOK OPNAME DI PT RATNA ASIA
DOI:
https://doi.org/10.51878/cendekia.v5i4.7115Keywords:
Microsoft Excel, Efektivitas, Stock OpnameAbstract
ABSTRACT
Stock opname is a crucial activity to ensure consistency between administrative records and the physical inventory conditions in the warehouse. At PT Ratna Asia, this process was previously performed manually, often resulting in reporting delays, the risk of recording errors, and a lack of efficiency. This study aims to illustrate the implementation of Microsoft Excel as a practical solution to improve the effectiveness of stock opname. The research method used was a case study with a qualitative approach through semi-structured interviews, direct observation over three weeks, and analysis of company documents. Data validity techniques were carried out using source triangulation, method triangulation, and member checking. The results showed that the use of Excel features, such as automatic formulas (SUM, IF, VLOOKUP), filters, and sorting, can speed up the recording process, minimize human error, and produce more accurate and systematic reports. Furthermore, Excel supports the digitalization of inventory management, making reports easier for management to analyze. Thus, the implementation of Microsoft Excel has been proven to improve the effectiveness of the stock opname process at PT Ratna Asia, both in terms of speed, accuracy, and report quality, while also providing a foundation for the company to adopt more advanced information systems in the future.
ABSTRAK
Stok opname merupakan aktivitas penting untuk memastikan kesesuaian antara catatan administrasi dan kondisi persediaan fisik di gudang. Di PT Ratna Asia, proses ini sebelumnya dilakukan secara manual sehingga sering menimbulkan keterlambatan pelaporan, risiko kesalahan pencatatan, dan kurangnya efisiensi. Penelitian ini bertujuan untuk menggambarkan penerapan Microsoft Excel sebagai solusi praktis dalam meningkatkan efektivitas pelaksanaan stok opname. Metode penelitian yang digunakan adalah studi kasus dengan pendekatan kualitatif melalui wawancara semi-terstruktur, observasi langsung selama tiga minggu, dan analisis dokumen perusahaan. Teknik keabsahan data dilakukan dengan triangulasi sumber, triangulasi metode, dan member check. Hasil penelitian menunjukkan bahwa penggunaan fitur Excel, seperti rumus otomatis (SUM, IF, VLOOKUP), filter, dan sorting, mampu mempercepat proses pencatatan, meminimalkan human error, serta menghasilkan laporan yang lebih akurat dan sistematis. Selain itu, Excel mendukung digitalisasi manajemen persediaan sehingga laporan lebih mudah dianalisis oleh manajemen. Dengan demikian, implementasi Microsoft Excel terbukti meningkatkan efektivitas proses stok opname di PT Ratna Asia, baik dari sisi kecepatan, ketelitian, maupun kualitas laporan, sekaligus memberikan landasan bagi perusahaan dalam mengadopsi sistem informasi yang lebih maju di masa depan.
Downloads
References
Ani, A. (2023). Perancangan sistem informasi akuntansi persediaan barang dagang spare part mesin fotocopy berbasis Microsoft Excel (studi kasus pada PT. XYZ) [Skripsi, Universitas Semarang]. https://eskripsi.usm.ac.id/files/skripsi/B21A/2019/B.231.19.0045/B.231.19.0045-01-Judul-20230216060002.pdf
Firmansyah, F., Amelia, I., Putri, P. D., Jasurjon, M., Syaputra, K., Meylani, A., & Apria, I. (2025). Sosialisasi Excel makro VBA untuk optimalisasi manajemen persediaan bahan UMKM Mama Tiga Putra. Jurnal Pengabdian West Science, 4(1), 54–60. https://doi.org/10.58812/jpws.v4i01.1912
Hendricks, K. B., Singhal, V. R., & Stratman, J. K. (2021). The impact of enterprise systems on corporate performance: A study of ERP, SCM, and CRM implementations. Journal of Operations Management, 67(3), 265–284. https://doi.org/10.1016/j.jom.2006.02.002
Jacobis, R., Rozaq, K., Husain, M., Ramadhan, D. A., & Ramadhani, B. Y. (2023). The role of technology adoption in shaping employee performance. Jurnal Ilmu Manajemen, 12(3), 680–688. https://doi.org/10.26740/jim.v12n3.p680-688
Jaryanto, Latifah Auladana, Z., Putri, I., Rahmawati, N., & Bahri, R. A. (2023). Penggunaan Microsoft Excel. Jurnal Pengabdian Pada Masyarakat Indonesia (JPPMI), 2(4), 53–62. https://doi.org/10.55606/jppmi.v2i4.760
Jims, M. (2023). Analisis dan Perancangan Sistem Stok Opname Berbasis Web pada PT Cakra Medika Utama. STORAGE: Jurnal Ilmiah Teknik dan Ilmu Komputer, 2(4), 201–213. https://doi.org/10.55123/storage.v2i4.2945
Krajewski, L. J., Malhotra, M. K., & Ritzman, L. P. (2018). Operations management: Processes and supply chains (12th ed.). Pearson Education. https://www.oreilly.com/library/view/operations-management-processes/9780134741062
Laudon, K. C., & Laudon, J. P. (2020). Management information systems: Managing the digital firm (16th ed.). Pearson. https://api.pageplace.de/preview/DT0400.9781292403571_A42098351/preview-9781292403571_A42098351.pdf
Mezmir, E. A. (2020). Qualitative data analysis: An overview of data reduction, data display and interpretation. Research on Humanities and Social Sciences, 10(21), 15–27. https://doi.org/10.7176/RHSS/10-21-02
Nursita, L., Astina, A., Isakasari, I., & Amiruddin, I. (2021). Efektivitas Penggunaan Microsoft Excel dalam Pengolahan Nilai Rapor Siswa SMA Negeri 11 Bone. Educational Leadership: Jurnal Manajemen Pendidikan, 1(1), 1–9. https://doi.org/10.24252/edu.v1i1.21994
Pratama, C. R., & Wibowo, S. A. (2022). Optimalisasi ruang gudang dan peningkatan material menggunakan sistem OFO di PT XXX. Jurnal Logistica, 20(2), 7–14. https://journal.iteba.ac.id/index.php/logistica/article/view/50
Putri, A. A., & Ginoga, F. (2024). Perancangan sistem informasi akuntansi penjualan dan persediaan barang dagang dengan Excel Macro di Toko Surya. Account: Jurnal Akuntansi, Keuangan dan Perbankan, 11(2), 2260–2273. https://doi.org/10.32722/account.v11i2.6974
Robbins, S. P., & Judge, T. A. (2019). Organizational behavior (18th ed.). Pearson Education. https://elibrary.pearson.de/book/99.150005/9781292259246
Sanistya, D. (2022). Analisis implementasi QR code untuk pengendalian stok opname pada BPJS Ketenagakerjaan Cabang Tegal [Skripsi, Universitas Islam Sultan Agung]. https://repository.unissula.ac.id/31194/
Turban, E., Pollard, C., & Wood, G. (2018). Information Technology for Management: On-Demand Strategies for Performance, Growth and Sustainability. Wiley. https://books.google.co.id/books/about/Information_Technology_for_Management.html?id=hJZXDwAAQBAJ&redir_esc=y
