Results 1 to 2 of 2

Thread: Excel solver

  1. #1
    New Lounger
    Join Date
    Jul 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel solver

    Pls see attached. Anyone have any thought what might be tripping up my solver? I keep running into the same issue where Excel says that the conditions required for a Linear solution aren't met by my (very basic) Excel models. I can use Data Tables to find solutions to these three projects, but I would like to know where I might be going wrong with solver. Others I know have been able to use solver to get solutions for the same models. Problem with Excel solver.xlsx

    Many thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You have the solving method as "Simplex LP" this is for solutions that are mathematically linear. Your setup is not linear

    Change the method to "GRG Non-linear" and you should not get the error.

    Steve
    PS when I use solver for 3 Problems I get
    A:36.2274653072142 at a price of -7662.26

    B: Price of 21 for a profit of 180500

    C: Price of 4.48022927114475 for 222.30
    Last edited by sdckapr; 2011-07-07 at 15:20.

Tags for this Thread

Posting Permissions

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