Results 1 to 3 of 3

Solver not finding optimium Result

Threaded View

EricGoldman Solver not finding optimium... 07-25-2016, 05:39 PM
Alf Re: Solver not finding... 07-26-2016, 03:20 AM
EricGoldman Re: Solver not finding... 07-26-2016, 12:00 PM
  1. #1
    Registered User
    Join Date
    07-01-2016
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    3

    Question Solver not finding optimium Result

    I am trying to minimize costs for our Line of Credits
    We have 5 lines which charge when we use their line and when we do not use it (albeit) a smaller rate
    The rates are tiered by $ amount

    We need a finite amount of money H17
    We cannot go over any specific credit line (c4:h4)
    And need the solver to solve for the amounts needed (C17:G17) that will minimize costs (H12).
    Attached Images Attached Images
    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. Solver Installed, but not generating a result
    By EricGoldman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2016, 01:44 PM
  2. Solver not finding the solution
    By Domux in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2015, 03:49 PM
  3. [SOLVED] finding a result of a specific text base on the next day result
    By top00001 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-15-2014, 02:01 AM
  4. Excel Solver Not finding Max Value
    By lbofbb in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-30-2014, 11:33 PM
  5. Solver - Finding the next best solution
    By mattdh12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2014, 10:41 AM
  6. Disable Solver Result Dialog Box & Display Result in Cell
    By yauchildchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2010, 01:46 PM
  7. Error running Macro/Solver result
    By JDMxB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2005, 06:10 PM

Tags for this Thread

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