Salt Sales Prediction Using the Moving Average Method (A Case Study of Madura-Indonesia Salt)

Muhammad Ali Syakur, Departemen of Informatics, Faculty of Engineering, University of Trunojoyo, Madura, Bangkalan, Indonesia
Yudha Dwi Putra Negara, Departemen of Informatics, Faculty of Engineering, University of Trunojoyo, Madura, Bangkalan, Indonesia, Indonesia
Aeri Rachmad, Departemen of Informatics, Faculty of Engineering, University of Trunojoyo, Madura, Bangkalan, Indonesia
Eka Mala Sari Rochman, Departemen of Informatics, Faculty of Engineering, University of Trunojoyo, Madura, Bangkalan, Indonesia

Abstract


Forecasting is a term used to forecast or predict the business that we run to see the direction in the future which uses historical data as the main reference. An appropriate strategy is needed to manage the production of salt raw materials properly, namely through sales forecasting. PT Budiono Madura Bangun Persada is a company engaged in salt processing with the brands "Anak pintar (AP)" and "Kapal Container (KC)" where the amount of production experiences uncertainty, namely an increase or decrease, this results in an uncertain amount of raw materials. This study aims to predict the exact amount of salt production in a certain period. The amount of data used is the period November 2020 - April 2021 as much as. The final result of this forecasting model is the best using predictions on day 6 for both AP salt and KC salt, with an MSE value of 290.71 for KC salt and an MSE value of 843.08 for AP salt

Keywords


forecast, salt, moving average

Full Text:

PDF

References


M. Mahrus, T. Yulianto, and F. Faisol, "Comparison of Exponential Smoothing and Moving Average Methods in Forecasting the Amount of Salt Production in Madura," Zeta-Math Journal, vol. 6, pp. 17-23, 2021.

G. S. Lilipaly, D. Hatidja, and J. S. Kekenusa, "Predicting the stock price of PT. BRI, TBK. Using the ARIMA (autoregressive integrated moving average) method," Jurnal Ilmiah Sains, vol. 14, pp. 60-67, 2014.

P. Sakti and R. J. PUTRI, "Management information systems," 2007.

A. Pratama and S. Salamah, "Implementation of a Single Expoenential Smoothing Forecasting Information System in Seeing Rice Stock Needs at the North Aceh Agricultural Service," Journal of Information Systems, vol. 2, 2018.

S. M. Hohle and K. H. Teigen, “Forecasting forecast: The trend effect,” Judgment and Decision Making, vol. 10, no. 5, pp. 416-428, 2015. [2] D. C. Montgomery, C. L. Jennings, and M. Kulahci, “Introduction to time series analysis and forecasting,” Canada: John Wiley and Sons, Inc, pp. 1-671, 2015.

A. C. Vallet, J. D. Bermúdez, and E. Vercher, “Forecasting correlated time series with exponential smoothing models,” International Journal of Forecasting, vol. 27 no. 2, pp. 252-265, 2011.

D. M. Khairina, A. Muaddam, S. Maharani, and H. Rahmania, “Forecasting of groundwater tax revenue using single exponential smoothing method,” The 4th Internasional Conference on Energi, Environment, Epidemiology and Information System (ICENIS), Semarang-Indonesia, vol. 125, pp. 1-5, 2019.

M. A. Maricar, P. Widiadnyana, and I. Wijaya, “Analysis of data mining for forecasting total goods delivery with moving average method,” International Journal of Engineering and Emerging Technology, vol. 2, no. 1, pp. 7-10, 2017.

W. Anggraeni, K. B. Andri, and F. Mahananto, “The performance of ARIMAX model and vector autoregressive (VAR) model in forecasting strategic commodity price in Indonesia,” Procedia Computer Science, Elsevier, vol. 124, pp. 189-196, 2017.

G. Airlangga, A. Rachmat, and D. Lapihu, “Comparison of exponential smoothing and neural network method to forecast rice production in Indonesia,” TELKOMNIKA Telecommunication Computing Electronics and Control, vol. 17, no. 3, pp. 1367-1375, 2019.

Dyna Marisa Khairina , Rizka Khairunnisa , Heliza Rahmania Hatta , Septya Maharani, “Comparison of the trend moment and double moving average methods for forecasting the number of dengue hemorrhagic fever patients”. Bulletin of Electrical Engineering and Informatics Vol. 10, No. 2, April 2021, pp. 978~987 978ISSN: 2302-9285, DOI: 10.11591/eei.v10i2.2711.Department of Information System, Mulawarman University, Indonesia

S. M. Hohle and K. H. Teigen, “Forecasting forecast: The trend effect,” Judgment and Decision Making, vol. 10, no. 5, pp. 416-428, 2015. [2] D. C. Montgomery, C. L. Jennings, and M. Kulahci, “Introduction to time series analysis and forecasting,” Canada: John Wiley and Sons, Inc, pp. 1-671, 2015.

E. L. de Faria, M. P. Albuquerque, J. L. Gonzalez, J. T. P. Cavalcante, and M. P. Albuquerque, “Predicting the Brazilian stock market through neural networks and adaptive exponential smoothing methods,” Expert System with Applications, vol. 36, no. 10, pp. 12506-12509, Dec. 2009.

L. Wu, S. Liu, and Y. Yang, “Grey double exponential smoothing model and its application on pig price forecasting in China,” Applied Soft Computing, vol. 39, pp. 117-123, 2016.

E.M.S. Rochman, Imamah, and A. Rachmad. "Desain Model Peramalan Jumlah Kerusakan Sim Card." MULTITEK INDONESIA 12.1 (2018): 20-26

E.M.S. Rochman; A. Rachmad, and F. Damayanti. Predicting the Final result of Student National Test with Extreme Learning Machine. Pancaran Pendidikan, 2018, 7.2.

E.M.S. Rochman and A. Rachmad. "Forecasting application for simpati telkomsel card using backpropagation (Case study in Bangkalan Madura-Indonesia)." Advanced Science Letters 23.12 (2017): 12340-12343.

A. Rachmad and D. R. Anamisa. "Forecasting the number of patients diseases using backpropagation." MATEC Web of Conferences. Vol. 58. EDP Sciences, 2016.

E.M.S. Rochman, A. Rachmad, M. A. Syakur, and I. O. Suzanti. "Method extreme learning machine for forecasting number of patients’ visits in dental poli (A case study: Community Health Centers Kamal Madura Indonesia)." Journal of Physics: Conference Series. Vol. 953. No. 1. IOP Publishing, 2018.

G. Sbrana and A. Silvestrini, “Random switching exponential smoothing and inventory forecasting,” International Journal Production Economics Elsevier, vol. 156, pp. 283-294, 2014.

D. Yang, V. Sharma, Z. Ye, L. I. Lim, L. Zhao, and A. W. Aryaputera, “Forecasting of global horizontal irradiance by exponential smoothing, using decompositions,” Energy, vol. 81, no. 1, pp. 111-119, 2015.

F. Poloni and G. Sbrana, “A note on forecasting demand using the multivariate exponential smoothing framework,” International Journal of Production Economics, vol. 162, pp. 143-150, 2015. [10] P. Guan, W. Wu, and D. Huang, “Trends of reported human brucellosis cases in main-land China from 2007 to 2017: An exponential smoothing time series analysis,” Environ. Health Preventive Med., vol. 23, no. 1, pp. 1-7, 2018.

L. Zhou, P. Zhao, D. Wu, C. Cheng, and H. Huang, “Time series model for forecasting the number of new admission inpatients,” BMC Med. Inf. Decis. Making, vol. 18, no. 1, pp. 1-11, 2018.

S. Wang, M. Petzold, J. Cao, Y. Zhang, and W. Wang, “Direct medical costs of hospitalization for cardiovascular diseases in shanghai, China,” Medicine, vol. 94, no. 20, pp. 1-8, 2015.

S. N. A. M. Razali, M. S. Rusiman, N. I. Zanawi, and N. Arbin, “Forecasting of water consumption expenditure using holt-winter’s and ARIMA,” Journal of Physics: Conference Series, vol. 995, no. 1, p. 012041, 2018.

W. Sulandari, S. Subanar, S. Suhartono, H. Utami, M. H. Lee, and P. C. Rodrigues, “SSA-based hybrid forecasting models and applications,” Bulletin of Electrical Engineering and Informatics, vol. 9, no. 5, pp. 2178-2188, 2020.

J. S. Armstrong, K. C. Green, and A. Graefe, “Golden rule of forecasting: Be conservative,” Journal of Business Research, Elsevier, vol. 68, no. 8, pp. 1717-1731, 2015.

W. Anggraeni, I. P. A. A. Pramana, F. Samopa, E. Riksakomara, R. P. Wibowo, L. Condro T. and Pujiadi “Forecasting the number of dengue fever cases in Malang regency Indonesia using fuzzy inference system models,” Journal of Theoretical and Applied Information Technology, vol. 95, no. 1, pp. 1-8, 2016.

W. H. Wang, A. N. Urbina, M. R. Chang, W. Assavalapsakul, P. L. Lu, Y. H. Chen, and S. F. Wang, “Dengue hemorrhagic fever–A systemic literature review of current perspectives on pathogenesis, prevention and control,” Journal of Microbiology, Immunology and Infection, Science Direct, vol. 53, no. 6, pp. 963-978, 2020.

W. Wanti, R. Yudhastuti, H. B. Notobroto, S. Subekti, O. Sila, R. H. Kristina, and F. Dwirahmadi, “Dengue hemorrhagic fever and house conditions in kupang city, East Nusa Tenggara province,” Kesmas: National Public Health Journal, vol. 13, no. 4, pp. 176-181, 2019. [19] B. P Candra, and H. A. Fatta, “Implementation of trend moment method for stock prediction as supporting production,” IOP Science Journal of Phsysics: Conference Series, vol. 1140, no. 1, pp. 1-8, 2018.

A. A. F. D. Izz, M. Sholihin, and M. Masruroh, “Trend moment method for predicting multimedia equipment rental needs,” Scientific Journal on Information and Communication Technology, vol. 5, no. 1, pp. 20-24, 2020.

M. A. Maricar, P. Widiadnyana, and I. Wijaya, “Analysis of data mining for forecasting total goods delivery with moving average method,” International Journal of Engineering and Emerging Technology, vol. 2, no. 1, pp. 7-10, 2017




DOI: https://doi.org/10.21831/elinvo.v8i2.56279

Refbacks

  • There are currently no refbacks.


Copyright (c) 2024 Elinvo (Electronics, Informatics, and Vocational Education)

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

Our Journal indexed by:

ISSN 2477-2399 (online) || ISSN 2580-6424 (print)

View My Stats

Flag Counter