Sales and Inventory Prediction with the EOQ Method based on Single Exponential Smoothing Forecasting

Authors

  • Alfin Andika Putra Universitas Putra Indonesia YPTK Padang
  • Vicky Ariandi Universitas Putra Indonesia YPTK Padang
  • Pradani Ayu Widya Purnama Universitas Putra Indonesia YPTK Padang

DOI:

https://doi.org/10.35134/jcsitech.v9i2.66

Keywords:

Supply Chain Management, Single Exponential Smoothing, EOQ, Forecasting.

Abstract

Along with the development of the era where technology is increasingly sophisticated as it is today, the needs are also increasing. Science and Technology also experienced drastic progress. Forecasting forecasting is a method for making estimates of future data by involving the use of past data in a systematic model form, and the forecasting method used is Single Exponential Smoothing. Planning for this EOQ method can minimize the occurrence of out of stock so that processes in a business are not disrupted and are able to save costs incurred due to the efficiency of inventory at the place of business concerned. Application of Supply Chain Management with data mining systems on CV. Amifa Keluarga Lestari can simplify the management of raw materials by implementing an SCM system which can reduce excess stock purchases. With the Single Exponential Smoothing method, you can predict the number of best sales for the following month in one period by looking at the smallest error. The calculation results show that the most economical order in one order is 1291 kilograms, and the total storage cost is Rp. 154,919 per Kilogram

References

Primawanti, EP, & Ali, H. (2022). The Influence of Information Technology, Web-Based Information Systems and Knowledge Management on Employee Performance (Literature Review Executive Support System (Ess) for Business). Journal of Information Systems Management Economics, 3(3), 267-285 https://doi.org/10.31933/jemsi.v3i3.818

Rusida, ND, & Noer, ZM (2018). Design of software for selling systems based on desktop applications at Instamie Pangandaran Cafe. Journal of Management and Information Engineering (JUMANTAKA), 1(1).

Yun, Y., & Kurniawan, A. (2017). Supply Chain Management Analysis of Competitive Advantage in Food Production Cooperatives in West Bandung Regency. GEMA: Journal of Gentiaras Management and Accounting, 9(2), 160-172.

Gustriansyah, R. (2017). Analysis of the single exponential smoothing method with brown exponential smoothing in the case study predicts the quantity of sales of pharmaceutical products in pharmacies. Semnasteknomedia online, 5(1), 3-5.

Ginantra, NLWSR, & Anandita, IBG (2019). Application of the Single Exponential Smoothing Method in Goods Sales Forecasting. J-SAKTI (Journal of Computer Science and Informatics), 3(2), 433-441. http://dx.doi.org/10.30645/j-sakti.v3i2.162

Pakpahan, HS, Basani, Y., & Hariani, RR (2020). Prediction of the Number of Poor Population in East Kalimantan Using Single and Double Exponential Smoothing. inform. Mulawarman J.Ilm. Computing Science, 15(1), 47-51. http://dx.doi.org/10.30872/jim.v15i1.3180

Hidayat, K., Efendi, J., & Faridz, R. (2020). Analysis of raw material inventory control for raw potato crackers and curly potatoes using the economic order quantity (EOQ) method. Performance: Industrial Engineering Scientific Media, 18(2). https://doi.org/10.20961/performa.18.2.35418 .

Umami, DM, Mu'tamar, MFF, & Rakhmawati, R. (2018). Inventory Cost Efficiency Analysis Using the Eoq (Economic Order Quantity) Method at Pt. Xyz. Journal of Agrotechnology, 12(01), 64-70. https://doi.org/10.19184/j-agt.v12i1.8100

Rachmawati, SA, Syafirullah, L., & Faiz, MN (2020, November). Inventory Control System Design Using Web-Based EOQ and ROP Methods. In Proceedings of the National Seminar on Applied Innovative Research (SENTRINOV) (Vol. 6, No. 1, pp. 778-786).

Mayasari, D. (2021). Raw Material Inventory Control Analysis Using the EOQ (Economic Order Quantity) Method at PT. Suryamas Lestari Prima. Bis-a, 10(02), 44-50. https://doi.org/10.55445/bisa.v10i02.10

Ismaya, YB, & Suseno, S. (2022). Analysis of Sweet Potato Raw Material Control Using Economic Order Quantity (EOQ) and H-Sin Rau Methods PT. Galih Indonesian Aesthetics. Journal of Applied Industrial Technology and Management, 1(2), 123-130. https://doi.org/10.55826/tmit.v1iII.37

Dewi, PCP, Herawati, NT, & Wahyuni, MA (2019). Inventory Control Analysis Using the Economic Order Quantity (EOQ) Method for Optimizing Inventory of Raw Materials for Mineral Water Packaging (Case Study at PT. Tirta Mumbul Jaya Abadi). Journal of Professional Accounting, 10(2), 54-65. https://doi.org/10.28932/jam.v10i1.926

Nugraha, YA, Niswatin, RK, & Helilintar, R. (2022). Application of the EOQ Method for Analysis of MSME Product Sales in Nganjuk Regency. Generation Journal, 6(1), 13-21. https://doi.org/10.29407/gj.v6i1.15886

Dyatmika, SB (2018). Generic Drug Inventory Control Using the ABC Analysis Method, Economic Order Quantity (EOQ) Method, and Reorder Point (ROP) at XYZ Pharmacies in 2017. Modus, 30(1), 87-95. https://doi.org/10.24002/modus.v30i1.1589

Downloads

Published

2023-04-30

How to Cite

Putra, A. A., Ariandi, V. ., & Purnama, P. A. W. (2023). Sales and Inventory Prediction with the EOQ Method based on Single Exponential Smoothing Forecasting. Journal of Computer Scine and Information Technology, 9(2), 72–76. https://doi.org/10.35134/jcsitech.v9i2.66

Issue

Volume 9 Issue 2 (2023): JCSITech

Section

Articles

License

Copyright (c) 2023 Journal of Computer Scine and Information Technology

Creative Commons License

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