Results 1 to 9 of 9

Help with solver as solver gives wrong answer

Threaded View

syjytg Help with solver as solver... 09-25-2013, 05:23 PM
6StringJazzer Re: Help with solver as... 09-25-2013, 10:33 PM
syjytg Re: Help with solver as... 09-25-2013, 10:35 PM
syjytg Re: Help with solver as... 09-26-2013, 12:18 PM
MrShorty Re: Help with solver as... 09-26-2013, 01:43 PM
syjytg Re: Help with solver as... 10-11-2013, 04:09 AM
syjytg Re: Help with solver as... 09-26-2013, 01:59 PM
6StringJazzer Re: Help with solver as... 09-26-2013, 11:50 PM
MrShorty Re: Help with solver as... 10-14-2013, 09:05 AM
  1. #1
    Registered User
    Join Date
    09-25-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Help with solver as solver gives wrong answer

    I want to minimize shipping costs (Cell B39) by filling in (Cell B21:F24) subject to certain constraints. The solver's solution are currently in Cell B21:F24 which give B39 answer of 79875.

    However, by trial and error I found a test case (answer in Cell I21:M24) that gives Cell B39 answer of 70500, which is less than 79875. It is not possible to try all possible cases by hand, so I am not sure whether 70500 is the best.

    How do I make solver give me the correct answer?

    I don't know whether to use Simplex LP, GRG Nonlinear or Evolutionary but whatever I use, the best answer it gave was 79875 (Using Evolutionary).

    The file is uploaded.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't start Solver. Error message says Solver.xlam already open.
    By DaveHills in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-21-2012, 11:02 AM
  2. [SOLVED] optimization problem - solver falling to get correct answer
    By timtim89 in forum Excel General
    Replies: 5
    Last Post: 09-27-2012, 10:51 AM
  3. solver macro + simulation code + not updating solver values
    By sabinemaria in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2012, 11:37 AM
  4. Solver not returning answer
    By jealkon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2010, 05:15 PM
  5. solver answer report for equilibrium point
    By mattll in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2009, 01:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1