Denny Kurniawati
Program Studi Magister Teknik Industri, Fakultas Teknologi Industri, Institut Adhi Tama Surabaya,

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

Found 1 Documents
Search

Penerapan Digitalisasi Sederhana Berbasis Google Sheets Sebagai Solusi Pencatatan Stok Dan Distribusi UMKM Tienz Denny Kurniawati; Eko Endi Priyatmoko; Muhammad Habibi Hanny Irawan; Fitria Rachmawaty; Mohamad Ferdaus Noor  Aulady
TEKIBA : Jurnal Teknologi dan Pengabdian Masyarakat Vol. 6 No. 2 (2026): TEKIBA : Jurnal Teknologi dan Pengabdian Masyarakat (Mei)
Publisher : Fakultas Teknik, Universitas PGRI Banyuwangi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36526/tekiba.v6i2.8199

Abstract

Tienz Nganjuk MSMEs face the challenge of managing distribution due to the absence of a stock and sales recording system, both manually and digitally. This condition causes owners to be unable to monitor stock in real-time, dificully identifyinh best-selling products, and unable to make data-driven decisions. This community service activity aims to implement a simple digital distribution recording system based on Google Sheets for Tienz MSMEs. The Participatory Action Research (PAR) method was applied through eight stages: observation, needs analysis, system design, development, socialization, training, mentoring, and evaluation. The developed system consists of three integrated modules: warehouse stock recording, sales orders, and sales reports. Implementation results show significant improvements: stock data is available in real-time through a dashboard, per-product sales reports are generated automatically, monthly recap time has been reduced to under 30 minutes, and data loss risk has decreased from high to low owing to cloud-based storage. User satisfaction reached a score of 4.2 out of 5. This activity demonstrates that SMEs with limited digital literacy are capable of effectively adopting digital recording technology, provided the platform is selected in accordance with users' capabilities and training is conducted in a practical and participatory manner.