Solving LP Transportation Problem | Excel Solver

How to use Solver in Excel to solve a transportation problem.

00:00 Components of Transportation matrix
00:22 Setting up for Solver
02:11 Loading Solver Addin
02:41 Solving the LP Problem
03:37 Solver Output and Answer Report
04:19 Prohibited Routes

[lmablackbird]

Sir, you are an absolute life saver. Thank you

[rayanmnasri]

brooo I was doing that for 3 hours, solved it in 5 minuts with this video, thx!!

[ehginemaeann]

Thank you so much! I learned a lot from your discussion. We are going to report this topic in class and I was really wondering how the book derived the optimal solution of transportation problem because it did not show how. Thanks God I found youu. Again, thank you so much! God Bless and more power!

[fasahiah]

This is simply wonderful explanation. Thank you for doing this

[maryjoycawaling]

THANKYOU SO MUCH! CURRENTLY REVIEWING FOR MY COMPREHENSIVE EXAM. IT HELPS ME A LOT

[enavedab]

What if there s an unbalanced transportation problem and we are being charged a penalty per each undelivered product unit ?

[godisgood]

XYZ company during the festival season combines two items A and B to form gift packs. Each pack must not weight more than 5 kg should contain at least 2 kg of A and not more than 4 kg of B. The net contribution to the company is taka 10 per kg of A and taka 12 per kg of B. the company wants to determine the optimum mix.

[nguyen_thi_quyen]

3:38: if I would like that the answer (solver output) only shows these numbers 0, 250, 380, 500 and 550 instead of other numbers like 330, 50 or 450, what should it be? Thank you so much.

[godisgood]

How to formulate and do by simplex method, XYZ company during the festival season combines two items A and B to form gift packs. Each pack must not weight more than 5 kg should contain at least 2 kg of A and not more than 4 kg of B. The net contribution to the company is taka 10 per kg of A and taka 12 per kg of B. the company wants to determine the optimum mix.

[Juanderfully]

Great video. Concise, to the point. Thank you

[julianizdebski]

Maybe this is too ‘out of the box’ but I think you could make ‘Harry Potter houses’ with this as well…..

[xero]

Hi Joshua, i am having an error occur when i attempt to multiply the objective coefficients by the decision variables. When i use the =SUMPRODUCT( and select the decision variables, i get "There's a problem with this formula error. It suggests i am not trying to type a formula. Do you know what i am doing wrong?

[skc]

Hi, thanks for the video but i have a question. How can i do exactly same thing with excel vba. i must use the excel developer its very important. Could you help me?

[nirajsatwani]

what signs should we use when Total Demand is equal to Total Demand ?? 1:36

[cococnk]

Hello Joshua, hope you are doing well, I come from a non traditional background, working on my own to become a data analyst. I have an interview for the role "Transport Analyst", can this video help for the interview? Do you know excel concepts I can study for the interview. Thanks

[nguyen_thi_quyen]

If each customer has to be in just one plant, so what will we do?

[jaswantviews]

If total supply is less than total demand then what we have to do