Helped Needed: Linear/nonlinear Optimization with Solver

**TomBurton_021978** · 03-29-2019, 06:04 PM

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 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

**AliGW** · 03-29-2019, 06:27 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I’ll provide the link for you this time.)

https://www.excelguru.ca/forums/show...on-with-Solver