Dewi Safitriani
Politeknik Sinar Mas Berau Coal

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

Found 2 Documents
Search

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.
Design and Development of a Restaurant Information System for Stasiun Jajanan Agus Ganda Permana; Dewi Safitriani; Devit Setiono
TEPIAN Vol. 7 No. 3 (2026): September 2026
Publisher : Politeknik Pertanian Negeri Samarinda

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51967/tepian.v7i3.3935

Abstract

The rapid advancement of information technology has encouraged Micro, Small, and Medium Enterprises (MSMEs) to adopt digital solutions to improve business performance and customer service. Stasiun Jajanan is a culinary MSME that offers various fast-food products, including kebabs, burgers, fried tapioca fritters, Indonesian fried tofu meatballs, and beverages. Promotional activities, order processing, and transaction recording are still conducted manually, resulting in limited promotional reach, inefficient data management, and potential recording errors. This study aims to design and develop a web-based restaurant information system to support business promotion, online ordering, and transaction management for Stasiun Jajanan. The system was developed using the System Development Life Cycle (SDLC) with the Waterfall model, consisting of requirement analysis, system design, development, and testing. Unified Modeling Language (UML) was utilized to model the system through use case, activity, sequence, and class diagrams. The developed system provides several features, including menu management, online ordering, payment processing, transaction management, business information services, and WhatsApp integration for customer communication. System testing was conducted using the Black Box Testing method to verify that all functionalities operated according to the specified requirements. The testing results indicate that the developed system successfully supports menu management, customer ordering, payment processing, and transaction recording. The system improves service efficiency, reduces manual recording errors, and provides customers with easier access to product information and ordering services. The proposed system can therefore support the digital transformation and business growth of culinary MSMEs.