Results 1 to 4 of 4

Thread: Helped Needed: Linear/nonlinear Optimization with Solver

  1. #1
    Neophyte TomBurton_021978's Avatar
    Join Date
    Mar 2019
    Posts
    1
    Articles
    0
    Excel Version
    16.23

    Helped Needed: Linear/nonlinear Optimization with Solver



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,186
    Articles
    0
    Excel Version
    Office 365 Subscription
    This query has been cross posted on another forum. Our rules require you to provide a link to that other thread, please.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    35
    Articles
    0
    Excel Version
    2010
    On lots of other forums, all of whose cross-post rules have been ignored...
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,186
    Articles
    0
    Excel Version
    Office 365 Subscription
    Solution provided on another forum - thread closed to avoid members' time being wasted.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •