Solving LP Transportation Problem | Excel Solver

[@lmablackbird9389]

Sir, you are an absolute life saver. Thank you

[@ehginemaeann3851]

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!

[@joshemman]

My pleasure, Ehgine.

[@rayanmnasri1400]

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

[@maryjoycawaling957]

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

[@fasahiah]

This is simply wonderful explanation. Thank you for doing this

[@zizo8737]

Best explanation on internet

[@jakestavely4939]

You saved my life. Thank you!!!

[@Juanderfully]

Great video. Concise, to the point. Thank you

[@gevaniokortstam7042]

Was very helpful!

[@udemezueonyinye6371]

Awesome...Thanks you

[@julianizdebski5035]

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

[@kirasidhu-pd2il]

Great video, very helpful :)

[@godisgood0223]

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.

[@yooouyt]

thank you so much

[@amjadaliikram3560]

Good Joshu

[@godisgood0223]

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.

[@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.

[@alyannatanap3591]

Super hpful!!

[@sk0c]

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?

[@joshemman]

I'm sorry, I don't work with VBA at all.

[@cococnk388]

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

[@joshemman]

I will suggest tailoring your prep along the job qualifications and responsibilities. If you want, you can also watch the Transhipment videos on this channel.

[@cococnk388]

Thanks

[@enavedab9281]

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

[@joshemman]

In that case, you can determine the number of undelivered units, multiply it by the penalty per unit, and add it to the shipping costs.

[@xero99]

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?

[@joshemman]

Check to be sure the “variable cells” do not contain other characters. You can copy an empty (unformatted) cell and paste in the “variable cells” to see what happens.

[@nirajsatwani8548]

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

[@joshemman]

When total demand equals total supply, use "= " throughout.

[@nguyen_thi_quyen]

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

[@joshemman]

I don't get your question. Can you rephrase?

[@nguyen_thi_quyen]

@@joshemman I mean If the condition is that each customer can only stay in one plant, what should be done? Thank you.

[@nguyen_thi_quyen]

for example: customer 4 just plant 1 or plant 3, not both of them

[@joshemman]

@@nguyen_thi_quyenYou have to define binary variables: Yij = 1 if Plant i ships to Customer j; 0 otherwise Then Y14 + Y24 + Y34 = 1

[@erginerceltik9525]

@@joshemman Can you explain it a bit more? I mean what would be the formula we should type in solver?

[@jaswantviews7353]

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

[@joshemman]

If total supply is less than total demand, then use "=" for Supply and use "

[@jaswantviews7353]

Whether this is for the the case if the total supply is less than total demand

[@joshemman]

You're right, I just edited the statement.

[@jaswantviews7353]

But the goal is too minimize the total distribution costs for the problem so what I have do in that case

[@jaswantviews7353]

​@@joshemmanpls let me know for the below doubt

[@user-ts1kn3jp3q]

you are alifesaver

[@shittyworld]

great job! helped a lot