Abstract :

BMTec is a telecommunication infrastructure manufacturer based in West Java, Indonesia. They produce tower accessories made of steel materials with various fabrication processes. The ineffectiveness of their current inventory management system has driven them to stockpile raw materials, resulting in reduced material quality in the form of corrosion and obsolescence. This brings up the question regarding how to improve the inventory management in the company, then drives the research to compare the effectiveness of BMTec’s current inventory management with the new-preferred inventory model. Before analyzing the mentioned issue, the primary data is gathered, accompanied by semi-structured interviews for the additional empirical data. An ABC classification is used to distinguish the essential items, which results in the telecommunication tower harmonica fence as the most crucial product in BMTec. Demand forecasting is applied based on the pattern of historical demand data. The Holt-Winters method was chosen due to the ability to adjust the seasonality and trend factor, although the forecasting inaccuracy reached 4.7 (MAD) and 78.4% (MAPE). By comparing the inventory costs over the current company’s method and EOQ model, analysis shows that with the EOQ model, BMTec could save their inventory cost 2022 up to 68%. The discussion in this paper begins with the background of the research’s underlying issues, followed by a literature review to update the scientific development for related studies. The third section conveys how the flow of this research is conducted, then discusses the findings or results from the analysis of collected data and chosen methods.

---

Keywords :

Demand forecasting, EOQ, Harmonica fence, Holt-Winters, Inventory management, Steel, Telecommunication infrastructure.

---

References :

1. IISI, “World steel in figures,” vol. 2021, no. 13 March, 2022, [Online]. Available: http://www.worldsteel.org/wsif.php
2. Wee Jin, “The ASEAN Steel Industry Situation,” no. March, 2020.
3. Muchaendepi, C. Mbohwa, T. Hamandishe, and J. Kanyepe, “Inventory management and performance of SMEs in the manufacturing sector of Harare,” in Procedia Manufacturing, 2019, vol. 33, pp. 454–461. doi: 10.1016/j.promfg.2019.04.056.

4. Z. Arifin, D. Kustono, and W. Widiyanti, “Characteristics of ASTM A36 steel plate corrosion rate due to bending treatment with angle, corrosion media, and corrosion time variations,” J. Eng. Appl. Technol., vol. 1, no. 1, pp. 21–29, 2020, doi: 10.21831/jeatech.v1i1.31478.
5. Jacob, Operations and Supply Chain Management. 2018.
6. D. Bula, B. Medina, and J. E. Sierra, “Inventory Management Model for the Manufacture of Products in a Steel Company,” Indian J. Sci. Technol., vol. 11, no. 11, pp. 1–9, 2018, doi: 10.17485/ijst/2018/v11i11/121750.
7. W. Chan, R. Tasmin, A. H. Nor Aziati, R. Z. Rasi, F. B. Ismail, and L. P. Yaw, “Factors Influencing the Effectiveness of Inventory Management in Manufacturing SMEs,” IOP Conf. Ser. Mater. Sci. Eng., vol. 226, no. 1, 2017, doi: 10.1088/1757-899X/226/1/012024.
8. S. Mor, A. Bhardwaj, V. Kharka, and M. Kharub, “Spare Parts Inventory Management in the Warehouse: A Lean Approach,” Int. J. Ind. Eng. Prod. Res., vol. 32, no. 3, pp. 1–11, 2021, doi: 10.22068/ijiepr.1110.
9. Daniel Kolawole, A. Busola Akomolafe, and B. Johnson Olusipe, “Inventory Management: An Impetus for Increased Profitability in Manufacturing Firms,” Int. J. Accounting, Finance. Risk Manag., vol. 4, no. 4, p. 110, 2019, doi: 10.11648/j.ijafrm.20190404.12.
10. Ngubane, S. Mayekiso, S. Sikota, S. Fitshane, M. Matsoso, and J. P. Bruwer, “Inventory management systems used by manufacturing small medium and micro enterprises in Cape Town,” Mediterr. J. Soc. Sci., vol. 6, no. 1, pp. 382–390, 2015, doi: 10.5901/mjss.2015.v6n1p382.
11. Chopra and P. Meindl, Supply Chain Management: Strategy, Planning, and Operation. 2016.
12. Darmawan, “Penerapan Economic Order Quantity (Eoq) Dalam Pengelolaan Persediaan Bahan Baku Tepung Pada Usaha Pia Ariawan Di Desa Banyuning,” J. Manaj. Indones., vol. 3, no. 1, 2015.
13. Yemane, A. M. Semegn, and E. Gidey, “ABC Classification for Inventory Optimization (Case Study Family Supermarket),” no. July, 2021, [Online]. Available: https://www.hilarispublisher.com/open-access/abc-classification-for-inventory-optimization-case-studyfamily-supermarket.pdf
14. Jaques and C. Morgan, “Adapting the Analytical Hierarchy Process to Identify Inventory Risk,” Int. J. Logist. Manag., vol. 15, no. 2, pp. 93–105, 2004, doi: 10.1108/95740930480000354.
15. Armstrong and G. Franke, Principles of forecasting. 2001. [Online]. Available: http://elibrary.ru/item.asp?id=4643952%5Cnpapers2://publication/uuid/2EF07596-D9F9-463E-8773-080AE5DD8ADC

16. Bacchetti and N. Saccani, “Spare parts classification and demand forecasting for stock control: Investigating the gap between research and practice,” Omega, vol. 40, no. 6, pp. 722–737, 2012, doi: 10.1016/j.omega.2011.06.008.
17. Nadiyah, “An Analysis of Spare parts Demand Forecasting Case Study: PT. Riung Mitra Lestari, Indonesia,” OISAA J. Indones. Emas, 2019, [Online]. Available: http://ejournal.ppi.id/index.php/oisaa/article/view/43%0Ahttps://ejournal.ppi.id/index.php/oisaa/article/download/43/11

18. J. Hyndman, G. Kapetanios, M. Mccracken, J. S. Armstrong, M. P. Clements, and G. Gonzalez-rivera, “Editorial Board,” Int. J. Forecast., vol. 32, no. 3, p. iv, 2016, doi: 10.1016/s0169-2070(16)30037-1.