Solving Transportation Problems With Excel (OnDemand Webinar)

$149.00

SKU: 410066EAU

Description

Utilize Excel to reduce transportation costs, increase the profit, and develop longterm transportation strategies.Supply chain management has become one of the most challenging topics that concern companies currently due to its direct influence on their revenues and margins. This complex network that links suppliers to final customers requires a huge cost control to remain competitive in the market, and transportation constitutes a leading factor in costefficiency strategies for companies. Here is where the transportation problem comes in, as it is a mathematical optimization problem that will help you find the most costeffective way to distribute a product from a set of locations to a set of customers. This presentation will provide you with a clear definition of the transportation problem, its types, and the steps you should follow to solve it in Excel using the Solver tool. This topic is important as it will allow you to reduce transportation costs and the environmental impact, increase the profit, and develop longterm transportation strategies.

Date: 2023-02-24 Start Time: End Time:

Learning Objectives

Introduction to Transportation Problems
• Transportation Management State of Art
• Introduction to Linear Programming and Transportation Problems

Formulating a Transportation Problem in Excel® With Case Study
• Introducing the Case Study
• Building the Necessary Tables of the Model in Excel®
• Handling Unbalanced Supply and Demand

Solve the Transportation Problem Using the Excel® Solver Tool
• Specifying the Target Cell and Decision Variables
• Setting Up the Solver Constraints Running the Solver
• Interpreting the Results

Best Practices and Advanced Techniques
• Best Practices for Maximizing Efficiency and Accuracy
• Advanced Techniques for Tackling Complex Problems

Questions, Answers, and Discussion

ISM ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Mohammed Boualam-DISLOG Group, Khalid Idrissi – JESA Group