Question;MAT540Week 10 HomeworkChapter 64. Consider the following transportation problem:From To (cost) Supply1 2 3 A $ 6 $ 9 $100 130B 12 3 5 70C 4 8 11 100Demand 80 110 60 Formulate this problem as a linear programming model and solve it by using the computer.6. Consider the following transportation problem:From To (cost) Supply1 2 3 A $ 6 $ 9 $ 7 130B 12 3 5 70C 4 8 11 100Demand 80 110 60 Solve it by using the computer.36. World Foods, Inc., imports food products such as meats, cheeses, and pastries to the United States from warehouses at ports in Hamburg, Marseilles and Liverpool. Ships from these ports deliver the products to Norfolk, New York and Savannah, where they are stored in company warehouses before being shipped to distribution centers in Dallas, St. Louis and Chicago. The products are then distributed to specialty foods stores and sold through catalogs. The shipping costs ($/1,000 lb.) from the European ports to the U.S. cities and the available supplies (1000 lb.) at the European ports are provided in the following table:From To (cost) Supply4. Norfolk 5. New York 6. Savannah 1. Hamburg $420 $390 $610 552. Marseilles 510 590 470 783. Liverpool 450 360 480 37The transportation costs ($/1,000 lb.) from each U.S. city of the three distribution centers and the demands (1,000 lb.) at the distribution centers are as follows:Warehouse Distribution Center7. Dallas 8. St. Louis 9. Chicago4. Norfolk $ 75 $ 63 $ 815. New York 125 110 956. Savannah 68 82 95Demand 60 45 50Determine the optimal shipments between the European ports and the warehouses and the distribution centers to minimize total transportation costs.48. The Omega pharmaceutical firm has five salespersons, whom the firm wants to assign to five sales regions. Given their various previous contacts, the salespersons are able to cover the regions in different amounts of time. The amount of time (days) required by each salesperson to cover each city is shown in the following table:Region (days)Sales-person A B C D E1 17 10 15 16 202 12 9 16 9 143 11 16 14 15 124 14 10 10 18 175 13 12 9 15 11Which salesperson should be assigned to each region to minimize total time? Identify the optimal assignments and compute total minimum time.Week 10 discussionDiscussion assignment and transshipment;problems;Select one (1) of the following;topics for your primary discussion posting;?;Explain the assignment model and how;it facilitates in solving transportation problems. Determine the benefits to be;gained from using this model.;?;Identify any challenges you have in;setting up an transshipment model in Excel, and solving it with Solver. Explain;exactly what the challenges are and why they are challenging. Identify;resources that can help you with that.
Paper#60565 | Written in 18-Jul-2015Price : $42