Spare Parts Demand Forecasting During Covid 19 pandemic : (Automotive Company Case Study)

The research was conducted to analyze the calculation of demand forecasting and inventory of spare parts . The data collection method uses descriptive quantitative by conducting literature studies, interviews, and collecting sample data of 140 spare parts from June 2019 to June 2020. The data classification process with FSN method, obtained 13 fast moving spare parts use for calculating demand forecasting based on the Triple Exponential Smoothing method. The results from the trial error to get the smoothing value of alpha, beta and gamma errors prioritize to best MAPE <5%. Some MAPE errors above 5% are X000000 000254 MAPE = 5.68% , X000000 005566 MAPE = 21.12, X400 401 10 72 MAPE = 13.14, and X400 401 26 71 MAPE = 16.70. The calculation result of safety stock and reorder point find 4 spare parts have low level inventory have to reorder.