Description
Excel Supply Chain Analysis: Solving Transportation Problems. This course shows you how to use Microsoft Excel to minimize transportation and handling costs in your supply chain network. Microsoft Excel can be a strategic tool for tackling complex supply chain challenges. In this course, instructor Kurt Frye teaches you how to use the Excel Solver add-in to minimize the costs associated with transporting and transshipping goods between different origins and destinations. Course topics include analyzing fixed costs to make decisions about whether to open or close a facility, applying constraints on expected service levels, and performing various scenario analyses. It also includes practical exercises to solve the presented problems and step-by-step solutions for each problem. By following this course and working through its examples, learners can understand and apply the techniques used in specialized supply chain analysis software in an Excel environment. At the end of the course, participants will have the ability to model and solve transportation optimization problems and will be able to make more informed decisions in supply chain management that will lead to significant savings in operational costs.
What you will learn
- Using the Excel Solver add-in to optimize and minimize transportation and transshipment costs.
- Analyze and examine the impact of fixed costs on decisions related to facilities and warehouses.
- Applying Level of Service Constraints in optimization models to ensure customer needs are met.
- Conducting scenario analysis to evaluate results under different operating conditions.
- Identify and describe the techniques used by specialized supply chain management software in solving problems.
- Modeling and solving sample problems presented during the course.
This course is suitable for people who:
- They are looking to leverage the advanced capabilities of Microsoft Excel for supply chain analysis.
- They work in jobs such as transportation managers, supply chain analysts, or operations analysts.
- They intend to improve their skills in optimizing logistics and reducing operational costs.
- They want to understand how specialized software solves complex transportation problems.
- They are looking to acquire practical and applicable skills in the following areas:
- Transportation Management
- Microsoft Excel
- Supply Chain Analytics
Excel Supply Chain Analysis: Solving Transportation Problems Course Details
- Publisher: LinkedIn
- Instructor: Curt Frye
- Education level: Intermediate
- Training duration: 2 hours and 25 minutes
Course syllabus in 2024/6
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
Downloadly
Rapidgator link
File(s) password: www.downloadly.ir
File size
378 MB
