A Development and Implementation of Manufacturing Resource Planning System for Small and Medium Enterprises

Abstract

Material Requirements Planning (MRP) refers to a system of management practices where production planning is integrated with inventory control. According to this paper, we have been able to make significant progress toward a revised Manufacturing Resource Planning (MRP II) system. During the application of the MRP II database, it was also considered how much dataset might be obtained using reports. MRP II database creation in MS Access software is covered in steps 1 and step 2 of this research article. This paper refers to the MS Access software to create a database that incorporates the theoretical knowledge and suggested a custom MRP II solution. In this paper, a three-step technique as a research methodology to formulate and apply a customized MRP II model was used. For the creation of a custom MRP II system database, this paper employed the MS access application over other commercially known software. With MRP's core idea, we should be able to schedule just what materials are required and when. The relevant literature has also put significant emphasis on technical issues, e.g., the ineffectiveness of MRP frameworks for optimization of the internal workflow.