Application of Double Exponential Smoothing Method and Dashboard Visualization to Analyze Sales Transaction Data at PT Natural Nusantara Partnership (Case Study: Stockis BG.3005 Muara Enim)

Tasriq Tasriq, Suzi Oktavia Kunang

Abstract


This study discusses the application of the BI roadmap method and the double exponential smoothing method. The BI roadmap method is used in building a business intelligence dashboard to evaluate product sales of PT. Natural Nusantara on Stockist BG.3005 Muara Enim and double exponential smoothing are used to forecast sales at Stockist BG.3005 Muara Enim for the next period. The application of the two methods showed that sales in 2020-2021 decreased, the best-selling product categories were cosmetic and body care, household, health, and agrocomplex products, and also got the 5 most interested products, namely Nasa Toothpaste, Moreskin: Clean & Glow Cream, Grece AntiPerspirant, Quwless : Liquid Hygiene For Man and Shanas : Shampoo 3 in 1. Forecasting on the five products for January 2022, namely, Nasa Toothpaste = 33 items, Moreskin : Clean & Glow Cream = 2 item , Grece AntiPerspirant = 3 items, Quwless : Liquid Hygiene For Man = 2 items, and Shanas : Shampoo 3 in 1 = 4 items.


Keywords


BI roadmap; dashboard; double exponential smoothing; forecasting sales

Full Text:

PDF

References


Achmad, M., Susilawati, D., 2020. Penerapan Business Intelligence untuk Menampilkan Keuntungan pada Data Superstore dengan Menggunakan Metode Olap 2, 9.

Andini, T.D., Auristandi, P., 2016. Peramalan Jumlah Stok Alat Tulis Kantor Di UD ACHMAD JAYA Menggunakan Metode Double Exponential Smoothing 10.

Asmuni, et al. (2020). Implementation of the principle of sale and purchase transactions through MLM in Brand Branch (BC) PT. Herba Penawar Alwahida Indonesia (HPAI) Tanjungbalai. Budapest International Research and Critics Institute-Journal (BIRCI-Journal) Volume 3, No. 4, Page: 3376-3385

Heizer, J., Render, B., Munson, C., 2017. Operations management: sustainability and supply chain management, Twelfth edition. ed. Pearson, Boston.

Huda, A.A.N., Zuhro, B.R., Nuha, C.S.U., Mukhomah, D.D., Nuraini, U., 2021. Pengembangan E-Commerce Sebagai Sarana Penjualan Dan Pembelian Produk Daur Ulang Sampah Plastik 1, 7.

Marlianah, S., Meilani, C., Lina, Q., Widodo, E., 2019. Analisis Double Exponential Smoothing Untuk Meramalkan Utang Pemerintah Indonesia ke Luar Negeri (Studi Kasus : Data Utang Pemerintah Indonesia ke Luar Negeri dari Bulan Januari 2010 sampai April 2019) 8.

Marlizar, et al. (2020). The Role of Market Orientation and Creativity in Affecting the Marketing Performance of Market Traders in Aceh Market Banda Aceh City. Budapest International Research and Critics Institute-Journal (BIRCI-Journal).P. 1114-1127

Nagitec, N., 2020. Pentingnya Teknologi Bagi Perusahaan [WWW Document]. Pentingnya Teknologi Bagi Perusahaan. URL https://nagitec.com/pentingnya-teknologi-bagi-perusahaan/ (accessed 11.18.21).

Romdonny, J., Rosmadi, M. L. N. (2019). Factors Affecting Customer Loyalty in Products. Budapest International Research and Critics Institute-Journal (BIRCI-Journal) Volume 2, No 1, Page: 337-343

Sharda, R., Delen, D., Turban, E., 2018. Business intelligence, analytics, and data science: a managerial perspective, Fourth edition. ed. Pearson, New York, NY.

Steven, K., Hariyanto, S., Arijanto, R., 2021. Penerapan Business Intelligence untuk Menganalisis Data pada PT. Suryaplas Intitama Menggunakan Microsoft Power BI 10.

Utama, R., 2019. Manajemen Operasi.




DOI: https://doi.org/10.33258/birci.v5i3.6208

Article Metrics

Abstract view : 53 times
PDF - 16 times

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

 

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.