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.

Abstract
1. 서 론
2. 이론적 배경
    2.1 MES(Manufacturing Execution System)
    2.2 BOM(Bill of Materials)
    2.3 MRP(Material Requirements Planning)
3. 분산형 MRP 구현 방법 설계
    3.1 분산형 MRP 구현을 위한 개선 방향
    3.2 MRP Process의 문제점
    3.3 개선된 MRP Process
    3.4 ADO를 활용한 MES System 기준정보 관리
4. 사례연구
    4.1 A사의 생산 일정 수립 절차
    4.2 BOM 테이블 구조 변경
    4.3 변경 전·후 소요량 산출결과 비교
5. 연구결과
    5.1 실험 표본 및 가설 설정
    5.2 가설검증
6. 결 론
7. References

• 남은재(한국교통대학교 산업경영공학과) | Eun-Jae Nam (Department of Industrial Engineering, Korea National University of Transportation)
• 김광수(한국교통대학교 산업경영공학과) | Kwang-Soo Kim (Department of Industrial Engineering, Korea National University of Transportation) Corresponding author