Excel - Linear Programming (Minimize Cost)

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

[@sophialoaf1372]

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]

You’re welcome. Glad it helped. Good luck in your class.

[@sophiawilson9696]

@@crowsmathclass Could you do one using three x variables and three y variables?

[@peterpham5215]

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]

You’re welcome. Glad it helped.

[@hazirah703]

Shouldn't the solving method in solver be "Simplex LP" instead of "GRG Nonlinear"?

[@whatfork]

was about to ask the same thing. i think it was supposed to be simplex LP right?

[@ashley0238]

Yeah me too

[@georgeaslanidis168]

Congratulations for this excellent tutorial!

[@galikireven6675]

Thank you. This was very helpful 🙏

[@crowsmathclass]

You’re welcome. Glad it helped.

[@Ambigouos010Pronoun]

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]

I don’t believe you can graph this in excel.

[@AndrewZavala]

This was excellent, very thorough. Thank you

[@crowsmathclass]

Thank you.

[@manishanembang9396]

What if instead of 11 units of carbohydrate there is 11% of carbohydrate? Do we need to write same 11% or 0.11?

[@imneus7331]

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?

[@masoodabbasi2527]

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

[@crgIN07]

why use the non-linear solver and not the simplex linear solver?

[@christianhustad7055]

What does “Set objective must be a formula” mean??

[@fuadawel2990]

thank you for sharing u save me a lot of time and it was very clear god bless you

[@crowsmathclass]

Thank you. Glad it helped.

[@SiriwanDeachasiriprapa]

Thanks a lot for your contribution

[@crowsmathclass]

You’re welcome.

[@ismaillahlou7730]

Hello when I am doing the dollar stuff i do not get 0 but the normal answer

[@alexandracopani1264]

you made it look so easy! thank you!

[@crowsmathclass]

You’re welcome

[@dwaynedobson2798]

Thank you so much for the very detailed walk through!!

[@crowsmathclass]

You're welcome. Glad it helped.

[@tericacoleman5323]

Wow! U explained this well. Thanks

[@crowsmathclass]

Thank you. Glad it helped.

[@louism.4980]

Thank you so much, sir! :)

[@crowsmathclass]

You’re welcome.

[@xuanzheng9513]

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.

[@sidfoundit]

Thank you for the video, Explained nicely.

[@crowsmathclass]

Thank you. Glad it helped.

[@heeralgajjar298]

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!

[@IChannelOfficial]

Huge thanks, sir!

[@crowsmathclass]

You’re welcome.

[@jmathew6988]

Thank you.

[@crowsmathclass]

You’re welcome.

[@wilsonseto1]

my solution cell kept showing an error in value

[@krizziasthecyalegoria5304]

OMG!! THANK YOU MUCH!

[@crowsmathclass]

You’re welcome.

[@acwn27]

Thanks!

[@crowsmathclass]

You're welcome. Glad it helped.

[@michaelt8804]

Wait a minute... aren’t you Dixi Cryptid?¿?¿

[@UltimatePrinceofBB]

EGWOLF LANG MALAKAS

[@aliezekiel5426]

where the graph bro

[@crowsmathclass]

N4SH LIT Don’t need a graph. Excel is solving for us.

[@aliezekiel5426]

Steve Crow How do we know the feasible region? I thought we only can get that region by using graph only

[@crowsmathclass]

Excel is taking care of all that.

[@aliezekiel5426]

Steve Crow Okay thanks for sharing the video and answered my questions