Reduce the Complexity of Material Requirement Planning on Excel by an Algorithm

Authors: Sumitra Nuanmeesri, Kanate Ploydanai

Abstract:

Many companies have excel, it is economy and well perform to use in material requirement planning (MRP) on excel. For several products, it, however, is complex problem to link the relationship between the tables of products because the relationship depends on bill of material (BOM). This paper presents algorithm to create MRP on excel, and links relationship between tables. The study reveals MRP that is created by the algorithm which is easier and faster than MRP that created by human. By this technique, MRP on excel might be good ways to improve a productivity of companies.

Keywords: Material requirement planning, Algorithm, Spreadsheet.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1081473

References:

[1] R.Sadeghian,"Continuous materials requirements planning (CMRP) approach when order type is lot for lot and safety stock is zero and its applications.", Int. J. Applied Soft Computing, vol. 11, pp. 5621-5629, 2011.
[2] J. T. Lin, T. LiChen and Y. TingLin, "Critical material planning for TFT-LCD production industry.", Int. J. Production Economics, vol. 122, pp. 639-655, 2009.
[3] J. Mula, R. Polerand et.al.,"A review Models for production planning under uncertainty.,. Int. J. Production Economics, vol. 103, pp. 271-285, 2006.
[4] J. Mula, R. Poler, and J.P. Garcia-Sabater,"Material Requirement Planning with fuzzy constraints and fuzzy Coefficients.", Int. J. Fuzzy Sets and Systems, Vol. 158, pp. 783-793, 2007.
[5] J. M. Spitter and et.al., "Negenman. Linear programming models with planned lead times for supply chain operations planning. European J. Operational Research, vol. 163, pp. 706-720,2005.
[6] D. Nakagiri and S Kuriyama,"A study of production management system with MRP.",Int.J.Production Economics, vol. 44, pp. 27-33, 1996.
[7] S. HamidMirmohammadi,S. Shadrokh and F Kianfar,"An efficientoptimalalgorithmforthequantitydiscountprobleminmaterial requirement planning." Computers and OperationsResearch., vol. 36, pp.1780-1788, 2009.
[8] R.W.Grubbstro, M.Bogatajand L.Bogataj,"Optimal lotsizing within MRP Theory.", Annual Reviews in Control, vol. 34, pp. 89-100, 2010.
[9] C. C. Sum,S.A.Quek and H. E. Lim,"Analysing interaction expectson MRP implementation using ACE.",Int.J.Production Economics, vol. 58, pp. 303-318, 1999.
[10] P.Jonsson,"Exploring problems related to the materials planning user environment.", Int.J.Production Economics, vol.113, pp. 383-400, 2008.