运用Excel工具优化战略投送基地选址

Using Excel to Optimize the Selection of Strategic Projection Bases

为解决战略投送基地优化选址问题,基于整数规划和离散点选址问题,建立了战略投送基地集合覆盖数学模型,运用Excel工具对战略投送基地进行优化选址,为战略投送基地的实际选址提供一种简便可行、易操作的量化方法。

To optimize the selection of the strategic projection bases,this paper builds a mathematic model of Set Covering Location Problem on the base of integer programming and dispersed site selection. Excel is used in optimizing the selection and is proved to be feasible,efficient and user-friendly in practice.