Solving 2 variables, 2 constraints using Excel Solver

Solves a simple Linear Program with 2 constraints and 2 variables.
Shows how to formulate in Excel, and solve using Solver.
Then walks through interpretation of Solver reports.

[@engineersunia]

Best video so far. Good Job Ron

[@RonNV11]

Thanks!

[@RashidWaqar]

thank u so much really helpful video for assignment 4 of everyday excel part 2 coursera

[@ZoomSEdit]

Sir when I look the my constraints' of Excel sensivity analysis table, I see the whole RHS numbers equal to 0. But actually all of them have a number. Even in some constraints the LHS and RHS equals to each other. I need to write down the binding and nonbinding constraints but in this case it wouldn't be possible. All my 17 constraints' RHS's equal to 0. Why? How can I change this? Thank you

[@ironwolfinsanity8105]

How do you run the regression analysis for this project?

[@fan5382]

How do you set constraints for sum? Say cell a1 + cell a 2 must b equal to a certain number

[@emmaruzicka9993]

thank you :DDD