• P-ISSN 0974-6846 E-ISSN 0974-5645

Indian Journal of Science and Technology


Indian Journal of Science and Technology

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

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


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


  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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).


© 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)


Subscribe now for latest articles and news.