Learn how to Use Excel Solver Add-in to Optimize Transportation and Distribution Networks
What you'll learn

Formulate Linear Programming Models for Logistics Problems

Use Excel Solver to Find Optimal Solutions for Logistics Problem

Interpret the Excel Solver Solution

Requirements

Basic Understanding of Logistics Concepts (e.g. Transportation, Distribution, Cost)

Description

Logistics Management is typically concerned with managing the flow of products across the supply chain efficiently and effectively. The task of planning and managing such flow is critical if the company is to compete in the marketplace. Transportation is one of the critical key activities of logistics and it constitutes a large proportion of the logistics cost. Almost every company deals in some way or another with transporting its products from where they are made to where they are consumed.

Linear Programming is a commonly used model in management science and it has a wide range of applications in many different areas of business management. In this course, you will learn how to apply the linear programming techniques to optimize logistics flows across the supply chain network using the Excel Solver Add-in.

We will start from the very basic definition of Linear Programming, how to formulate and solve Linear Programming models, and subsequently we will extend what we have learned to step-by-step solve and optimize more complex logistics problems.

You will be introduced to three critical issues in Logistics Management and Distribution Planning:

Transportation Problem,