Preprint has been published in a journal as an article
Preprint / Version 1

Enhancing Sales Prediction for MSMEs: A Comparative Analysis of Neural Network and Linear Regression Algorithms


Meningkatkan Prediksi Penjualan untuk UMKM: Analisis Perbandingan Algoritma Neural Network dan Linear Regression

##article.authors##

DOI:

https://doi.org/10.21070/ups.3954

Keywords:

Prediction, Sales, Neural Network, Linear Regression

Abstract

The increasingly fierce competition in the MSME (Micro, Small and Medium Enterprises) industry has made business actors predict sales to find out future sales predictions and prepare strategies to deal with market trends that will occur in the future. Therefore, this research aims to predict sales and analyze the error value of sales data forecasting so that it can provide recommendations for strategies to increase sales. Based on the test results, the neural network algorithm is more suitable for forecasting sales than the linear regression algorithm. The test results obtained an RMSE value of 40,070 in the Neural Network method using one hidden layer and an RMSE value of 66,998 derived from the feature selection T-Test and Iterative T-Test with a Min-Tolerance value of 0.05 in the Linear Regression method.

Downloads

Download data is not yet available.

References

R. Iriane, “CLICK: Scientific Review of Informatics and Computers Application of Data Mining for Sales Prediction of Animal Food Products Using the K-Nearest Neighbor Method,” Media Online, vol. 3, no. 5, pp. 509–515, 2023, [Online]. Available: https://djournals.com/klik

T. k and M. Wadhawa, “Analysis and Comparison Study of Data Mining Algorithms Using Rapid Miner,” Int. J. Comput. Sci. Eng. Appl., vol. 6, no. 1, pp. 9–21, 2016, doi: 10.5121/ijcsea.2016.6102.

F. Widiastuti, W. Murniati, and Saikin, “Application of Data Mining to Predict Sales of Woven Fabrics Using Linear Regression Case Study: Ud.Bintang Remawe Sukarare,” J. Ilm. Tek. Mesin, Elektro, dan Komput., vol. 2, no. 1, pp. 27–39, 2022.

K. Nugroho, W. Hadi Kurniawati, and R. M. Herdian Bhakti, “Designing Sales Prediction Model Using Neural Network Method,” J. Ilm. Intech Inf. Technol. J. UMUS, vol. 4, no. 02, pp. 153–160, 2022, doi: 10.46772/intech.v4i02.870.

M. Yasin, “Comparison Of The Application Of Linear Regression Method Estimation Using Rapidminer And Ms. Excel,” vol. 8, pp. 17–29, 2023.

W. B. Sebayang, “Adolescent Childbirth with Asphyxia Neonatorum,” J. Aisyah J. Ilmu Kesehat., vol. 7, no. 2, pp. 669–672, 2022, doi: 10.30604/jika.v7i2.1507.

O. Access, C. Sciences, and C. Sciences, “Soil Ph Prediction Using Rapid Miner And Machine Learning Algorithms,” no. 04, pp. 6503–6509, 2023.

M. M. Sidabutar, “Comparison Of Linear Regression , Neural Net , And Arima Methods For Sales Prediction Of Instrumentation And Control Products In Pt . Sarana Instrument,” vol. 02, no. 8, pp. 1694–1705, 2023, doi: 10.59141/jrssem.v2i08.397.

L. Lahindah and I. D. Sudirman, “Classification Approach To Predict Customer Decision Between Product Brands Based on Customer Profile and Transaction,” J. Theor. Appl. Inf. Technol., vol. 101, no. 9, pp. 3362–3370, 2023.

B. Tiara, “Sales Prediction Using Neural Network Algorithm: Case Study at PT Balaraja Food Makmur Abadi,” Insa. Pembang. Sist. Inf. dan Komput. …, vol. 6, no. 1, 2018, [Online]. Available: https://ojs.ipem.ecampus.id/ojs_ipem/index.php/stmik-ipem/article/viewFile/93/10

L. Kovács and H. Ghous, “Efficiency comparison of Python and RapidMiner,” Multidiszcip. Tudományok, vol. 10, no. 3, pp. 212–220, 2020, doi: 10.35925/j.multi.2020.3.26.

H. A. Ryantika et al., “Linear Regression Method Application To Predict Cimory Milk,” vol. 7, no. 1, pp. 1–7, 2023.

A. S. Batubara, H. Dafitri, and I. Faisal, “Analysis Of Linear Regression And Trend Moment Methods In Predcting Sales Using MAPE,” J. Sist. Inf. dan Ilmu Komput. Prima, vol. 6, no. 1, pp. 75–81, 2022.

D. Haryadi, D. Marini, U. Atmaja, and A. R. Hakim, “Regression Algorithm,” vol. 1089, no. June, pp. 1–12, 2023.

S. Sunardi, A. Fadlil, and N. M. P. Kusuma, “Comparing Data Mining Classification for Online Fraud Victim Profile in Indonesia,” INTENSIF J. Ilm. Penelit. dan Penerapan Teknol. Sist. Inf., vol. 7, no. 1, pp. 1–17, 2023, doi: 10.29407/intensif.v7i1.18283.

H. Supendar, R. Rusdiansyah, N. Suharyanti, and T. Tuslaela, “Application of the Naïve Bayes Algorithm in Determining Sales Of The Month,” SinkrOn, vol. 8, no. 2, pp. 873–879, 2023, doi: 10.33395/sinkron.v8i2.12293.

S. Minta, Suriani, and R. Meutia, “The Effect of Income and Population on Public Consumption in Aceh Province with Panel Data Regression,” J. Ilm. Basis Ekon. dan Bisnis, vol. 1, no. 1, pp. 1–17, 2022, doi: 10.22373/jibes.v1i1.1577.

M. Adjie Setyadj, A. Faqih, and Y. Arie Wijaya, “Forecasting Rice Commodity Prices in East Kalimantan Using Neural Network Algorithm,” JATI (Jurnal Mhs. Tek. Inform., vol. 7, no. 1, pp. 320–324, 2023, doi: 10.36040/jati.v7i1.6327.

A. Massaro, V. Maritati, and A. Galiano, “Data Mining Model Performance of Sales Predictive Algorithms Based on Rapidminer Workflows,” Int. J. Comput. Sci. Inf. Technol., vol. 10, no. 3, pp. 39–56, 2018, doi: 10.5121/ijcsit.2018.10303.

B. Pradito and D. S. Purnia, “Comparison of Linear Regression and Neural Network Algorithms for Predicting Currency Exchange Rates,” EVOLUSI J. Sains dan Manaj., vol. 10, no. 2, pp. 64–71, 2022, doi: 10.31294/evolusi.v10i2.13284.

W. C. Utomo, A. History, and C. Utomo, “Journal of Information Technology and Management Prediction of BBRI Stock Movement amid the Issue of 2023 Recession Threat with Machine Learning Approach Article Info ABSTRACT,” vol. 9, no. 1, pp. 20–27, 2023, [Online]. Available: http://http//jurnal.unmer.ac.id/index.php/jtmi

T. Wahyudi and D. S. Arroufu, “Implementation of Data Mining Prediction Delivery Time Using Linear Regression Algorithm,” J. Appl. Eng. Technol. Sci., vol. 4, no. 1, pp. 84–92, 2022, doi: 10.37385/jaets.v4i1.918.

F. Kurniawan, Y. Miftachul, F. Nugroho, and M. Ikhlayel, “Comparing neural network with linear regression for stock market prediction,” vol. 7, no. 1, pp. 8–13, 2023.

N. Izzah, A. Mohd, N. H. Shafii, N. F. Fauzi, and D. S. Nasir, “Prediction of Future Stock Price Using Recurrent Neural Network,” vol. 8, no. 2, pp. 103–111, 2023.

V. P. Ramadhan and F. Y. Pamuji, “Comparative Analysis of Forecasting Algorithms in LQ45 Stock Price Prediction PT Bank Mandiri Sekuritas (BMRI),” J. Teknol. dan Manaj. Inform., vol. 8, no. 1, pp. 39–45, 2022, doi: 10.26905/jtmi.v8i1.6092.

M. Juanda Saputra and M. Izman Herdiansyah, “Application of Naive Bayes in Predicting Sales and Inventory of Jumputan Fabric at Batiq Colet Shop Tuan Kentang Palembang,” J. Mantik, vol. 6, no. 2, pp. 2502–2507, 2022.

A. Muliawan, “Experiment Time Series Forcasting Using Machine Learning ( Case study : Stock Value Prediction ),” pp. 834–839, 2023.

Fernos Jhon and Ayadi Syarief Ahmad, “The Effect of Marketing Mix on Consumer Purchase Interest in the Lapai Honey Donut Shop,” J. Valuasi J. Ilm. Ilmu Manaj. dan Kewirausahaan, vol. 3, pp. 593–604, 2023.

G. R. Saputra and R. Roswaty, “The Effect of 4P Marketing Mix on Retail Fertilizer Purchasing Decisions at Toko Tani Makmur Pagar Alam South Sumatra,” J. Nas. Manaj. Pemasar. SDM, vol. 1, no. 2, pp. 32–45, 2020, doi: 10.47747/jnmpsdm.v1i2.125.

Y. Citra, S. Nurwahidah, A. Wrtiningsih, and L. Belakang, “Marketing mix of krupuk atum saleng beme business in sampar layang hamlet, pemanto village, empang sub-district,” vol. 3, no. 1, pp. 62–71, 2023.

M. Sofiah, S. Ramadhani, and N. A. Bi Rahmani, “Analysis of the influence of the 4p marketing mix (product, price, promotion, and place) on purchasing decisions in micro, small and medium enterprises (umkm),” J. Ris. Ekon. dan Bisnis, vol. 16, no. 2, p. 122, 2023, doi: 10.26623/jreb.v16i2.7288.

J. Ilmiah and E. Islam, “4P Marketing Mix Strategy in Determining the Source of Islamic Business Capital for Market Traders in Sidoarjo,” J. Ilm. Ekon. Islam, vol. 6, no. 03, pp. 693–702, 2020, [Online]. Available: http://jurnal.stie-aas.ac.id/index.php/jie

L. R. Dihuma, M. Din, and F. Lamusa, “Marketing Mix (4P) on Coconut Oil Products ‘Lanarasa’ in Tambu Village, Balaesang District,” vol. 2, no. 1, 2023.

A. Triyawan, I. Prastyaningsih, and M. Pradhistya, “The Effect of Islamic Marketing Mix (4P) on Consumer Loyalty Mangrove Corporation (Ummilovely),” J. Sharia Econ., vol. 4, no. 1, pp. 29–52, 2023, doi: 10.22373/jose.v4i1.2517.

N. Sabila, “Analysis Of Marketing Strategies In Small Businesses Rambak Crackers Dwi Djaya Kendal District In The Perspective Of Business Riyadhoh,” Pap. Knowl. . Towar. a Media Hist. Doc., vol. 3, no. 2, p. 6, 2021.

Posted

2024-02-20