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!
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.
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?
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.
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.
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.