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.

Up to date cosmetic OEM/ODM (original equipment manufacturing/original development manufacturing) industry receives attention as a future growth engine due to steady growth. However, because of limited research and development capability, many companies have employed commercial management platforms specialized for large-sized companies; thus, overall system effectiveness and efficiency is low. Especially, MRP (material requirement planning) system introduced originally in 1970s is employed to calculate the requirement of the parts. However, dynamic nature of production lead time usually results in incorrect requirements. In addition, its algorithm does not consider the capability of the production resources. Also, because the commercial MRP system calculates all subcomponent for fixed period, the more goods have subcomponent, the slower calculation is. Therefore, conventional MRP system cannot respond complicated situation in time. In this study, we will suggest a new method that can respond to complicated situations resulting from short lead time and urgent production order in Korean cosmetic market. In particular, a distributed MRP system is proposed, that consists of multi-functional and operational modules, based on the characteristic of the BOM (bill of material). The distributed MRP system divides components (i.e. products and parts) into several fields and decrease the problem size; thus, we can respond to dynamically changed data any time. Through this solution, we can order components quickly, adjust schedules and planned quantity, and manage stocks reasonably. In addition, a prototype of the distributed MRP system is presented in this paper, in which ERP (enterprise resource planning) sever data is associated with an excel spreadsheet via MSsql. System user interface is implemented by a VBA (visual basic for applications) tool. According to a case study, response rate for delivery and planning achievement rate were enhanced about 20%, and inventory turnover was also decreased. Consequently, the proposed system improves overall profit.

Decentralized water supply systems, treating the water in users’vicinity, cutting down the distribution system, utilizing the alternative water resources(rainwater harvesting, water reclamation and reuse and so on.) and saving energy and other resources, could be categorized into POU(Point-Of-Use), POE(Point-Of-Entry) and community small scale system. From the literature review, we could thought that decentralized water supply system and hybrid system(integrating centralized and decentralized water supply system within urban water management) might have strengthening comparative advantages to centralized system with respect to: (1) water security, (2) sustainability, (3) economical affordability. Even though it is difficult to derive and quantify direct benefit advantages from decentralized and hybrid system in comparison with centralized system, (1) operational cost reduction, (2) assurance for safe and stability water supply and (3) greenhouse gas reduction can be expected from successful establishment of the former.

국내 최초의 분산형 생태환경저류지 시스템으로 방재기능뿐만 아니라 초기 비점오염원에 대한 생태적 수질정화 및 생태복원, 근린공원의 친수적 이용성, 토지이용도 제고 등의 다양한 기능을 융합하여 대상지 특성에 적합한 다목적용 저류지가 조성되었다. 복원 후 수리·수문 모니터링 결과는 서울지역 재현기간 10년의 강우량과 홍수량에서 첨두홍수량은 12% 감소하고 20분의 지체효과를 보였다. 생태환경수로의 하상 평균소류력의 범위는 86.29-376.18N/m2, 유속의 범위는 2.76-10.07m/s이었다. 하상보호공은 평균 소류력이 133.94N/m2 이하인 곳에는 자연석을, 133.94N/m2 이상인 곳에는 생태목틀이 적용되었다. 현장조사결과 생태목틀과 자연석이 적용된 생태환경수로는 자연석의 이탈이나 자연석 주변 하상 세굴과 토사의 퇴적이 발생하지 않았음을 확인하였다. 생태환경 저류지 시스템의 홍수저감효과와 생태환경 수로의 안정성을 입증하였다. 국내 융합적인 생태환경 저류지나 생태하천의 표준화와 적용에 필요한 중요한 기준을 확립하는데 기여할 수 있을 것이다. 다만 생태환경저류지 시스템 조성이후 생태적 안정화 기간인 2년 이상의 연구개발자(전문가)의 유지관리 참여가 필요하다. 이를 통해 일반기술자도 생태환경저류지의 조성 및 유지관리가 용이하도록 지침을 마련해야 할 것이다.