摘要
根据中石化沥青铁路自备车运输统一调配使用的实际,建立目标函数总车/天数为最小的运输优化数学模型。应用Excel电子表格进行运输问题的线性规划建模和求解,并摸拟运输旺季车辆供应紧张时的情况,建立运输线性规划扩展模型,根据求解结果调整约束条件,进行二次规划求解达到最大运输量。利用电子表格建模和求解,具有很强的实际推广应用价值。
According to fact that unify to dispense the Sinopec's asphaltum railway tank car transportation it establishes the mathematical model which includes the minimal objective function such as total car and day, supply Excel electrical form to solve the linear programming and establishes the model of transportation problem. Simulating the tensional, situiation of car supplying in midseason it establishes expansional model of transportion linear programming. According to the result of solution to adjust the tensional condition and then use quadratic programming to get the strongest traasportion ability. Based on the electrical form to set up the model and beg the solution, the author points out that it has very strong and aclual extension application value.
出处
《物流科技》
2006年第9期42-45,共4页
Logistics Sci-Tech
关键词
运输
数学模型
线性规划
EXCEL
transportation
mathematical model
linear programming, Excel