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 makes reference 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.
Keywords
Material Requirements Planning (MRP), Manufacturing Resource Planning (MRP II), Small and Medium Enterprises (SMEs)
L. Sook Ling, "Impacts Of Information Technology Capabilities on Small and Medium Enterprises (Smes) and Large Enterprises", Journal of Innovation Management in Small and Medium Enterprises, pp. 1-9, 2017. Available: 10.5171/2017.133143.
"Beyond Manufacturing Resource Planning (MRPII): Advanced Models and Methods for Production Planning", Integrated Manufacturing Systems, vol. 10, no. 3, pp. 57-58, 1999. Available: 10.1108/ims.1999.10.3.57.2.
"MRP (Material requirements planning)/Material part decision system with consideration given to improvement of quality", Assembly Automation, vol. 26, no. 1, 2006. Available: 10.1108/aa.2006.03326aad.011.
P. Dewi and D. Saroso, "IMPLEMENTASI MATERIAL REQUIREMENTS PLANNING (MRP) PADA PERENCANAAN PERSEDIAAN MATERIAL PANEL LISTRIK DI PT.TIS", SINERGI, vol. 20, no. 1, p. 36, 2016. Available: 10.22441/sinergi.2016.1.006.
M. Thürer, N. Fernandes, S. Haeussler and M. Stevenson, "Dynamic planned lead times in production planning and control systems: does the lead time syndrome matter?", International Journal of Production Research, pp. 1-15, 2022. Available: 10.1080/00207543.2022.2034193.
H. Matsuura and H. Tsubone, "Determining Net Requirements for Material Requirements Planning", Journal of the Operational Research Society, vol. 42, no. 11, pp. 981-990, 1991. Available: 10.1057/jors.1991.188.
D. Milanovic, D. Milanovic, M. Misita, M. Klarin and A. Zunjic, "Universal equation for the relative change in profit of manufacturing company", Production Planning & Control, vol. 21, no. 8, pp. 751-759, 2010. Available: 10.1080/09537281003601605.
S. Junayed and H. Khan, "Inventory Investment and the Real Interest Rate", Economics, vol. 3, no. 1, 2009. Available: 10.5018/economics-ejournal.ja.2009-34.
J. Hennet, "A combined open-loop and closed-loop production planning scheme", IFAC Proceedings Volumes, vol. 33, no. 20, pp. 279-284, 2000. Available: 10.1016/s1474-6670(17)38063-1.
N. Hasanati, E. Permatasari, N. Nurhasanah and S. Hidayat, "Implementation of Material Requirement Planning (MRP) on Raw Material Order Planning System for Garment Industry", IOP Conference Series: Materials Science and Engineering, vol. 528, no. 1, p. 012064, 2019. Available: 10.1088/1757-899x/528/1/012064.
L. Gelders and L. Van Wassenhove, "Capacity planning in MRP, JIT and OPT: A critique", Engineering Costs and Production Economics, vol. 9, no. 1-3, pp. 201-209, 1985. Available: 10.1016/0167-188x(85)90029-1.
T. Wuttipornpun and P. Yenradee *, "Development of finite capacity material requirement planning system for assembly operations", Production Planning & Control, vol. 15, no. 5, pp. 534-549, 2004. Available: 10.1080/09537280412331270797.
H. Kim and Y. Hosni, "Manufacturing lot-sizing under MRP II environment: An improved analytical model & heuristic procedure", Computers & Industrial Engineering, vol. 35, no. 3-4, pp. 423-426, 1998. Available: 10.1016/s0360-8352(98)00124-7.
О. Іванець and М. Дворнік, "Development of a database in MS Access environment", Electronics and Control Systems, vol. 2, no. 24, 2010. Available: 10.18372/1990-5548.24.810.
Acknowledgements
The authors would like to thank to the reviewers for nice comments on the manuscript.
Funding
No funding was received to assist with the preparation of this manuscript.
Ethics declarations
Conflict of interest
The authors have no conflicts of interest to declare that are relevant to the content of this article.
Availability of data and materials
No data available for above study.
Author information
Contributions
All authors have equal contribution in the paper and all authors have read and agreed to the published version of the manuscript.
Corresponding author
Vita Kogan
Vita Kogan
School of Business, Kazan Federal University, Kazan, Republic of Tatarstan, 420015, Russia.
Open Access This article is licensed under a Creative Commons Attribution NoDerivs is a more restrictive license. It allows you to redistribute the material commercially or non-commercially but the user cannot make any changes whatsoever to the original, i.e. no derivatives of the original work. To view a copy of this license, visit https://creativecommons.org/licenses/by-nc-nd/4.0/
Cite this article
Vita Kogan and Morley Maria, “A Development and Implementation of Manufacturing Resource Planning System for Small and Medium Enterprises”, Journal of Enterprise and Business Intelligence, vol.2, no.2, pp. 056-065, April 2022. doi: 10.53759/5181/JEBI202202007.
