Тёмный

Excel - Linear Programming (Minimize Cost) 

Steve Crow
Подписаться 61 тыс.
Просмотров 64 тыс.
50% 1

This video shows how to solve a linear programming problem in excel to minimize cost.

Опубликовано:

 

12 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 53   
@georgeaslanidis168
@georgeaslanidis168 4 года назад
Congratulations for this excellent tutorial!
@peterpham5215
@peterpham5215 3 года назад
Thank you very much for a great tutoring lesson. As a "low" tech guy with limited uses of Excel, I really appreciate your step-by-step instructions on using Excel Solver to solve this problem.
@crowsmathclass
@crowsmathclass 3 года назад
You’re welcome. Glad it helped.
@sophialoaf1372
@sophialoaf1372 4 года назад
Thank you!! I am taking MS3053 and Covid has impacted the resources we have for classes and I am glad that this is a very comprehensive video of this example.
@crowsmathclass
@crowsmathclass 4 года назад
You’re welcome. Glad it helped. Good luck in your class.
@sophiawilson9696
@sophiawilson9696 3 года назад
@@crowsmathclass Could you do one using three x variables and three y variables?
@dwaynedobson2798
@dwaynedobson2798 4 года назад
Thank you so much for the very detailed walk through!!
@crowsmathclass
@crowsmathclass 4 года назад
You're welcome. Glad it helped.
@AndrewZavala
@AndrewZavala 2 года назад
This was excellent, very thorough. Thank you
@crowsmathclass
@crowsmathclass 2 года назад
Thank you.
@masoodabbasi2527
@masoodabbasi2527 4 года назад
Thanks @Steve for wonderful tutorial. I have 4th degree polynomial (Quadratic) cost function to minimize, can you guide how to do it in excel to get minimum cost? Thanks
@alexandracopani1264
@alexandracopani1264 3 года назад
you made it look so easy! thank you!
@crowsmathclass
@crowsmathclass 3 года назад
You’re welcome
@sidfoundit
@sidfoundit 4 года назад
Thank you for the video, Explained nicely.
@crowsmathclass
@crowsmathclass 4 года назад
Thank you. Glad it helped.
@fuadawel2990
@fuadawel2990 4 года назад
thank you for sharing u save me a lot of time and it was very clear god bless you
@crowsmathclass
@crowsmathclass 4 года назад
Thank you. Glad it helped.
@xuanzheng9513
@xuanzheng9513 3 года назад
Hi steve i had a similar model as this however if its possible i would like to get in contact with you to see how i could work things out as i am facing some boundaries feasibility issue from solver.
@galikireven6675
@galikireven6675 Год назад
Thank you. This was very helpful 🙏
@crowsmathclass
@crowsmathclass Год назад
You’re welcome. Glad it helped.
@imneus7331
@imneus7331 2 года назад
Hi. If the question is asking to do a linear programming model and show the spreadsheet template, is it mean that I have to name the constraints instead of just typing 'constraint 1,2,3'? Or it is based on the question?
@heeralgajjar298
@heeralgajjar298 4 года назад
Hiii I’m super stuck on a similar problem like this, it would be great if I can get in touch with you and get some help!
@tericacoleman5323
@tericacoleman5323 3 года назад
Wow! U explained this well. Thanks
@crowsmathclass
@crowsmathclass 3 года назад
Thank you. Glad it helped.
@IChannelOfficial
@IChannelOfficial 2 года назад
Huge thanks, sir!
@crowsmathclass
@crowsmathclass 2 года назад
You’re welcome.
@SiriwanDeachasiriprapa
@SiriwanDeachasiriprapa 8 месяцев назад
Thanks a lot for your contribution
@crowsmathclass
@crowsmathclass 8 месяцев назад
You’re welcome.
@louism.4980
@louism.4980 Год назад
Thank you so much, sir! :)
@crowsmathclass
@crowsmathclass Год назад
You’re welcome.
@Ambigouos010Pronoun
@Ambigouos010Pronoun 3 года назад
very good. Matches the answer on the example in my textbook. now i know how to do it by excel, and by hand. Is there a way to generate a graph?
@crowsmathclass
@crowsmathclass 3 года назад
I don’t believe you can graph this in excel.
@christianhustad7055
@christianhustad7055 3 года назад
What does “Set objective must be a formula” mean??
@krizziasthecyalegoria5304
@krizziasthecyalegoria5304 3 года назад
OMG!! THANK YOU MUCH!
@crowsmathclass
@crowsmathclass 3 года назад
You’re welcome.
@acwn27
@acwn27 4 года назад
Thanks!
@crowsmathclass
@crowsmathclass 4 года назад
You're welcome. Glad it helped.
@manishanembang9396
@manishanembang9396 Год назад
What if instead of 11 units of carbohydrate there is 11% of carbohydrate? Do we need to write same 11% or 0.11?
@ismaillahlou7730
@ismaillahlou7730 2 года назад
Hello when I am doing the dollar stuff i do not get 0 but the normal answer
@crgIN07
@crgIN07 3 года назад
why use the non-linear solver and not the simplex linear solver?
@hazirah703
@hazirah703 3 года назад
Shouldn't the solving method in solver be "Simplex LP" instead of "GRG Nonlinear"?
@whatfork
@whatfork 3 года назад
was about to ask the same thing. i think it was supposed to be simplex LP right?
@ashley0238
@ashley0238 2 года назад
Yeah me too
@jmathew6988
@jmathew6988 2 года назад
Thank you.
@crowsmathclass
@crowsmathclass 2 года назад
You’re welcome.
@wilsonseto1
@wilsonseto1 4 года назад
my solution cell kept showing an error in value
@UltimatePrinceofBB
@UltimatePrinceofBB 3 года назад
EGWOLF LANG MALAKAS
@michaelt8804
@michaelt8804 3 года назад
Wait a minute... aren’t you Dixi Cryptid?¿?¿
@aliezekiel5426
@aliezekiel5426 4 года назад
where the graph bro
@crowsmathclass
@crowsmathclass 4 года назад
N4SH LIT Don’t need a graph. Excel is solving for us.
@aliezekiel5426
@aliezekiel5426 4 года назад
Steve Crow How do we know the feasible region? I thought we only can get that region by using graph only
@crowsmathclass
@crowsmathclass 4 года назад
Excel is taking care of all that.
@aliezekiel5426
@aliezekiel5426 4 года назад
Steve Crow Okay thanks for sharing the video and answered my questions