Managing inventory in maintenance department of building services company with ABC analysis and Monte Carlo simulation
List of Authors
  • Ainaa Nadhirah Abd Razak, Muhammad Zulfadhli Zulkifli, Noriah Yusoff, Norliana Mohd Abbas

Keyword
  • Inventory, ABC Analysis, Monte Carlo Simulation, Dashboard

Abstract
  • Inventory management is crucial in ensuring the right products are in the right location at the right time. This requires visibility into inventory, including knowing when to place orders, determining optimal order quantities, and identifying suitable storage locations. This work focuses on managing inventory of spare parts for maintenance in a two-tower office building covering electrical and plumbing activities. Through ABC analysis the spare parts where clustered according to total annual price, respectively. Then, Pareto chart is used to assemble the most important items grouped in A. Then, Monte Carlo simulation is applied to predict the demand and controlling the inventory for the topmost item for both, electrical and plumbing items based on historical data from year 2022 and 2023. The result shows that there are five electrical and six plumbing items categorized as items A. The topmost electrical item is LED tube T8 18W 6500K 4FT and angle valve is the top item for plumbing. Through Monte Carlo simulation, it was predicted that 51 LED tubes and 7 angle valves will be needed every month in year 2024. A dashboard using Google Data Studio was created to visualize the predicted and actual inventories for any decision.

Reference
  • 1. Annie Rose Nirmala, D., Kannan, V., Thanalakshmi, M., Joe Patrick Gnanaraj, S., & Appadurai, M. (2022). Inventory Management and Control System using ABC and VED Analysis. Materials Today: Proceedings, 60, 922–925. https://doi.org/10.1016/J.MATPR.2021.10.315

    2. Dehghani, M., Abbasi, B., & Oliveira, F. (2021). Proactive Transshipment in the Blood Supply Chain: A stochastic programming approach. Omega, 98, 102112. https://doi.org/10.1016/J.OMEGA.2019.102112

    3. Denny Sentia, P., Elia Sastri, S., & Prasanti, N. (2018). Decision Making of Inventory System Using Monte Carlo Simulation: A Case Study. International Journal of Conceptions on Computing and Information Technology, 6(1), 2017–2019.

    4. Kova, J. (2018). ABC Analysis As a Technique of Inventory Control. Engineering Management, 4(2), 78–86.

    5. Ledy Vanesa, & Helma, H. (2023). Analysis of Raw Material Inventory Control using the ABC Analysis Method and EOQ Method in the Fajar Onion Crackers Business. Mathematical Journal of Modelling and Forecasting, 1(1), 1–9. https://doi.org/10.24036/mjmf.v1i1.7

    6. Leepaitoon, S., & Bunterngchit, C. (2019). The Application of Monte Carlo Simulation for Inventory Management: a Case Study of a Retail Store. International Journal of the Computer, the Internet and Management (Vol. 27, Issue 2, pp. 76–83).

    7. Mansur, A., Mar’Ah, F. I., & Amalia, P. (2020). Platelet Inventory Management System using Monte Carlo Simulation. IOP Conference Series: Materials Science and Engineering, 722(1). https://doi.org/10.1088/1757-899X/722/1/012004

    8. Ravinder, H. V., & Misra, R. B. (2016). ABC Analysis For Inventory Management: Bridging The Gap Between Research And Classroom. American Journal of Business Education (AJBE), 9(1), 39–48. https://doi.org/10.19030/ajbe.v9i1.9578

    9. Woo, J. S., Suslow, P., Thorsen, R., Ma, R., Bakhtary, S., Moayeri, M., & Nambiar, A. (2019). Development and Implementation of Real-Time Web-Based Dashboards in a Multisite Transfusion Service. Journal of Pathology Informatics, 10(1), 3. https://doi.org/10.4103/JPI.JPI_36_18