This paper proposes an efficient and effective BOM management scheme for small and medium manufacturing (SME) companies that produce automobile parts. Automobile part‘s manufacturers produce very various products due to various automobile characteristics such as types, colors, and options of cars. These products are classified into product groups with common parts and like this product groups with commonality are regarded as product family. This paper proposes a BOM data model for product family structures and implements the practical EXCEL-based BOM management system for real small and medium manufacturing (SME) companies that produces automobile parts.

Abstract 
1. Introduction 
2. EXCEL Form and Process for Generating BOM Information 
3. Data Model for Product Family Structure 
4. Implementation of EXCEL-based BOM Management System 
5. Conclusions 
References

• Gil-Sang Jang
• Jung-Sang Choi