Development of MRP Software for Clutch Manufacturing Unit Using VBA

Abstract

Material requirements planning is inventory control tool. From last few years Global clutch industry has facing problems with inaccurate inventory control system. Therefore, company need to do material requirements planning using MRP software i.e. one of the inventory control tool. There are many software's available in market like MRP II, MRP 90 etc. But these software's are more expensive, and training is required to do material requirements planning. MRP software is one of the main tool considered in improving the performance of manufacturing company. The global clutch is small unit, hence decision taken to design and develop MRP software for company. In this report development of MRP software is done using VBA for global clutch industry, Which helps the company in improving productivity, reduced inventory level, and released planned ordered dates for end products and its component.

As an input of MRP product structure, inventory status le, and MPS are required, Therefore data collection has been carried out for various clutch plate assembly. Then manual method of MRP has been implemented for one of the clutch plate assembly and subsequently, used for software development using VBA.

In this report the manual method of lot sizing for ordering component is also explained, it helps the company in ordering of component on lot for lot basis or ordering the component on part period basis.