+ Reply to Thread
Results 1 to 9 of 9

Warehouse Optimization

Hybrid View

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Warehouse Optimization

    shg, Thank you for your response. I wish it was homework, more a mini project that will greatly effect my business savings. I am lucky in the sense I would contract a warehouse so zoning, land prices, construction costs, and taxes are variables I wont have to mess with, however you hit the nail on the head as far as what I am trying to do. Any suggestions?

    I looked at the link you sent me, I dont have access to to IEEE.

  2. #2
    Registered User
    Join Date
    12-29-2010
    Location
    Europe, CET
    MS-Off Ver
    Excel 2004, Excel 2003, Excel 2007
    Posts
    15

    Re: Warehouse Optimization

    I think you can do well without taking everything into account at once... To get started, if I were you, I would define say 5 regions for your warehouses, with approximately equal areas. Then, within each area I would minimize the average distance to the customers (euclidian norm as mentioned above). That's a start - then you may start to think about adding details later, such as road standards, taxes and so on...

    It is always better ot start with the simple assumptions and arrive at a useful solution than to make everything super-realistic but close to impossible to solve. The latter is the academic approach (as I learned from doing PhD research....)

  3. #3
    Registered User
    Join Date
    08-04-2010
    Location
    Ohio
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Warehouse Optimization

    That is a great point, I guess my problem is implenting the best method in which to produce such data. Any suggestions?

  4. #4
    Registered User
    Join Date
    12-29-2010
    Location
    Europe, CET
    MS-Off Ver
    Excel 2004, Excel 2003, Excel 2007
    Posts
    15

    Re: Warehouse Optimization

    Well, I suppose you have the addresses of your customers? :-) Say you have defined a "midwest" region and your customers are scattered around, but concentrations exist (say Twin Cities, Chicago, Wichita... add some yourself... ). Then assign customers to those cities depending on which city they are closest to (this introduced a simplifying assumption - it is wrong, you know it is wrong, but it simplifies life and allows you to proceed with a first solution). Then, you can consider where to put your warehouse - minimizing the average "weighted" distance to those selected cities would be a meaningful approach, where the distance to each city would be weighted by the number of customers assigned to it... this would be managable, don't you think?
    http://excelblog.optkontek.com - notes on excel
    Follow @nerdpub on twitter!

+ 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