Solving LP Transportation Problem | Excel Solver
Вставка
- Опубліковано 26 лип 2024
- 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
Sir, you are an absolute life saver. Thank you
brooo I was doing that for 3 hours, solved it in 5 minuts with this video, thx!!
THANKYOU SO MUCH! CURRENTLY REVIEWING FOR MY COMPREHENSIVE EXAM. IT HELPS ME A LOT
You saved my life. Thank you!!!
This is simply wonderful explanation. Thank you for doing this
great job! helped a lot
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!
My pleasure, Ehgine.
Great video. Concise, to the point. Thank you
Great video, very helpful :)
Was very helpful!
Awesome...Thanks you
Best explanation on internet
Super hpful!!
thank you so much
Good Joshu
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.
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.
Maybe this is too ‘out of the box’ but I think you could make ‘Harry Potter houses’ with this as well…..
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.
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
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.
Thanks
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?
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.
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?
I'm sorry, I don't work with VBA at all.
What if there s an unbalanced transportation problem and we are being charged a penalty per each undelivered product unit ?
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.
what signs should we use when Total Demand is equal to Total Demand ?? 1:36
When total demand equals total supply, use "= " throughout.
If each customer has to be in just one plant, so what will we do?
I don't get your question. Can you rephrase?
@@joshemman I mean If the condition is that each customer can only stay in one plant, what should be done? Thank you.
for example: customer 4 just plant 1 or plant 3, not both of them
@@nguyen_thi_quyenYou have to define binary variables:
Yij = 1 if Plant i ships to Customer j; 0 otherwise
Then
Y14 + Y24 + Y34 = 1
@@joshemman Can you explain it a bit more? I mean what would be the formula we should type in solver?
If total supply is less than total demand then what we have to do
If total supply is less than total demand, then use "=" for Supply and use "
Whether this is for the the case if the total supply is less than total demand
You're right, I just edited the statement.
But the goal is too minimize the total distribution costs for the problem so what I have do in that case
@@joshemmanpls let me know for the below doubt
you are alifesaver