Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Supply Chain Analysis: Solve Transportation Issues
Rating: 4.6 out of 5(11 ratings)
245 students

Excel for Supply Chain Analysis: Solve Transportation Issues

Mastering Supply Chain Analysis and Decision-Making with Excel Solver
Created byExcel Insights
Last updated 5/2025
English

What you'll learn

  • 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.
  • Scenario Analysis: Perform scenario analysis to evaluate different supply chain strategies and their outcomes.
  • Practical Problem Solving: Work through real-world problem scenarios and review detailed solutions.
  • Advanced Techniques: Understand techniques used by specialized supply chain programs and how to replicate them in Excel.

Course content

8 sections33 lectures2h 25m total length
  • Welcome1:19
  • Introduction2:03

Requirements

  • Familiar with functions

Description

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.

Who this course is for:

  • This course is ideal for supply chain professionals, analysts, and managers who want to enhance their ability to solve transportation problems using Excel.