JESCEE- Journal of Emerging Supply Chain, Clean Energy, and Process Engineering
Vol 3 No 1 (2024): Journal of Emerging Supply Chain, Clean Energy and Process Engineering

Forecast Analysis of Fruit Supply Using Time-Series Method: A Study at PT Aerofood Indonesia

Nasution, Baginda Muhammad (Unknown)
Vikaliana, Resista (Unknown)



Article Info

Publish Date
29 Jun 2024

Abstract

PT Aerofood Indonesia is an entity operating in the aviation logistics industry, specifically as a partner of the Garuda Indonesia airline.  The main problem faced is the tendency to have excessive supplies of raw materials, especially in the aspect of purchasing fruit because it is susceptible to damage. This phenomenon often recurs and peaks beyond dry goods capacity limits, especially the availability of papaya fruit which often exceeds capacity by more than 50%. Therefore, this research aims to identify the optimal forecasting method for papaya fruit to overcome the problem of excessive stock. In this research, four forecasting approaches were tested, namely Trend Analysis, Single Average Exponential, Double Average Exponential, and Holt's Winter Method. Forecasting calculations were carried out using a manual approach and supported by Minitab 18 software. The research results showed that the Holt's Winter method with a multiplicative approach produced the lowest Mean Absolute Percentage Error (MAPE), namely 16%.  The Holt's Winter method with a multiplicative approach has proven to be effective in producing accurate forecasts. By implementing this recommended forecasting method, it is hoped that companies can be more efficient in managing inventory and reduce the impact of losses due to excess stock.

Copyrights © 2024






Journal Info

Abbrev

jescee

Publisher

Subject

Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Electrical & Electronics Engineering Industrial & Manufacturing Engineering Mechanical Engineering

Description

The Journal of Emerging Supply Chain, Clean Energy and Process Engineering (JESCEE) is a peer-reviewed journal that provides an authoritative source of scientific information for researchers and engineers in academia, research institutions, government agencies, and industries. We publish original ...