IMPLEMENTATION OF THE MOVING AVERAGE ALGORITHM IN A WEB-BASED FOOD AND BEVERAGE RAW MATERIAL STOCK REQUIREMENT PREDICTION INFORMATION SYSTEM
Published:
2026-06-15Downloads
Abstract
Inventory is a critical component in business operations, particularly in the Food and Beverages (F&B) sector, which demands accurate management to mitigate the risks of stockouts and overstocking. However, many MSMEs still rely on conventional methods based on subjective assumptions, which are prone to errors and unable to accommodate demand fluctuations. This research aims to develop a web-based raw material stock forecasting information system integrated with the Single Moving Average (SMA) method to enhance inventory management efficiency. The system development follows a prototyping approach, encompassing data collection, quick design using UML, prototype construction using PHP Laravel and Python, evaluation, and system refinement. The dataset utilized consists of 12 periods of monthly financial reports from Benjiro Sushi, Lamper branch. Accuracy evaluation was conducted using MAPE, MSE, and RMSE metrics. The results indicate that the application of SMA without data pre-processing resulted in a high error rate (MAPE 77.25%). However, after implementing pre-processing techniques—including backward interpolation, outlier capping, and iterative smoothing—the accuracy improved significantly, with MAPE values ranging between 20.4% and 21.0%. The developed system provides automated and real-time stock predictions, facilitating more precise, efficient, and structured procurement decision-making. Thus, this system is considered effective in addressing inventory challenges within the F&B sector.
Keywords:
inventory forecasting moving average information systems Food and Beverages.References
Ardiana, D. P. Y., & Loekito, L. H. (2018). Sistem Informasi Peramalan Persediaan Barang Menggunakan Metode Weighted Moving Average. J. Teknol. Inf. dan Komput., 4(1), 71–79. https://doi.org/10.36002/jutik.v4i1.397
Breckling, J. (Ed.). (1989). The Analysis of Directional Time Series: Applications to Wind Speed and Direction (Vol. 61). Springer.
Buwono, R. C., P, A. G. M. S. M. D., Teknologi, U., & Indonesia, D. (2022). 3 1,2,3. [Journal Name], 2(5), 2239–2246.
Cahyani, V. F., & Nudin, S. R. (2019). Pengembangan Sistem Informasi Manajemen Rantai Pasok Pemasaran Produk Bumdes Berbasis Website Dengan Menggunakan Metode Moving Average (Studi Kasus: BUMDes Desa Sempu). 1–10.
Chidiebube, I. N., Onyeka, N. C., & Sunday, A. P. (2025). A Comparative Analysis Of Machine Learning Models For Inventory Demand Forecasting In A Food Manufacturing Sme. 2, 35–48.
Gunawan, I. N. D., & Setiawan, P. Y. (2022). Inventory Management with EOQ Method at ‘ Nitra Jaya ’ Fashion-Making Company in Badung. 7(3), 347–351.
Hyndman, L. R. J. (2022). Forecasting: Principles & Practice.
IEEE. (2002). The IEEE website. Retrieved from http://www.ieee.org/
Karnik, A. (1999). Performance of TCP congestion control with rate feedback: TCP/ABR and rate adaptive TCP/IP [Master's thesis, Indian Institute of Science]. Bangalore, India.
Lutfi, A. Z., Dewi, H. E., Koestiono, D., & Shabrina, A. R. (2025). Comparative Forecasting Demand For Robusta Ground Coffee Product in SME SL Malang Regency Using Holt-Winters Exponential Smoothing and Seasonal ARIMA Method. 36(August), 94–104. https://doi.org/10.21776/ub.habitat.2025.036.2.8
Ma, B. J., Jackson, I., Huang, M., & Villegas, S. (2025). A data-driven and context-aware approach for demand forecasting in the beverage industry. Int. J. Logist. Res. Appl., 5567, 1–28. https://doi.org/10.1080/13675567.2025.2566806
Metev, S., & Veiko, V. P. (1998). Laser Assisted Microtechnology (R. M. Osgood, Jr., Ed.; 2nd ed.). Springer-Verlag.
Motorola. (1996). FLEXChip Signal Processor (MC68175/D).
Muna, M. K. (2023). Sistem Informasi Peramalan Stok Barang Toko Al Umm Menggunakan Metode Single Moving Average. Intechno J. (Information Technol. Journal), 5(2), 87–97. https://doi.org/10.24076/intechnojournal.2023v5i2.825
Opto Speed SA. (n.d.). PDCA12-70 data sheet. Mezzovico, Switzerland.
Padhye, J., Firoiu, V., & Towsley, D. (1999). A stochastic model of TCP Reno congestion avoidance and control (CMPSCI Tech. Rep. 99-02). Univ. of Massachusetts, Amherst, MA.
Rachmawati, N. L., & Lentari, M. (2022). Penerapan Metode Min-Max untuk Minimasi Stockout dan Overstock Persediaan Bahan Baku. 8(2), 143–148.
Ruas, T., & Grosky, W. (2020). Software Engineering: A Practitioner’s Approach 9 th Edition.
Shell, M. (2002). IEEEtran homepage on CTAN. Retrieved from http://www.ctan.org/tex-archive/macros/latex/contrib/supported/IEEEtran/
Sorace, R. E., Reinhardt, V. S., & Vaughn, S. A. (1997). High-speed digital-to-RF converter (U.S. Patent 5,668,842).
Sumiati, M., Abdillah, R., & Cahyo, A. (2021). Pemodelan UML untuk Sistem Informasi Persewaan Alat Pesta. 11(2), 79–86.
Wegmuller, M., von der Weid, J. P., Oberson, P., & Gisin, N. (2000). High resolution fiber distributed measurements with coherent OFDR. Prosiding ECOC’00, 109.
Zhang, S., Zhu, C., Sin, J. K. O., & Mok, P. K. T. (1999). A novel ultrathin elevated channel low-temperature poly-Si TFT. IEEE Electron Device Lett., 20, 569–571.
License
Copyright (c) 2026 Ainia Hasna Salsabila, Bambang Agus Herlambang, Ramadhan Renaldy
This work is licensed under a Creative Commons Attribution 4.0 International License.
