No video

How to Setup & Solve Linear Programming Transportation Optimization with Excel Solver

  Рет қаралды 40,146

Matt Macarty

Matt Macarty

Күн бұрын

#excel #solver #minimize
Linear Programming - Transportation Problem - Network Problem
Please SUBSCRIBE:
www.youtube.co...
Transportation Optimization in Excel
alphabench.com...
Download the spreadsheet used in the tutorial at the link above
Demonstration of model development and the optimal solution of a network transportation model, or transportation problem, with Excel Solver. In this example, you would like to minimize the cost of shipping products to distribution points. You are given the cost to ship products along each path in a network of origins to destinations. You are also given forecast demand and production capacities. Learn how to build the model in Excel and then set up and use solver to minimize the cost associated with meeting product demand.

Пікірлер: 48
@88spaces
@88spaces 4 жыл бұрын
This lesson is helpful because it gives an example of linear optimization and uses the sum-product function which makes it easier to solve. Thank you, Matt.
@MattMacarty
@MattMacarty 4 жыл бұрын
Thanks. Glad it helped
@johnlivingood5715
@johnlivingood5715 2 жыл бұрын
I had subtitles on and it was still a very clear and informative video. Helped me through a project, thanks Matt.
@MattMacarty
@MattMacarty 2 жыл бұрын
Glad it helped
@moneyinahurry
@moneyinahurry 3 жыл бұрын
Thank you for laying it out extremely simply
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped
@stelladecarvalhofonseca5143
@stelladecarvalhofonseca5143 3 жыл бұрын
This lesson is so clear and straight to the point. Thank you so much for sharing!
@MattMacarty
@MattMacarty 3 жыл бұрын
Thank you. Glad it helped.
@EISSPORTVEREINZUG
@EISSPORTVEREINZUG 2 жыл бұрын
Thanks a lot! Your videos are great and so easy to understand!
@MattMacarty
@MattMacarty 2 жыл бұрын
Thank you. Glad it helped
@dooleyafq989
@dooleyafq989 3 жыл бұрын
Wow, thank you so much! Feels great to finally get that right answer.
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped.
@nguyenvuong7243
@nguyenvuong7243 2 жыл бұрын
The video sound is pretty good, beyond my imagination
@MattMacarty
@MattMacarty 2 жыл бұрын
Glad it helped
@neerajkumar-fd7qw
@neerajkumar-fd7qw 4 жыл бұрын
The most sorted video on this topic Thank a lot Sir
@MattMacarty
@MattMacarty 4 жыл бұрын
Glad it helped
@gardenboydon
@gardenboydon 2 жыл бұрын
Fantastic and very helpful! Thank you
@MattMacarty
@MattMacarty 2 жыл бұрын
Thanks. Glad it helped
@kylekaske548
@kylekaske548 3 жыл бұрын
excellent video! you explained this better than my professor
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped!
@isadorabarradas1234
@isadorabarradas1234 3 жыл бұрын
Thank you very much, Matt! Loved this video!
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped.
@SR-fl7ki
@SR-fl7ki 4 жыл бұрын
Great video! Thank you so much!
@MattMacarty
@MattMacarty 4 жыл бұрын
Thanks. Glad it helped
@ayseerdem5154
@ayseerdem5154 3 жыл бұрын
Thank you for the great tutorial!
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it was helpful!
@dipitmill
@dipitmill Жыл бұрын
Thnx, this video helped aloot!
@MattMacarty
@MattMacarty Жыл бұрын
Glad it helped!
@OverlordOfDarkness95
@OverlordOfDarkness95 2 жыл бұрын
This was very interesting.
@MattMacarty
@MattMacarty 2 жыл бұрын
Thanks. Glad it helped
@sunny19916
@sunny19916 3 жыл бұрын
thanks a lot Sir, very helpful. Request you to kindly share different problems
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped. Let me see what I can do.
@AniMax_cjs
@AniMax_cjs 3 жыл бұрын
thank you so much, helped a lot.
@MattMacarty
@MattMacarty 3 жыл бұрын
Glad it helped!
@tompoknongthombam6644
@tompoknongthombam6644 4 жыл бұрын
Great video Sir. Love from India
@MattMacarty
@MattMacarty 4 жыл бұрын
Thanks. Glad it helped
@ericgibson9206
@ericgibson9206 2 жыл бұрын
Thanks!
@MattMacarty
@MattMacarty 2 жыл бұрын
Glad it helped
@itsmejohnson5931
@itsmejohnson5931 2 жыл бұрын
Thanks a Ton Sir! How did you come up with capacity and demand numbers ? How can I show you the matrix I have? It has the same suuply and demand values.
@MattMacarty
@MattMacarty 2 жыл бұрын
I just made up the numbers I used for this problem.
@itsmejohnson5931
@itsmejohnson5931 2 жыл бұрын
I'm getting excel solver couldn't find feasible solution. Why?
@MattMacarty
@MattMacarty 2 жыл бұрын
Likely due to a missing constraint or the wrong direction in an inequality
@monicafernando6662
@monicafernando6662 4 жыл бұрын
Hi, can you help me solve this below problem:? Let set M contain the sources that generate waste and N denote the set which includes all disposal sites. The amount of waste generated at source i is w_i and capacity of disposal site j is c_j. Let K denote the set of candidate transfer facilities. Each candidate transfer facility k has a fixed cost f_k , capacity cost q_k and processing cost α_k per tonne of waste. Let d_ik denote the distance from source i and transfer facility k and d_kj denote the distance from transfer facility k and disposal site j. A typical waste flow is as follows: From source i to transfer facility k, then from transfer facility k to disposal site j. Formulate an optimization problem such as the cost of transportation and fixed cost of locating transfer facilities is minimized. Present the formulation in general form For |M| = 4; |N| = 4 and |K| = 3, assume other quantities (w_i,c_j,f_k,α_k ,d_ik etc.,) and solve the problem in excel and present the results (Also ensure d_ik + d_kj≤ d_ij)
@MattMacarty
@MattMacarty 4 жыл бұрын
Hi, this problem is very similar to what was presented in my video. While I can't really solve it through comments, you can download the file I used here: alphabench.com/data/linear-programming-transportation-problem.html You should then replace my variables with yours to repurpose the model for your problem.
@monicafernando6662
@monicafernando6662 4 жыл бұрын
@@MattMacartythank you so much!
@MattMacarty
@MattMacarty 4 жыл бұрын
@@monicafernando6662 Glad it helped
@suyziljackson8202
@suyziljackson8202 2 жыл бұрын
i got a degenerate solution
@MattMacarty
@MattMacarty 2 жыл бұрын
Check you constraints. You may have one duplicated.
Solve Linear Program problem in Excel (Solver)
5:22
Joshua Emmanuel
Рет қаралды 112 М.
ROLLING DOWN
00:20
Natan por Aí
Рет қаралды 8 МЛН
Son ❤️ #shorts by Leisi Show
00:41
Leisi Show
Рет қаралды 10 МЛН
Stay on your way 🛤️✨
00:34
A4
Рет қаралды 32 МЛН
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 43 МЛН
Class-9;Polynomials Part-3
30:05
Maths with varsha
Рет қаралды 1
Solving LP Transportation Problem | Excel Solver
5:39
Joshua Emmanuel
Рет қаралды 53 М.
Linear Programming (LP) Optimization with Excel  Solver
17:32
Matt Macarty
Рет қаралды 631 М.
Intro to Linear Programming
14:23
Dr. Trefor Bazett
Рет қаралды 183 М.
Linear Programming Solver Excel
23:28
Jason Bitmead
Рет қаралды 102 М.
Linear Optimization in Excel with Solver Add-in | LPP in Excel
11:11
Sane's Academy of Artificial Intelligence
Рет қаралды 34 М.
Solving Transportation Problems in Excel
5:43
Neha Mittal
Рет қаралды 247 М.
ROLLING DOWN
00:20
Natan por Aí
Рет қаралды 8 МЛН