Cover Image

Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly

The project focus on the development spreedsheet model of material requirement planning (MRP) for panel front door left hand side assembly for an automotive part. The objective of the study was to identify the elements of MRP implementation and develop the model. Three major inputs required to deve...

Full description

Saved in:
Bibliographic Details
Main Author: Nazri Talib, Nazri
Format: Final Year Project
Language:English
English
English
English
English
English
English
English
English
Published: Universiti Teknologi Petronas 2010
Subjects:
TJ Mechanical engineering and machinery
Online Access:http://utpedia.utp.edu.my/1305/1/APPENDIX.pdf
http://utpedia.utp.edu.my/1305/2/CHAPTER_1.pdf
http://utpedia.utp.edu.my/1305/3/CHAPTER_2.pdf
http://utpedia.utp.edu.my/1305/4/CHAPTER_3.pdf
http://utpedia.utp.edu.my/1305/5/CHAPTER_4.pdf
http://utpedia.utp.edu.my/1305/6/CHAPTER_5.pdf
http://utpedia.utp.edu.my/1305/7/REFERENCE.pdf
http://utpedia.utp.edu.my/1305/8/Table_of_Contents.pdf
http://utpedia.utp.edu.my/1305/9/Title_Page.pdf
http://utpedia.utp.edu.my/1305/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my-utp-utpedia.1305
record_format eprints
spelling my-utp-utpedia.13052017-01-25T09:43:37Z http://utpedia.utp.edu.my/1305/ Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly Nazri Talib, Nazri TJ Mechanical engineering and machinery The project focus on the development spreedsheet model of material requirement planning (MRP) for panel front door left hand side assembly for an automotive part. The objective of the study was to identify the elements of MRP implementation and develop the model. Three major inputs required to develop MRP model were identified. There were production schedule for the panel front door left hand side assembly, inventory status records, and bill of material of the components. Using the inputs, mathematical modelling of products was developed and integrated using a spreadsheet, the model was expanded to MRP model. The developed MRP was used to prepare MRP for 12 components of the panel. Simulation results indicate the MRP was able to estimate the net requirements for all components for each period based on lot-for-lot. Universiti Teknologi Petronas 2010 Final Year Project NonPeerReviewed application/pdf en http://utpedia.utp.edu.my/1305/1/APPENDIX.pdf application/pdf en http://utpedia.utp.edu.my/1305/2/CHAPTER_1.pdf application/pdf en http://utpedia.utp.edu.my/1305/3/CHAPTER_2.pdf application/pdf en http://utpedia.utp.edu.my/1305/4/CHAPTER_3.pdf application/pdf en http://utpedia.utp.edu.my/1305/5/CHAPTER_4.pdf application/pdf en http://utpedia.utp.edu.my/1305/6/CHAPTER_5.pdf application/pdf en http://utpedia.utp.edu.my/1305/7/REFERENCE.pdf application/pdf en http://utpedia.utp.edu.my/1305/8/Table_of_Contents.pdf application/pdf en http://utpedia.utp.edu.my/1305/9/Title_Page.pdf Nazri Talib, Nazri (2010) Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly. Universiti Teknologi Petronas. (Unpublished)
institution Universiti Teknologi Petronas
building UTP Resource Centre
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Petronas
content_source UTP Electronic and Digitized Intellectual Asset
url_provider http://utpedia.utp.edu.my/
language English
English
English
English
English
English
English
English
English
topic TJ Mechanical engineering and machinery
spellingShingle TJ Mechanical engineering and machinery
Nazri Talib, Nazri
Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
description The project focus on the development spreedsheet model of material requirement planning (MRP) for panel front door left hand side assembly for an automotive part. The objective of the study was to identify the elements of MRP implementation and develop the model. Three major inputs required to develop MRP model were identified. There were production schedule for the panel front door left hand side assembly, inventory status records, and bill of material of the components. Using the inputs, mathematical modelling of products was developed and integrated using a spreadsheet, the model was expanded to MRP model. The developed MRP was used to prepare MRP for 12 components of the panel. Simulation results indicate the MRP was able to estimate the net requirements for all components for each period based on lot-for-lot.
format Final Year Project
author Nazri Talib, Nazri
author_facet Nazri Talib, Nazri
author_sort Nazri Talib, Nazri
title Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
title_short Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
title_full Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
title_fullStr Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
title_full_unstemmed Development of Spreadsheet MRP model for Panel Front Door Left Hand Side Assembly
title_sort development of spreadsheet mrp model for panel front door left hand side assembly
publisher Universiti Teknologi Petronas
publishDate 2010
url http://utpedia.utp.edu.my/1305/1/APPENDIX.pdf
http://utpedia.utp.edu.my/1305/2/CHAPTER_1.pdf
http://utpedia.utp.edu.my/1305/3/CHAPTER_2.pdf
http://utpedia.utp.edu.my/1305/4/CHAPTER_3.pdf
http://utpedia.utp.edu.my/1305/5/CHAPTER_4.pdf
http://utpedia.utp.edu.my/1305/6/CHAPTER_5.pdf
http://utpedia.utp.edu.my/1305/7/REFERENCE.pdf
http://utpedia.utp.edu.my/1305/8/Table_of_Contents.pdf
http://utpedia.utp.edu.my/1305/9/Title_Page.pdf
http://utpedia.utp.edu.my/1305/
_version_ 1739830760456585216
score 13.211869

Similar Items