Browse > Article

Implementation of EXCEL-based BOM Management System for Automobile Part's Companies  

Jang, Gil-Sang (College of Business Administration, University of Ulsan)
Kim, Jae-Do (Computer System Team, DAS Ltd., Co.)
Park, Chang-Kwon (School of Industrial Engineering, University of Ulsan)
Publication Information
Journal of Korean Society of Industrial and Systems Engineering / v.28, no.4, 2005 , pp. 28-40 More about this Journal
Abstract
This paper focuses on a BOM(Bill of Materials) management problem for a small and medium manufacturing company that produce automobile parts. Automobile part's manufacturers produce various products due to various automobile characteristics such as types, colors, and the other options of car. These products are classified into product groups with common parts. And each product group is regarded as a product family. This paper proposes an efficient and effective EXCEL-based BOM management scheme using characteristics of the product family. And we have implemented the practical EXCEL-based BOM management system for real small and medium automobile part's manufacturing companies.
Keywords
BOM; product group; product family; EXCEL; automobile parts;
Citations & Related Records
연도 인용수 순위
  • Reference
1 고석환, 김선호, '객체지향기법을 이용한 BOM관리시스템 개발', 대한산업공학회 1997년도 추계학술대회 발표논문집, 인하대학교, 1997
2 이동국, 김재균, 장길상, '객체지향기법을 이용한 Generic BOM 관리시스템(GBMS)의 설계 및 구현', 산업공학, 12(1) : 102:113, 1999
3 Clement, J., Coldrick, A., and Sari, J.; Manufacturing Data Structures, Oliver Wight Publications, 1992
4 김정기, 김영호, 강석호, 'Web-based BOM', 대한산업공학회/한국경영과학회 1997년도 춘계공동학술대회 발표논문집, 포항공과대학교, pp.401-404, 1997
5 장길상, 김재균, 이종헌, '웹 기반의 Generic BOM 관리시스템 설계 및 구현', 산업경영시스템학회지, 23(5) : 21-39, 2000
6 Nandakumar, G.; 'The Design of a Bills of Material Processor Using a Relational Database', Computers in Industry, 6(1)：15-21, 1991   DOI   ScienceOn
7 Chung, Y., and Fischer, G. W.; 'A Concetual Structure and Issues for an Object-Oriented Bill of Materials (BOM) Data Model', Production Planning and Control, 3(3)：314-326, 1992   DOI
8 이한표, 이춘열, 이국철, 'Family BOM 데이터베이스구조에 대한 대안 : 목적별 연결 구조의 간접 표현방법', 대한산업공학회 1995년도 추계학술대회 발표논문집, 경희대학교, 1995