Dinasti International Journal of Economics, Finance & Accounting (DIJEFA)
Vol. 2 No. 3 (2021): Dinasti International Journal of Economics, Finance & Accounting (July - August

Forecasting With Time Series Method at PT. RSM in Bekasi Jawa Barat

Andi Bimantoro, Fanji (Unknown)
Madelan, Sugiyono (Unknown)
Badawi Saluy, Ahmad (Unknown)



Article Info

Publish Date
06 Jul 2021

Abstract

This study aims to determine the most valid forecasting method based on the time series method. This research uses a quantitative descriptive method, the research variable is sales data of MT products belonging to PT. RSM period August 2018 to January 2021. Data processing using Microsoft excel and Minitab 19 software. ABC analysis results show product codes RSM020, RSM021, and RSM017 occupy the three highest ranks in class A by contributing 26.16% sales figures. Based on the forecasting results using various time series methods (linear trend, decomposition, moving average, single exponential smoothing, Holt Method, and Winter Method) it is found that the Winter Method produces the lowest MAPE value, which is below 20%. Product code RSM020 with an alpha value of 0.06; beta 0.09; and 0.07 gamma produces 17.2% MAPE. Product code RSM021 with an alpha value of 0.01; beta 0.01; and 0.01 gamma produces a 15.3% MAPE. Product code RSM017 with an alpha value of 0.01; beta 0.02; and 0.02 gamma produces 18.1% MAPE.

Copyrights © 2021






Journal Info

Abbrev

DIJEFA

Publisher

Subject

Economics, Econometrics & Finance

Description

The author is invited to submit a paper for Dinasti International Journal of Economics, Finance & Accounting (DIJEFA). Topics related to this journal include but are not limited to: Accounting and financial reporting Audit Accounting management Taxation Corporate finance Personal finance Financial ...