Design and Application of BOM Architecture in Electric Cabinet Company

Abstract:

Single-piece-small-batches are typical in electric cabinet company. It results in huge BOM (bill of material) data. The article analyzes the product processes in electric cabinet company and presents BOM architecture. It is consist of design BOM, parameter BOM, manufacturing BOM, purchasing BOM and cost BOM, which simplifies BOM management and storage. BOM is denoted as weight number tree. Tuples are put forward to express the tree and the structure is converted to relational database storage. It is applied to express node query and checksum algorithms with structure query language, which proves the tuples maintainability. On this basis, BOM management system is established. Enterprise applications show that a feasible plan for electric cabinet company BOM management is presented.

• Periodical: Key Engineering Materials (Volumes 474-476)
• Pages: 1412-1417
• DOI: https://doi.org/10.4028/www.scientific.net/KEM.474-476.1412
• Online since: April 2011
• Authors: Bing Feng Liu
• Keywords: BOM, Electric Cabinet, Store Procedure, Tuple, Weight Number Tree

References

[1] Zhao Han, Liang ping, Liu Ming Zhou. Constructs the Material Detailed list of the Mechanical and Electrical Products with the Object Database. Computer Integration Manufacture System Vol. 10 (2004), pp.1537-1540.

[2] Qiu Fa sheng, Wang Huachang, Li Jianjun, et al. Research on Material Management Information System in the Lean Manufacture. Wuhan University of Technology Journal Vol. 28(2006), pp.117-120.

[3] Chenkong, Ge Yang. MRPII / ERP Theory and Application. Tsinghua University (2006), in press.

[4] Zhang Li, Zhang Jianjun, Ren Qile, et al. Solution techniques of the product concept design Based on BOM. Agricultural Machinery Journal Vol. 38(2007), pp.97-102.

[5] Liu Yu, Mai Jiajian, Li Lei. Flexible BOM structure and product configuration algorithm based on and-or tree. Computer Engineering Vol. 31(2005), pp.189-191.