Solving 2 variables, 2 constraints using Excel Solver

Рет қаралды 40,047

Күн бұрын

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.

Пікірлер: 7

@RashidWaqar Жыл бұрын

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

@engineersunia 3 жыл бұрын

Best video so far. Good Job Ron

@RonNV11 3 жыл бұрын

Thanks!

@ironwolfinsanity8105 10 ай бұрын

How do you run the regression analysis for this project?

@fan5382 2 жыл бұрын

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

@emmaruzicka9993 2 жыл бұрын

thank you :DDD

@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