Excel for Supply Chain Analysis: Solve Transportation Issues – Radhe Global
Mastering Supply Chain Analysis and Decision-Making with Excel Solver
Instructor Names: Excel Insights
link: https://www.udemy.com/course/excel-for-supply-chain-analysis/
Objective
Fundamentals of Excel Supply Chain Analysis for Solving Transportation Problems Utilize Excel Solver: Learn to apply the Excel Solver add-in to minimize transportation and transshipment costs. Cost Analysis: Analyze and manage fixed costs and strategic facility opening decisions.
Curriculum
Introduction, Welcome, Introduction, Solve Transportation Issues, Describe the transportation issue, Outline a transportation model in Excel, Define decision variables, constraints, and total cost, Create and run the Solver model, Transshipment problem, Describe the transshipment problem, Outline a transshipment problem in Excel, Define decision variables, constraints, and total cost, Create and run the Solver model, Evaluate a Solver solution, Analyze Fixed Cost and Facility, Fixed cost and facility opening problems, Outline a linking constraint problem in Excel, Implement linking constraints in Excel, Create and run the Solver model, Level of Service Constraints, Describe level of service constraints, Outline level of service constraint analysis in Excel, Calculate level of service metrics, Create and run the Solver model, Practice, Test: Analyze a transportation problem, Answer: Analyze a transportation problem, Test: Analyze a transshipment problem, Answer: Analyze a transshipment problem, Test: Which distribution centers to open, Answer: Which distribution centers to open, Test: Level of service constraints problem, Answer: Level of service constraints problem, More Analysis, Change parameters by hand, Adjust distances using factors, Explore extreme scenarios, Find solutions based on a target cost, Perform sensitivity analysis, Conclusion, Conclusion
Paid (True/ False): True
No. Of Subscribers: 135
Rating: 5.0
No. Of Reviews: 1
Instructional Level: All Levels