Developing a multi-item, multi-product, and multi-period supply chain planning optimization model

Mohamed Sayed Alashhab; Ehab A Mlybari

doi:10.17485/IJST/v14i37.867

Article

Developing a multi-item, multi-product, and multi-period supply chain planning optimization model

VIEWS 2177
PDF 362

Indian Journal of Science and Technology

DOI: 10.17485/IJST/v14i37.867

Year: 2021, Volume: 14, Issue: 37, Pages: 2850-2859

Original Article

Developing a multi-item, multi-product, and multi-period supply chain planning optimization model

Mohamed Sayed Alashhab¹,^2*, Ehab A Mlybari¹

¹College of Engineering and Islamic architecture, Umm Al-Qura University, Makkah, Saudi Arabia
²Faculty of Engineering, Ain-Shams University, Cairo, Egypt

*Corresponding Author
Email: [email protected]

Received Date:18 May 2021, Accepted Date:19 July 2021, Published Date:03 November 2021

This work is licensed under a Creative Commons Attribution 4.0 International License.

Abstract

Objectives: To develop a multi-item, multi-product, and multi-period mathematical model that optimizes supply, production, distribution, and inventory planning for a supply chain network. Methods: Mixed Integer Linear Programming has been used to formulate the proposed model, while Excel and Evolver solvers have been used to solve problems regarding supply chain network (consisting of two suppliers and two retailers) for profit maximization. Findings: The analysis showed that the developed model has the ability to efficiently and effectively solve real-life problems of the multi-item, multi-product, and multiperiod supply chain. Novelty: The model considered multi-item, multi-product, and multi-period. In addition, it considers initial, final, and intermittent inventory in multi-periods. The model is solved using both Excel and Evolver solvers. The model assists organizations involved in the supply chain to design and plan their network efficiently.

Keywords: Supply chain; multi-item; multi-products; multi-periods; MILP;Excel; Evolver Solver

References

Chen CT, Huang SF. Order-fulfillment ability analysis in the supply-chain system with fuzzy operation times. International Journal of Production Economics. 2006;101(1):185–193. Available from: https://dx.doi.org/10.1016/j.ijpe.2005.05.003
Mentzer JT, DeWitt W, Keebler JS, Min S, Nix NW, Smith CD, et al. Defining supply chain management. Journal of Business Logistics. 2001;22(2):1–25. Available from: https://dx.doi.org/10.1002/j.2158-1592.2001.tb00001.x
Towill DR. Time compression and supply chain management ‐ a guided tour. Supply Chain Management: An International Journal. 1996;1(1):15–27. Available from: https://dx.doi.org/10.1108/13598549610799040
Alashhab MS. Developing a robust green supply chain planning optimization model considering potential risks. International Journal of GEOMATE. 2020;19(73):208–223. Available from: https://dx.doi.org/10.21660/2020.73.52896
Wang F, Lai X, Shi N. A multi-objective optimization for green supply chain network design. Decision Support Systems. 2011;51(2):262–269. Available from: https://dx.doi.org/10.1016/j.dss.2010.11.020
El-Sayed M, Afia N, El-Kharbotly A. A stochastic model for forward–reverse logistics network design under risk. Computers & Industrial Engineering. 2010;58(3):423–431. Available from: https://dx.doi.org/10.1016/j.cie.2008.09.040
Al-Ashhab MS, Nabil OM, Afia NH. Perishable products supply chain network design with sustainability. Indian Journal of Science and Technology. 2021;14(9):787–800. Available from: https://dx.doi.org/10.17485/ijst/v14i9.24
Dwivedi A, Jha A, Prajapati D, Sreenu N, Pratap S. Meta-heuristic algorithms for solving the sustainable agro-food grain supply chain network design problem. Modern Supply Chain Research and Applications. 2020;2(3):161–177. Available from: https://dx.doi.org/10.1108/mscra-04-2020-0007
Mogale DG, Kumar SK, Tiwari MK. Green food supply chain design considering risk and post-harvest losses: a case study. Annals of Operations Research. 2020;295(1):257–284. Available from: https://dx.doi.org/10.1007/s10479-020-03664-y
Chan FTS, Wang ZX, Goswami A, Singhania A, Tiwari MK. Multi-objective particle swarm optimisation based integrated production inventory routing planning for efficient perishable food logistics operations. International Journal of Production Research. 2020;58(17):5155–5174. Available from: https://dx.doi.org/10.1080/00207543.2019.1701209
Wang C. Research on Optimal Design of Short-Life Cycle Product Logistics Supply Chain Based on Multicriteria Decision Model. Security and Communication Networks. 2021;2021:1–12. Available from: https://doi.org/10.1155/2021/5564831
Al-Ashhab MS, Attia T, Munshi SM. Multi-Objective Production Planning Using Lexicographic Procedure. American Journal of Operations Research. 2017;07(03):174–186. Available from: https://dx.doi.org/10.4236/ajor.2017.73012
Al-Ashhab MS, Afia N, Shihata LA. Objective Effect on the Performance of a Multi- Period Multi-Product Production Planning Optimization Model. International Journal of Mechanical & Mechatronics Engineering IJMME-IJENS IJENS I J E N S. 2016;16(03).

Copyright

© 2021 Alashhab & Mlybari. This is an open-access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Published By Indian Society for Education and Environment (iSee)