International Journal of Advanced Science Computing and Engineering
Vol 4, No 2 (2022)

Implementation of The Moving Average Method for Forecasting Inventory in CV. Tre Jaya Perkasa

Putri Huriati (Department of Information Technology, Politeknik Negeri Padang, West Sumatera, Indonesia)
Aldo Erianda (Department of Information Technology, Politeknik Negeri Padang, West Sumatera, Indonesia)
Alde Alanda (Department of Information Technology, Politeknik Negeri Padang, West Sumatera, Indonesia)
Dwiny Meidelfi (Department of Information Technology, Politeknik Negeri Padang, West Sumatera, Indonesia)
- Rasyidah (Faculty of Computer Science and Information Technology, Universiti Tun Hussein Onn Malaysia, 86400 Batu Pahat, Johor, Malaysia)
- Defni (Department of Information Technology, Politeknik Negeri Padang, West Sumatera, Indonesia)
Ade Irma Suryani (Department of Computer Science and Information Engineering, National Yunlin University of Science and Technology, Yunlin, Taiwan)



Article Info

Publish Date
19 May 2022

Abstract

The supply chain is an organization's place to distribute production goods and services to customers. This chain is a network of various organizations that are interrelated and have the aim of carrying out the procurement or supply of goods. Inventory is storing goods in the form of raw materials, semi-finished goods or finished goods that will be used in the production or distribution process. CV. Tre Jaya Perkasa is a company engaged in the distribution of goods such as snacks, drinks and daily necessities. CV. Tre Jaya Perkasa is located in Solok, West Sumatra, Indonesia. From January 2020 to June 2021, CV. Tre Jaya Perkasa has made more than 10 thousand transactions. Based on the sales data, each period (month) of sales transactions can increase and decrease, and the company must plan product sales in the coming period. To maximize profits and minimize losses, a strategy is needed to maintain the availability of goods that are often purchased by customers. From historical transaction data, the company can predict how much stock should be provided for transactions in the coming period. The method used is the moving average method, to measure the error rate of forecasting, MAD, MSE and MAPE are used. Based on the research that has been done, then carried out on the product Trick Potato Biscuit BBQ 24 BOX X 10X18 forecasting comparison between using 3 periods and 5 periods, using 5 product data that are most often purchased by buyers, it was found that the average value of MAD, MSE and MAPE closer to 0 is to use 3-period forecasting.

Copyrights © 2022






Journal Info

Abbrev

IJASCE

Publisher

Subject

Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering

Description

The journal scopes include (but not limited to) the followings: Computer Science : Artificial Intelligence, Data Mining, Database, Data Warehouse, Big Data, Machine Learning, Operating System, Algorithm Computer Engineering : Computer Architecture, Computer Network, Computer Security, Embedded ...