Predicted Sales of Industrial Homes Exclusive Anugrah Bean Cake using the Linear Regression Method

Wulan ayu ananda surya; Novriyenni; Lina Arliana Nur Kadim

doi:10.59934/jaiea.v5i1.1572

Authors

Wulan ayu ananda surya STMIK Kaputama
Novriyenni STMIK KAPUTAMA
Lina Arliana Nur Kadim STMIK KAPUTAMA

DOI:

https://doi.org/10.59934/jaiea.v5i1.1572

Keywords:

Sales Prediction, Linear Regression, MSMEs, Web Dashboard

Abstract

UD. Anugrah Exclusive is a peanut cake home industry in Binjai City that faces monthly sales fluctuations so that it has an impact on the management of raw material stocks. This study aims to build a sales prediction model using a simple linear regression method with sales data for the period January 2021–June 2025. Independent variables are in the form of time (months) and dependent variables are in the form of sales (pouch). The model is implemented in a web-based system using Python and MySQL and evaluated using Mean Absolute Percentage Error (MAPE). The results of the study resulted in a regression equation Y = 349.55 + 2.55X with a MAPE accuracy rate of 9.03%, which is in the very good category. The system built can help business owners estimate raw material needs, avoid the risk of overstock or lack of stock, and develop a more appropriate marketing strategy.

Downloads

Download data is not yet available.

References

Muttaqin, Wahyu Wijaya Widiyanto, M. M., Green Ferry Mandias, Stenly Richard Pungus, A. W., Wiranti Kusuma Hapsari, S. A. H., Aslam Fatkhudin,Pasnur, E. F. B., & Mochammad Anshori, Suryani, N. S. (2023). Pengenalan Data Mining (Issue July).

Buaton, R., Anton Sihombing, Fuji Dodo Aritonang, & Clara Rosa Wijaya. (2017). Data Mining Untuk Menentukan Korelasi (Confidence Dan Support)Jurusan Siswa Pada Tingkat Sekolah Menengah Terhadap Indeks Prestasi Kumulatif (Ipk) Di Perguruan Tinggi Sebagai Solusi Tepat Pemilihan Program Studi Di Perguruan Tinggi. Jurnal Sistem Informasi Kaputama (JSIK ), 1(2), 1–13. https://doi.org/10.59697/jsik.v1i2.744

Guntur, M., Santony, J., & Yuhandri, Y. (2018). Prediksi Harga Emas dengan Menggunakan Metode Naïve Bayes dalam Investasi untuk Meminimalisasi Resiko. Jurnal RESTI (Rekayasa Sistem Dan Teknologi Informasi), 2(1), 354-360. https://doi.org/10.29207/resti.v2i1.276

Anggraini, S. D., & Nurcahyo, G. W. (2021). Prediksi Peningkatan Jumlah Pelanggan dengan Simulasi Monte Carlo. Jurnal Informatika Ekonomi Bisnis, 3, 95–100. https://doi.org/10.37034/infeb.v3i3.92

Suhandi, N., Putri, E. A. K., & Agnisa, S. (2018). Analisis Pengaruh Jumlah Penduduk terhadap Jumlah Kemiskinan Menggunakan Metode Regresi Linear di Kota Palembang. Jurnal Ilmiah Informatika Global, 9(2), 77–82. https://doi.org/10.36982/jiig.v9i2.543

Setyoningrum, N. R., Rahimma, P. J., Teknologi, S. T., Tanjungpinang, I., & Tanjungpinang, K. (2022). Implementasi Algoritma Regresi Linear Dalam Sistem Prediksi Pendaftar Mahasiswa Baru Sekolah Tinggi Teknologi Indonesia Tanjungpinang. Prosiding Seminar Nasional Ilmu Sosial Dan Teknologi (SNISTEK), 4, 13–18. https://ejournal.upbatam.ac.id/index.php/prosiding/article/view/5200