Article Per Year (5 Year)
p-Index From 2021 - 2026
0.408
P-Index
This Author published in this journals
All Journal Buletin Poltanesa SWARNA
Nur Ainun Musvirah
Politeknik Sinar Mas Berau Coal
Religion Agriculture, Biological Sciences & Forestry Humanities Computer Science & IT Education Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice

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

Found 2 Documents
Search

 1 
Implementation and Training of a VBA for Service Information System using Waterfall Model: A Case Study of Laundry Hasanah Zulfahmi Noor; Lintang Puja Prameswarie; Siti Irma Fadilla; Sheila Carol Dorothy Kemur; Arif Mustakim; Nur Ainun Musvirah; Nurmasitya Kemalaintan; Fauziah Fauziah
SWARNA: Jurnal Pengabdian Kepada Masyarakat Vol. 5 No. 5 (2026): SWARNA : Jurnal Pengabdian Kepada Masyarakat, Mei, 2026
Publisher : LPPM Sekolah Tinggi Ilmu Ekonomi 45 Mataram

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55681/swarna.v5i5.2335

Abstract

The advancement of information technology has driven the digitalization of the MSME sector; however, most businesses still rely on manual systems that are inefficient and prone to errors. This issue is also encountered by Laundry Hasanah MSME in Berau Regency in managing its service operations. Therefore, this study aims to develop and implement a service information system based on Visual Basic for Applications (VBA) to improve data processing efficiency and enhance service quality, which is expected to have a significant impact on the business sustainability of Laundry Hasanah. The development and design method employed in this study and community service activity is the Waterfall model, consisting of the stages of analysis, design, implementation, and testing. The implementation results indicate that the system is capable of accelerating the recording process, reducing errors, and improving service quality in a more effective and accurate manner. Based on the design and implementation of the VBA based laundry service information system, it can be concluded that the application was systematically designed and developed in accordance with the Waterfall model. Each stage, from requirements analysis to maintenance, was carried out sequentially and consistently, ensuring that the development process was structured, controlled, and capable of minimizing potential errors.
Warehouse Inventory Recording System Based on VBA Excel at Sinar Mas Berau Coal Polytechnic Dewi Safitriani; Hamim Rachman; Nur Ainun Musvirah
Poltanesa Vol 27 No 1 (2026): June 2026
Publisher : P3KM Politeknik Pertanian Negeri Samarinda

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51967/tanesa.v27i1.3587

Abstract

Effective inventory management is a crucial aspect in supporting smooth logistics operations, including in vocational education institutions such as Politeknik Sinar Mas Berau Coal. However, manual inventory recording is still a common obstacle, especially in terms of efficiency, data accuracy, and ease of tracking goods. This study aims to design and implement a warehouse inventory recording system based on Microsoft Excel with Visual Basic for Applications (VBA) support to improve recording efficiency and accuracy. This system is designed to document incoming and outgoing goods data, monitor stock in real-time, and present integrated automatic reports. The implementation results show that this VBA Excel-based system is able to simplify the warehouse administration process, minimize the risk of data input errors, and simplify the internal logistics audit process. This system can also be an economical and applicable solution for educational institutions with limited resources. In the future, this system can be further developed with database integration and higher security features.
Co-Authors Arif Mustakim Dewi Safitriani Fauziah Fauziah Lintang Puja Prameswarie Nurmasitya Kemalaintan Rachman, Hamim Sheila Carol Dorothy Kemur Siti Irma Fadilla Zulfahmi Noor