Analysis of the Application of the Rolling Forecast Method for Personal Care Products at PT. Kosmetiku
DOI:
https://doi.org/10.31933/dijemss.v5i3.2377Keywords:
Demand Forecast, Demand Planning, Personal Care, Planning Horizon, Rolling ForecastAbstract
Abstract: Demand planning is a significant factor that affects the performance of each stage of supply chain management in fast-moving consumer goods. An unavoidable problem is the inaccuracy of demand planning which has an impact on production planning for the procurement of personal care products. The more products, the more the accuracy of demand forecasting varies, so it is necessary to make efforts to improve the quality of demand planning to have an impact on effective, efficient demand planning and increase customer satisfaction. This research is a mixed method with a concurrent embedded strategy by providing a simulated rolling forecast process (to be) of the current rolling forecast process (as is). The analysis uses the method of rolling forecast, double moving average, double exponential smoothing, and forecast error calculation with Mean Absolute Percentage Error (MAPE). The purposive sampling method is used to calculate demand forecasting for 2022 focusing on product categories with the 80/20 Pareto principle, where 20% of products generate 80% of the company's revenue. This research improves the business process by implementing a planning time horizon that is dissected into 3 months consisting of frozen, slushy, and liquid periods in a rolling forecast and setting safety stock to be obeyed by distributors to get the smallest forecast error rate. The appropriate demand forecasting method for forecasting product demand based on test results shows that each product requires a different forecasting method, depending on the characteristics of each product's historical data.
Keywords: Demand Forecast, Demand Planning, Personal Care, Planning Horizon, Rolling
Forecast
References
Abolghasemi, M., Beh, E., Tarr, G., & Gerlach, R. (2020). Demand forecasting in supply chain: The impact of demand volatility in the presence of promotion. Computers and Industrial Engineering, 142, 106380. https://doi.org/10.1016/j.cie.2020.106380
Bae, H. S. (2017). Empirical Relationships of Perceived Environmental Uncertainty, Supply Chain Collaboration and Operational Performance: Analyses of Direct, Indirect and Total Effects. Asian Journal of Shipping and Logistics, 33(4), 263–272. https://doi.org/10.1016/j.ajsl.2017.12.010
Bowersox, D., Closs, D., & Cooper, M. B. (2020). Supply Chain Logistics Management (5th ed.). McGraw Hill Education.
Chen, C., Wang, Y., Huang, G., & Xiong, H. (2019). Hierarchical Demand Forecasting for Factory Production of Perishable Goods. Proceedings - 2019 IEEE International Conference on Big Data, Big Data 2019, 188–193. https://doi.org/10.1109/BigData47090.2019.9006161
Christopher, M. (2011). Logistics & Supply Chain Management (4th ed.). Pearson UK.
Cooper, D. R., & Schindler, P. S. (2014). Business research methods (12th ed.). The McGraw-Hill Irwin.
Dharmawan, P. A. S., & Indradewi, I. G. A. A. D. (2021). Double exponential smoothing brown method towards sales forecasting system with a linear and non-stationary data trend. Journal of Physics: Conference Series, 1810(1). https://doi.org/10.1088/1742-6596/1810/1/012026
Etikan, I. (2016). Comparison of Convenience Sampling and Purposive Sampling. American Journal of Theoretical and Applied Statistics, 5(1), 1. https://doi.org/10.11648/j.ajtas.20160501.11
Febrian, D., Idrus, S. I. Al, & Nainggolan, D. A. J. (2020). The Comparison of Double Moving Average and Double Exponential Smoothing Methods in Forecasting the Number of Foreign Tourists Coming to North Sumatera. Journal of Physics: Conference Series, 1462(1). https://doi.org/10.1088/1742-6596/1462/1/012046
Gu, M., Zhang, Y., Li, D., & Huo, B. (2023). The effect of high-involvement human resource management practices on supply chain resilience and operational performance. Journal of Management Science and Engineering, 8(2), 176–190. https://doi.org/10.1016/j.jmse.2022.12.001
Hayes, B. E. (2008). Measuring customer satisfaction: Survey design, use, and statistical analysis method. In P. O’Mara (Ed.), Quality Management Journal (3rd ed.). American Society for Quality, Quality Press, Milwaukee, WI 53203. https://doi.org/10.1080/10686967.1999.11919216
Hutabarat, L. M., Setyawati, A., Sholihah, S. A., & Sundoro, O. Y. (2023). Pengendalian Persediaan dan Waktu Tunggu Pengiriman pada Perusahaan Online Store di Jakarta Inventory Control and Lead Time Delivery of Online Store. 10(02), 141–154.
Jain, N., & Singh, A. R. (2020). Sustainable supplier selection under must-be criteria through Fuzzy inference system. In Journal of Cleaner Production (Vol. 248). Elsevier Ltd. https://doi.org/10.1016/j.jclepro.2019.119275
Krisma, A., Azhari, M., & Widagdo, P. P. (2019). Perbandingan Metode Double Exponential Smoothing Dan Triple Exponential Smoothing Dalam Parameter Tingkat Error Mean Absolute Percentage Error (MAPE) dan Means Absolute Deviation (MAD). Prosiding Seminar Nasional Ilmu Komputer Dan Teknologi Informasi, 4(2), 81–87.
Ku?yk, P., Micha?owska, M., & Kotylak, S. (2017). Assessment of customer satisfaction with logistics service in the light of the results of the research. Management, 21(1), 205–222. https://doi.org/10.1515/manment-2015-0089
Li, M., Yang, H., & Guo, X. (2020). Research on Supply Chain Collaborative Manufacturing Mode. Journal of Physics: Conference Series, 1670(1). https://doi.org/10.1088/1742-6596/1670/1/012027
Maiseli, B. J. (2019). Optimum design of chamfer masks using symmetric mean absolute percentage error. Eurasip Journal on Image and Video Processing, 2019(1), 16–25. https://doi.org/10.1186/s13640-019-0475-y
Nodee, M. (2016). Stepping ahead with rolling forecast: Can Bangladesh look beyond? Stepping ahead with rolling forecast: Can Bangladesh look beyond? Journal of Advances in Humanities and Social Sciences, 2(1), 36–43. https://doi.org/10.20474/jahss2.1.4
Oshri, I., Kotlarsky, J., & Willcocks, L. P. (2015). The Handbook of Global Outsourcing and Offshoring The Definitive Guide to Strategy and Operations (3rd ed.). Palgrave Macmillan.
Pasaribu, T. O. R., & Wahyuni, R. S. (2014). Penentuan Metode Peramalan Sebagai Dasar Penentuan Tingkat Kebutuhan Persediaan Pengaman Pada Produk Karet Remah SIR 20. Prosiding Seminar Ilmiah Nasional Komputer Dan Sistem Intelijen (KOMMIT 2014), 8(Oktober), 402–408.
Rodrigue, J.-P. (2020). The Geography of Transport System (Jean-Paul Rodrigue (ed.); 5th ed.). Routledge. https://transportgeography.org/
Schramm, V. B., Cabral, L. P. B., & Schramm, F. (2020). Approaches for supporting sustainable supplier selection - A literature review. Journal of Cleaner Production, 273, 123089. https://doi.org/10.1016/j.jclepro.2020.123089
Seyedan, M., & Mafakheri, F. (2020). Predictive big data analytics for supply chain demand forecasting: methods, applications, and research opportunities. Journal of Big Data, 7(1). https://doi.org/10.1186/s40537-020-00329-2
Uddin, M. B. (2022). The effect of strategic commitment and supply chain collaboration on operational and innovation performance. IIMB Management Review, 34(4), 364–377. https://doi.org/10.1016/j.iimb.2022.12.002
Yusuf, M. (2016). Metode Penelitian: Kuantitatif, Kualitatif, dan Penelitian Gabungan. In Jurnal Penelitian Pendidikan Guru Sekolah Dasar (Vol. 6, Issue August). KENCANA.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Tenaka Budiman, Harry Purwoko, Laura Malau, Theresye Yoanita Octora, Tri Mulyani Setyowati
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish their manuscripts in this journal agree to the following conditions:
- The copyright on each article belongs to the author(s).
- The author acknowledges that the Dinasti International Journal of Education Management and Social Science (DIJEMSS) has the right to be the first to publish with a Creative Commons Attribution 4.0 International license (Attribution 4.0 International (CC BY 4.0).
- Authors can submit articles separately, arrange for the non-exclusive distribution of manuscripts that have been published in this journal into other versions (e.g., sent to the author's institutional repository, publication into books, etc.), by acknowledging that the manuscript has been published for the first time in the Dinasti International Journal of Education Management and Social Science (DIJEMSS).