Article Per Year (5 Year)
p-Index From 2021 - 2026
1.745
P-Index
This Author published in this journals
All Journal Journal of Applied Science, Engineering, Technology, and Education Quantitative Economics and Management Studies CENDEKIA : Jurnal Ilmu Pengetahuan KNOWLEDGE: Jurnal Inovasi Hasil Penelitian dan Pengembangan Procedia of Social Sciences and Humanities Edukasiana: Jurnal Inovasi Pendidikan Journal of Economics and Management Jurnal Ilmiah Manajemen Dan Kewirausahaan
Setyowati, Lis
Unknown Affiliation
Arts Humanities Astronomy Biochemistry, Genetics & Molecular Biology Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Decision Sciences, Operations Research & Management Earth & Planetary Sciences Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Immunology & microbiology Industrial & Manufacturing Engineering Mathematics Mechanical Engineering Physics Social Sciences Other

Published : 11 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 11 Documents
Search

 1   2 
IMPLEMENTASI MICROSOFT EXCEL UNTUK MENINGKATKAN EFEKTIVITAS PROSES STOK OPNAME DI PT RATNA ASIA Yuafini, Chamdan; Zaman, Komarun; Setyowati, Lis
CENDEKIA: Jurnal Ilmu Pengetahuan Vol. 5 No. 4 (2025)
Publisher : Pusat Pengembangan Pendidikan dan Penelitian Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51878/cendekia.v5i4.7115

Abstract

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.
Co-Authors A.A. Ketut Agung Cahyawan W Aini Anisa, Nur Anisa, Nur Aini Asto, I Gusti Putu A’yuna, Qori Bambang Yulianto Darim, Abu Diana, Khori Nur Eka Intan Kumala Putri Elfiana , Cicilia Tika Kurniawati Kurniawati Kurniawati Lilik Anifah Lucky Virda Lorensa, Adelia Megasari, Aisyah Darti Nur Aisyah, Putri Nur Farida Nur Hidayah Nurfatimah Wiratnatika Azzahra, Eliza Nuryadi Soeryanto Soeryanto Widawati, Etty Yuafini, Chamdan Zakaria Pambudi, Angga Zaman, Komarun Zulkarnain, Muhammad Afiq