Main Menu Sales Forecasting at Bakso Pak Eko MSME Using the Single Exponential Smoothing Method
DOI:
https://doi.org/10.35870/ijsecs.v6i3.8215Keywords:
Sales Forecasting, Single Exponential Smoothing, MSMEs, Streamlit, Web-Based ApplicationAbstract
Sales volume is a critical factor influencing business sustainability, particularly for Micro, Small, and Medium Enterprises (MSMEs) operating in the perishable culinary sector. Bakso Pak Eko MSME faces persistent operational challenges in daily production planning, which currently relies on manual intuition and informal estimation, frequently resulting in inventory surpluses, ingredient spoilage, or unmet consumer demand. To address these operational inefficiencies, this study develops a responsive web-based sales forecasting system for primary menu items using the Single Exponential Smoothing (SES) method to support data-driven production scheduling. The SES method was selected due to its mathematical simplicity, low computational overhead, and proven efficacy in processing short-term historical sales records that exhibit stationary demand patterns without pronounced trend or seasonal fluctuations. The application was engineered using Python and the Streamlit framework, integrating dynamic menu catalog administration, daily transaction logging, customizable smoothing constants, automated forecasting routines, and real-time gross revenue estimation. Functional reliability was verified through Black Box Testing, while predictive performance was benchmarked using the Mean Absolute Percentage Error (MAPE) metric across three core menu items: regular meatballs, egg meatballs, and jumbo meatballs. The evaluation results demonstrate that the application operates reliably across all functional workflows without runtime anomalies. Configured with an optimal smoothing constant of α = 0.3, the model achieved a MAPE value of 1.56%, categorizing the forecast as highly accurate with an absolute deviation of only one to two portions per menu item. Furthermore, directly translating unit portion projections into daily revenue calculations provides the enterprise owner with actionable financial transparency alongside physical preparation targets. Consequently, this system effectively bridges computational modeling and shop-floor decision-making, enabling MSME managers to streamline raw material procurement, mitigate food waste, and enhance overall operational cost-efficiency.
Downloads
References
Ahmad, F. (2022). Implementasi metode Single Exponential Smoothing pada sistem prediksi penjualan. Jurnal Sisfokom (Sistem Informasi dan Komputer), 11(2), 198–205. https://doi.org/10.32736/sisfokom.v11i2.1412
Anwar, M. (2023). Penerapan metode Single Exponential Smoothing pada prediksi penjualan produk kuliner. Jurnal Ilmiah Komputer dan Informatika, 8(1), 55–63. https://doi.org/10.34010/komputika.v8i1.1892
Firmansyah, M., & Rahman, A. (2022). Implementasi forecasting penjualan menggunakan metode Single Exponential Smoothing pada toko retail. Jurnal Sistem Informasi, 9(2), 120–129. https://doi.org/10.36549/jsi.v9i2.195
Handayani, S., & Putra, R. (2023). Prediksi penjualan produk UMKM menggunakan metode Single Exponential Smoothing. Jurnal Informatika Ekonomi Bisnis, 5(2), 101–109. https://doi.org/10.37034/infeb.v5i2.584
Heizer, J., Render, B., & Munson, C. (2020). Operations management: Sustainability and supply chain management. Pearson.
Hyndman, R. J., & Athanasopoulos, G. (2021). Forecasting: Principles and practice. OTexts. https://otexts.com/fpp3/
Kadir, A. (2020). Pengenalan sistem informasi (Edisi Revisi). Penerbit Andi.
Khotimah, N., & Rohman, F. (2023). Implementasi sistem prediksi penjualan berbasis web menggunakan Single Exponential Smoothing. Jurnal Teknologi Informasi dan Komunikasi, 12(1), 32–41. https://doi.org/10.35870/jti.v12i1.821
Kurniawan, D., & Hidayat, T. (2022). Forecasting penjualan pada UMKM menggunakan Single Exponential Smoothing. Jurnal RESTI (Rekayasa Sistem dan Teknologi Informasi), 6(3), 502–509. https://doi.org/10.29207/resti.v6i3.4150
Makridakis, S., Spiliotis, E., & Assimakopoulos, V. (2022). Forecasting: Methods and applications. John Wiley & Sons.
Prayitno, A. (2022). Implementasi metode forecasting untuk prediksi penjualan UMKM. Jurnal Teknologi dan Sistem Informasi, 10(1), 44–52. https://doi.org/10.33395/sinkron.v7i1.11245
Rahmawati, D., & Nugroho, S. (2023). Analisis peramalan penjualan menggunakan metode Single Exponential Smoothing pada UMKM. Jurnal Sistem Informasi dan Teknologi, 4(2), 45–53. https://doi.org/10.37034/jsisfotek.v4i2.138
Saputra, R. (2022). Implementasi forecasting penjualan menggunakan metode Single Exponential Smoothing berbasis web. Jurnal Teknologi Informasi, 8(1), 15–23. https://doi.org/10.31004/coreit.v8i1.4012
Suryani, E., & Mulyanto, A. (2023). Analisis forecasting penjualan produk makanan. Jurnal Media Informatika Budidarma, 7(1), 95–103. https://doi.org/10.30865/mib.v7i1.5412
Turban, E., Volonino, L., & Wood, G. (2021). Information technology for management: Advancing sustainable, profitable business growth. John Wiley & Sons.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Gabriel Alezhandro Pakpahan, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
