220 likes | 248 Views
Learn how to solve transportation, transshipment, and assignment problems in this comprehensive lesson covering network flow models, linear programming, Excel and QM solutions. Understand the transportation model, transshipment model, and assignment model.
E N D
Quantitative Methods MAT 540 Transportation, Transshipment, and Assignment Problems
Objectives • When you complete this lesson, you will be able to solve: • Transportation problems • Transshipment problems • Assignment problems
Overview • Network flow problems • Transportation models • Transshipment models • Assignment models
The Transportation Model • Characteristics • A product is transported from a number of sources to a number of destinations at the minimum cost • Each source is able to supply a fixed amount of the product, and each destination has a fixed amount of demand for the product
The Transportation Model, continued Grain ElevatorSupplyMill Demand 1. Kansas City 150 A. Chicago 200 2. Omaha 175 B. St. Louis 100 3. Des Moines 275 C. Cincinnati 300 Total 600 tons Total 600 tons
The Transportation Model, continued • Linear programming model
Computer Solution of a Transportation Problem • Excel solution
Computer Solution of a Transportation Problem, continued • Excel QM solution
Computer Solution of a Transportation Problem, continued • Excel QM solution
Computer Solution of a Transportation Problem, continued • QM for Windows solution
The Transshipment Model • Transshipment points • Transportation may take place from • Sources through transshipment points to destinations • One source to another • One transshipment point to another • One destination to another • Sources to destinations
The Transshipment Model, continued • Nebraska, Colorado each harvest 300 tons • Kansas City, Omaha, and Des Moines are transshipment points
The Transshipment Model, continued • Supply constraints for the farms • Demand constraints at mills
The Transshipment Model, continued • Grain shipped into Kansas City: • Grain shipped out of Kansas City: • The two amounts must equal one another • Constraints for Omaha and Des Moines
The Transshipment Model, continued • Linear programming model
The Transshipment Model, continued • Excel solution
The Assignment Problem • All supply and demand values equal 1 • The supply at each source and the demand at each destination are each limited to one unit
The Assignment Problem, continued • Four teams of officials to four games • Minimize distance traveled • Supply and demand is one team of officials per game
The Assignment Problem, continued • Linear programming model
The Assignment Problem, continued • Excel solution
The Assignment Problem, continued • Excel QM solution
The Assignment Problem, continued • QM for Windows Solution