Preprint / Version 1

Daily Rice Sales Prediction Based on Brand, Price, and Package Size Using Linear Regression and Random Forest Methods

Prediksi Penjualan Beras Harian Berdasarkan Merek, harga, dan Ukuran Kemasan Menggunakan Metode Linear Regression dan Random Forest

Authors

DOI:

https://doi.org/10.21070/wbgg5k34

Keywords:

Sales Prediction, Linear Regression, Random Forest Regression, Machine Learning, Rice Sales

Abstract

Sales prediction helps identify sales patterns and supports inventory planning using historical data. This study predicts daily rice sales and compares Linear Regression and Random Forest Regression across different attribute counts and data splits. The dataset covers August 2025 to May 2026, with 4,420 initial records and 4,301 records after preprocessing. Eighteen configurations were tested using 7, 5, and 3 attributes with training-to-testing ratios of 80:20, 70:30, and 60:40. Random Forest Regression with 5 attributes and an 80:20 split achieved the lowest errors: MAE 2.3805, MSE 17.6392, and RMSE 4.1999. In the test data, 2 Rajawali had the highest average predicted sales by brand at 7.32 units, while March 2026 had the highest monthly average prediction at 5.72 units. Among groups with at least three test observations, 2 Rajawali rice in 25 kg packages recorded the highest average prediction of 12.57 units in August 2025.

References

[1] L. Habibah, A. Futri, A. P. Khuzaeri, F. Shidqi, and W. A. Winata, “Bursa : Jurnal Ekonomi dan Bisnis Beras Sebagai Makanan Pokok : Faktor Penyebab Ketergantungan Dan,” J. Ekon. Bisnis, vol. 3, no. 2, pp. 110–114, 2024, [Online]. Available: https://jurnal.risetilmiah.ac.id/index.php/jeb%0ABeras

[2] N. B. Hilalia, “As-Syirkah: Islamic Economics & Finacial Journal Optimalkan Pengelolaan Persediaan Untuk Mengurangi Kerugian: Strategi Menghadapi Permasalahan Persediaan Rusak,” As Syirkah Islam. Econ. Finacial J., vol. Volume 3 N, no. Optimalkan Pengelolaan Persediaan Untuk Mengurangi Kerugian : Strategi Menghadapi Persediaan Rusak, pp. 767–778, 2024, doi: 10.56672/assyirkah.v3i2.200.

[3] A. Asrul et al., “Pemanfaatan Big Data Analytics dalam Proses Manajemen Teknologi untuk Prediksi Permintaan Pasar,” J. Minfo Polgan, vol. 13, no. 2, pp. 2433–2438, 2025, doi: 10.33395/jmp.v13i2.14516.

[4] R. Angela Tiurma and R. Sefina Samosir, “Penerapan Algoritma Regresi Linear untuk Prediksi Penjualan Beberapa Produk Makanan dan Minuman (Studi Kasus: Kantin Berkat),” J. Sains dan Teknol., vol. 12, no. 02, pp. 2775–5576, 2025.

[5] J. Ilmu, T. Informasi, V. No, and J. Hal, “STUDI PERBANDINGAN ALGORITMA MACHINE LEARNING,” vol. 1, no. 1, pp. 22–28, 2026.

[6] I. N. Syahri, M. Martanto, A. R. Dikananda, and M. Mulyawan, “Implementasi Algoritma Regresi Linear Untuk Model Prediksi Penjualan Di Toko Amanda Brownies,” J. Inform. dan Tek. Elektro Terap., vol. 13, no. 2, 2025, doi: 10.23960/jitet.v13i2.6337.

[7] F. Nur Farida, A. Faqih, and S. Eka Permana, “Penerapan Model Prediksi Penjualan Pada Usaha Rumah Makan Menggunakan Algoritma Random Forest,” JATI (Jurnal Mhs. Tek. Inform., vol. 9, no. 4, pp. 5895–5902, 2025, doi: 10.36040/jati.v9i4.13912.

[8] Frira Sesilia, Viktor Handrianus Pranatawijaya, and Ressa Priskila, “Machine Learning untuk Memprediksi Jumlah Penjualan, Stok dan Jumlah Tanam Hasil Pertanian Hidroponik,” KONSTELASI Konvergensi Teknol. dan Sist. Inf., vol. 4, no. 1, pp. 222–233, 2024, doi: 10.24002/konstelasi.v4i1.9055.

[9] Ilham Amansyah, Jamaludin Indra, Euis Nurlaesari, and Ayu Ratna Juwita, “Prediksi Penjualan Kendaraan Menggunakan Regresi Linear:Studi Kasus pada Industri Otomotif di Indonesia,” J. Soc. Sci. Res., vol. Volume 4 Nomor 4, p. Page 1199-1216, 2024.

[10] S. A. Pradana et al., “Penjualan Produk Berbasis Web Pada Umkm Toko,” vol. 4, no. 4, 2026.

[11] H. Wijaya, D. Pramana Hostiadi, and E. Triandini, “Meningkatkan Prediksi Penjualan Retail Xyz Dengan TeknikOptimasi Random Search Pada Model Xgboost,”  Spinter, vol. 1, no. 2, p. 2024, 2024.

[12] R. Hidayat et al., “Implementasi Algoritma Random Forest Regression Untuk Memprediksi Penjualan Produksi di Supermarket,” Simkom, vol. 10, no. 1, pp. 101–109, 2025, doi: 10.51717/simkom.v10i1.703.

[13] M. Hardika, Martono, Arif Rinaldy Dikananda, “Meningkatkan Model Prediksi Penjualan Pada Toko Devanjayaban,” JITET (Jurnal Inform. dan Tek. Elektro Ter., vol. 13, no. 2, pp. 913–921, 2025.

Posted

2026-10-13