运输问题发收平衡调整与通用EXCEL求解模板

Transportation Charge Balance Adjustment and General EXCEL Solution Template

在物流运输的工作中,需要面对很多运输的问题,如何快捷地调度并使运输的费用达到最小,应用运输问题的线性规划模型进行规划求解是一个有效的方法。在Excel内置的规划求解程序中,可通过单元格的函数公式编程,将各种可发出货物数量与可收入货物数量的不平衡的运输问题,自动转化为一个标准的发收平衡的运输问题求解模板,形成一种简便的智能化的运输调度方案。

In logistics and transport work,need to face a lot of transportation problem,how to quickly dispatch and transportation cost minimized transportation problem,application of the linear planning model of programming is an effective method.In the Excel built-in programming procedures,through the cell function formula programming,all can deliver goods quantity and quantity of the goods is income unbalanced transportation problem,automatically converted to a standard charge balance transportation problem solution template,form a kind of simple and convenient intelligent transportation dispatching scheme.