Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Applied Business and Administration Journal (ABAJ)

Design of Inventory Monitoring Information System of Office Equipment and Supplies at BAZNAS City of Bandung Based on Macro Excel (VBA) Lisyafa, Okta Bella Yuan; Sayuti, Abdul Malik
Applied Business and Administration Journal Vol. 3 No. 1 (2024): Business Analytics and System Innovations: Insights from Finance, Marketing, an
Publisher : Ebiz Prima Nusa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62201/abaj.v3i1.343

Abstract

BAZNAS, the National Amil Zakat Agency, is the official institution overseeing zakat management at the national level. In Bandung City, BAZNAS runs programs such as Healthy Bandung, Smart Bandung, Taqwa Bandung, and Caring Bandung, contributing to the city's prosperity. To streamline office operations, related institutions must conduct inventory activities for office equipment and supplies. However, BAZNAS Bandung City currently employs a manual inventory management system, involving paper-based recording, recapitulation, and individual input into Excel sheets, leading to inefficiency, security concerns, and data loss risks. Recognizing the need for improvement, a new information system has been designed using Microsoft Excel, Macros, and Visual Basic Applications. The design includes Data Flow Diagrams and Entity Relationship Data to enhance the management and monitoring of inventory data, ensuring data integrity and structured inventory activities. Project evaluations, following the End User Computing Satisfaction (EUCS) principle, show that the system meets institutional needs and is user-friendly. Users are provided with a manual book during testing to enhance system understanding. While the trial results are positive, constructive feedback suggests the need for further feature enhancement to ensure smoother system operation and greater overall benefits. This information system aims to speed up and simplify inventory data management, bringing efficiency to BAZNAS Bandung City's operations.
Digitalisasi Sistem Seleksi Karyawan Berbasis Web di Bank Woori Saudara Kantor Cabang Diponegoro Kota Bandung Aldiyansah; Sayuti, Abdul Malik
Applied Business and Administration Journal Vol. 2 No. 3 (2023): Transformasi Digital dan Optimalisasi Proses Bisnis di Era Modern
Publisher : Ebiz Prima Nusa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62201/h0x13y62

Abstract

Bank Woori Saudara KC Diponegoro is one of the branch offices of PT. Bank Woori Saudara Indonesia 1906, Tbk. which is engaged in commercial banking. In carrying out its banking activities, Bank Woori Saudara always involves important files that will be used for dealing with a customer. One example of such a file is the CIF Application Document which contains a number of important customer-related information. The collection of archives is stored and managed by the Front Office Department at Bank Woori Saudara. In managing the archives of the frontliner staff, a manual storage system is used, where the documents are stored based on the order and CIF number located in the available filling cabinet. The lack of archival management and an adequate record-keeping system causes frontliner staff to often find it difficult to search for the required documents. Therefore, in order to meet fast-paced technological developments and an adequate archive management system, an electronic filing application was created. This application is expected to help frontliner staff in carrying out operational activities, especially for information needs. In doing the design and manufacture, the application uses the Macro VBA Excel system so that it has an easy-to-reach appearance and work.