Excel - Linear Programming (Minimize Cost)

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024
  • This video shows how to solve a linear programming problem in excel to minimize cost.

Комментарии • 53

  • @sophialoaf1372
    @sophialoaf1372 4 года назад +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 года назад +3

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

    • @sophiawilson9696
      @sophiawilson9696 4 года назад

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

  • @peterpham5215
    @peterpham5215 3 года назад +1

    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.

  • @georgeaslanidis168
    @georgeaslanidis168 4 года назад +4

    Congratulations for this excellent tutorial!

  • @AndrewZavala
    @AndrewZavala 2 года назад

    This was excellent, very thorough. Thank you

  • @hazirah703
    @hazirah703 4 года назад +5

    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 3 года назад

      Yeah me too

  • @fuadawel2990
    @fuadawel2990 4 года назад

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

  • @dwaynedobson2798
    @dwaynedobson2798 4 года назад

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

  • @galikireven6675
    @galikireven6675 Год назад

    Thank you. This was very helpful 🙏

  • @SiriwanDeachasiriprapa
    @SiriwanDeachasiriprapa 10 месяцев назад

    Thanks a lot for your contribution

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

  • @tericacoleman5323
    @tericacoleman5323 3 года назад

    Wow! U explained this well. Thanks

  • @louism.4980
    @louism.4980 Год назад

    Thank you so much, sir! :)

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

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

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

  • @sidfoundit
    @sidfoundit 4 года назад

    Thank you for the video, Explained nicely.

  • @christianhustad7055
    @christianhustad7055 4 года назад

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

  • @IChannelOfficial
    @IChannelOfficial 2 года назад

    Huge thanks, sir!

  • @crgIN07
    @crgIN07 4 года назад

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

  • @ismaillahlou7730
    @ismaillahlou7730 2 года назад

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

  • @xuanzheng9513
    @xuanzheng9513 4 года назад

    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.

  • @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!

  • @krizziasthecyalegoria5304
    @krizziasthecyalegoria5304 3 года назад

    OMG!! THANK YOU MUCH!

  • @wilsonseto1
    @wilsonseto1 4 года назад

    my solution cell kept showing an error in value

  • @jmathew6988
    @jmathew6988 2 года назад

    Thank you.

  • @acwn27
    @acwn27 4 года назад

    Thanks!

  • @michaelt8804
    @michaelt8804 4 года назад

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

  • @UltimatePrinceofBB
    @UltimatePrinceofBB 4 года назад

    EGWOLF LANG MALAKAS

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

  • @alexandracopani1264
    @alexandracopani1264 3 года назад

    you made it look so easy! thank you!