tailieunhanh - Lecture Introduction to Management Science with Spreadsheets: Chapter 6 - Stevenson, Ozgur
Chapter 6 - Supplement "Transportation and assignment solution procedures", after completing this chapter, you should be able to: Use the transportation method to solve problems manually, deal with special cases in solving transportation problems, use the assignment (Hungarian) method to solve problems manually. deal with special cases in solving assignment problems. | Chapter 6 Transportation, Transshipment, and Assignment Problems Part 2 Deterministic Decision Models Learning Objectives Describe the nature of transportation, transshipment, and assignment problems. Formulate a transportation problem as a linear programming model. Use the transportation method to solve problems with Excel. Solve maximization transportation problems, unbalanced problems, and problems with prohibited routes. Solve aggregate planning problems using the transportation model. After completing this chapter, you should be able to: McGraw-Hill/Irwin 6– Learning Objectives (cont’d) Formulate a transshipment problem as a linear programming model. Solve transshipment problems with Excel. Formulate an assignment problem as a linear programming model. Use the assignment method to solve problems with Excel. After completing this chapter, you should be able to: McGraw-Hill/Irwin 6– Transportation Problems Transportation Problem A distribution-type problem in which supplies of goods that are held at various locations are to be distributed to other receiving locations. The solution of a transportation problem will indicate to a manager the quantities and costs of various routes and the resulting minimum cost. Used to compare location alternatives in deciding where to locate factories and warehouses to achieve the minimum cost distribution configuration. McGraw-Hill/Irwin 6– Formulating the Model A transportation problem Typically involves a set of sending locations, which are referred to as origins, and a set of receiving locations, which are referred to as destinations. To develop a model of a transportation problem, it is necessary to have the following information: Supply quantity (capacity) of each origin. Demand quantity of each destination. Unit transportation cost for each origin-destination route. McGraw-Hill/Irwin 6– Transshipment Problems Transshipment Problems A transportation problem in which some locations are used as intermediate . | Chapter 6 Transportation, Transshipment, and Assignment Problems Part 2 Deterministic Decision Models Learning Objectives Describe the nature of transportation, transshipment, and assignment problems. Formulate a transportation problem as a linear programming model. Use the transportation method to solve problems with Excel. Solve maximization transportation problems, unbalanced problems, and problems with prohibited routes. Solve aggregate planning problems using the transportation model. After completing this chapter, you should be able to: McGraw-Hill/Irwin 6– Learning Objectives (cont’d) Formulate a transshipment problem as a linear programming model. Solve transshipment problems with Excel. Formulate an assignment problem as a linear programming model. Use the assignment method to solve problems with Excel. After completing this chapter, you should be able to: McGraw-Hill/Irwin 6– Transportation Problems Transportation Problem A distribution-type problem in which supplies
đang nạp các trang xem trước
