Скачать или смотреть Supply Chain Analysis 102 Transportation Optimization Solver

Hi Everyone.

In this video, we use Excel Solver to solve one of the most common supply chain optimization problems — the Transportation Problem.

⚙️ Model Setup

Scenario:
2 plants (North, South)
3 markets (M1, M2, M3)
Each plant has limited supply, each market has fixed demand
Cost per ton differs by route

Solver Settings:
Set Objective: B15 → Minimize total cost
Changing Variables: B10:D11
Constraints:
E10 = E4 (North supply)
E11 = E5 (South supply)
B12 = B6 (Demand M1)
C12 = C6 (Demand M2)
D12 = D6 (Demand M3)
B10:D11 = 0

Solver will automatically find the optimal shipment plan that minimizes total cost while satisfying all supply and demand.

#SupplyChainAnalytics #ExcelSolver #TransportationOptimization #LogisticsOptimization #SupplyChainPlanning #ExcelForSupplyChain #OperationsResearch #NetworkOptimization #ManufacturingAnalytics #BusinessAnalytics #ExcelTips #SCM #Logistics #OptimizationModel #DecisionScience #SupplyChainManagement #DataDrivenSupplyChain #ProcessOptimization #ChainChainowski