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.