Excel - Linear Programming (Minimize Cost)

No video

Excel - Linear Programming (Minimize Cost)

Рет қаралды 64,028

Steve Crow

4 жыл бұрын

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

Пікірлер: 53

@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 4 жыл бұрын

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

@sophiawilson9696 3 жыл бұрын

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

@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 3 жыл бұрын

You’re welcome. Glad it helped.

@georgeaslanidis168 4 жыл бұрын

Congratulations for this excellent tutorial!

@AndrewZavala 2 жыл бұрын

This was excellent, very thorough. Thank you

@crowsmathclass 2 жыл бұрын

Thank you.

@galikireven6675 Жыл бұрын

Thank you. This was very helpful 🙏

@crowsmathclass Жыл бұрын

You’re welcome. Glad it helped.

@hazirah703 3 жыл бұрын

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

@whatfork 3 жыл бұрын

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

@ashley0238 2 жыл бұрын

Yeah me too

@fuadawel2990 4 жыл бұрын

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

@crowsmathclass 4 жыл бұрын

Thank you. Glad it helped.

@SiriwanDeachasiriprapa 8 ай бұрын

Thanks a lot for your contribution

@crowsmathclass 8 ай бұрын

You’re welcome.

@dwaynedobson2798 4 жыл бұрын

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

@crowsmathclass 4 жыл бұрын

You're welcome. Glad it helped.

@alexandracopani1264 3 жыл бұрын

you made it look so easy! thank you!

@crowsmathclass 3 жыл бұрын

You’re welcome

@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 3 жыл бұрын

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

@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

@louism.4980 Жыл бұрын

Thank you so much, sir! :)

@crowsmathclass Жыл бұрын

You’re welcome.

@sidfoundit 4 жыл бұрын

Thank you for the video, Explained nicely.

@crowsmathclass 4 жыл бұрын

Thank you. Glad it helped.

@tericacoleman5323 3 жыл бұрын

Wow! U explained this well. Thanks

@crowsmathclass 3 жыл бұрын

Thank you. Glad it helped.

@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?

@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 2 жыл бұрын

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

@christianhustad7055 3 жыл бұрын

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

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