Web-Based F&B Lazatto Product Sales and Stock Prediction System with Double Moving Average (DMA) Method
DOI:
https://doi.org/10.30871/jaic.v9i4.10012Keywords:
Information System, Sales Forecasting, Double Moving Average, Web, Inventory ManagementAbstract
This study aims to develop a web-based sales and stock prediction system for Lazatto, a Food and Beverage (F&B) company, using the Double Moving Average (DMA) method. The background of this research is based on issues stock requirement planning is still done conventionally, where the head of the restaurant places stock orders solely based on personal experience and intuition, without utilizing past sales data as a basis for decision-making, which often result in overstocking or stockouts. By implementing a web-based forecasting information system, the company can obtain real-time and structured data. This study uses sales data from April 2024 to March 2025. The prediction results show a downward trend in sales for the "Kentang" (Potato) product, with a forecasted value of 107.33 for April 2025, compared to an actual value of 95. Model evaluation indicates an average MAPE of 21.19%, which is considered a "fair" level of forecasting accuracy. Additionally, the time required for weekly stock planning was reduced, and interviews with staff revealed increased user satisfaction and ease of use. The developed system has proven to support more accurate and efficient decision-making in inventory management.
Downloads
References
[1] M. Alda, “Pemanfaatan Barcode Scanner Pada Aplikasi Manajemen Inventory Barang Berbasis Android,” J. Sisfokom (Sistem Inf. dan Komputer), vol. 10, no. 3, pp. 368–375, 2021, doi: 10.32736/sisfokom.v10i3.1175.
[2] D. Irwansyah, J. Hutahaean, and S. Suparmadi, “Peramalan Penjualan Produk Sepatu dengan Menggunakan Metode Double Moving Average (DMA),” Build. Informatics, Technol. Sci., vol. 4, no. 2, pp. 972–982, 2022, doi: 10.47065/bits.v4i2.2199.
[3] H. Hazem, A. Singhal, and Y. Tabaa, “Comparative Analysis of Machine Learning, Hybrid, and Deep Learning Forecasting Models – Evidence from European Financial Markets and Bitcoins,” 2023. [Online]. Available: https://arxiv.org/abs/2307.08853 ER
[4] A. P. Gani, R. Akbar, K. Arya, and J. Sitompul, “Peramalan Harga Saham Nvidia Dengan Metode Double Moving Average,” vol. 29, no. 2, pp. 154–166, 2024.
[5] N. Amani, D. Permana, and J. U. Beredar, “Peramalan Jumlah Uang Beredar Di Indonesia,” vol. 9, no. 1, pp. 1–9, 2023.
[6] R. Sari and F. Hamidy, “Sistem Informasi Akuntansi Perhitungan Harga Pokok Produksi Pada Konveksi Sjm Bandar Lampung,” J. Teknol. dan Sist. Inf., vol. 2, no. 1, pp. 65–73, 2021.
[7] I. Bekti Ma’arif, A. Mahmudi, and J. Dedy Irawan, “Aplikasi Peramalan Penjualan Ikan Mujair Dengan Metode Double Moving Average (DMA),” JATI (Jurnal Mhs. Tek. Inform., vol. 7, no. 5, pp. 3106–3115, 2024, doi: 10.36040/jati.v7i5.7608.
[8] R. Ikhwani, Y. Siagian, and N. Marpaung, “Penerapan Metode Double Moving Average Dalam Peramalan Permintaan Produk Beras,” Build. Informatics, Technol. Sci., vol. 4, no. 1, pp. 80–87, 2022, doi: 10.47065/bits.v4i1.1499.
[9] D. C. I. Astuti, D. M. Khairina, and S. Maharani, “Peramalan Nilai Ekspor Nonmigas Kalimantan Timur dengan Metode Double Moving Average (DMA),” Adopsi Teknol. Dan Sist. Inf., vol. 2, no. 1, pp. 20–34, 2023, doi: 10.30872/atasi.v2i1.393.
[10] D. Mallisza, H. S. Hadi, and A. T. Aulia, “Implementasi Model Waterfall Dalam Perancangan Sistem Surat Perintah Perjalanan Dinas Berbasis Website Dengan Metode SDLC,” J. Tek. Komputer, Agroteknologi Dan Sains, vol. 1, no. 1, pp. 24–35, 2022, doi: 10.56248/marostek.v1i1.9.
[11] Sunarmi, Yuda Syahidin, and Yuyun Yunengsih, “Perancangan Sistem Informasi Penyimpanan Rekam Medis Rawat Jalan Di Uptd Puskesmas,” INFOKES (Informasi Kesehatan), vol. 5, no. 2, pp. 66–77, 2021, doi: 10.56689/infokes.v5i2.466.
[12] D. Sarumaha, “Penerapan Metode Double Moving Average Untuk Memprediksi Penjualan Tiket Kereta Api,” J. Comput. Sci. Inf. Technol., vol. 1, no. 1, pp. 10–13, 2021.
[13] N. Rahmansyah, S. A. Lusinia, R. L. Gema, and S. Safira, “Peramalam Garis Kemiskinan menggunakan Metode Double Moving Average di Provinsi Sumatera Barat,” Maj. Ilm. UPI YPTK, vol. 28, pp. 25–29, 2021, doi: 10.35134/jmi.v28i1.68.
[14] Y. S. Hidayat, A. Aziz, and M. Ahsan, “Implementasi Metode Single Moving Average dan Double Moving Average untuk Memprediksi Populasi Sapi Potong di Jawa Timur,” vol. 5, no. 3, 2023.
[15] D. Irawan, R. T. A. Agus, and S. Sahren, “Penerapan Metode Double Moving Average dalam Memprediksi Permintaan Kayu,” J. Media Inform. Budidarma, vol. 6, no. 4, p. 1998, 2022, doi: 10.30865/mib.v6i4.4648.
[16] B. Humaira’Bintu, Mahir Membuat Website dengan Adobe Dreamweaver CS6, CSS, dan JQuery. Yogyakarta: Andi, 2015.
[17] Mutia, I. Ibrahim, and M. T. Sunilfa, “Double Moving Average and Double Exponential Smoothing Method in Sales Forecasting,” vol. 3, no. 3, pp. 112–120, 2024.
[18] K. Harahap, Fujiati, and D. H. Tanjung, “Prediksi Persediaan Stok Sparepart Mesin Produksi Kategori Fast Moving Menggunakan Metode Double Moving Average Berbasis Website Pada PT. Intan Hevea Industry,” J. JUREKSI, vol. 2, no. 1, pp. 394–408, 2024.
[19] S. Agrawal and T. Choudhury, “A Comparative Analysis of Forecasting Models on COVID‑19,” in New Perspectives in Operations Research and Management Science, Springer, 2022, pp. 95–111. doi: 10.1007/978-3-030-91851-4_8.
[20] G. Bontempi, S. Ben Taieb, and Y. A. Le Borgne, “Machine Learning Advances for Time Series Forecasting,” 2020. [Online]. Available: https://arxiv.org/abs/2012.12802 ER
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Dzira Faza Zarasky, Muhamad Alda
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) ) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
