%0 Journal Article
	%A Sumitra Nuanmeesri and  Kanate Ploydanai
	%D 2013
	%J International Journal of Industrial and Manufacturing Engineering
	%B World Academy of Science, Engineering and Technology
	%I Open Science Index 78, 2013
	%T Reduce the Complexity of Material Requirement Planning on Excel by an Algorithm
	%U https://publications.waset.org/pdf/13624
	%V 78
	%X 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.

	%P 992 - 995