Back to search

Clemson University

DESIGN OF A MULTI-ECHELON GLOBAL SUPPLY CHAIN NETWORK WITH MICROSOFTå¨ EXCEL PREMIUM SOLVER PLATAFORM

Abstract

dc:description.abstract

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 materials per transportation node to meet demand of several regions of the world. Any combination of nodes is possible, although the production rate at each manufacturing facility must be able to provide all materials required at each region - no extension is allowed. A supplementary mixed-integer model is provided to address country's economic freedom when selecting global manufacturing sites.

Degree

thesis:*
Name thesis:degree_name
Master of Science (MS)
Level thesis:degree_level
Thesis
Discipline thesis:degree_discipline
Industrial Engineering

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Ferreira, Wilder
Contributors dc:contributor
  • Kurz, Mary Beth
  • Ferrell , William
  • Mayorga , Maria E

Subjects

dc:subject × 5

Identifiers

dc:identifier.*
Repository record dc:identifier
https://open.clemson.edu/all_theses/534

Chain of custody

source
Harvested from
Clemson University
Base URL
open.clemson.edu/do/oai/
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Ferreira, Wilder. DESIGN OF A MULTI-ECHELON GLOBAL SUPPLY CHAIN NETWORK WITH MICROSOFTå¨ EXCEL PREMIUM SOLVER PLATAFORM. Thesis thesis, https://open.clemson.edu/all_theses/534