+ Reply to Thread
Results 1 to 3 of 3

Solving Problem

  1. #1
    Registered User
    Join Date
    05-25-2007
    Posts
    1

    Solving Problem

    I have a total number of cubic meters (CBM), and need to figure out the best
    combination of shipping containers that leaves the least amount left over.
    Here is an example:

    Total CBM = 311

    Container Type 20' holds max of 28 CBM
    Container Type 40' holds between 55 and 58 CBM
    Container Type 40H holds between 65 - 68 CBM
    Container Type 45 holds max of 75 CBM

    To further complicate this, I would like to minimize the number of 45'
    containers, and also have an alternative solution that doesn't involve using
    20' containers. I've tried using Solver, but can't seem to get things set up
    right to make it work.

    Thanks in advance!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Have a look at

    http://www.excelforum.com/showthread.php?t=596847

    which gives a method for generating all possible combinations of any number of variables with a defined number of options for each.

    Using this you could generate all the possible combinations of volume and sort to see when gets closest to your target.
    Martin

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Here's a solution based upon the previous answer. Please see the attachment. It looks like you have a couple of exact answers for your 311 problem. Change this figure in the spreadsheet to get the macro to calculate the optima for other values.
    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)

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