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 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.