Engineering Commons^™

Design Of A Multi-Echelon Global Supply Chain Network With Microsoftå¨ Excel Premium Solver Plataform, Wilder Ferreira

All Theses

I designed a global supply chain distribution model of one single product, with the objective of minimizing the costs of transportation, handling materials, duties and tariffs, production, and fixed infrastructure. The distribution network has a combination of manufacturing facilities (fixed and to-be-determined), warehouses (to-be-determined), distribution centers (to-be-determined), and customer zones at fixed locations. This network design is similar to the mathematical mixed-integer linear model from Tsiakis, Shah and Pantelides (2001). This model has been implemented in Microsoft Excel, using the Standard Simplex method from Frontline, Inc. This model optimizes the number of facilities worldwide (multi-echelon) along with the flow of …