==>> 点击下载文档 |
An important group of Solver applications is based on distribution or network models.
The amount of money that companies save each year by applying linear programming
towards their distribution problems is enormous.
In this series we will look at a simple transportation problem in worksheet Transport1, then
extend it to a 2-level multi-product model in worksheets Transport2 and Transport3.
We'll also examine a frequently encountered class of problems called 'knapsack'
problems, in worksheet Knapsack. As an example we will look at a truck that has to
transport different kinds of gas.
In the Facility worksheet we will look at a facility location problem, where a company has
to decide if it's profitable to close down one or more of their plants and save overall costs.
Finally, in the Prodtran worksheet, we will examine a combination production and
transportation model where the number of products made in plants depends on choices
made in distribution. This kind of combination is often possible, but many users prefer to
split these models up into smaller ones to simplify the problem.