Production management in the automobile parts industry is carried out according to the production plan of the customer, so it is important to prevent shortages in product supply. As the product composition became increasingly complex, the MES System was built for the purpose of efficient production plan management and inventory management, but its utilization is low. This study analyzed the problems of the MES system and sought to improve it. Through previous studies, it was confirmed that the inventory management of the pull approach that actually occurred in the warehouse is more suitable than the push approach based on the forecast of the warehouse for the volatility, complexity, and uncertainty of orders in the auto parts industry. To realize this, we tried distributed MRP by using the ADO function of VBA to link the standard information of the MES system with Excel and change the structure of the BOM table. Through this, it can help increase the accuracy of production planning and realize efficient inventory management, thereby increasing the utilization of the MES system in the auto parts industry and enhancing the competitiveness of the company.