首页 > 资料专栏 > 制造 > 供应链 > 物流设计 > 物流规划模型(excel)英文版.rar

物流规划模型(excel)英文版.rar

三通物流***
V 实名认证
内容提供者
资料大小:80KB(压缩后)
文档格式:WinRAR
资料语言:中文版/英文版/日文版
解压密码:m448
更新时间:2015/1/24(发布于广东)
阅读:16
类型:积分资料
积分:8分 (VIP无积分限制)
推荐:升级会员

   点此下载 ==>> 点击下载文档


文本描述

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.