FIT MANUFACTURING: MAPPING PRODUCT COST REQUIREMENTS USING RELATIONAL DATABASE DESIGN
Abstract
Efficiency of a manufacturing system depends on the capability of production to transform customer orders into products. Elimination of seven production wastes (i.e. defects, waiting, inventory, overproduction, transportation, motion, over-processing) is the concept used in Lean Manufacturing system to improve manufacturing efficiency. In this regard, the seven production wastes cause additional costs to the total product cost. Therefore, this paper aims to introduce a data model of product cost measurement system named as Product Cost System (PCS). The PCS will compute cost of a unit product that is important to the calculation of Production Waste Index (PWI). Thus, the concept of Relational Database Design has been applied in the development of PCS architecture. As the PWI will be measured on a monthly basis, the PCS database has been designed for calculating cost of a unit product based on one month production period. In this regard, the PCS data model integrates production input (order) quantity with materials cost, packaging cost, and labor cost. However, this paper presents only the first part of PCS that focuses on material cost and packaging cost. For the second part of PCS, a system for determining labor cost per unit product will be developed which is named as Labor Cost System (LCS). Then, both parts of PCS will be integrated to determine the PWI. Result of the first part of PCS prototype shows that further improvement is required in the aspect of bugs and errors.
Downloads
Download data is not yet available.
How to Cite
Ebrahim, Z., Anawar, S., & Cheah, A. (1). FIT MANUFACTURING: MAPPING PRODUCT COST REQUIREMENTS USING RELATIONAL DATABASE DESIGN. Journal of Advanced Manufacturing Technology (JAMT), 9(1), 65-77. Retrieved from https://jamt.utem.edu.my/jamt/article/view/284
Issue
Section
Articles
Authors who publish with this journal agree to the following terms:
- Authors transfer copyright to the publisher as part of a journal publishing agreement with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) after the manuscript is accepted, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).