Skip to content
UdemyExcelPaid courseBeginner levelCertificate

Logistics Optimization with Excel Solver (Udemy.com)

Learn how to Use Excel Solver Add-in to Optimize Transportation and Distribution Networks

Created by: LKB Training

Last updated April 2019

icon
What you will learn

  • Formulate Linear Programming models for logistics problems
  • Use Excel Solver to find optimal solutions for logistics problem
  • Interpret the Excel Solver solution

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews893#185 of 356 by number of reviews
  • Length1.5 hoursshorter than 90% of them
  • Last updatedApril 2019earlier than 79% of them

icon
Course 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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

LKB Training

LKB is a team of professional & passionate academics, specialized in the area of Logistics and Supply Chain.

We believe that there are always better and new ways to perform tasks. That's why we are committed to provide high quality courses that help learners grow and develop their skills set.

We Love Logistics ! , and we hope you'll also love it. 

icon
More Excel courses

$11.99

Original price $39.9970% off

Free

$14.99

Original price $99.9985% off

Free

$15.99

Original price $109.9985% off

$16.99

Original price $119.9986% off

icon
Reviews

4.5

893 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Anantharaman Murali on 7/17/2026

Excellent course as I learned the course the author , made me complete the course in one short no breaks( some unavoidable) full of curious and interest no where we felt bore , I expect more on non linear as well and dummy concept can also be explained instead of notes , over all I enjoyed & waiting for his next session :)

By Shaniek Watson on 10/24/2024

A course as detailed as this requires a live tutor whether online or in person. Self learning is good however not always suitable for this type of content. Once with opportunity to ask questions and obtain clarification on grey areas

By Jake Alexander Kenneth Dionne on 10/15/2024

Extraordinarily helpful course, with a great tool at the center of everything! I would have liked a different format for the assignments section, but it was good overall. The only issue I really had was with some user error on Assignment 3 but other than that it was great!

By Mazen Al-Sakkaf on 5/23/2023

I recently completed the course and I must say it was an amazing experience. The course was well-structured and the instructor was knowledgeable and engaging. I learned a lot about using Excel Solver to optimize logistics operations and I feel confident in applying these skills in my work. I highly recommend this course to anyone looking to improve their logistics optimization skills.

By Anna Pilatowska on 10/5/2022

The course is tought in an easy way, that even a beginner can understand the special tool which is solver. Moreover the examples are very wide so many circumstances are taken into account during this course.

By Pavlos Adamidis on 8/15/2022

Very nice course, which drills very well into the application of linear programming in the three problems described. Would be very interesting if there is an extension to this course, or maybe another course, which also covers linear goal programming and e-constraint, since the criteria nowadays that need to be considered when solving logistics problems are not only cost reduction, but others as well, including: - Maximizing Customer Satisfaction - Minimizing Transportation Emissions amongst others. Overall, this course covers the basics very well and I am satisfied. Cheers!

By Humayun Omar on 8/6/2021

Excellent Course. Great content, wonderfully explained. The concepts were very clear and problems that were solved were very helpful in implementing the LP Logistics Solver in any Logistics related or material related problems. Hope to see more of your courses. Thanks :)

By Simon Wood on 11/8/2020

Yes, it is what I expected

By Kwabena kyeremateng on 10/21/2020

It was a good match.

By Hlio Teles on 10/18/2020

That is pretty good and straight forward course! Totally recommended! I would suggest just to add a non-linear problem as a last section and show how to deal with discontinuity functions.
Cheers!

By Binh Duong Nhat on 9/24/2020

many thanks

By Nguyn Thnh Trung on 9/10/2020

This course is great opportunity to review my knowledge. Thanks

Showing 12 of 62 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100