In manufacturing companies, engineering information is a central data which defines a product to be produced. This is changed by various factors such as changes of product configuration, changes of drawings information of a technology's licensor, etc, and

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.