Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : International Journal of Engineering, Science and Information Technology

Sales Forecasting by Using Exponential Smoothing Method and Trend Method to Optimize Product Sales in PT. Zamrud Bumi Indonesia During the Covid-19 Pandemic Virgin Wineka Nirmala; Dikdik Harjadi; Robi Awaluddin
International Journal of Engineering, Science and Information Technology Vol 1, No 4 (2021)
Publisher : Master Program of Information Technology, Universitas Malikussaleh, Aceh Utara, Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (744.847 KB) | DOI: 10.52088/ijesty.v1i4.169

Abstract

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.
Co-Authors A.A. Ketut Agung Cahyawan W Abdul Aziz Agustian, Agung Gumelar Agustiani, Intan Aini Nursafaah Alawiyah, Widi Suci Amir Hamzah Anastasya, Tyas Fitria Arief Surya Lesmana Awalia, Nida Putri Ayu Siti Nurhasanah Bakar, Azizi Abu Dadang Suhardi Dede Djuniardi Dede Djuniardi Dewi Fatmasari Dikha Anugrah Diki Sagita Egi Saripudin Pratama Erga Yuhandra Eti Rusmiati Fahmi Zakariya Al Anshori Fahmi1993 Fahmi Zakariya Al Anshori Fany Oktaviani Fatmasari, Dewi Fauzi Abdillah, Fauzi Firdaus, Galih Adam Gilang Kripsiyadi Praramdana Gios Adhyaksa Haris Budiman Hendriyadi, Resnu Hidayat, Abas Ilham Akbar Indriarto, Enricho Dwi Indriyani Indriyani Indriyani Indriyani Iqbal Arraniri Irfan Aprilianto Suhara Jaelani Jaelani Juwita Juwita Karmela, Lili Komarudin*, Munir Nur Komarudin, Munir Nur Lia Kurniasih Lili Karmela F. Lili Karmela Fitriani Lisa Lismawati Mardiani, Teti Marlina Agustia Martiani, Evita Muhamad Akmal Sayidul Fadillah Muhammad Iftor Nawawi Munir Nur Komarudin Nanda Fajarwati Neng Evi Kartika Ningsih, Arum Ningsih, Liya Nok Ayu Permata Sari Novi Satria Pradja Nugraha . Nugraha Nugraha Nur Ayisiyah Nurdin Nurdin Nurdiyansyah, Erik Diyan Pasha, Riska Ayu Pina, Pina Pupu Saeful Rahmat, Pupu Saeful Purnama, Dendi Ramdani Ramdani Resky Fauzi Rifa’i, Iman Jalaludin Robi Awaluddin Roni Nursyamsu Salsha Billa Azzhara Azzhara Sifa Nurfatimah Silvia Hendriyani Siti Nurjanah Supriatna, Odang Suwari Akhmaddhian Syakiroh Vigory Gloriman Manalu Virgin Wineka Nirmala Wachjuni Wely Hadi Gunawan Wijaya, Tri Sukma Wijaya Wu, Mingchang Yasir Maulana Yuliana Fitroh