Linear Programming: Blending/Mixing with Excel Solver (Flexible Recipe)

Поделиться
HTML-код
  • Опубликовано: 2 фев 2025

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

  • @SeanWyatt-h6f
    @SeanWyatt-h6f 4 месяца назад

    Thank you! I did not even know that I was trying to solve a flexible variable problem until I saw you define it. That is staying in my toolbox.

  • @tbirdspy8911
    @tbirdspy8911 11 месяцев назад

    This was a huge help completing my homework assignment in time. Thank you!

  • @tubuddcfo5833
    @tubuddcfo5833 4 года назад +1

    thanks a lot for the linearisation tip! I was struggling with my assignment and didn't understand why it didn't work, now I know how to resolve it. Also the way that you explained different types of the problems in your videos is very easy for new learners to categorise the problems and sort out how to solve it. So helpful!

    • @TallysYunes
      @TallysYunes  4 года назад +1

      You're welcome. Glad it was helpful.

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

    Wonderful examples explained in a logical and simple way.

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

      Thank you for this kind compliment! I'm happy to hear you liked the video!

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

    This is the BEST explanation of a flexible blending problem. Thank you so much. New subscriber here.

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

      Thank you so much! I appreciate your subscribing! Glad the video was helpful.

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

    It looks so easy when its done wow. Thank you for your work!

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

    Thank you this was very helpful.

  • @patricksydow4266
    @patricksydow4266 2 года назад +1

    Very well explained. I would like to see one with cost minimization.

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

      Thanks! You could simply remove the revenue portion from the objective function, delete the negative sign in front of the cost portion, and switch the "max" to a "min." That's it!

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

    thank you , really helped out

  • @JohnFerrante-ep3jw
    @JohnFerrante-ep3jw 8 месяцев назад

    dude! I just enrolled in a mba and they have me doing linear optimization. The initial problems weren't bad, but it just seriously kicked up a notch. Would really appreciate if I could send you this one problem in particular and see how you would approach it.

    • @TallysYunes
      @TallysYunes  8 месяцев назад

      I can't do homework for you, but it's likely that the one you need to tackle is similar to one of the examples in my videos. Look through my Excel Models playlist.

    • @JohnFerrante-ep3jw
      @JohnFerrante-ep3jw 8 месяцев назад

      @@TallysYunes of course not! I'll be sure to check out the videos. I'm struggling with determining if it's blending or allocation, and determining the inequalities for blending. Especially when there's multiple rates and units of measurement. Do you offer tutoring?

    • @TallysYunes
      @TallysYunes  8 месяцев назад

      At the moment I don't have time for one-on-one tutoring, but this is something your teacher would be able to clarify for you (it's their job). Have you tried reaching out to them? Do they offer office hours?

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

    Can you tell me how to tackle this kind of problems when the components have a specific range of amount to be used(As an example - S should contain atleast 2 gallons of component 1 and atmost 5 gallons of component 1)

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

      You just add two more constraints. In my gasoline example:
      C1S >= 2 and C1S

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

      @@TallysYunes I had a feeling it might be something like this but wasn't sure .. Thanks a lot❤️

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

    How can we detect problems in the constraints of this type of blending problems?, can you give a textbook reference on the subject?

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

      What do you mean by detect problems in the constraints? Determining whether or not a constraint is correct is equally difficult for all kinds of problems. It takes practice. There are several good books on modeling. One of them is "Model Building in Mathematical Programming" by H. Paul Williams.

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

      @@TallysYunes so there's no heuristic to find if the constraints are making the problem unfeasible or trivial? Suppose you have a number of n blendings, if the constraints are too loose would there be overlap in the blendings such that blend m is similar or equal to blend n, and the problem is unfeasible, is that why there's redundancy en the constraint matrix, what would be the clue if that is so, or am I completely wrong? How would I understand that from the constraint matrix. Sorry for the convoluted question...

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

      I'm self studying so that's why I took myself down this labyrinth ... Thanks 🙏🏼

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

      Your question makes sense. Finding a constraint or set of constraints that are responsible for the infeasibility of a problem is an entire field of study in itself. There have been doctoral theses published on this. Depending on the problem type, it may be easier or harder. In general, it's not trivial. Some commercial solvers try to do this automatically and also try to detect redundant constraints automatically to delete them.