Results 1 to 5 of 5

Thread: Solver doesn't find maxium revenue

  1. #1

    Solver doesn't find maxium revenue



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

    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

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu

  3. #3
    ooh I'm really sorry.

    I new in forums (Join date Sep-2015) and didn't noticed the problems of cross posting.

    Sorry.

  4. #4
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    FYI cross-posting is treated the same way in every forum I know of

  5. #5
    Hi,


    the problem could be fixed by buying a upgrade for the solver.
    Now it's able to find the maximum.

Posting Permissions

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