Effective relational database approach to represent bills-of-materials
- 15 March 2005
- journal article
- research article
- Published by Informa UK Limited in International Journal of Production Research
- Vol. 43 (6), 1143-1170
- https://doi.org/10.1080/00207540512331336528
Abstract
Today's production systems are under the pressure of mass customization where customer orders may result in an explosive number of product variations. Handling information related to materials and components becomes a complex issue with the increasing variability. This paper presents an effective approach to handle product information in a relational database environment for multi-product and multi-process production systems. The approach presented in this paper aims to reduce the efforts when defining products to the production systems for the purpose of generating bills-of-materials (BOMs) and executing material requirements planning (MRP). Two algorithms are presented in this paper. The first algorithm is to retrieve information from the relational database environment to generate the BOMs. The second algorithm calculates the material requirements for all products in a customer order list. Examples are chosen from textiles since complications related to the MRP issues are at a greater extent in this branch of the industry.Keywords
This publication has 11 references indexed in Scilit:
- Production and inventory control at ABB Motors and Volvo Wheel Loaders, two examples of MRP in practical useProduction Planning & Control, 2002
- Mass customization: Literature review and research directionsInternational Journal of Production Economics, 2001
- Generic Bill-of-Materials-and-Operations for High-Variety Production ManagementConcurrent Engineering, 2000
- A procedure-oriented generic bill of materialsComputers & Industrial Engineering, 1997
- A conceptual structure and issues for an object-oriented bill of materials (BOM) data modelComputers & Industrial Engineering, 1994
- The performance of materials management in multi-level product structures with demand uncertainty and back-orderingComputers & Industrial Engineering, 1993
- A structured analysis of material requirements planning systems under combined demand and supply uncertaintyInternational Journal of Production Research, 1993
- New developments in generative BOM processing systemsProduction Planning & Control, 1992
- Generative bill of material processing systemsProduction Planning & Control, 1992
- Generic bill-of-material: a new product modelInternational Journal of Production Economics, 1991