Effective relational database approach to represent bills-of-materials

Aydin, Ali Orhan; Güngör, Aşkıner

doi:10.1080/00207540512331336528

Cited by 21 publications

(9 citation statements)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The second analysis is about BoM and MRP. The automotive industry has switched from mass produc-tion to MC to meet customer expectations better [5]. However, it increases the complexity and diversity of end-products that drive many commonalities and significant differences [9].…”

Section: A Analysis Phasementioning

confidence: 99%

“…Then, a practical approach is presented to handling product information in information technology and systems-related database environment for multi-Material Resource Planning and Supply Chain Procurement: A Case Study of XYZ Company", CommIT Journal 16 (2), [183][184][185][186][187][188][189][190][191][192][193]2022. product and process production systems [5].…”

Section: Introductionmentioning

confidence: 99%

“…The research proposes a customized Integrated Information System (IIS) design with an opensource platform due to a limited budget and minimizing the risk of failed implementation with the subject company. The research also incorporates the algorithm proposed by previous research [5] with modifications according to the subject company's process and routing to calculate MRP explosion by utilizing BoM. Then, an algorithm is proposed to calculate SCP distribution to enable the IIS framework in the implementation stage.…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Integrated Information System of Material Resource Planning and Supply Chain Procurement: A Case Study of XYZ Company

Wijaya¹,

Sari²,

Supriatna³

2022

CommIT (Communication and Information Technology) Journal

View full text Add to dashboard Cite

Human errors are inevitable due to the mass customization and complex supply chain, which must be considered in the Material Resource Planning (MRP) explosion calculation and the Supply Chain Procurement (SCP) distribution of sales orders. Such errors lead to SCP problems with the subject company. The research presents the design and implementation of an integrated information system of MRP and SCP. The objective is to solve the issues in the subject company by designing and implementing an Integrated Information System (IIS) framework with an open-source software platform, which utilizes a generic Bill-of-Materials (BoM) explosion algorithm to calculate the MRP of customers’ sales orders. Then, an algorithm is also proposed to calculate SCP distribution to enable the framework in the implementation stage. The research subject is the process business in Indonesia’s local Original Equipment Manufacturer (OEM) for automotive components. The name of the company is concealed to be XYZ Company. The calculation is introduced in the testing phase to illustrate the algorithm’s mechanism. This approach ensures a valid calculation of efficient supply chain processes. The combined approaches in the subjected business process yield satisfactory results. It reduces significant issues to 12.5% for the stated problems. Hence, the design objective is achieved.

show abstract

Section: A Analysis Phasementioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Integrated Information System of Material Resource Planning and Supply Chain Procurement: A Case Study of XYZ Company

Wijaya¹,

Sari²,

Supriatna³

2022

CommIT (Communication and Information Technology) Journal

View full text Add to dashboard Cite

show abstract

“…Many researchers focused on BOM management in high-variety production with generic bill of materials (GBOM) and generic bill-of-materials-and-operations (BOMO; Jiao et al, 2000;Romanowski and Nagi, 2002). Moreover, a relational database approach was proposed for multiproduct and multiprocess production systems (Aydin and Gu¨ngo¨r, 2005). For make-to-order environment, a product structure model was proposed to support the flexibility of a PLM system (Ni et al, 2008).…”

Section: Current Status Reviewmentioning

confidence: 99%

Integration of bill of materials with unified bill of materials model for commercial aircraft design to manufacturing

Ming

et al. 2014

Concurrent Engineering

View full text Add to dashboard Cite

The commercial aircraft enterprise faces a major challenge in product data management as it deals with increasing product complexity and global manufacturing. As such, the effective bill of materials management throughout the product lifecycle is becoming much more important for the advanced competitiveness. This study proposed a unified bill of materials model based on single source of product data for commercial aircrafts. This study illustrated the details of the unified bill of materials model throughout the product lifecycle and presented the technology to support the integration of engineering bill of materials and manufacturing bill of materials with unified bill of materials model. A prototype system was implemented to verify the developed technology by taking into account real cases of a local commercial aircraft enterprise. It proved that the developed technology could substantially improve industrial competitive advantage. Keywords Commercial aircraft, bill of materials management, single source of product data, product data management, unified bill of materials model

show abstract

“…Then, MRP II uses finished goods’ bill‐of‐materials (BOM) together with on‐hand and on‐order inventory quantities stored in ERP to determine the quantity of each BOM component required to manufacture the MPS requirements for finished goods. Also, MRP II uses the MPS delivery dates along with purchasing and manufacturing lead‐times stored in ERP to plan start dates for the purchase orders and shop orders that will replenish the required quantities of BOM components (Aydin and Gungor, ; Dickersbach, Keller, and Weihrauch, ; JD Edwards, ). Although many companies use lean manufacturing strategies such as Just‐In‐Time (JIT), most of these companies continue to use MRP II along with JIT (Agrawal, Minis, and Nagi, ).…”

Section: Introductionmentioning

confidence: 99%

Assembly FG: An Educational Case on MRP II Integrated within ERP

Lambert

Calvasina

Bee

et al. 2017

Accounting Perspectives

View full text Add to dashboard Cite

This case teaches students how discrete (job order) manufacturing companies use Manufacturing Resource Planning (MRP II) within Enterprise Resource Planning (ERP) systems to plan purchase orders for direct materials and shop orders for work‐in‐process and finished goods. Students simulate MRP II integrated within ERP, using Microsoft Excel to learn MRP II's bill‐of‐materials (BOM) Explosion that plans order quantities and MRP II's scheduling logic that uses lead‐times to determine start dates for planned orders. Students explain why MRP II is most practical and effective when executed within ERP and how MRP II can reduce excess inventories, prevent inventory shortages, and help companies deliver quality products to customers on schedule. Also, students explain why BOM, inventory, and lead‐time inaccuracies can adversely affect the accuracy of MRP II‐planned replenishments and identify controls that reduce the risks of these inaccuracies.

show abstract

Effective relational database approach to represent bills-of-materials

Cited by 21 publications

References 11 publications

Integrated Information System of Material Resource Planning and Supply Chain Procurement: A Case Study of XYZ Company

Integrated Information System of Material Resource Planning and Supply Chain Procurement: A Case Study of XYZ Company

Integration of bill of materials with unified bill of materials model for commercial aircraft design to manufacturing

Assembly FG: An Educational Case on MRP II Integrated within ERP

Contact Info

Product

Resources

About