Analysis forecasting sales of tart products

Dewi Cahyani Pangestuti, Raulian Franciskus Pasaribu

Abstract


Sales forecasting is an effective and efficient tool for organizations or business people to predict the products that will be produced. Sales forecasting is a method that uses historical data as a reference to get a picture of future value. This research was conducted at the Kuwenak Shop, which produces in the food sector, to be precise, cakes or birthday cakes. On the occasion of this research, there are three forecasting methods used, including moving average, exponential smoothing, and linear trend, taking into account the smallest error rate or error in each method. The linear trend forecasting method is the best choice because it has a low error rate. Specifically, the MAD error value is 2.4, the MSE error is 6.6, the MAPE error is 5.9% and the standard error is 9.3. From the data management on the selected method, the linear trend sales forecasting method for cake products predicts that for the next week, Kuwenak Shop s can produce 40.6 or 41 products. This means that Kuwenak Shop can provide 41 tarts the following week or even each week.

Keywords


Sales forecasting; moving average method; exponential smoothing method; linear trend method

Full Text:

PDF

References


Ajeng, S. (2011). Pengadaan Persediaan Buah Durian Di Rumah Durian Harum Bintaro , Jakarta. Universitas Islam Negeri, 1–178.

Assauri, S. (1984). Teknik Dan Metode Peramalan (1st ed.). Lembaga Penerbit Fakultas Ekonomi Universitas Indonesia: Jakarta.

Babenko, V. (2017). Development of the model of minimax adaptive management of innovative processes at an enterprise with consideration of risks. Eastern-European Journal of Enterprise Technologies, 5(4), 49–56. https://doi.org/10.15587/1729-4061.2017.112076

Binus, U. (2018). Mengukur Error dalam Forecasting. 18 Desember.

Hartono, A., Dwijana, D., & Headiwidjojo, W. (2015). Perbandingan Metode single Exponential Smoothing Dan Metode Exponential Smoothing Adjusted For Trend (Holt’s Method) Untuk Meramalkan Penjualan. Studi Kasus: Toko Onderdil Mobil “Prodi, Purwodadi.†Jurnal EKSIS, 5(1), 8–18.

Lestari, N., Lestari, N., & Wahyuningsih, N. (2012). Peramalan Kunjungan Wisata Dengan Pendekatan Model Sarima (Studi kasus : Kusuma Agrowisata). In Jurnal Sains dan Seni ITS (Vol. 1, Issue 1). https://doi.org/10.12962/j23373520.v1i1.1010

Marwanto, A. (2015). Marketing Sukses (1st ed.). Kobis-Yogya.

Maulana, M. S. R. (2017). Analisis Ramalan Penjualan dan Pengendalian Persediaan Bahan Baku Pada PT. INDAC INT L. Ekp, 13(3), 1576–1580.

Mulyadi. (2009). Akuntansi Biaya (1st ed.). Sekolah Tinggi Ilmu Manajemen YKPK: Padang.

Nurhidayah, A., Yuliniar, Y., & Pangestuti, D. C. (2021). Pengaruh Brand Image Dan Brand Trust Terhadap Loyalitas Pelanggan Menggunakan E-Wallet Gopay. Prosiding BIEMA (Business Management, Economic, and Accounting National Seminar), 2.

Nurlifa, A., & Kusumadewi, S. (2017). Sistem Peramalan Jumlah Penjualan Menggunakan Metode Moving Average Pada Rumah Jilbab Zaky. INOVTEK Polbeng - Seri Informatika, 2(1), 18. https://doi.org/10.35314/isi.v2i1.112

Pangestuti, D. C. (2018). Anggaran Perusahaan (A. A. Mahardika (ed.); 1st ed.). Kresna Insan Bina Insan Prima: Jakarta.

Raharja, A., Angraeni, W., & Aulia Vinarti, R. (2017). Penerapan Metode Exponential Smoothing Untuk Peramalan Penggunaan Waktu Telepon Di Pt.Telkomsel Divre3 Surabaya. Jurnal Sistem Informasi (SISFO), 59, 73.

Susanti, D. S., Sukmawaty, Y., & Salam, N. (2019). Analisis Regresi Dan Korelasi - Dewi Sri Susanti, Yuana Sukmawaty, Nur Salam - Google Buku (1st ed.). CV IRDH : Malang.

Wardah, S., & Iskandar, I. (2016). menurut Tjiptono Darmadji (2006: 73), dalam Penawaran Umum (Public Issue) Penawaran umum atau sering pula disebut go public. Jurnal Teknik Industri, 11(3), 135.

Yanti, N. P. L. P., Tuningrat, I. . M., & Wiranatha, A. A. P. A. S. (2016). Analisis Peramalan Penjualan Produk Kecap Pada Perusahaan Kecap Manalagi Denpasar Bali. Jurnal Rekayasa Dan Manajemen Agroindustri, 4(1), 72–81.




DOI: https://doi.org/10.30872/jinv.v17i4.10180

Refbacks

  • There are currently no refbacks.


Copyright (c) 2021 Dewi Cahyani Pangestuti, Raulian Franciskus Pasaribu

Crossref logo 

Editorial Address

INOVASI: Jurnal ekonomi, keuangan dan manajemen
Faculty of Economics and Business, Mulawarman University
Jl. Tanah Grogot No.1 Samarinda Kalimantan Timur 75119
Email: jakt.feb.unmul@gmail.com

StatCounter: INOVASI: Jurnal ekonomi, keuangan dan manajemen