scholarly journals Perbandingan metode Double Exponential Smoothing dan Simple Moving Average pada kasus peramalan penjualan

Teknologi ◽  
2021 ◽  
Vol 11 (2) ◽  
pp. 93-100
Author(s):  
Fajar Rohman Hariri ◽  
◽  
Waskita Sari ◽  
Chamdan Mashuri ◽  
◽  
...  

Barokah Building Shop (TB. Barokah) located in Singosari, Malang, East Java is one of the shops that sells building materials. Some of the items being sold are white cement and black cement. The number of cement sales every month is very diverse and fluctuating. Black cement occupies a very high number compared to black cement on the sales chart every month. Likewise with the black cement from the Bosowa brand, white cement from the Gresik brand and the Tiga Roda brand, although demand is small, there is still a movement in the number of sales. The fluctuating amount of demand made the amount of product inventory prepared uncertain, which was influenced by the number of types and brands, so that the product inventory management had difficulty in supplying it. This study aims to predict the amount of cement sold in the following month, as well as to determine the performance between the two double exponential smoothing (DES) methods and the simple moving average (SMA) to forecast cement sales results in TB. Barokah. The SMA method is able and can perform forecasts with stable/constant demand or sales data. Meanwhile, the DES method is able and can provide values to the stratified weights with up to date data. DES is capable of forecasting cement sales each month with an average percentange error (PE) of 0.14%, while the SMA is with an average PE value of 1.35%. Based on the test results using data from TB. Barokah found that the most effective method is DES because it has a smaller PE value than the SMA.

2021 ◽  
Vol 8 (2) ◽  
pp. 117-122
Author(s):  
Sambas Sundana ◽  
Destri Zahra Al Gufronny

Permasalahan yang dihadapi PT. XYZ yaitu kesulitan dalam menentukan jumlah permintaan produk yang harus tersedia untuk periode berikutnya agar tetap dapat memenuhi kebutuhan pelanggan dan tidak menyebabkan penumpukan barang dalam jangka waktu yang lama terutama produk SN 5 ML yang memiliki permintaan jumlah paling besar dari produk lainnya. Tujuan dari penelitian ini yaitu menentukan metode peramalan yang tepat untuk meramalkan jumlah permintaan produk SN 5 ml periode Januari sampai dengan Desember 2021 Metode yang digunakan dalam penelitian ini yaitu metode peramalan Moving Average (MA), Weighted Moving Average (WMA), Single Exponential Smoothing (SES), dan Double Exponential Smoothing (DES). Adapun langkah langkah peramalan yang dilakukan yaitu menentukan tujuan peramalan,memilih unsur apa yang akan diramal, menentukan horizon waktu peramalan (pendek, menengah, atau panjang), memilih tipe model peramalan, mengumpulkan data yang di perlukan untuk melakukan peramalan, memvalidasi dan menerapkan hasil peramalan Berdasarkan perhitungan didapat metode peramalan dengan persentase tingkat kesalahan terkecil dibandingkan dengan metode lainnya yaitu  metode Moving Average (MA) dengan hasil yang diperoleh permintaan produk SN 5 ML pada bulan Januari sampai dengan Desember 2021 yaitu sebanyak 22.844.583 unit


2019 ◽  
Vol 9 (2) ◽  
Author(s):  
Rendra Gustriansyah ◽  
Wilza Nadia ◽  
Mitha Sofiana

<p class="SammaryHeader" align="center"><strong><em>Abstract</em></strong></p><p><em>Hotel is  a type of accommodation that uses most or all of the buildings to provide lodging, dining and drinking services, and other services for the public, which are managed commercially so that each hotel will strive to optimize its functions in order to obtain maximum profits. One such effort is to have the ability to forecast the number of requests for hotel rooms in the coming period. Therefore, this study aims to forecast the number of requests for hotel rooms in the future by using five forecasting methods, namely linear regression, single moving average, double moving average, single exponential smoothing, and double exponential smoothing, as well as to compare forecasting results with these five methods so that the best forecasting method is obtained. The data used in this study is data on the number of requests for standard type rooms from January to November in 2018, which were obtained from the Bestskip hotel in Palembang. The results showed that the single exponential smoothing method was the best forecasting method for data patterns as in this study because it produced the smallest MAPE value of 41.2%.</em></p><p><strong><em>Keywords</em></strong><em>: forecasting, linier regression, moving average, exponential smoothing.</em></p><p align="center"><strong><em>Abstrak</em></strong></p><p><em>Hotel merupakan jenis akomodasi yang mempergunakan sebagian besar atau seluruh bangunan untuk menyediakan jasa penginapan, makan dan minum serta jasa lainnya bagi umum, yang dikelola secara komersial, sehingga setiap hotel akan berupaya untuk mengoptimalkan fungsinya agar memperoleh keuntungan maksimum. Salah satu upaya tersebut adalah memiliki kemampuan untuk meramalkan jumlah permintaan terhadap kamar hotel pada periode mendatang. Oleh karena itu, penelitian ini bertujuan untuk meramalkan jumlah permintaan terhadap kamar hotel di  masa mendatang dengan menggunakan lima metode peramalan, yaitu regresi linier, single moving average, double moving average, single exponential smoothing, dan double exponential smoothing, serta untuk mengetahui perbandingan hasil peramalan dengan kelima metode tersebut sehingga diperoleh metode peramalan terbaik. Adapun data yang digunakan dalam penelitian ini merupakan data jumlah permintaan kamar tipe standar dari bulan Januari hingga November tahun 2018, yang diperoleh dari hotel Bestskip Palembang. Hasil penelitian menunjukkan bahwa metode single exponential smoothing merupakan metode peramalan terbaik untuk pola data seperti pada penelitian ini karena menghasilkan nilai MAPE paling kecil sebesar 41.2%.</em></p><strong><em>Kata kunci</em></strong><em>: peramalan, regeresi linier, moving average, exponential smoothing.</em>


Author(s):  
Nugroho Arif Sudibyo ◽  
Ardymulya Iswardani ◽  
Arif Wicaksono Septyanto ◽  
Tyan Ganang Wicaksono

Tujuan dari penelitian ini adalah untuk mengetahui model peramalan yang paling baik digunakan untuk meramalkan inflasi di Indonesia dengan data inflasi Januari 2015 sampai dengan Mei 2020. Penelitian ini menggunakan beberapa metode peramalan. Berdasarkan metode peramalan yang dilakukan didapatkan hasil peramalan yang paling baik dilihat dari MAPE, MAD dan MSD adalah single exponential smoothing. Selanjutnya, hasil peramalan menunjukkan bahwa tingkat inflasi di Indonesia pada Agustus 2020 sebesar  1,41746%.


2018 ◽  
Vol 2 (1) ◽  
pp. 137
Author(s):  
Yolanda Sari ◽  
Nurlia Fusfita

The revenue of customs and excise is very important in APBN. By making accurate estimation, target of revenue can be better determined. In addition, the revenue of customs and excise is also influenced by many external factors that are difficult to predict therefore a rational approach is needed to estimate revenue. This research uses Double Exponential Smoothing, Ordinary Least Square (OLS) model and Moving Average in predicting customs and excise revenue. Data used in this research is secondary data in time coherent pattern. The data includes import duty, export duty and excise obtained from the Directorate General of Customs and excise (DJBC) in the form of annual and quarterly data. This data starts from 2002 to 2016 with out of sample from 2017 to 2019. Some of these models are compared to each other to obtain the best model, and from the best model is also obtained estimating results in 3 years ahead. This study shows that the Double Exponential Smoothing model is better for predicting import duties compared to OLS and Moving Average models, which are models that have the smallest Sum Square Error (SSE) value. While the export and excise duty is best estimated by using OLS model which is shown with coefficient of determination value (R2)  regression model of export duty is 0.8, while the excise regression model has coefficient of determination of 0.9.Keywords:  Customs Estimation, Double Exponential Smoothing, Ordinary Least Square, Moving Average


2021 ◽  
Vol 7 (1) ◽  
Author(s):  
Suto Sugiraharjo ◽  
Rina Candra Noor Santi

Problems that occur CV. Mustika Rajawali, which deals with laptop sales ranking and forecasting, is how to predict future laptop sales based on previous sales data. Forecasting is very influential in determining the sales target that must be achieved by CV. Mustika Rajawali. The method has not been used in predicting laptop sales at CV. Mustika Rajawali so that consumers' needs can be seen, whether it has met the sales target or not. The products to be developed in this study are laptop sales ranking and forecasting using the TOPSIS method and double exponential smoothing. To calculate the potential sales as accurately as possible, it can be done using data mining techniques using double exponential smoothing, while the TOPSIS method is used for ranking. Ranking of laptop sales using the TOPSIS method obtained the sales order of Asus A490JA laptops, Asus A409JP, Asus A409MA, Asus E402YA, Asus TP203NAH. Prediction of laptop sales at CV. Mustika Rajawali with a value of α = 0.1 to α = 0.9 obtained the smallest MAE value using α = 0.9, which is 178,237,067 so that the prediction of CV sales. Mustika Rajawali with the exponential smoothing method using a value of α = 0.9.


2021 ◽  
Vol 6 (1) ◽  
pp. 17-23
Author(s):  
Mahrus Mahrus ◽  
Tony Yulianto ◽  
Faisol Faisol

Madura merupakan salah satu penghasil garam terbesar di Indonesia, produksi garam di Madura pada musim produksi tahun 2015 mencapai 914.484 ton, dari empat kabupaten di wilayah Madura. Produksi garam tersebut untuk memenuhi kebutuhan garam nasional, untuk memenuhi produksi garam di Madura diperlukan peramalam jumlah produksi agar mendapatkan hasil yang maksimal. Salah satu metode peramalan adalah metode time series. Pada penelitian ini membandingkan hasil peramalan menggunakan metode double exponential smoothing dan moving average, yang menghasilkan bahwa metode double exponential smoothing lebih baik dengan nilai RMSE = 664313,1792 dan MAPE = 5.720599.


2020 ◽  
Vol 9 (3) ◽  
pp. 316-325
Author(s):  
Dilla Retno Deswita ◽  
Abdul Hoyyi ◽  
Tatik Widiharih

The tourism sector is one of the national development priority sectors because it contributes to foreign exchange earnings, the development of business areas, and the absorption of investment and labor. In 2018 the tourism sector will become the second largest foreign exchange earner after oil palm. Foreign exchange contributed by the tourism sector in 2018 was US $ 19.29 billion, an increase of 15.4%. The increase in contributions was driven by an increase in the number of foreign tourist arrivals by 12.58%, domestic tourists by 12.37%, and from investment. Therefore it is necessary to study the forecasting of the number of tourists after seeing the great potential generated from the tourism sector. The data forecast is data on the number of tourists in Central Java, both foreign and domestic data. Both data shows the tendency of an upward trend pattern. So that both data can be analyzed using B-DESmethods (Brown's Double Exponential Smoothing) and B-WEMA (Brown's Weighted Exponential Moving Average)that are optimized with LM (Levenberg-Marquardt). Both methods are able to analyze trend patterned data without assumptions making it easier in the analysis process. In addition, the two methods in previous studies were able to produce a small forecasting accuracy. The MAPE (Mean Absolute Percentage Error) value out sample is used to compare the forecasting results of the two methods. The results of the implementation of LM optimization on the data of the number of domestic tourists obtained the optimal parameter value of the B-DES method is 0.21944386 with MAPE out sample 16.26516% and B-WEMA method is 0.219441 with MAPE out sample 16.26515%. While the data on the number of foreign tourists obtained the optimal parameter value of the B-DES method was 0.26213368 with the MAPE out of the sample 23.61278% and the B-WEMA method was 0.26213367 with the MAPE out the sample 23.61278%. This means that both methods have a good level of forecasting accuracy in the data on the number of domestic tourists and an adequate level of accuracy in the data on the number of foreign tourists. Keywords : B-DES, B-WEMA, Levenberg-Marquardt, Tourists in Central Java


2021 ◽  
Vol 21 (2) ◽  
pp. 91
Author(s):  
Wahyudi Sutopo ◽  
Azizah Hadny Quarrota A'yun ◽  
Hanif Ardian ◽  
Maulidina Khairannisa Nunuh ◽  
Sherlinta Immanuella ◽  
...  

Pada era digital saat ini, banyak sekali industri yang mengalami dampak dari digitalisasi, salah satunya adalah industri surat kabar (koran). Adanya digitalisasi menyebabkan permintaan koran semakin fluktuatif dan sulit diprediksi. Hal ini juga menyebabkan tingkat retur atau pengembalian koran dari agen-agen yang cukup tinggi dan tentu saja akan memberikan kerugian yang cukup besar bagi perusahaan. Untuk itu, perlu dilakukan penentuan métode peramalan jumlah permintaan koran yang memiliki tingkat kesalahan terkecil sehingga dapat membantu perusahaan mengurangi kerugian akibat retur koran. Penelitian ini menghitung peramalan permintaan menggunakan beberapa metode antara lain trend line analysis, double exponential smoothing, dan two months moving average. Selain itu, penelitian ini juga membandingkan hasil peramalannya dengan penelitian terdahulu yang menggunakan metode ARIMA. Pemilihan metode peramalan yang terbaik dilakukan dengan membandingkan tingkat kesalahan (MAPE) dari tiap-tiap metode kemudian dipilih metode dengan tingkat kesalahan terkecil. Berdasarkan perbandingan yang dilakukan, dapat diketahui bahwa metode peramalan yang memiliki tingkat kesalahan terkecil adalah metode trend line analysis dengan nilai MAPE sebesar 2,94%. Oleh karena itu, metode peramalan yang terbaik untuk melakukan peramalan permintaan jumlah koran di Kota Surakarta adalah metode trend line analysis.


2016 ◽  
Vol 2 (1) ◽  
pp. 46 ◽  
Author(s):  
Faisol Faisol ◽  
Sitti Aisah

Time series model is the model used to predict the future using past data, one example of a time series model is exponential smoothing. Exponential smoothing method is a repair procedure performed continuously at forecasting the most recent data. In this study the exponential smoothing method is applied to predict the number of claims in the health BPJS Pamekasan using data from the period January 2014 to December 2015, the measures used to obtain the output of this research there are four stages, namely 1) the identification of data, 2) Modeling, 3) forecasting, 4) Evaluation of forecasting results with RMSE and MAPE. Based on the research methodology, the result for the period 25 = 833.828, the 26 = 800.256, period 27 = 766.684, a period of 28 = 733.113, period 29 = 699.541, and the period of 30 = 655, 970. Value for RMSE = 98.865 and MAPE = 7.002, In this case the moving average method is also used to compare the results of forecasting with double exponential smoothing method. Forecasting results for the period 25 = 899.208, the 26 = 885, 792, 27 = 872.375 period, a period of 28 = 858.958, period 29 = 845.542, and the period of 30 = 832.125. Value for RMSE = 101.131 and MAPE = 7.756. Both methods together - both have very good performance because the value of MAPE is below 10%, but the method of exponential smoothing has a value of RMSE and MAPE are smaller than the moving average method.


Sign in / Sign up

Export Citation Format

Share Document