SUNConferences, SAIIE NeXXXt

Font Size: 
Using Excel solver in the optimization of prepositioned disaster relief supply chain in a humanitarian operation
Jean-Claude Munyaka Baraka, Sarma Yadavalli, Mendon Dewa

Last modified: 2019-08-30


In this research, a transportation problem is resolved using Excel solver. This study intends to optimize transportation time and cost solution in order to assist humanitarian operations to prepositioned Distribution Centre (DC) in SADC countries. The objective of this research is to develop a holistic approach to regional humanitarian supply chain including all countries and their available transportation modes.  Following selected assumptions and constraints, the results reveal that incorporating all SADC countries and their available transportation modes into the transportation problem optimize the region response capacity by minimizing transportation cost during a disaster relief operation.

Full Text: PDF