Implementation of the Least Square Method in Website-Based Product Sales Prediction
DOI:
https://doi.org/10.35335/jict.v16i2.270Keywords:
Forecasting, Inventory Management, Least Squares Method, Sales Prediction, Web-Based SystemAbstract
Sales play a crucial role in determining the continuity and growth of a company. PT. Medan Bajaindo, which operates in the steel product sales sector, requires a system capable of accurately predicting future sales to support decision-making and inventory planning. Currently, sales data analysis is still conducted manually, which is inefficient and prone to errors in forecasting. This research aims to design and develop a web-based sales prediction system by applying the Least Square method. The Least Square method is chosen because it can predict data trends based on historical sales patterns with relatively low error rates. The system is developed using web-based programming languages and supported by a database for storing sales data. The testing results show that the developed system can automatically calculate predictions and present sales trend information more quickly, accurately, and structurally compared to the manual method. With this system, the company’s management can more easily plan sales strategies and stock procurement in a timely manner.
References
Fahrudin, T. M., Ambariawan, R. P., & Kamisutara, M. (2020). Demand forecasting of the automobile sales using Least Square, Single Exponential Smoothing and Double Exponential Smoothing. Indonesian Journal of Business Science, 4(2), 122-130. https://doi.org/10.9744/ijbs.4.2.122-130
Hatta, M., & Fitri, A. F. (2020). Sistem prediksi persediaan stok darah dengan metode Least Square pada Unit Transfusi Darah studi kasus PMI Kota Cirebon. Jurnal Ilmiah Ilmu Komputer Fakultas Ilmu Komputer Universitas Al Asyariah Mandar, 6(1), 41-45.
Hermiati, R., Asnawati, A., & Kanedi, I. (2021). Pembuatan e-commerce pada Raja Komputer menggunakan bahasa pemrograman PHP dan database MySQL. Jurnal Media Infotama, 17(1), 54-66. https://doi.org/10.37676/jmi.v17i1.131
Janis, J. W., Mamahit, D. J., Sugiarso, B. A., Rumagit, A. M., & Elektro, T. (2020). Rancang bangun aplikasi online sistem pemesanan jasa tukang bangunan berbasis lokasi. Jurnal Teknik Informatika, 15(1), 1-12. https://doi.org/10.35793/jti.15.1.2020.29023
Larasati Amalia, E., Yunhasnawa, Y., & Rahmatanti, A. R. (2022). Sistem prediksi penjualan frozen food dengan metode Monte Carlo (Studi kasus: Supermama Frozen Food). Jurnal Buana Informatika, 13(2), 136-145. https://doi.org/10.24002/jbi.v13i02.6496
Lestari, V. A., Ananta, A. Y., & Basudewa, P. (2019). Sistem informasi prediksi persediaan obat di Apotek Naylun Farma menggunakan Holt-Winters. Jurnal Informatika Polinema, 9(2), 229-236.
Muhadzdzab, H., Asfi, M., & Putri, T. E. (2020). Sistem prediksi untuk menentukan jumlah pendaftaran mahasiswa baru pada Universitas Catur Insan Cendekia menggunakan metode Least Square. Jurnal Informatika Universitas Pamulang, 5(3), 350.
Nasution, N., Sitompul, D. R., & Walhidayat. (2023). Application of Sales Forecasting using the Least Square method in web-based information systems. Jurnal Teknologi dan Open Source, 6(1), 11-22. https://doi.org/10.36378/jtos.v6i1.2580
Prasetia, A., Suriati, S., & Usman, A. (2022). Implementasi metode Trend Moment untuk prediksi data penjualan sparepart sepeda motor. Jurnal Sistem Informasi dan Ilmu Komputer Prima (JUSIKOM PRIMA), 5(2), 73-79. https://doi.org/10.34012/jurnalsisteminformasidanilmukomputer.v5i2.2354
Putri, A. G. A., Lestanti, S., & Chulkamdi, M. T. (2023). Sistem forecasting penjualan sepeda motor dengan menerapkan metode Least Square. JATI (Jurnal Mahasiswa Teknik Informatika), 7(2), 1185-1190.
Raufun, L., Liwang, R., & Dewi, R. S. (2020). Sistem prediksi harga pangan Kota Baubau menggunakan metode Least Square. Jurnal Informatika, 9(1), 58-67.
Ridwan, A., Faisol, A., & Wahyuni, F. S. (2020). Penerapan metode Least Square untuk prediksi penjualan berbasis web pada Doni Sport Malang. JATI (Jurnal Mahasiswa Teknik Informatika), 4(1), 129-136.
Wijaya, A., & Kunang, S. O. (2022). Implementation of the Least Square method in forecasting system prices of staple materials in traditional market units of Palembang City. BIRCI Journal, 5(3). https://doi.org/10.33258/birci.v5i3.6212
Ananta, A. Y., & Basudewa, P. (2023). Sistem informasi prediksi persediaan obat di Apotek Naylun Farma menggunakan Holt-Winters. Jurnal Informatika Polinema, 9(2).
Candra, R. (2021). Using the Least Square Method for estimation number of new students. International Journal of Advanced Research Science and Engineering Technology, 8(12).
Saputri, W. C. F., Khusnuliawati, H., & Fitriyadi, F. (2024). Pembangunan sistem forecasting berbasis web menggunakan metode Holt-Winters Exponential Smoothing untuk meningkatkan akurasi kebutuhan jumlah panen bunga potong (Studi Kasus: Shenda Florist Surabaya). JIMSTEK, 6(1), 1-10.
Dzikria, I., Narulita, L. F., Hermanto, A., & Kusnanto, G. (2022). ISO 15489 Attributes prioritization in electronic document management system of the first level healthcare facilities. In Seventh International Conference on Informatics and Computing (ICIC) (pp. 1-6). IEEE. https://doi.org/10.1109/ICIC56845.2022.10006980
Ozhegov, E. M., & Teterina, D. (2018). Ensemble method for censored demand prediction. arXiv. https://arxiv.org/abs/1810.09166
Li, C., Cheang, B., Luo, Z., & Lim, A. (2020). An exponential factorization machine with percentage error minimization to retail sales forecasting. arXiv. https://arxiv.org/abs/2009.10619
Roque, L., Fernandes, C. A. C., & Silva, T. (2019). Optimal combination forecasts on retail multi-dimensional sales data. arXiv. https://arxiv.org/abs/1903.09478
Jurnal ICT : Information and Communication Technologies is licensed under a 