RABIT: Jurnal Teknologi dan Sistem Informasi Univrab
Vol 11 No 2 (2026): Juli

SISTEM INFORMASI MANAJEMEN PEMASARAN KOPI MURIA WILHELMINA DENGAN PERBANDINGAN METODE SMA, WMA, DAN DES

Anisa Handayani (Universitas Muria Kudus)
Noor Latifah (Universitas Muria Kudus)
Fajar Nugraha (Universitas Muria Kudus)



Article Info

Publish Date
10 Jul 2026

Abstract

UMKM Kopi Muria Wilhelmina faces challenges in managing marketing data manually and has not yet utilized historical sales data to support production planning. This study aims to develop a web-based Marketing Management Information System using Laravel, MySQL, and the Waterfall method, as well as to compare the Simple Moving Average (SMA), Weighted Moving Average (WMA), and Double Exponential Smoothing (DES) methods based on MAD and MAPE values. The data used consists of 41 sales periods from January 2023 to May 2026 across three top-selling products. The results show that the DES method produces the smallest MAPE for Kopi Wilhelmina Gold at 48.00% and Kopi Wilhelmina Arabica at 54.35%, while the WMA method produces the smallest MAPE for Kopi Wilhelmina Black at 63.41%. The high MAPE values are attributed to demand fluctuations and the consignment distribution pattern. The system automatically recommends the method with the smallest MAPE value for each product. Blackbox Testing confirmed that all system functions performed as specified. The developed system successfully integrates marketing data management and forecasting features in a single platform to support production decision-making in small and medium enterprises.

Copyrights © 2026






Journal Info

Abbrev

rabit

Publisher

Subject

Computer Science & IT Engineering

Description

This journal is called RABIT, where the name comes from two words namely, RAB which means Abdurrab University and IT which means information technology, it can be interpreted as a journal of this journal Journal of Informatics Engineering Study Program Pekanbaru Abdurrab University. This RABIT ...