Supply Chain Optimization

Welcome to Module 1, Optimization Defined. The word optimization has filled our lives in the last decade. Everywhere we turn, we either hear or see the word optimization, especially for those involved in marketing, supply chain, and operations. In this module, we will define optimization and describe its purpose in the supply chain. We will also identify the components of an optimization algorithm and see how to use an objective function in Excel. In our activity, we will practice formulating a maximization function.

Welcome to Module 2, Capacity Optimization. In the previous module, we described optimization in general and saw how to set up an optimization problem in Excel. Over these next two modules, we will dive into two specific examples of optimization: capacity optimization and resource optimization. In this module, we will identify the goal of capacity optimization and overview some examples of how it can be used in the supply chain. We will also demo the steps to create a capacity optimization problem in Excel and recall these steps for our quiz. In our activity, we will describe how everyday tasks or functions can benefit from capacity optimization.

Welcome to Module 3, Resource Optimization. In this module, we will identify the goal of resource optimization, how it differs from capacity optimization, and go through some industry examples. We will learn how to set up a resource optimization problem in Excel through our demo video and recall these steps in our quiz. Finally, we will put what we’ve learned into practice by setting up and solving a resource optimization problem in Excel.