scholarly journals Sales Forecasting by Using Exponential Smoothing Method and Trend Method to Optimize Product Sales in PT. Zamrud Bumi Indonesia During the Covid-19 Pandemic

2021 ◽  
Vol 1 (4) ◽  
pp. 59-64
Author(s):  
Virgin Wineka Nirmala ◽  
Dikdik Harjadi ◽  
Robi Awaluddin
Keyword(s):  
Historical Data ◽  
Exponential Smoothing ◽  
Least Square ◽  
Manufacturing Companies ◽  
Trend Model ◽  
Forecasting Error ◽  
Forecasting Method ◽  
Product Sales ◽  
Exponential Smoothing Method ◽  
A Company

Forecasting is important for a company in achieving goals effectively and efficiently. Forecasting aims to determine the next steps to be taken based on historical data. PT. Zamrud Bumi Indonesia is one of the manufacturing companies in the management of agricultural liquid fertilizers with the trademark “Power Bumi”. The purpose of this study is to analyze the sales pattern of Power Bumi products during the covid-19 pandemic and compare the forecasting method that is able to produce the smallest error value in forecasting sales of Power Bumi products PT. Zamrud Bumi Indonesia. This study uses 2 methods, namely exponential smoothing and least square trend model. To calculate the error rate using MAD, MSE and MAPE. The results show that the exponential smoothing alpha 0.9 method has the smallest error value compared to other forecasting methods. In forecasting product sales, the MAD value is 130.329, MSE is 28251.23 and MAPE is 22.00% with a forecast of 627.628 boxes. Although the exponential smoothing a 0.9 method produces a forecast value that is relatively low than other methods. However, the comparison of products sold and forecasting results has a relatively small average difference (MSE). It can be interpreted that the exponential smoothing a 0.9 method is able to suppress the forecasting error value for the 2nd period. After getting the forecasting results, it can be concluded that the number of products sold for the 2nd covid-19 pandemic period will not differ much from the number of sales in the 1st covid-19 pandemic period. If the company applies this scientific forecasting method, then sales will be optimal so that excess or shortage of stock can be avoided and the predetermined sales target can be achieved. In addition, the costs incurred during the production process to sales will be more efficient.

scholarly journals ANALISIS PERAMALAN PENJUALAN PRODUK KERIPIK PISANG KEMASAN BUNGKUS (Studi Kasus : Home Industry Arwana Food Tembilahan)

2017 ◽  
Vol 11 (3) ◽  
pp. 135 ◽  
Author(s):  
Siti Wardah ◽  
Iskandar Iskandar
Keyword(s):  
Data Processing ◽  
Trend Analysis ◽  
Standard Error ◽  
Moving Average ◽  
Exponential Smoothing ◽  
A Value ◽  
Forecasting Method ◽  
Past Data ◽  
Product Sales ◽  
Exponential Smoothing Method

Peramalan adalah metode untuk memperkirakan suatu nilai dimasa depan dengan menggunakan data masa lalu. Penelitian ini dilakukan pada Home Industry Arwana Food. Pada penelitian ini, penulis membahas mengenai analisis peramalan penjualan produk kripik pisang untuk jenis kemasan bungkus. Peramalan yang dilakukan mengggunakan tiga metode yaitu metode Moving Average, metode Exponential Smoothing with Trend dan metode Trend Anayisis dengan membandingkan tingkat kesalahan (error) terkecil, maka metode peramalan yang  terpilih yaitu metode Trend Analysis, dengan nilai MAD sebesar 161,3539, MSE sebesar 55744,16, dan standar error sebesar 242,947. Dari analisis pengolahan data yang telah dilakukan berdasarkan metode peramalan yang terpilih, peramalan penjualan terhadap produk kripik pisang jenis kemasan bungkus adalah sebanyak 1121,424 atau 1122 bungkus/bulan, artinya pihak Home Industry Arwana Food Tembilahan harus menyediakan produk kripik pisang kemasan bungkus adalah sebanyak 1122 bungkus untuk tiap bulannya.      ABSTRACT Forecasting is a method to estimate a value of the future using past data. This research was conducted at the Home Industry Arowana Food. In this study, the authors discuss the analysis of product sales forecasting banana chips for this type of packaging wrap. Forecasting that do use traditional three methods are methods Moving Average, Exponential Smoothing method with Trend and Trend Anayisis method by comparing the level of errors (error) the smallest, then the selected forecasting method is the method of Trend Analysis, with a value of 161.3539 MAD, MSE of 55744 , 16, and the standard error of 242.947. From the analysis of data processing that has been carried out based on the method chosen forecasting, sales forecasting for products banana chips are as many types of packaging wrap 1121.424 or 1 122 packs / month, meaning the Home Industry Arowana Food Tembilahan must provide products banana chips wrapped packs is as much as 1122 wrap for each month.

scholarly journals PERBANDINGAN METODE SINGLE EXPONENTIAL SMOOTHING DAN MOVING AVERAGE PADA PERAMALAN PENJUALAN PRODUK MINYAK GORENG DI PT TUNAS BARU LAMPUNG

2021 ◽  
Vol 6 (2) ◽  
pp. 101
Author(s):  
Niken Chaerunnisa ◽  
Ade Momon
Keyword(s):  
Moving Average ◽  
Exponential Smoothing ◽  
Smoothing Method ◽  
Oil Products ◽  
Cooking Oil ◽  
Forecasting Method ◽  
Double Exponential Smoothing ◽  
Product Sales ◽  
Exponential Smoothing Method ◽  
Single Exponential

PT Tunas Baru Lampung is a company that produces palm cooking oil products under the Rose Brand brand. In product sales, companies sometimes experience ups and downs. Based on the sales data from Rose Brand Cooking Oil, the size of 1 L has fluctuated or in each period it changes and is not always boarding. Even though product sales are one of the important things to be evaluated from time to time on an ongoing basis. To predict future sales, forecasting is done. The forecasting method used is Double Exponential Smoothing and Moving Average. The method of accuracy will be compared using MSE, MAD, and MAPE. The results showed a comparison of the accuracy and the smallest error value in each method. By using the weight values ​​0.1, 0.3, 0.4, 0.5, 0.6, 0.7, and 0.8 on the Single Exponential Smoothing method the weight value is 0.8 or α = 0.8, namely MSE of 250,570,764.80, MAD of 12,922.32 and MAPE of 33.55 Then, using the movement value n = 3 in the Moving Average method has an accuracy of 438,980,942.75 MSE, 18,142.14 MAD, and 41.37 MAPE. After comparing the accuracy of the two methods, the Single Exponential Smoothing method is the best method to predict sales of Rose Brand 1 L Cooking Oil products.

scholarly journals PERAMALAN JUMLAH PENUMPANG PESAWAT DI BANDARA INTERNASIONAL AHMAD YANI DENGAN METODE HOLT WINTER’S EXPONENTIAL SMOOTHING DAN METODE EXPONENTIAL EMOOTHING EVENT BASED

2020 ◽  
Vol 9 (4) ◽  
pp. 535-545
Author(s):  
Sofiana Sofiana ◽  
Suparti Suparti ◽  
Arief Rachman Hakim ◽  
Iut Triutami
Keyword(s):  
Historical Data ◽  
Seasonal Pattern ◽  
Exponential Smoothing ◽  
Smoothing Method ◽  
International Airport ◽  
Special Event ◽  
Special Events ◽  
Forecasting Method ◽  
Event Based ◽  
Exponential Smoothing Method

Forecasting the number of airplane passengers can be a consideration for the airline at Ahmad Yani International Airport related with addition of extra flight. The number of airplane passengers can be influenced by certain seasonal or special events. The seasonal influences can be known through historical data patterns and if there is a seasonal pattern, the Holt Winter’s Exponential Smoothing method can be used. Exponential Smoothing Event Based (ESEB) forecasting method can be use to see the special events that effect the number of airplane passengers at Ahmad Yani International Airport. After compared, the Holt Winter’s Exponential Smoothing method is a better method of forecasting the number of airplane passengers at Ahmad Yani International Airport because it has a smaller error value, namely the MSE value and the MAPE value than the Exponential Smoothing Event Based (ESEB)method. The MAPE and MSE values be produced from the best method each of  5,644139% and 619,998,718 .Keywords : Airplane Passengers, Seasonal Pattern, Special Event, Exponential Smoothing Event Based , Holt Winter’s Exponential Smoothing.

scholarly journals ANALISIS PERAMALAN PENJUALAN AIR MINUM DALAM KEMASAN 240ml PADA PT TRIJAYA TIRTA DARMA (GREAT) DENGAN METODE SINGLE MOVING AVARAGE DAN EXPONENTIAL SMOOTHING

2020 ◽  
Vol 4 (2) ◽  
Author(s):  
Dita Meliana ◽  
◽  
Suharto Suharto ◽  
Putri Endah Suwarni ◽  
◽  
...  
Keyword(s):  
Moving Average ◽  
Exponential Smoothing ◽  
Bottled Water ◽  
A Value ◽  
Forecasting Method ◽  
The Future ◽  
Future Events ◽  
Past Data ◽  
Product Sales ◽  
Exponential Smoothing Method

Abstract Companies engaged in the field of product sales or distribution services, definitely want success in their activities in the future. This shows that every company always strives to continue to be able to develop in its business field in the future. Forecasting is a method for estimating a value in the future by using past data. Forecasting can also be interpreted as an art and science to predict future events. Researchers conducted a study by taking a location in PT Trijaya Tirta Dharma bottled water company. The author discusses forecasting sales of 240ml bottled water using two methods, namely Single Moving Average and Exponential Smoothing. The author compares the smallest error rate, the forecasting method chosen is Exponential Smoothing. For the Exponential Smoothing method, the results obtained using alpha 0.2 are for February of 195,767, March 197905, April 199,527, May 213,661, June 227,287, July 238,295, August 246,234, September 263,600, October 256,923, November 266,857, December 238,762. Then the forecast is MFE 22466,593, MAD 22466.593, MSE 55522225874, MAPE 2%.

scholarly journals Forecasting of Groundwater Tax Revenue Using Single Exponential Smoothing Method

2019 ◽  
Vol 125 ◽  
pp. 23006
Author(s):  
Dyna Marisa Khairina ◽  
Aqib Muaddam ◽  
Septya Maharani ◽  
Heliza Rahmania
Keyword(s):  
Reference Value ◽  
Exponential Smoothing ◽  
Smoothing Method ◽  
Percentage Error ◽  
Tax Revenue ◽  
Regional Office ◽  
Forecasting Error ◽  
The Government ◽  
Exponential Smoothing Method ◽  
Single Exponential

Setting the target of groundwater tax revenues for the next year is an important thing for Kutai Kartanegara Regional Office of Revenue to maximize the regional income and accelerate regional development. Process of setting the target of groundwater tax revenue for the next year still using estimation only and not using a mathematical calculation method that can generate target reference value. If the realization of groundwater tax revenue is not approaching the target, the implementation of development in the Government of Kutai Kartanegara can be disrupted. The mathematical method commonly used to predict revenue value is the Single Exponential Smoothing (SES) method, which uses alpha constant value which is randomly selected for the calculation process. Forecasting of groundwater tax revenue for 2018 using groundwater tax revenue data from 2013 to 2017. Single Exponential Smoothing method using alpha constant value consists of 0.1, 0.2, 0.3, 0.4 and 0.5. The forecasting error value of each alpha value is calculated using the Mean Absolute Percentage Error (MAPE) method. The best result is forecasting using alpha value 0.1 with MAPE error value was 45.868 and the best forecasting value of groundwater tax for 2018 is Rp 443.904.600,7192.

scholarly journals Komparasi Metode Peramalan Jumlah Permintaan Kamar Hotel

2019 ◽  
Vol 9 (2) ◽  
Author(s):  
Rendra Gustriansyah ◽  
Wilza Nadia ◽  
Mitha Sofiana
Keyword(s):  
Moving Average ◽  
Exponential Smoothing ◽  
Standard Type ◽  
The Public ◽  
Forecasting Methods ◽  
Forecasting Method ◽  
Double Exponential ◽  
Double Exponential Smoothing ◽  
Exponential Smoothing Method ◽  
Single Exponential

<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>

scholarly journals Advising an Appropriate Forecasting Method for a Snacks Item (Biscuit) Manufacture Company in Bangladesh

2018 ◽  
Vol 66 (1) ◽  
pp. 55-58
Author(s):  
Nandita Barman ◽  
M Babul Hasan ◽  
Md Nayan Dhali
Keyword(s):  
Time Series ◽  
Inventory Management ◽  
Linear Trend ◽  
Exponential Smoothing ◽  
Demand And Supply ◽  
Forecasting Methods ◽  
Forecasting Method ◽  
Short Term Forecasting ◽  
Exponential Smoothing Method ◽  
Manufacture Company

In this paper, we study the most appropriate short-term forecasting methods for the newly launched biscuit factory produces different types of biscuits. One of them is nut-orange twisted biscuits. As it is a newly launched biscuit factory, it does not use any scientific method to find future demand of their products to produce for the purpose of sales. Having an error free production as well as a good inventory management we try to find an appropriate forecasting method for the sets of data we analyzed for that specific production. Several forecasting methods of time series forecasting such as the Moving Averages, Linear Regression with Time, Exponential Smoothing, Holt‘s Method, Holt-Winter‘s Method etc. can be applied to estimate the demand and supply for these companies. This paper focuses on selecting an appropriate forecasting technique for the newly launched biscuit company. For this, we analyze Exponential Smoothing method as used to time series. We observe from the empirical results of the analysis that if the data has no trend as well as seasonality, Exponential Smoothing Forecasting Method processes as the most appropriate forecasting method for the factory. If the data experiences linear trend in it then Holt’s Forecasting Method processes as the most appropriate forecasting method for the sets of data we analyzed. Dhaka Univ. J. Sci. 66(1): 55-58, 2018 (January)

scholarly journals Pengurangan Efek Bullwhip Pada Vendor Tunggal dan Eceran Multi Di PT. XYZ

2019 ◽  
Vol 2 (4) ◽  
Author(s):  
Meilita Tryana Sembiring ◽  
Feby Sanna Sibarani
Keyword(s):  
Supply Chain ◽  
Moving Average ◽  
Linear Method ◽  
Bullwhip Effect ◽  
Exponential Smoothing ◽  
Glass Bottle ◽  
Forecasting Methods ◽  
Forecasting Method ◽  
The Impact ◽  
A Company

PT. XYZ merupakan perusahaan yang bergerak dalam produksi produk – produk olahan teh. Perusahaan telah memproduksi berbagai varian the yakni bentuk mau pun jenis teh. Objek penelitian ini ialah the dalam kemasan botol kaca dengan ukuran 220 ml. Ukuran the tersebut dipilih berdasarkan akumulasi dari penjualan the tertinggi. Terdapat perbedaan pada prediksi jumlah produksi yang akan dilakukan. Prediksi jumlah produksi dapat dilakukan dengan melakukan peramalan permintaan serta penggunaan metode yang tepat. Rantai pasok yang diteliti pada PT. XYZ terdiri atas Manufaktur (Vendor), Kantor Penjualan, dan Dister. Awalnya peramalan dilakukan pada masing – masing level rantai pasok dengan metode peramalan yang berbeda – beda. Maka, diperlukan penyeragaman metode peramalan pada masing – masing pelaku rantai pasok. Berdasarkan pengujian metode peramalan yang dilakukan yakni metode Linear, Exponential Smoothing, Moving Average, dan Winter’sMethod. Diperoleh bahwa error terkecil terdapat pada metode peramalan Winter’s Method dengan parameter Level sebesar 0,5, Trend sebesar 0,2 dan Seasonal sebesar 0,6. Parameter error yang digunakan ialah MAPE, MAD, dan MSD. Hasil penelitian menunjukkan bahwa penggunaan metode peramalan yang tepat akan mengurangi dampak dari bullwhip effect yang terjadi pada PT. XYZ.   PT. XYZ is a company engaged in the production of processed tea products. The company has produced various variants of tea, that is the shape and type of tea. The object of this research is the 220 ml glass bottle packaging. The size of the tea is chosen based on the accumulation of the highest tea sales. There is a difference in the prediction of the amount of production to be carried out. Prediction of the amount of production can be done by forecasting demand and using appropriate methods. The supply chain studied at PT. XYZ consists of Manufacturing (Vendors), Sales Offices, and Disters. Initially forecasting is done at each level of the supply chain with different forecasting methods. Therefore, uniform forecasting methods are needed for each supply chain actor. Based on testing the forecasting method that is done namely the Linear method, Exponential Smoothing, Moving Average, and Winter’s Method. Obtained that the smallest error is found in the Winter’s Method forecasting method with a Level parameter of 0.5, a Trend of 0.2 and a Seasonal of 0.6. The error parameters used are MAPE, MAD, and MSD. The results showed that the use of appropriate forecasting methods would reduce the impact of the bullwhip effect that occurred at PT. XYZ

scholarly journals Perancangan Aplikasi Peramalan untuk Metode Exponential Smoothing Menggunakan Aplikasi Lazarus (Studi Kasus: Data Konsumsi Listrik Kota Samarinda)

2021 ◽  
pp. 57-70
Author(s):  
Hairi Septiyanor ◽  
Syaripuddin Syaripuddin ◽  
Rito Goejantoro
Keyword(s):  
Golden Section ◽  
Electricity Consumption ◽  
Exponential Smoothing ◽  
Consumption Data ◽  
Forecasting Method ◽  
Double Exponential ◽  
Application Procedure ◽  
Golden Section Method ◽  
Smoothing Parameters ◽  
Exponential Smoothing Method

Exponential smoothing is forecasting method used to predict the future. Lazarus is an open source software based on free pascal compiler. at this research, program Lazarus be design used exponential smoothing method to predict electricity consumption data in Samarinda City from September to November 2018. Purposed of this researched is to determine the procedure of building an exponential smoothing forecasting application and obtained forecasting result using the built application. Procedure of built the application are designed interface, designed properties and filled coding. The optimum smoothing parameters were obtained used the golden section method. Based on the analysis, electricity consumption data in Samarinda City shows a trend pattern, then the forecasting was used double exponential smoohting (DES) method are DES Brown and DES Holt. The best forecasting method for at this researched is DES Holt, because DES Holt method produced MAPE 0,0659% less than DES Brown method produced MAPE 0,0843%.

scholarly journals Peramalan Penjualan dengan Metode Exponential Smoothing (Studi Kasus : Penjualan Bakso Kemasaan/Kiloan Rumah Bakso Bang Ipul)

2019 ◽  
Vol 1 (1) ◽  
pp. 1
Author(s):  
Hisyam Ihsan ◽  
Rahmat Syam ◽  
Fahrul Ahmad
Keyword(s):  
Mean Squared Error ◽  
Mean Absolute Error ◽  
Absolute Error ◽  
Exponential Smoothing ◽  
Trial And Error ◽  
Squared Error ◽  
Forecasting Method ◽  
Operational Activities ◽  
Exponential Smoothing Method ◽  
Single Exponential

Abstrak. Peramalan penjualan memungkinkan sebuah perusahan memilih kebijakan yang optimal untuk membuat keputusan yang sesuai dan mempertahankan efisiensi dari kegiatan operasional. Rumah Bakso Bang Ipul adalah salah satu usaha yang melakukan penjualan yakni penjualan bakso kemasaan/kiloan. Oleh sebab itu,. Rumah Bakso Bang Ipul sangat memerlukan peramalan penjualan untuk meningkatkan keuntungan dan menghindari terjadinya kelebihan atau kekurangan persedian bakso kemasaan/kiloan. Penelitian ini dilakukan peramalan dengan metode exponential smoothing. Adapun parameter atau a yang digunakan dalam meramalkan penjualan adalah a = 0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8, dan 0.9. Singel exponential smoothing melakukan perbandingan dalam menentukan nilai a, dengan mencari nilai a tersebut secara trial and error sampai menemukan a yang memiliki error minimum dengan pencarian menggunakan metode mean absolute error (MAE) dan metode Mean Squaered error (MSE). Sehingga dipilih a = 0.1 dengan nilai MAE = 6.23 dan nilai MSE = 58.32. berdasarkan hasil ini, dengan menggunakan metode singel exponential smoothing dan a =0.1 diperoleh hasil peramalan penjualan bakso bang ipul pada bulan juni 2018 sebanyak 48 kilogram.Kata Kunci: Peramalan, Metode Exponential Smoothing, Metode Singel Exponential SmoothingAbstract. Sales forecasting enables an optimal policy of the company had to make the appropriate decision and maintain the efficiency of operational activities. Rumah Bakso Bang Ipul is a business that sells packaged meatballs. Therefore, Rumah Bakso Bang Ipul is in need of sales forecasting to increase profit and avoid the occurrence or lack of supply of packaged meatballs. This research was conducted by the method of exponential smoothing forecasting. As for parameter or a used predicting sales is a = 0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8, and 0.9. single exponential smoothing do a comparison in determining the value of a, by searching for the value of such a trial and error to find a that has minimum error with search method using the mean absolute error (MAE) and mean squared error (MSE). So that selected a = 0.1 with MAE value = 6.23 and MSE Value = 58.32. Based on  these results, using the method of single exponential smoothing and retrieved results forecasting Rumah Bakso Bang Ipul in July 2018 as much as 48 kilograms.Keywords: Forecasting, Method of exponential smoothing, Method of single exponential smoothing.

Sign in / Sign up

Export Citation Format

Share Document