+ Reply to Thread
Results 1 to 2 of 2

Excel Solver help

  1. #1
    Registered User
    Join Date
    08-08-2019
    Location
    Ljubljana, Slovenia
    MS-Off Ver
    365
    Posts
    1

    Excel Solver help

    Hello,
    I need a help with Excel Solver.
    I have a list of different types of boxes (001-014), which contains multiple items (Box 001 contains 1 B item, 2 C items, 2 D items, 1 E item and 1 F item.
    I want solver to figure out how many (variables) and which type of box to take, that the total of all items will match predefined number ( 100 in my case), while also considering that total sum of each individual item should equal or at least be very close (+- 2) to predefined number which represent the optimal number for a total sum for an item.
    Constraints:
    My variables should all be positive whole numbers.
    Difference between total sum of A (or any other) item and predefined limit for A item should not be larger then 2.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    373

    Re: Excel Solver help

    What is wrong with the solution given by Excel solver?

    You only need to select Simplex LP since this is a linear problem.
    Attached Images Attached Images
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel solver - Trouble with linear programming using solver excel
    By spicyscreamer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2017, 08:01 AM
  2. Replies: 7
    Last Post: 12-31-2016, 12:29 PM
  3. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  4. [SOLVED] Excel Solver VBA - Solver Violating Constraints
    By lespaul00 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2015, 04:00 PM
  5. Replies: 0
    Last Post: 09-22-2015, 06:09 PM
  6. Replies: 0
    Last Post: 07-20-2014, 12:45 PM
  7. Replies: 11
    Last Post: 10-30-2013, 02:11 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