Helped Needed: Linear/nonlinear Optimization with Solver

Status
Not open for further replies.

TomBurton_021978

New member
Joined
Mar 29, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
16.23
Hi guys. I am currently working on an simple optimization problem that has a two non-linear constraint. Nevertheless, I want to solve this problem (I am required to do so) using Simplex LP and I struggle how to convert these constraints into linear constraints or how to approach this problem in general.

To make it clearer, a mathematical formulation of this problem would be:

Maximize R=550x+1100y

where quantities x and y have to be chosen in order to maximize R.

There are 4 linear constraints (I know how to handle them) and 2 nonlinear constraints, which both include a ratio of x and y:

(5,379+x)/(3,260+y) ≥ 1.4
(5,379+x)/(3,260+y) ≤ 1.75

I attached the Excel file for this problem. Would really appreciate your help :)

Best Tom
 

Attachments

  • Maximization Problem.xlsx
    14.2 KB · Views: 7
This query has been cross posted on another forum. Our rules require you to provide a link to that other thread, please.
 
On lots of other forums, all of whose cross-post rules have been ignored...
 
Solution provided on another forum - thread closed to avoid members' time being wasted.
 
Status
Not open for further replies.
Back
Top