问题描述
我有一个仓库以及三个分发和接收地点。我知道彼此之间的距离。每个位置都有不同数量的标准尺寸包装，但重量不同。
I have a warehouse and three distribution and receiving locations. I know the distances between each of them in relation to each other. Each location has a varying amount of standard size packages but of varying weight.
我有三辆车，一辆载有30个包裹或1100磅，一辆载有20个包裹或700磅，一辆载有15个包裹或500磅。
I have three vehicles, one that carries 30 packages or 1100lbs, one that carries 20 packages or 700lbs, and one that carries 15 packages or 500lbs.
我正在尝试制作一个电子表格，可以输入到包裹中以及必须发送到每个位置的重量以及它们需要携带的重量，并需要携带多少来自动计算出哪个车辆或
I am trying to make a spreadsheet that can enter in the packages and their weights I have to send to each location and a how many I need to bring in and have it automatically calculate which vehicle or combination to use and which route in the most efficient manner.
任何建议将不胜感激。
Geno
推荐答案
好吧，您可以使用求解器从此基本模型开始，然后使用要包含的详细信息对其进行扩展。显示按单元格，行或列进行的计算...
Well, you can start with this basic model using the solver and expand it with the detail you want to include. Shown the calculation by cell, row or column...
这篇关于高效的车辆路线安排，以运送包裹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！