
Outline a transportation model in Excel by setting up demand, capacities, and miles between cities. Copy data, designate changing cells, and transpose capacities to prepare for analysis and cost calculations.
Define decision variables, constraints, and total cost in Excel for a transportation problem by using autosum checks, sumproduct with the distance matrix, and Solver to find the lowest cost solution.
Define decision variables, constraints, and a cost in an Excel transshipment model. Enforce conservation of flow from factories to centers to customers, and compute inbound, outbound, and costs with sumproduct.
Minimize total cost in a transshipment network using Excel solver by defining demands, capacities, and conservation of flow, and setting objective, variable cells, and integer constraints with simplex LP.
Learn to build a solver model in Excel to minimize total cost in a two-facility transportation problem, using open/close binary variables, capacity constraints, and simplex LP.
Learn how to manually adjust demand and other parameters in a transportation problem to test business performance with a solver, and observe how shifts affect routing and capacity.
Unlock the power of Microsoft Excel to tackle intricate supply chain challenges with our comprehensive course, "Excel for Supply Chain Analysis: Solve Transportation Problems." This course is designed to transform your approach to managing transportation and transshipment costs by leveraging the Excel Solver add-in.
Course Highlights:
Optimize Transportation Costs: Learn how to use Excel Solver to efficiently minimize transportation and transshipment expenses within your supply chain.
Analyze Fixed Costs: Dive deep into assessing fixed costs and making strategic decisions about facility openings to enhance cost-effectiveness.
Enforce Service Level Constraints: Understand how to implement and manage service level constraints to ensure your supply chain meets required performance standards.
Scenario Analysis: Gain the skills to conduct thorough scenario analysis, allowing you to evaluate different strategies and their potential impacts.
Practical Problem Scenarios: Apply your knowledge to real-world problem scenarios provided throughout the course. Work through these examples and review comprehensive solutions to solidify your understanding.
By the end of this course, you'll not only master the techniques used by specialized supply chain programs but also be able to replicate these methods using Excel. Whether you're aiming to improve your current supply chain strategies or seeking to develop new skills, this course offers practical, hands-on experience to advance your expertise.