1 16 Optimization Excel Supply Optimization Transportation Problem Excel Solver

Here I solve a transportation model using the Simplex method in Excel Solver. The transportation model is a linear optimization model that seeks to minimize the cost of shipping from sources such as factories to destinations such as warehouses or customer zones. This model is the basis for more advanced supply chain optimization models. In the previous video, I solved this problem manually.
Supply chain optimization is the process of ensuring that a supply chain operates at the highest levels of efficiency and effectiveness. This includes minimizing the total costs of manufacturing and transportation, which might consider sourcing, distribution, and inventory placement throughout the supply chain. Various optimization approaches are used to model complex transportation configurations.