TAILIEUCHUNG - Lecture Introduction to Management Science with Spreadsheets: Chapter 6S - 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 Supplement Transportation and Assignment Solution Procedures Learning Objectives 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. After completing this chapter, you should be able to: McGraw-Hill/Irwin 6S– Table 6S–1 Transportation Table for Harley’s Sand and Gravel McGraw-Hill/Irwin 6S– Figure 6S–1 Overview of the Transportation Method McGraw-Hill/Irwin 6S– Finding an Initial Feasible Solution: The Northwest-Corner Method The Northwest-Corner Method is a systematic approach for developing an initial feasible solution. is simple to use and easy to understand. does not take transportation costs into account. gets its name because the starting point for the allocation process is the upper-left-hand (northwest) corner of the transportation table. McGraw-Hill/Irwin 6S– Table 6S–2 Initial Feasible Solution for Harley Using Northwest-Corner Method McGraw-Hill/Irwin 6S– Finding an Initial Feasible Solution: The Intuitive Approach Identify the cell that has the lowest unit cost. Cross out the cells in the row or column that has been exhausted (or both, if both have been exhausted), and adjust the remaining row or column total accordingly. Identify the cell with the lowest cost from the remaining cells. Repeat steps 2 and 3 until all supply and demand have been allocated. McGraw-Hill/Irwin 6S– Table 6S–3a Find the Cell That Has the Lowest Unit Cost Table 6S–3b Allocate 150 Units to Cell B–2 McGraw-Hill/Irwin 6S– Table 6S–4 200 Units Are Assigned to Cell C–3 and 50 Units Are Assigned to cell A–1 Table 6S–5 Completion of the Initial Feasible Solution for the Harley Problem Using the Intuitive Approach McGraw-Hill/Irwin 6S– Table 6S–6 Vogel’s Approximation Initial Allocation Tableau with Penalty Costs McGraw-Hill/Irwin 6S– Table 6S–7 Initial

• Quản trị kinh doanh
• Management science
• Management science with spreadsheets
• Deterministic decision models
• Probabilistic decision models
• Transportation method
• Solving transportation problems
• Applications of management science
• Excel spreadsheets
• Management thought
• Evolution of management thought
• Ideas in management
• Management theory
• Systems in management
• Production management
• Forecasting process
• Qualitative forecasts
• Linear programming
• Graphical solution
• Marketing applications
• Simplex method
• Sensitivity analysis
• Integer programming
• Integer programming problems
• Solving integer programming
• Nonlinear programming
• Network optimization models
• Differential arithmetic
• Multicriteria decision
• Making models
• Decision theory
• Decision making
• Waiting line models
• Poisson distribution
• Fixed Interval simulations
• Discrete simulations
• An introduction to management science
• Advanced linear programming applications
• Integer linear programming
• Markov processes
• Nonlinear optimization models
• Inventory models
• Decision analysis