Jurnal Tecnoscienza
Vol. 11 No. 1 (2026): JURNAL TECNOSCIENZA

Optimasi Koefisien Single dan Double Exponential Smoothing Menggunakan Solver untuk Prediksi Produksi Gula Nasiona

Gusman Simon (Universitas Pelita Bangsa)



Article Info

Publish Date
31 Oct 2026

Abstract

Sugar has an important in the national economy and food security; however, consumption levels continues to rise due to population growth and industrial expansion. Fluctuations in national sugar production—often falling short of demand—have created supply gaps and necessitated reliance on imports. To support strategic planning and balance supply and demand, this study forecasts national sugar production using historical data spanning 40 periods (1985–2024) from Statistics Indonesia (BPS) publications. The study’s main contribution is the use of Single Exponential Smoothing (SES) and Double Exponential Smoothing (DES) with MS Excel Solver to optimize the α and β coefficients, rather than relying on trial-and-error approaches or omitting detailed coefficient selection. Forecast results were evaluated using the Mean Absolute Percentage Error (MAPE) metric; both methods demonstrated high forecasting accuracy based on MAPE classification standards. A comparative analysis revealed nearly comparable performance, with SES yielding a slightly lower MAPE than DES. 

Copyrights © 2026






Journal Info

Abbrev

TECNOSCIENZA

Publisher

Subject

Civil Engineering, Building, Construction & Architecture Computer Science & IT Engineering Mathematics Other

Description

TECNOSCIENZA is an academic journal on the issued related to engineering, earth science, and technology. Published actually in April and October. It is open to all scientist, researchers, education practitioners, and other scholar. Therefore this journal welcomes to various topics that have recieved ...