Implementation of Web Based Motorcycle Sales Prediction System Using the Least Squares Method

Syamsudin Hidayatullah; Kemal Farouq Mauladi; M Hasan Wahyudi

doi:10.59934/jaiea.v5i2.1835

Authors

Syamsudin Hidayatullah Universitas Islam Lamongan
Kemal Farouq Mauladi Universitas Islam Lamongan
M Hasan Wahyudi Universitas Islam Lamongan

DOI:

https://doi.org/10.59934/jaiea.v5i2.1835

Keywords:

Prediction, Least Squares Method, Web Based System, Mape

Abstract

The development of information technology has brought significant changes in business data management, including in the automotive industry. Dony Jaya Motor, as one of the motorcycle dealers, faces challenges in predicting sales, particularly in balancing stock availability with market demand. This study aims to develop a web-based motorcycle sales prediction system using the Least Squares method due to its ability to identify linear trend patterns from historical data, producing accurate and measurable sales projections. The data used cover motorcycle sales from May 2024 to April 2025. The implementation results show that the Least Squares method provides good predictive accuracy, with the average Mean Absolute Percentage Error (MAPE) value below 10%, indicating a very low prediction error rate. For example, for the Honda Beat 2015 type, the predicted sales for May 2025 were 5.67 units compared to the actual 6 units, resulting in a MAPE value of 4.67%. The developed system includes features for data input, graphical visualization, and real-time prediction reporting. The application of the Least Squares method in this web-based system has proven to assist management in stock planning, improve decision-making processes, and enhance overall operational efficiency and effectiveness within the company.

Downloads

Download data is not yet available.

References

T. Y. Tulsi, A. Erianda, and R. Afyenni, “Implementasi Metode Least Square untuk Peramalan Persediaan Barang Pada Sistem Inventori CV. Tre Jaya Perkasa,” JITSI : Jurnal Ilmiah Teknologi Sistem Informasi, vol. 3, no. 4, pp. 137–142, Dec. 2022, doi: 10.62527/jitsi.3.4.100.

G. A. F. Seber and A. J. Lee, Linear Regression Analysis. Wiley, 2022.

N. Fuad and D. Aprianto, “Implementasi Algoritma Least Square Untuk Pembuatan Toko Mebel,” Jurnal SPIRIT, vol. XVIII, no. 1, pp. 1–5, 2023.

N. Nasution, D. R. Sitompul, and W. Walhidayat, “Application Of Sales Forecasting Using The Least Square Method In Web-Based Information Systems,” Jurnal Teknologi Dan Open Source, vol. 6, no. 1, pp. 11–22, 2023, doi: https://doi.org/10.36378/jtos.v6i1.2580.

S. Mejía and J. Aguilar, “A demand forecasting system of product categories defined by their time series using a hybrid approach of ensemble learning with feature engineering,” Computing, vol. 106, no. 12, pp. 3945–3965, 2024, doi: https://doi.org/10.1007/s00607-024-01320-y.

S. Mulyani, D. Hayati, and A. N. Sari, “Analisis Metode Peramalan (Forecasting) Penjualan Sepeda Motor Honda Dalam Menyusun Anggara Penjualan Pada PT Trio Motor Martadinata Banjarmasin,” Jurnal Ekonomi Dan Bisnis, vol. 14, no. 1, pp. 178–189, 2021.

A. Ridwan, A. Faisol, and F. S. Wahyuni, “Penerapan Metode Least Square Untuk Prediksi Penjualan Berbasis Web Pada Doni Sport Malang,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 4, no. 1, pp. 129–136, 2020, doi: https://doi.org/10.36040/jati.v4i1.2745.

L. A. Herlambang and W. Sugianto, “Analisis Peramalan Penjualan Sepeda Dan Motor Listrik Di PT XYZ,” Jurnal Comasie, vol. 4, no. 1, pp. 130–138, 2021, [Online]. Available: http://ejournal.upbatam.ac.id/index.php/comasiejournal

R. J. Hyndman and G. Athanasopoulos, Forecasting: Principles and Practice (3rd edition). OTexts / Monash University, 2021.

A. Aimmatul Khazanah, “Performa kenaikan dan prediksi penjualan motor pada PT Cikande Motor Cabang Dealer Selikur,” Kaze Multidisiplin, vol. 1, 2024.

K. Agisni, N. A. Yuliana, and A. P. Dewi, “Analisis Peramalan Penjualan Dengan Metode Least Square Pada Azzikra Mebel,” Jurnal Tagalaya Pengabdian Kepada Masyarakat, vol. 8, no. 3, pp. 309–318, 2024, doi: https://doi.org/10.71315/jtpkm.v1i3.77.

P.-H. Lu, J.-L. Keng, F.-M. Tsai, P.-H. Lu, and C.-Y. Kuo, “An Apriori Algorithm-Based Association Rule Analysis to Identify Acupoint Combinations for Treating Diabetic Gastroparesis,” Evidence-Based Complementary and Alternative Medicine, vol. 2021, pp. 1–9, Mar. 2021, doi: 10.1155/2021/6649331.

I. H. Susilowati, “Peramalan Penjualan Mobil Pada PT Toyota Astra Motor Indonesia Dengan Metode Trend Semi Average Dan Metode Least Square,” JIMF (Jurnal Ilmiah Manajemen Forkamma), vol. 6, no. 1, p. 28, 2022, doi: https://doi.org/10.32493/frkm.v6i1.23893.

R. Dewantara and J. Giovanni, “Analisis Peramalan Item Penjualan dalam Optimalisasi Stok Menggunakan Metode Least Square,” Jurnal Krisnadana, vol. 3, no. 1, pp. 59–66, 2023, doi: https://doi.org/10.58982/krisnadana.v3i1.504.

R. Nasution, “Pengembangan Sistem Prediksi Kegagalan Mesin Berbasis AI untuk Industri Manufaktur Development of an AI-Based Machine Failure Prediction System for the Manufacturing Industry,” JURNAL TERAPAN ILMU PENGETAHUAN, pp. 47–51, 2024, [Online]. Available: https://journal-upmi.com/index.php/jtip

A. Gaum Amanda Putri, S. Lestanti, and M. T. Chulkamdi, “Sistem Forecasting Penjualan Sepeda Motor Dengan Menerapkan Metode Least Square,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 7, no. 2, pp. 1185–1190, 2023, doi: https://doi.org/10.36040/jati.v7i2.6732.

R. Maulidya, R. Rizaldi, and E. Saputra, “Metode Least Square Seabagai Prediksi Penjualan Sembako di Toko Suryono,” J-Com (Journal of Computer), vol. 1, no. 3, pp. 213–218, 2021, doi: https://doi.org/10.33330/j-com.v1i3.1388.

S. Makin, N. Supriana, and M. A. Kurniawan, “Model Peramalan Jumlah Penjualan Sparepart dengan Algoritma Forecasting Time Series: Studi Kasus di PT. XYZ,” Jurnal Pendidikan Dan Teknologi Indonesia, vol. 3, no. 6, pp. 265–271, 2023, doi: https://doi.org/10.52436/1.jpti.306.

A. Hidayatullah, “Metode Least Square Untuk Memprediksi Jumlah Penjualan Sepeda Motor Honda Pada PT. Daya Motor Majalengka,” Jurnal STIKOM Politeknik Cirebon, vol. 1, no. 1, pp. 373–380, 2020.