+ Reply to Thread
Results 1 to 4 of 4

Solver LPX

  1. #1
    Registered User
    Join Date
    12-15-2023
    Location
    Islamabad
    MS-Off Ver
    2019
    Posts
    2

    Solver LPX

    Hi, I need help to setup a solver task, details are as follows


    Cotton Farms Supply (bales) Requirement 71,000 bales
    A 20,000
    B 34,000
    C 17,000

    Ports
    1 2 3 4
    Capacity (bales) 28,000 21,000 16,000 14,000

    A x x x x
    B x x x x
    C x x x x

    The condition must be that 1 farm must provide 80% of ports capacity, how do I set up this condition in solver, do I need some more calculation to do before I set up the condition?

    Thanks.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,956

    Re: Solver LPX

    Is this a homework assignment?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,760

    Re: Solver LPX

    You know the farm production as well as the max capacity of each port. You also got an additional constraint that a farmer will only ship 80% of its production through one port. So each farmer has 4 ports to export from with the constraint that each number of bales shipped from a port must be less than 80% of that farms production but you also know that the total numbers shipped from a port most be the equal to that farms production.

    Alf

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,760

    Re: Solver LPX

    As sell-by date must have been passed by now and Christmas is the time of good will among mankind I'll post one possible solver setup for this problem.

    Alf
    Attached Files Attached Files

+ 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. [SOLVED] How to update individual pages with Solver results and skip Solver dialogue box using VBA
    By Mayushii in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2023, 12:03 PM
  2. SOLVER Error Message: excel solver objective cell contents must be a formula
    By bluevil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2022, 05:38 AM
  3. Replies: 5
    Last Post: 10-09-2020, 03:33 AM
  4. Replies: 2
    Last Post: 06-22-2020, 03:14 PM
  5. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  6. Replies: 0
    Last Post: 07-20-2014, 12:45 PM
  7. 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

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