Application of Single Exponential Smoothing for Sales Forecasting: A Data-Driven Approach to Demand Management

Authors

  • Robbi Djefri Lakatua Universitas Kristen Indonesia Maluku, Maluku, Indonesia
  • Jondry Adrin Hetharie Universitas Kristen Indonesia Maluku, Maluku, Indonesia https://orcid.org/0000-0003-3515-490X
  • Kiz Inalessy Manuhutu Universitas Kristen Indonesia Maluku, Maluku, Indonesia

DOI:

https://doi.org/10.51135/PublicPolicy.v6.i2.p373-390

Keywords:

Forecasting, Single Exponential Smoothing

Abstract

Forecasting is a method used to predict future values based on historical data. This study aims to analyze and apply the Single Exponential Smoothing (SES) method to forecast the sales volume at Cafe Sibu-Sibu 01 for the upcoming period. The data used in this research consist of monthly sales records from January 2022 to December 2023. The forecasting results are then evaluated for accuracy using Mean Absolute Deviation (MAD), Mean Squared Error (MSE), and Mean Absolute Percentage Error (MAPE). The findings indicate that the sales volume for January 2024 is projected to increase to approximately IDR 68,882,000. With a smoothing constant of 0.1, the obtained values are MAD = 8,210.9, MSE = 114,138,110, and MAPE = 11.4%. Based on these results, it is concluded that the Single Exponential Smoothing method can be effectively used to forecast sales volume at Cafe Sibu-Sibu 01.

Downloads

Download data is not yet available.

References

Ahaggach, H., Abrouk, L., & Lebon, E. (2024). Systematic Mapping Study of Sales Forecasting: Methods, Trends, and Future Directions. Forecasting, 6(3), 502–532. https://doi.org/10.3390/forecast6030028

Calvo, G. A., & Thoumi, F. E. (1984). Demand Fluctuations, Inventories and Capacity Utilization. Southern Economic Journal, 50(3), 743. https://doi.org/10.2307/1057989

Chaker, N. N., Habel, J., Hewett, K., & Zablah, A. R. (2024). The Future of Research on International Selling and Sales Management. Journal of International Marketing, 32(1), 1–14. https://doi.org/10.1177/1069031X231224712

Chaowai, K., & Chutima, P. (2024). Demand Forecasting and Ordering Policy of Fast-Moving Consumer Goods with Promotional Sales in a Small Trading Firm. Engineering Journal, 28(4), 21–40. https://doi.org/10.4186/ej.2024.28.4.21

Claro, D. P., Ramos, C., & Palmatier, R. W. (2024). Dynamic and Global Drivers of Salesperson Effectiveness. Journal of the Academy of Marketing Science, 52(2), 399–425. https://doi.org/10.1007/s11747-023-00954-2

Danese, P., & Kalchschmidt, M. (2011). The Role of the Forecasting Process in Improving Forecast Accuracy and Operational Performance. International Journal of Production Economics, 131(1), 204–214.

Donaldson, B., & Donaldson, B. (1998). Sales Forecasting and Budgeting. Sales Management: Theory and Practice, 128–146.

Fose, N., Singh, A. R., Krishnamurthy, S., Ratshitanga, M., & Moodley, P. (2024). Empowering Distribution System Operators: A Review of Distributed Energy Resource Forecasting Techniques. Heliyon, 10(15), e34800. https://doi.org/10.1016/j.heliyon.2024.e34800

Goodwin, P. (2002). Integrating Management Judgment and Statistical Methods to Improve Short-Term Forecasts. Omega, 30(2), 127–135.

Grimson, J. A., & Pyke, D. F. (2007). Sales and Operations Planning: An Exploratory Study and Framework. The International Journal of Logistics Management, 18(3), 322–346.

Gupta, M., & Kohli, A. (2006). Enterprise Resource Planning Systems and its Implications for Operations Function. Technovation, 26(5–6), 687–696.

Guru, P., Sathyapriya, J., Rajandran, K. V. R., Bhuvaneswari, J., & Parimala, C. (2024). Product Sales Forecasting and Prediction Using Machine Learning Algorithm. International Journal of Intelligent Systems and Applications in Engineering, 12(4s), 355–366.

Gustriansyah, R., Suhandi, N., Antony, F., & Sanmorino, A. (2019). Single Exponential Smoothing Method to Predict Sales Multiple Products. Journal of Physics: Conference Series, 1175(1), 012036. https://doi.org/10.1088/1742-6596/1175/1/012036

He, Z., Ni, S., Jiang, X., & Feng, C. (2023). The Influence of Demand Fluctuation and Competition Intensity on Advantages of Supply Chain Dominance. Mathematics, 11(24), 4931. https://doi.org/10.3390/math11244931

Heng, L., Ferdinand, A. T., Afifah, N., & Ramadania, R. (2020). Service Innovation Capability for Enhancing Marketing Performance: An SDL Perspectives. Business: Theory and Practice, 21(2), 623–632. https://doi.org/10.3846/btp.2020.12163

Majidi, A. (2019). A Conceptual Framework of Sales Forecast: in Business Processes Dependent on the Actual Location of Sales with Analysis of Past Data and Coming Information About Future Days from Valid Online Resources. Universidade NOVA de Lisboa (Portugal).

Makridakis, S., Hogarth, R. M., & Gaba, A. (2009). Forecasting and Uncertainty in the Economic and Business World. International Journal of Forecasting, 25(4), 794–812.

Manalu, A., Roito, D., Rizkiadina, E., & Laia, Y. (2022). Analysis Forecasting Sales with Single Exponential Smoothing Method. Paradigma-Jurnal Komputer Dan Informatika, 24(2), 135–138. https://doi.org/https://doi.org/https://doi.org/10.31294/p.v24i2.1255

Martin, M., Gneiting, S., Benfer, M., & Lanza, G. (2025). Incentive System to Smooth Out Fluctuations in Demand. Production Engineering, 19(1), 157–171. https://doi.org/10.1007/s11740-024-01300-3

Mehdiyev, N., Enke, D., Fettke, P., & Loos, P. (2016). Evaluating Forecasting Methods by Considering Different Accuracy Measures. Procedia Computer Science, 95, 264–271.

Mentzer, J. T., & Moon, M. A. (2004). Sales Forecasting Management: a Demand Management Approach. Sage Publications.

Muth, M., Lingenfelder, M., & Nufer, G. (2024). The Application of Machine Learning for Demand Prediction under Macroeconomic Volatility: a Systematic Literature Review. Management Review Quarterly, 1–44. https://doi.org/10.1007/s11301-024-00447-8

Oliva, R., & Watson, N. (2011). Cross-Functional Alignment in Supply Chain Planning: A Case Study of Sales and Operations Planning. Journal of Operations Management, 29(5), 434–448.

Park, M.-J., & Yang, H.-S. (2024). Comparative Study of Time Series Analysis Algorithms Suitable for Short-Term Forecasting in Implementing Demand Response Based on AMI. Sensors, 24(22), 7205. https://doi.org/10.3390/s24227205

Qi, B., McCauley, E., Baxter, K., Poo, M. C.-P., & Lau, Y. (2025). A Manufacturing Industry Perspective on Pandemic-Induced Supply Chain Disruptions. Businesses, 5(1), 8. https://doi.org/10.3390/businesses5010008

Racela, O. C. (2014). Customer Orientation, Innovation Competencies, and Firm Performance: A Proposed Conceptual Model. Procedia - Social and Behavioral Sciences, 148, 16–23. https://doi.org/10.1016/j.sbspro.2014.07.010

Redman, T. C. (2008). Data driven: profiting from your most important business asset. Harvard Business Press.

Saleh, M. A., Rasel, H. M., & Ray, B. (2024). A Comprehensive Review Towards Resilient Rainfall Forecasting Models Using Artificial Intelligence Techniques. Green Technologies and Sustainability, 2(3), 100104. https://doi.org/10.1016/j.grets.2024.100104

Sanders, N. R., & Ritzman, L. P. (2001). Judgmental Adjustment of Statistical Forecasts. Principles of Forecasting: A Handbook for Researchers and Practitioners, 405–416.

Sharifhosseini, S. M., Niknam, T., Taabodi, M. H., Aghajari, H. A., Sheybani, E., Javidi, G., & Pourbehzadi, M. (2024). Investigating Intelligent Forecasting and Optimization in Electrical Power Systems: A Comprehensive Review of Techniques and Applications. Energies, 17(21), 5385. https://doi.org/10.3390/en17215385

Song, X., Deng, L., Wang, H., Zhang, Y., He, Y., & Cao, W. (2024). Deep Learning-Based Time Series Forecasting. Artificial Intelligence Review, 58(1), 23. https://doi.org/10.1007/s10462-024-10989-8

Thoumrungroje, A., & Racela, O. C. (2022). Innovation and Performance Implications of Customer-Orientation across Different Business Strategy Types. Journal of Open Innovation: Technology, Market, and Complexity, 8(4), 178. https://doi.org/10.3390/joitmc8040178

Tuomikangas, N., & Kaipia, R. (2014). A Coordination Framework for Sales and Operations Planning (S&OP): Synthesis from the Literature. International Journal of Production Economics, 154, 243–262.

Wiedyaningsih, C., Yuniarti, E., & Ginanti Putri, N. P. V. (2024). Comparison Of Forecasting Drug Needs Using Time Series Methods in Healthcare Facilities: A Systematic Review. Jurnal Farmasi Sains Dan Praktis, 24(22), 156–165. https://doi.org/10.31603/pharmacy.v10i2.11145

Yagoub Abker, A., & Gebreil Musa, A. (2024). The Impact of Strategic Orientations on Service Innovation: The Moderating Effect of Technological Capabilities. Problems and Perspectives in Management, 22(4), 83–94. https://doi.org/10.21511/ppm.22(4).2024.07

Downloads

Published

2025-08-12

How to Cite

Lakatua, R. D., Hetharie, J. A., & Manuhutu, K. I. (2025). Application of Single Exponential Smoothing for Sales Forecasting: A Data-Driven Approach to Demand Management . Public Policy ; Jurnal Aplikasi Kebijakan Publik Dan Bisnis, 6(2), 373–390. https://doi.org/10.51135/PublicPolicy.v6.i2.p373-390

Issue

Vol. 6 No. 2 (2025): Public Policy : Jurnal Aplikasi Kebijakan Publik dan Bisnis (on process)

Section

Articles

License

Copyright (c) 2025 author(s)

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Authors whose manuscripts are published in the Journal of Public Policy must agree to the following terms;

  1. Publication rights for all manuscript materials published are held by the editorial board with the author's consent.
  2. The legal formalities for digital access to the Journal of Public Policy are subject to the Creative Commons Attribution Sharealike (CC BY SA) license, which means the Journal of Public Policy has the right to store, redistribute, reformat, manage in a database, maintain, and publish the manuscript without seeking permission from the author as long as the author's name is included as the copyright owner.
  3. Published manuscripts are open access for the purpose of disseminating research results. Besides this purpose, the editorial board is not responsible for copyright law violations.