The modeling and re-design of global supply chains is a very hot topic these days, fueled by widespread tariff changes across the major world economies.

Our team has created a complete supply chain design and optimization model in Excel, using Excel’s Solver as the optimization engine to solve specific scenarios. We have modeled an end-to-end operation, from the purchase of raw materials at suppliers, to the shipment of finished goods to markets. We have also included tariffs in the model.

This complimentary model will be useful to those of you interested in what this is all about, as well as those of you currently considering a supply chain design and optimization project in your organization.