SUGAR DEMAND FORECASTING IN PT XYZ WITH WINQSB SOFTWARE
Abstract
PT XYZ is a manufacturing company engaged in the production of sugar and its by-products. Currently, the determination of the amount of production at PT XYZ has not been adjusted to meet customer demand, which may continue to decrease or increase for each period. If there is a condition that the amount of production is greater than demand, it will increase the cost of storage due to accumulation. Meanwhile, if the amount of production is smaller than demand, there will be an out-of-stock condition that can reduce consumer confidence. These problems can be solved by forecasting Tambora Sugar demand at PT XYZ to meet consumer demand using the forecasting method (forecasting) with the help of WinQsb software with input, namely sugar demand data from 2021 PT SMS. The request data will later be analyzed from the request using a scatter diagram. Furthermore, after the pattern is known, the appropriate forecasting method will be determined and inputted into the WinQsb software. Based on the calculation results, it is known that the demand pattern from last year tends to trend down so the chosen method is the Double Exponential Smoothing (DES), Single Exponential Smoothing (SES), and Linear Regression (LR) method, with the best method being Linear Regression which produces the smallest error. The output is in the form of a Master Production Schedule (MPS), namely in the 13th to 18th periods, respectively 2142; 1757; 1373; 989; 604; 220 sacks.
Downloads
References
Industry of Ministry, “Press Conference,” 2022.
A. Purwanto and S. Hanief, “Teknik Peramalan dengan Double Exponential Smoothing pada Distributor Gula,” Jurnal Teknologi Informasi dan Komputer, vol. 3, no. 1, pp. 362–366, 2017.
D. Agista Pratama, S. Hidayati, E. Suroso, and D. Sartika, “Analisis Peramalan Permintaan dan Pengendalian Persediaan Bahan Baku Pembantu pada Industri Gula (Studi Kasus PT. XYZ Lampung Utara) Analysis Forecasting Dem & Control of Supply Raw Materialsi In The Sugar Industry (Case Study of PT. XYZ North Lampung),” Jurnal Penelitian Pertanian Terapan, vol. 20, no. 2, pp. 148–160, 2020, doi: 10.25181/jppt.v120i2.1636.
I. Basri K, D. F. Abdillah, T. Khotiah, J. Jumain, and A. Rohman, “Forecasting the Number of Patient Visits by Arima and Holwinters Method at the Public Health Center,” Journal of Computer Networks, Architecture and High Performance Computing, vol. 5, no. 1, pp. 75–86, Jan. 2023, doi: 10.47709/cnahpc.v5i1.2008.
K. I. Basri and I. D. Sumitra, “Comparison of Forecasting the Number of Outpatients Visitors Based on Naïve Method and Exponential Smoothing,” in IOP Conference Series: Materials Science and Engineering, Institute of Physics Publishing, Nov. 2019, pp. 1–5. doi: 10.1088/1757-899X/662/4/042002.
A. G. Billé, A. Gianfreda, F. Del Grosso, and F. Ravazzolo, “Forecasting electricity prices with expert, linear, and nonlinear models,” Int J Forecast, vol. 39, no. 2, pp. 570–586, Apr. 2023, doi: 10.1016/J.IJFORECAST.2022.01.003.
B. Holmes, I. G. McHale, and K. Żychaluk, “A Markov chain model for forecasting results of mixed martial arts contests,” Int J Forecast, vol. 39, no. 2, pp. 623–640, Apr. 2023, doi: 10.1016/J.IJFORECAST.2022.01.007.
Y. Zhang and Y. Wang, “Forecasting crude oil futures market returns: A principal component analysis combination approach,” Int J Forecast, vol. 39, no. 2, pp. 659–673, Apr. 2023, doi: 10.1016/J.IJFORECAST.2022.01.010.
N. Meade and C. Driver, “Differing behaviours of forecasters of UK GDP growth,” Int J Forecast, vol. 39, no. 2, pp. 772–790, Apr. 2023, doi: 10.1016/J.IJFORECAST.2022.02.005.
P. Macias, D. Stelmasiak, and K. Szafranek, “Nowcasting food inflation with a massive amount of online prices,” Int J Forecast, vol. 39, no. 2, pp. 809–826, Apr. 2023, doi: 10.1016/J.IJFORECAST.2022.02.007.
N. Gradojevic, D. Kukolj, R. Adcock, and V. Djakovic, “Forecasting Bitcoin with technical analysis: A not-so-random forest?,” Int J Forecast, vol. 39, no. 1, pp. 1–17, Jan. 2023, doi: 10.1016/J.IJFORECAST.2021.08.001.
V. Alp and B. C. Ervural, “Strategic Demand Forecasting with Machine Learning Algorithms in a Dyeing Company,” pp. 188–197, 2023, doi: 10.1007/978-3-031-24457-5_16.
E. Theodorou, S. Wang, Y. Kang, E. Spiliotis, S. Makridakis, and V. Assimakopoulos, “Exploring the representativeness of the M5 competition data,” Int J Forecast, vol. 38, no. 4, pp. 1500–1506, Oct. 2022, doi: 10.1016/j.ijforecast.2021.07.006.
S. Kolassa, “Commentary on the M5 forecasting competition,” Int J Forecast, vol. 38, no. 4, pp. 1562–1568, Oct. 2022, doi: 10.1016/j.ijforecast.2021.08.006.
X. Li, Y. Bai, and Y. Kang, “Exploring the social influence of the Kaggle virtual community on the M5 competition,” Int J Forecast, vol. 38, no. 4, pp. 1507–1518, Oct. 2022, doi: 10.1016/J.IJFORECAST.2021.10.001.
B. Seaman and J. Bowman, “Applicability of the M5 to Forecasting at Walmart,” Int J Forecast, vol. 38, no. 4, pp. 1468–1472, Oct. 2022, doi: 10.1016/j.ijforecast.2021.06.002.
S. Makridakis, E. Spiliotis, and V. Assimakopoulos, “Responses to the discussions and commentaries of the M5 Special Issue,” Int J Forecast, vol. 38, no. 4, pp. 1569–1575, Oct. 2022, doi: 10.1016/j.ijforecast.2022.05.004.
E. Theodorou, S. Wang, Y. Kang, E. Spiliotis, S. Makridakis, and V. Assimakopoulos, “Exploring the representativeness of the M5 competition data,” Int J Forecast, vol. 38, no. 4, pp. 1500–1506, Oct. 2022, doi: 10.1016/J.IJFORECAST.2021.07.006.
B. Seaman and J. Bowman, “Applicability of the M5 to Forecasting at Walmart,” Int J Forecast, vol. 38, no. 4, pp. 1468–1472, Oct. 2022, doi: 10.1016/J.IJFORECAST.2021.06.002.
E. Chiew and S. S. Choong, “A solution for M5 Forecasting - Uncertainty: Hybrid gradient boosting and autoregressive recurrent neural network for quantile estimation,” Int J Forecast, vol. 38, no. 4, pp. 1442–1447, Oct. 2022, doi: 10.1016/J.IJFORECAST.2022.01.009.
N. Mamonov, E. Golubyatnikov, D. Kanevskiy, and I. Gusakov, “GoodsForecast second-place solution in M5 Uncertainty track: Combining heterogeneous models for a quantile estimation task,” Int J Forecast, vol. 38, no. 4, pp. 1434–1441, Oct. 2022, doi: 10.1016/J.IJFORECAST.2022.04.003.
A. D. Lainder and R. D. Wolfinger, “Forecasting with gradient boosted trees: augmentation, tuning, and cross-validation strategies: Winning solution to the M5 Uncertainty competition,” Int J Forecast, vol. 38, no. 4, pp. 1426–1433, Oct. 2022, doi: 10.1016/J.IJFORECAST.2021.12.003.
S. Makridakis et al., “The M5 uncertainty competition: Results, findings and conclusions,” Int J Forecast, vol. 38, no. 4, pp. 1365–1385, Oct. 2022, doi: 10.1016/J.IJFORECAST.2021.10.009.
T. M. Baykal, H. E. Colak, and C. Kılınc, “Forecasting future climate boundary maps (2021–2060) using exponential smoothing method and GIS,” Science of The Total Environment, vol. 848, p. 157633, Nov. 2022, doi: 10.1016/J.SCITOTENV.2022.157633.
K. F. Pritularga, I. Svetunkov, and N. Kourentzes, “Shrinkage estimator for exponential smoothing models,” Int J Forecast, vol. 39, no. 3, pp. 1351–1365, Jul. 2023, doi: 10.1016/J.IJFORECAST.2022.07.005.
G. Moiseev, “Forecasting oil tanker shipping market in crisis periods: Exponential smoothing model application,” The Asian Journal of Shipping and Logistics, vol. 37, no. 3, pp. 239–244, Sep. 2021, doi: 10.1016/J.AJSL.2021.06.002.
G. López and P. Arboleya, “Short-term wind speed forecasting over complex terrain using linear regression models and multivariable LSTM and NARX networks in the Andes Mountains, Ecuador,” Renew Energy, vol. 183, pp. 351–368, Jan. 2022, doi: 10.1016/J.RENENE.2021.10.070.
Y. Hu and N. Sharma, “Ergodic estimators of double exponential Ornstein–Uhlenbeck processes,” J Comput Appl Math, vol. 434, p. 115329, Dec. 2023, doi: 10.1016/J.CAM.2023.115329.
D. J. Wright, “Forecasting irregularly spaced data: An extension of double exponential smoothing,” Comput Ind Eng, vol. 10, no. 2, pp. 135–147, Jan. 1986, doi: 10.1016/0360-8352(86)90035-5.
F. X. Diebold, M. Göbel, and P. Goulet Coulombe, “Assessing and comparing fixed-target forecasts of Arctic sea ice: Glide charts for feature-engineered linear regression and machine learning models,” Energy Econ, vol. 124, p. 106833, Aug. 2023, doi: 10.1016/J.ENECO.2023.106833.
L. Wu, S. Liu, and Y. Yang, “Grey double exponential smoothing model and its application on pig price forecasting in China,” Appl Soft Comput, vol. 39, pp. 117–123, Feb. 2016, doi: 10.1016/J.ASOC.2015.09.054.
S. Baharaeen and A. S. Masud, “A computer program for time series forecasting using single and double exponential smoothing techniques,” Comput Ind Eng, vol. 11, no. 1–4, pp. 151–155, Jan. 1986, doi: 10.1016/0360-8352(86)90068-9.
E. Cadenas, O. A. Jaramillo, and W. Rivera, “Analysis and forecasting of wind velocity in chetumal, quintana roo, using the single exponential smoothing method,” Renew Energy, vol. 35, no. 5, pp. 925–930, May 2010, doi: 10.1016/J.RENENE.2009.10.037.
M. N. Sidiq, A. Sutoni, J. P. Gede, and R. Cianjur, “Perencanaan dan Penentuan Jadwal Induk Produksi di P.T. Arwina Triguna Sejahtera,” 2017. [Online]. Available: http://jurnal.unsur.ac.id/index.php/JMTSI
Copyright (c) 2023 Astrid Wahyu Adventri Wibowo, Fitri Maimunah
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:
- Author retain copyright and grant the journal right of first publication with the work simultaneously licensed under a creative commons attribution license that allow others to share the work within an acknowledgement of the work’s authorship and initial publication of this journal.
- Authors are able to enter into separate, additional contractual arrangement for the non-exclusive distribution of the journal’s published version of the work (e.g. 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 websites) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published works.
1.gif)
