Implementation of Forecasting in Determining Sales of Goods at Wiwi Stores Using the Holts Method
Abstract
The Wiwi shop, which is located on Jalan Tanjung Jati Pekanbaru, is one of the MSME businesses that sells daily necessities such as oil, sugar, salt, etc. The storage of sales transactions at this Wiwi store is still manual to determine the inventory of goods every month, still using estimates. Then the problem arises in the difficulty of determining the inventory of goods so that there is an excess and shortage of inventory that makes a loss for the shop owner. From these problems, an application will be built by implementing forecasting or forecasting an application using the Hypertext Preprocessor (PHP) programming language and MySQL as a database to process sales data in determining the amount of inventory that must be provided. The forecasting method used is the Holts method. The results of forecasting the amount of inventory from this method will be tested using the Mean Square Error (MSE) method to get an error from the method, so that it can be taken into consideration for the Wiwi store in providing supplies. Based on the results of testing with black box testing, the system functions run 100% successfully as expected. Testing the Holts method by using the Mean Square Error showed that the Holts method with low variation got the number of recommendations, namely 682 and the Holts method with variations got the number of recommendations, namely 365. So from these results it was found that the low variation value is more recommended.References
Achmad Solichin. (2016). Pemrograman Web dengan PHP dan MySQL. Jakarta: Budi Luhur.
Edhy Sutanta. (2004). Sistem Basis Data. Yogyakarta: Graha Ilmu.
Han, J., & Kamber, M. (2006). Data Mining Concepts and Techniques. San Fransisco: Morgan Kauffman Publisher.
Heizer, J. & Render, B. (2014). Operations Management, Eleventh Edition. New Jersey: Pearson Education, Inc.
Kusrini & Emha Taufiq Lithfi. (2009). Algoritma Data Mining. Yogyakarta: ANDI.
Luqman Affandi, Dimas Wahyu Wibowo, Indra Wahyu Setya
Nugraha. (2015). Pengembangan Sistem Peramalan Penjualan Galon Menggunakan Metode Single Exponential Smoothing. Politeknik Negeri Malang.
Reyhan Dzickrillah Laksmana, Edy Santoso, Bayu Rahayudi (2019). Prediksi Penjualan Roti Menggunakan Metode Exponential Smoothing (Studi Kasus: Harum Bakery). Universitas Brawijaya.
Salman Alfarisi. (2016). Sistem Prediksi Penjualan Gamis Toko Qitaz Menggunakan Metode Single Exponential Smoothing. Universitas Indraprasta PGRI.
Slamet Riyadi. (2015). Aplikasi Peramalan Penjualan Obat Menggunakan Metode Pemulusan (Studi Kasus: Instalasi Farmasi RSUD dr Murjani). STMIK AMIKOM Yogyakarta.
Published
Issue
Section
License
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.