Best Products with TOPSIS Method and Sales Forecasting with Weighted Moving Average
Abstract
In a company engaged in the sale and purchase of products can not be separated from the calculation of profit or loss that is the main factor for the company's progress. However, in certain companies such as minimarkets and convenience stores, it is not easy to record company profits and losses. This of course requires a system that can help companies in determining sales strategies or at least a picture of sales in the future. Things that can be done to help these problems is to create a system that forecast sales or forecasting. One method that can be used to make sales forecasts is the wighted moving average method. However, due to the large number of products sold in minimarkets with different values, of course there must be other methods that can filter products so that forecasting can be more effective. One way to handle this is to use a product ranking system with the Techinique for Order Preference by Similarity to Ideal Solution (TOPSIS) method. The topsis method was chosen because the calculation is very detailed and structured, so that it can maximize the ranking value. By combining sales forecasts and product ranking is expected to create a system that can help companies in determining sales strategies in the future. Later this system is combined with the point of sale system to get accurate sales results. This system is designed using PHP and Javascript programming languages, then the database is stored in MySQL.
Downloads
References
P. Wang and D. Xie, “Activation of a modern industry,” J. Dev. Econ., vol. 74, no. 2, pp. 393–410, 2004, doi: 10.1016/j.jdeveco.2003.06.005.
J. Mysiak, C. Giupponi, and P. Rosato, “Towards the development of a decision support system for water resource management,” Environ. Model. Softw., vol. 20, no. 2, pp. 203–214, 2005, doi: 10.1016/j.envsoft.2003.12.019.
P. C. Chang and Y. W. Wang, “Fuzzy Delphi and back-propagation model for sales forecasting in PCB industry,” Expert Syst. Appl., vol. 30, no. 4, pp. 715–726, 2006, doi: 10.1016/j.eswa.2005.07.031.
R. Rahim et al., “TOPSIS Method Application for Decision Support System in Internal Control for Selecting Best Employees,” J. Phys. Conf. Ser., vol. 1028, no. 1, 2018, doi: 10.1088/1742-6596/1028/1/012052.
M. Zeydan and C. Çolpan, “A new decision support system for performance measurement using combined fuzzy TOPSIS/DEA approach,” Int. J. Prod. Res., vol. 47, no. 15, pp. 4327–4349, 2009, doi: 10.1080/00207540802662870.
G. R. Jahanshahloo, F. H. Lotfi, and M. Izadikhah, “An algorithmic method to extend TOPSIS for decision-making problems with interval data,” Appl. Math. Comput., vol. 175, no. 2, pp. 1375–1384, 2006, doi: 10.1016/j.amc.2005.08.048.
S. Opricovic and G. H. Tzeng, “Compromise solution by MCDM methods: A comparative analysis of VIKOR and TOPSIS,” Eur. J. Oper. Res., vol. 156, no. 2, pp. 445–455, 2004, doi: 10.1016/S0377-2217(03)00020-1.
D. E. Kurniawan, ‘Sistem Pendukung Keputusan Pemilihan Pemasok Bahan Baku Menggunakan Metode Technique for Order Preference by Similarity to Ideal Solution’, J. Integr., vol. 8, no. 1, pp. 56–60, Apr. 2016.
D. E. Kurniawan, ‘Pemilihan Wisata Menggunakan Technique for Order Preference By Similarity To Ideal Solution (Topsis) Dengan Visualisasi Lokasi Objek’, Klik - Kumpul. J. Ilmu Komput., vol. 5, no. 1, p. 75, 2018.
B. C. Jiang, C. C. Wang, and H. C. Liu, “Liquid crystal display surface uniformity defect inspection using analysis of variance and exponentially weighted moving average techniques,” Int. J. Prod. Res., vol. 43, no. 1, pp. 67–80, 2005, doi: 10.1080/00207540412331285832.
I. H. Al Amin, F. Widiyanto, “In Vulcanizing Rubber Sales Forecasting System With Weighted Moving Aaverage And Quadratic Method at PT. Bernike Semarang,” Universitas Stikubank Semarang, 2019.
S. S. Sundari, Susanto, and W. Revianti, “Sistem Peramalan Persediaan Barang Dengan Weight Moving Average Di Toko The Kids 24,” Konf. Nas. Sist. dan Inform., pp. 598–603, 2015.
P. Chris, “K-th Moving , Weighted and Exponential Moving Average for Time Series Forecasting Models,” vol. 3, no. 3, pp. 406–416, 2010.
Copyright (c) 2020 Mohamad Helmi Ilman Fahmi, Imam Husni Al Amin
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) ) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).