Results 1 to 14 of 14

Solver doesn't find maxium revenue

Threaded View

Surminderbains Solver doesn't find maxium... 10-03-2015, 12:02 PM
MrShorty Re: Solver doesn't find... 10-03-2015, 01:02 PM
Surminderbains Re: Solver doesn't find... 10-03-2015, 01:36 PM
MrShorty Re: Solver doesn't find... 10-03-2015, 02:03 PM
Surminderbains Re: Solver doesn't find... 10-03-2015, 02:22 PM
shg Re: Solver doesn't find... 10-03-2015, 02:41 PM
Surminderbains Re: Solver doesn't find... 10-03-2015, 03:00 PM
MrShorty Re: Solver doesn't find... 10-03-2015, 02:49 PM
Alf Re: Solver doesn't find... 10-03-2015, 02:53 PM
MrShorty Re: Solver doesn't find... 10-04-2015, 01:59 AM
Pepe Le Mokko Re: Solver doesn't find... 10-04-2015, 03:07 AM
Surminderbains Re: Solver doesn't find... 10-04-2015, 04:09 AM
Alf Re: Solver doesn't find... 10-04-2015, 03:43 PM
Surminderbains Re: Solver doesn't find... 10-09-2015, 04:53 PM
  1. #1
    Registered User
    Join Date
    10-03-2015
    Location
    Frankfurt, Germany
    MS-Off Ver
    2010
    Posts
    6

    Solver doesn't find maxium revenue

    Hi Experts,

    I'm looking for the maximum revenue. I have already setup everything in the following excel.
    (If there are formulas with WENN replace them with IF but there shouldn't.)
    To the row C (Origin) I would like to add or subtract values according to the min and max values in the row a and b, but only that much that the gap between to values is a max of 25 (or -25).

    The values should be added or subtracted by the prices. Negativ prices should suggest to subtract and positiv to add.
    The value which is add or subtracted and the prices equal the revenue.
    All revenue in the sum should be maximized.

    It's complicated to write, but If you see the excel you should understand what I mean.

    To solve the problem I have used the solver.

    It should maximized the cell H10.
    For the any infringement of rules its if check Cell E10 = 0.
    And the values which should be add on or subtracted are in the cells D2 to D9

    The solver finds a result, but not the maximum.
    I want to find the maximum.

    Do you see any mistakes or should I solve this problem in a other way.

    Thanks for help

    Surminder
    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. Revenue Calculation based on Variable revenue Percentage
    By suhabthan in forum Excel General
    Replies: 0
    Last Post: 06-19-2014, 12:48 PM
  2. Look Up or Match Range to Criteria, Then Find Minimum or Maxium
    By mycon73 in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 02-06-2014, 01:27 PM
  3. solver doesn't search
    By yangbo07520 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 04:34 PM
  4. Solver doesn't find the right answer
    By yangbo07520 in forum Excel General
    Replies: 1
    Last Post: 10-09-2013, 02:24 PM
  5. solver doesn't find all solutions
    By Alexander_Golinsky in forum Excel General
    Replies: 4
    Last Post: 05-26-2012, 06:13 PM
  6. Replies: 2
    Last Post: 05-23-2012, 07:23 PM
  7. Solver checked but doesn't appear
    By charles_weaver@post.harvard.edu in forum Excel General
    Replies: 1
    Last Post: 02-06-2005, 05:05 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