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...
Saved in:
| Main Author: | |
|---|---|
| Format: | Final Year Project |
| Language: | English English English English English English English English English |
| Published: |
Universiti Teknologi Petronas
2010
|
| Subjects: | |
| 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!
|
| Summary: | 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. |
|---|