Best Products with TOPSIS Method and Sales Forecasting with Weighted Moving Average

  • Mohamad Helmi Ilman Fahmi Universitas Stikubank Semarang
  • Imam Husni Al Amin Universitas Stikubank Semarang
Keywords: TOPSIS, WMA, Forecasting, Product Rangking


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.


Download data is not yet available.


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.

How to Cite
M. Fahmi and I. Al Amin, “Best Products with TOPSIS Method and Sales Forecasting with Weighted Moving Average”, JAIC, vol. 4, no. 2, pp. 116-123, Sep. 2020.