Claim Missing Document
Check
Articles

Found 13 Documents
Search

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.
Membangun Visibilitas Daring untuk UMKM Minuman Tradisional melalui Media Sosial dan Google Bisnisku Tjahjawati, Sri Surjani; Pramono, Tangguh Dwi; Gaffar, Mohammad Rizal; Lastari, Hidya Indira; Diputra, Naafi Yudha; Nazofatullidya, Nazofatullidya; Sarah, Ira Siti; Putri, Ivon Sandya Sari; Sayuti, Abdul Malik; Fujiasti, Sherry Novalia
Jurnal ABDINUS : Jurnal Pengabdian Nusantara Vol 10 No 1 (2026): Volume 10 Nomor 1 Tahun 2026
Publisher : Universitas Nusantara PGRI Kediri

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.29407/ja.v10i1.27175

Abstract

Proyek pengabdian kepada masyarakat ini bertujuan untuk meningkatkan kehadiran digital dan kinerja pemasaran Es Tali Merah, sebuah usaha mikro yang bergerak di bidang minuman teh es. Tujuannya adalah membantu bisnis tersebut dalam mengadopsi alat digital yang mudah diakses guna memperluas jangkauan, meningkatkan interaksi dengan pelanggan, dan memperkuat visibilitas lokal. Proyek ini memberikan kontribusi nyata kepada masyarakat dengan memberdayakan UMKM lokal melalui strategi pemasaran digital yang praktis, khususnya melalui penggunaan Instagram dan Google Bisnisku. Pendampingan langsung diberikan dalam pembuatan konten, pengembangan citra digital, dan keterlibatan pelanggan agar bisnis menjadi lebih kompetitif di pasar daring. Pendekatan partisipatif digunakan dalam pelaksanaan kegiatan, meliputi pendampingan langsung dan dukungan implementasi. Aktivitas yang dilakukan mencakup pembuatan dan optimalisasi akun Instagram serta profil Google Bisnisku. Akun Instagram berhasil memperoleh 67 pengikut secara organik, dengan tayangan Reels rata-rata lebih dari 1.000 kali. Profil Google Bisnisku mengumpulkan 67 ulasan pelanggan dengan rata-rata penilaian 4,9 dari 5. Dalam hasil pencarian lokal untuk kata kunci “es teh Gerlong,” Es Tali Merah muncul di posisi kedua pada Google Maps, menunjukkan kekuatan SEO lokal yang signifikan. Inisiatif ini berhasil mencapai tujuannya dengan menunjukkan bahwa alat digital yang sederhana dan berbiaya rendah dapat secara signifikan meningkatkan visibilitas, keterlibatan, dan kredibilitas usaha kecil, serta berkontribusi terhadap keberlanjutan jangka panjang mereka dalam ekonomi digital.