I'm doing a project for my Finite Mathmatics course which deals with Linear Programming and we have to use Solver in Excel to get the answers.
One of my constraints is I have to make B1 <= 1.25 times B2 which I can't figure out how to do in Solver.
The rest of the project looks like this
A1 is Product X
A2 is Product Y
A3 is Total
A5 is Profit
B1:B2 0
B3 is the Sum of B1 and B2 so I put in =SUM(B1+B2)
B5 adds 5 times B1 and 4 times B2 so I put in =SUM(5*B1+4*B2)
Then I have to activate Solver with B5 as the Target Cell and B1:B2 as the changing cells, the constraints are B1 and B2 are integers and >=0 so I put tha in twice once B1 and B2 as integers and once as B1 and B2 >=0, the final constraint is B3 <=1000
When I run solver I should get 555 and 445 for Answers in the Answer Report.
So yeah how would i add that constraint to make B1 <= 1.25 times B2 and also am I doing the rest of the work right?
EDIT: Nevermind I figured it out