物流中心储位管理与物流中心作业系统

log96

最初由 游客游 发布
[B]to log96,

2。我试验了7、8个数，好像都是按进出比递减排列最佳。差点我就投降了，差点我还（一瞬间）有用数学证明去了；不过估计自己也证明不出来。但还是不负苦心人，你把D的进出次数改成 进＝300，出＝430（比值还是0.7）看看？是否D/E该对调了呢？ [/B]

仔细研究一下

Ocean_wx

目标：使coef_c*c - coef_d*d - coef_e*e的值最小
        其中，coef_c,coef_d,coef_e分别为c,d,e前的系数,c,d,e分别为商品放置位置离仓库入口的距离

LOG96例中对应的表达式为---125c - 13d - 90e
        为使整个表达式的值最小,就要使c值尽可能小,同时d与e尽可能大,很显然,C商品应该放在库位1,D与E商品则应分别放在库位4与库位5上;

游客游例中对应的表达式为---125c - 130d - 90e
        为使整个表达式的值最小,就要使c值尽可能小,同时d与e尽可能大,很显然,C商品应该放在库位1,D与E商品则应分别放在库位5与库位4上;

归根结底一句话，哪个商品应该放在哪个库位上，就是求解诸如上述表达式的最小值，求解结果应与表达式各项前的系数相关

ncyear

谢谢您们的友情提供，帮助我们增长物流知识和工作技能。

游客游

to Ocean wx, 谢谢你的参与。你说的没错，求解结果应与表达式各项前的系数相关。但不直接相关，而是与货物的进出库频率相关；但又不像书中说的那样与频次比相关。

to log96: 附件是俺根据你给的数据做的一个Excel小玩意儿。注意看里面的公式和规划求解(solver)。

另，有人感兴趣再回过头来，把书中的那个A~H8种货物的库位安排依葫芦画瓢吗？

soven_chan

牛人云集！！

yangfred

...............8888:::8888888888888888888888888
.............8888::::::8888888888888888888888888888
............88::::::::888:::8888888888888888888888888
..........88888888::::8:::::::::::88888888888888888888
........888.8::888888::::::::::::::::::88888888888...888                  
...........88::::88888888::::顶::::::::::88888888888....8
.........888888888888888888:顶:::::::::::8888888888888
........88888888888888888888::::::::::::顶88888888888888
........8888888888888888888888:::::::::顶8888888888888888
.........8888888888888888888888:::::::顶888888888888888888
........8888888888888888::88888::::::顶88888888888888888888
......88888888888888888:::88888:::::顶888888888888888...8888                 
.....88888888888888888:::88888::::顶::;o*顶*o;888888888....88
....88888888888888888:::8888:::::顶:::::::::::88888888....8
...88888888888888888::::88::::::顶:;:::::::::::888888888
..8888888888888888888:::8::::::顶::aAa::::::::顶8888888888.......8
..88...8888888888::88::::8::::顶:::::::::::::888888888888888.8888
.88..88888888888:::8:::::::::顶::::::::::;::88:88888888888888888
.8..8888888888888:::::::::::顶::"@@@@@@@"::::8w8888888888888888
..88888888888:888::::::::::顶:::::"@a@":::::顶8i888888888888888
.8888888888::::88:::::::::顶88:::::::::::::顶88z88888888888888888
8888888888:::::8:::::::::顶88888:::::::::顶顶888!888888888888888888
888888888:::::8:::::::::顶8888888顶A顶顶顶A顶V顶顶888*88888888...88888888
888888.顶:::::::::::::::顶888888888:::::::顶顶88888888888888...8888888
8888...顶::::::::::::::顶88888888888::::::顶顶888888888888888....88888
.888...顶:::::::::::::顶8888888888888顶:::::顶顶888888888888888....8888
..888..顶::::::::::::顶8888:888888888888::::顶::顶顶88888.888888...8888
...88..顶::::::::::::8888:88888888888888888::::::顶顶8...88888...888
...88..顶::::::::::8888顶::88888::888888888888:::::::顶顶88888....88
...8...顶顶::::::::8888顶:::8888:::::888888888888::::::::顶顶8.....4
.......8顶:::::::8888顶:::::888:::::::88:::8888888::::::::顶顶....2
......88顶顶:::::8888顶:::::::88::::::::8:::::888888:::顶:::::顶
.....8888顶:::::888顶顶::::::::8:::::::::::顶::::8888::::顶::::顶
....88888顶:::::88:顶::::::::::8:::::::::::顶:::8888::::::顶::顶
...88.888顶顶:::888:顶:::::::::::::::::::::::顶:8888:::::::::顶:
...8.88888顶:::88::顶:::::::::::::::::::::::顶顶:88::::::::::::顶
.....88888顶:::88::顶::::::::::*88*::::::::::顶:88::::::::::::::顶
....888888顶:::88::顶:::::::::88@@88:::::::::顶::88::::::::::::::顶
....888888顶顶::88::顶顶::::::::88@@88:::::::::顶:::8::::::::::::::*8
....88888..顶:::8::顶顶:::::::::*88*::::::::::顶:::::::::::::::::88@@
....8888...顶顶::::::顶顶:::::::::::::::::::::顶顶:::::::::::::::::88@@
.....888....顶:::::::顶顶:::::::::::::::::::顶顶::顶::::::::::::::::*8
.....888....顶顶:::::::顶顶顶::::::::::::::::顶顶:::顶顶:::::::::::::::顶
......88.....顶::::::::顶顶顶顶:::::::::::顶顶顶顶:::::顶顶::::::::::::顶顶
.......88....顶顶:::::::::顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶::::::::顶顶顶
........88....顶顶::::::::::::顶顶顶顶顶顶顶::::::::::::::顶顶顶顶顶顶
.........88...8顶顶::::::::::::::::::::::::::::::::::顶顶顶顶顶顶
..........8...88顶顶::::::::::::::::::::::顶:::顶::::::::顶顶
..............888顶顶::::::::::::::::::顶顶::::::顶顶::::::顶顶
.............88888顶顶:::::::::::::::顶顶顶:::::::顶顶:::::顶顶
.............888888顶顶:::::::::::::顶顶顶:::::::::顶顶顶:::顶
............88888888顶顶:::::::::::顶顶顶:::::::::::顶顶:::顶
...........88.8888888顶:::::::::顶顶顶::::::::::::::顶:::顶
...........8..888888.顶:::::::顶顶:::::::::::::::::顶:::顶:
..............888888.顶::::::顶:::::::::::::::::::顶:::顶顶
.............888888..顶:::::顶::::::::::::::::::::::::顶:顶
.............888888..顶:::::顶:::::::::@::::::::::::::顶::顶
.............88888...顶::::::::::::::@@:::::::::::::::顶::顶
............88888...顶::::::::::::::@@@::::::::::::::::顶::顶
...........88888...顶:::::::::::::::@@::::::::::::::::::顶::顶
..........88888...顶:::::顶::::::::::@::::::::::顶顶:::::::顶:::顶
..........8888...顶:::::顶:::::::::::::::::::::::顶顶:::::::顶:::顶
.........8888...顶:::::顶:::::::::::::::::::::::顶顶顶::::::::顶:::顶
........888....顶:::::顶顶::::::::::::::::::::::顶顶顶:::::::::顶::::顶
......8888....顶顶::::顶顶:::::::::::::::::::::顶顶顶顶:::::::::顶::顶:::顶
.....888......顶:::::顶::::::::::::::::::::顶顶顶::::::::::::顶::顶顶:::顶
..8888.......顶顶:::::::::::::::::::::::::顶顶:::::::::::::顶顶::顶顶:::顶:
.............顶:::::::::::::::::::::::::顶:::::::::::::::顶顶::顶顶:::顶顶
............顶顶::::::顶:::::::::::::::::::::::::::::::::::顶::顶顶:::顶顶
............顶::::::::顶:::::::::::::::::::::::::::::::::::顶::顶:::顶顶
...........顶顶:::::::::顶:::::::::::::顶:::::::::::::::::::::顶:顶:::顶顶
...........顶:::::::::::顶88:::::::::顶:::::::::::::::::::::::顶顶::顶顶顶
...........顶::::::::::::8888888888顶::::::::::::::::::::::::顶顶::顶顶
...........顶:::::::::::::88888888顶:::::::::::::::::::::::::顶::顶顶
...........顶::::::::::::::888888顶:::::::::::::::::::::::::顶::顶顶
...........顶:::::::::::::::88888顶:::::::::::::::::::::::::顶:顶顶
...........顶:::::::::::::::::88顶::::::::::::::::::::::::::顶顶顶
...........顶:::::::::::::::::::顶::::::::::::::::::::::::::顶顶顶
...........顶顶:::::::::::::::::顶::::::::::::::::::::::::::顶顶顶
............顶:::::::::::::::::顶::::::::::::::::::::::::::顶顶顶
............顶顶:::::::::::::::顶::::::::::::::::::::::::::顶顶顶
.............顶:::::::::::::::顶:::::::::::::::::::::::::顶顶顶
.............顶顶:::::::::::::顶:::::::::::::::::::::::::顶顶顶
..............顶:::::::::::::顶::::::::::::::::::::::::顶顶顶
..............顶顶:::::::::::顶::::::::::::::::::::::::顶顶顶
...............顶:::::::::::顶:::::::::::::::::::::::顶顶顶
...............顶顶:::::::::顶:::::::::::::::::::::::顶顶顶
................顶:::::::::顶::::::::::::::::::::::顶顶顶
................顶顶:::::::顶::::::::::::::::::::::顶顶顶
.................顶顶::::::顶:::::::::::::::::::::顶顶顶
.................顶顶:::::顶:::::::::::::::::::::顶顶顶
..................顶顶::::顶::::::::::::::::::::顶顶顶
..................顶顶:::顶::::::::::::::::::::顶顶顶
...................顶顶::顶:::::::::::::::::::顶顶顶
...................顶顶:顶:::::::::::::::::::顶顶顶
....................顶顶顶::::::::::::::::::顶顶顶
....................顶顶::::::::::::::::::顶顶顶
.....................顶:::::::::::::::::顶顶顶
....................顶顶::::::::::::::::顶顶顶
....................顶顶:::::::::::::::顶顶顶
....................顶顶::::顶:::::::::顶顶顶:
....................顶顶顶::::顶顶:::::::顶顶顶顶
.....................顶顶顶:::::::::::顶顶顶:顶
.....................顶顶顶:::顶:::::::顶:顶:顶
......................顶顶::顶顶顶顶:::::::顶:顶
......................顶顶::顶顶顶::::::::顶:顶
......................顶顶顶::顶顶::::::::顶:顶
.......................顶顶::顶顶:::::::::顶:顶
.......................顶顶::顶顶::::::::::顶:顶
.......................顶顶:::顶:::::::::::顶顶
.......................顶顶顶:::::::::::::::顶:
.......................顶顶顶:::::::::::::::顶:
.......................顶顶顶::::::::::::::::顶
.......................顶顶顶::::::::::::::::顶
.......................顶顶顶::::::::::::::::顶顶
........................顶顶::::::::::::::::顶顶
........................顶顶顶:::::::::::::::顶顶
........................顶顶顶:::::::::::::::顶顶
........................顶顶顶:::::::::::::::顶顶
........................顶顶顶:::::::::::::::顶顶
.........................顶顶::::::::::::::顶顶顶
.........................顶顶顶:::::::::::::顶顶
.........................顶顶顶:::::::::::::顶顶
.........................顶顶顶::::::::::::顶顶
..........................顶顶::::::::::::顶顶
..........................顶顶::::::::::::顶顶
..........................顶顶:::::::::::顶顶
..........................顶顶顶::::::::::顶顶
..........................顶顶顶::::::::::顶顶
...........................顶顶:::::::::顶顶
...........................顶顶顶::::::::顶顶
...........................顶顶顶::::::::顶顶
............................顶顶::::::::顶顶
............................顶顶顶::::::顶顶
............................顶顶顶::::::顶顶
.............................顶顶::::::顶顶
.............................顶顶::::::顶顶
..............................顶顶:::::顶顶
..............................顶顶:::::顶顶:
..............................顶顶:::::顶:顶
..............................顶顶:::::顶:顶
..............................:顶::::::顶:
.............................顶:顶:::::::顶
............................顶:::顶::::::顶
...........................顶::::顶::::::顶
..........................顶:::::顶:::::::顶
.........................顶::::::顶顶:::::::顶
.........................顶:::::::顶::::::::顶
.........................顶;:;::::顶:::::::::顶
.........................顶:顶:;:::顶::::::::::顶
.........................顶顶:顶:顶::顶::::::::;:顶
..........................顶顶:顶::顶顶:::::::;:;顶
...........................顶顶::顶顶顶::::::;:顶:顶
............................顶顶顶顶.顶顶::::顶:顶:顶顶
..................................顶顶::::顶:顶顶
...................................顶顶::::顶顶
....................................顶顶::顶顶

WALLY8901

多谢

xiarryll

详尽

iwaitforu

恩，大受启发
可以总结规律如下了：
布置的原则：以总的行走距离最小为目标
步骤如下：
1.分为3组，入库次数>出库次数，根据入库次数由多到少，从入库口向出库口布置
2.入库次数<出库次数，根据出库次数由多到少，从出库口向入库口布置
3.入库次数＝出库次数，随便放哪都可以

对原来的8种产品重新排列，得出的结果是G、F对调位置！
如果将D改为300、430，G、D分别和F、E对调！

iwaitforu

这个问题是不是还可以延伸？
假如出入库口在一处，如何布置？