Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Logistics Optimization with Excel Solver
Rating: 4.4 out of 5(870 ratings)
3,173 students

Logistics Optimization with Excel Solver

Learn how to Use Excel Solver Add-in to Optimize Transportation and Distribution Networks
Created byLKB Training
Last updated 4/2019
English

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

Course content

7 sections • 26 lectures • 1h 30m total length

  • Course Structure1:40

    In this short video, the course structure is outlined.

  • About the Instructor !0:40

    Brief bio of the instructor !

Requirements

  • A computer with Microsoft Excel installed.
  • 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,

Transshipment Problem,

Production and Inventory Scheduling Problem. 

You'll also have the opportunity to test your knowledge with the additional worksheets, exercises and the short quizzes provided in the course.

On completion of this course, you will be very confident in modeling logistics problems into linear programs that can be optimized with Excel Solver. You will also be able to think structurally about the logistics problems and come up with sound business decisions.

Who this course is for:

  • Undergraduate and graduate business students (Logistics/ Supply Chain Majors)
  • Logistics professionals and business Owners
  • Beginners who are curcious about optimization using linear programming
  • Learners with no or little previous knowledge on the topic. This course is NOT for Advanced Learners

Report abuse