Citation :

Niyati Raut, Harshal Nemade, "Material Planning with Goal Programming in MATLAB," International Journal of Engineering Trends and Technology (IJETT), vol. 74, no. 8, pp. 454-462, 2026. Crossref, https://doi.org/10.14445/22315381/IJETT-V74I8P130

Abstract

Material Requirement Planning (MRP) is an important part of production management because it ensures the timely availability of materials while reducing costs and surplus inventory. This study introduces a Goal Programming (GP)-based optimization model for material planning in a furniture manufacturing company that produces three product types: dining tables, folding chairs, and fittings. The suggested methodology combines MRP concepts with preemptive multi-objective optimization to address common challenges in the manufacturing process and ultimately to reduce production costs, inventory holding costs, and expenses related to resource idle time and overtime. The mathematical formulation is built on a preemptive priority structure and solved using two computing approaches: Microsoft Excel Solver for baseline linear programming cost minimization and MATLAB's goal attain function for multi-objective goal programming. The suggested model achieves zero excess in priority production goals while keeping total production costs at 10.3% of the LP-derived optimum. The combination of MRP and Goal Programming is demonstrated to provide a practical, scalable, and computationally efficient decision-support framework for production managers in small and medium-sized manufacturing industries, outperforming conventional single-objective planning approaches reported in the literature.

Keywords

Goal Programming, Integer linear programming, Linear programming problems, Multi-Objective Linear Programming, Simplex method.

References

[1] Prem Kumar Gupta, and D.S. Hira, Operations Research, S Chand Publishing, 1976.
[Google Scholar] [Publisher Link]

[2] Mohamed-Aly Louly, and Alexandre Dolgui, “Optimal MRP Parameters for a Single Item Inventory with Random Replenishment Lead Time, POQ Policy and Service Level Constraint,” International Journal of Production Economics, vol. 143, no. 1, pp. 35-40, 2013.
[CrossRef] [Google Scholar] [Publisher Link]

[3] Aboozar Jamalnia, Evaluating the Performance of Aggregate Production Planning Strategies under Uncertainty, University of Manchester, 2017.
[Google Scholar]

[4] S. Noori et al., Optimization of Material Requirement Planning by Fuzzy Multi-Objective Linear Programming, Proceedings of the Institution of Mechanical Engineers, Part B: Journal of Engineering Manufacture, vol. 222, no. 7, pp. 887-900, 2008. 
[CrossRef] [Google Scholar] [Publisher Link]

[5] Alaa Alden Al Mohamed, Sobhi Al Mohamed, and Marwa Ahmad, “Solving Aggregate Production Planning Problem with Uncertainty using Fuzzy Goal Programming,” International Journal of Mathematics in Operational Research, vol. 25, no. 4, pp. 527-547, 2023.
[CrossRef] [Google Scholar] [Publisher Link]

[6] UgoChukwu O. Chineh, “Imprecise WareHouse Space in Aggregate Production Planning using Fuzzy Goal Programming,” European Journal of Theoretical and Applied Sciences, vol. 1, no. 5, pp. 111-128, 2023.
[CrossRef] [Publisher Link]

[7] Ahm Shamsuzzoha, and Tuomas Jaakkola, “The Scope of Demand-Driven Material Requirements Planning in Operative Purchasing of a Multi-National Company: A Case Study,” International Journal of Engineering Business Management, vol. 16, pp. 1-21, 2024.
[CrossRef] [Google Scholar] [Publisher Link]

[8] Muhammad Qasim, Kuan Yew Wong, and Komarudin, “A Review on Aggregate Production Planning under Uncertainty: Insights from a Fuzzy Programming Perspective,” Engineering Applications of Artificial Intelligence, vol. 128, 2024.
[CrossRef] [Google Scholar] [Publisher Link]

[9] Babak Javadi et al., “Production and Distribution Planning, Scheduling, and Routing Optimization in a Yogurt Supply Chain under Demand Uncertainty: A Case Study,” arXiv preprint, pp. 1-27, 2024.
[CrossRef] [Google Scholar] [Publisher Link]

[10] Naveen Kant Sharma, and Onkar Singh Bhatia, “Application of Linear Goal Programming (LGP) to Case Study Provider Quota Distribution,” IOSR Journal of Mechanical and Civil Engineering, vol. 13, no. 2, pp. 38-40, 2016.
[CrossRef] [Google Scholar]

[11] Katlea Fitriani, “Reverse Logistic Decision using Goal Programming: A Review,” Asia Pacific Journal of Advanced Business and Social Studies, vol. 13, no. 1, pp. 1-10, 2017.
[Google Scholar]

[12] Mehrdad Tamiz, Dylan Jones, and Carlos Romero, “Goal Programming for Decision Making: An Overview of the Current State-of-the-Art,” European Journal of Operational Research, vol. 111, no. 3, pp. 569-581, 1998.
[CrossRef] [Google Scholar] [Publisher Link]

[13] Wiwik Anggraeni et al., “Production Planning Optimization using Goal Programming Method in Habibah Busana,” Journal of Advanced Management Science, vol. 3, no. 4, pp. 270-275, 2015.
[CrossRef] [Google Scholar] [Publisher Link]

[14] Ing. Lenka Veselovska, “A Linear Programming Model of Integrating Flexibility Measures into Production Processes with Cost Minimization,” Journal of Small Business and Entrepreneurship Development, vol. 2, no. 1, pp. 67-82, 2014.
[Google Scholar] [Publisher Link]

[15] Susanta Banik, and Debasish Bhattacharya, “Weighted Goal Programming Approach for Solving Multi-Objective De Novo Programming Problems,” International Journal of Engineering Research in Computer Science and Engineering, vol. 5, no. 2, pp. 316-322, 2018.
[Google Scholar] [Publisher Link]

[16] Sylva Waribugo, Wilson Ofoegbu, and Ekom Akpan, “The Impact of Knowledge Management on Product Innovation of Manufacturing Firms in Nigeria,” Journal of Information and Knowledge Management, vol. 6, no. 6, pp. 78-87, 2016.
[Google Scholar] [Publisher Link]

[17] Ukamaka Cynthia Orumie, and Daniel Ebong, “A Glorious Literature on Linear Goal Programming Algorithms,” American Journal of Operations Research, vol. 4, no. 2, pp. 59-71, 2014.
[Google Scholar]

[18] T. Kliestik, M. Misankova, and V. Bartosova, “Application of Multi Criteria Goal Programming Approach for Management of the Company,” Applied Mathematical Sciences, vol. 9, no. 115, pp. 5715-5727, 2015.
[CrossRef] [Google Scholar] [Publisher Link]

[19] Abdelkrim Yahia-Berrouiguet, and Khadija Tissourassi, “Application of Goal Programming Model for Allocating Time and Cost in Project Management: A Case Study from the Company of Construction SEROR,” Yugoslav Journal of Operations Research, vol. 25, no. 2, pp. 283-289, 2015.
[CrossRef] [Google Scholar]

[20] Anuradha Gamage, “Application of Goal Programming Approach on Finding an Optimal Land Allocation for Five Other Field Crops in Anuradhapura District,” Operations Research and Applications an International Journal, vol. 4, no. 2, pp. 1-13, 2017.
[CrossRef] [Google Scholar]

[21] Bharat Bhushan, and Renu Sharma, and Hemlata Vasishtha, “A Goal Programming Technique for Decision Making in the Ethanol Production Planning,” IJSETR, vol. 3, no. 8, pp. 2095-2099, 2014.
[Google Scholar]

[22] O. Ezeokwelume, “Solving Linear Programming and Transportation Problems using Excel Solver,” International Journal of Scientific and Engineering Research, vol. 7, no. 9, pp. 134-142, 2016.
[Google Scholar]

[23] J. Magalhães-Mendes, “Multiobjective Optimization: Time-Cost Application in Construction,” Congress on Numerical Methods in Engineering, 2015.
[Google Scholar]