In each of the following, name the term defined. Answers are listed at the bottom. The main cost criterion employed when a transportation model is used for analyzing a logistics network. The Microsoft Excel function used to solve the transportationmodel. For the transportation model to be able to find a feasible solution, this must always be greater than or equal to total demand. The “changing cells” in a transportation model represent this. This is a method that locates facilities relative to an X, Y grid. A technique that is useful for screening potential locations for services.

In each of the following, name the term defined. Answers are listed at the bottom. The main cost criterion employed when a transportation model is used for analyzing a logistics network. The Microsoft Excel function used to solve the transportationmodel. For the transportation model to be able to find a feasible solution, this must always be greater than or equal to total demand. The “changing cells” in a transportation model represent this. This is a method that locates facilities relative to an X, Y grid. A technique that is useful for screening potential locations for services.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section6.5: Set-covering And Location-assignment Models

Problem 34P

See similar textbooks

Similar questions

PLEASE SHOW ALL FORMULA PharmaCo wants to determine how to deploy sales representatives across its Western U.S. region to support a new drug for obesity. Sales representatives will be located in a "home city", which they serve, in addition to cities with feasible commuting distance, with the objective that all cities must be served by at least one sales representative. The feasible connections between each city in the region are listed below (1 indicates a feasible connection, potential home cities are shown in columns, and cities served in rows): Potential Rep Home City Served? Albuquerque El Paso Denver Phoenix San Diego Los Angeles San Francisco Portland Seattle Las Vegas Salt Lake City Albuquerque 1 1 1 1 0 0 0 0 0 0 0 El Paso 1 1 0 1 0 0 0 0 0 0 0 Denver 1 0 1 1 0 0 0 0 0 0 1 Phoenix 1 1 1 1 1 1 0 0 0 1 1 San Diego 0 0 0 1 1 1…
a.Find the starting solution of this transportation model by Least Cost Method. (Unit transportation costs are given in the table) Then find the optimal solution of this transportation model by Stepping Stone Method. D1 D2 D3 D4 Supply M1 16 24 14 11 25 M2 21 18 17 9 30 M3 15 13 21 14 40 Demand 25 25 20 25
A manufacturer of printing inks, has five manufacturing plants worldwide. Their locations and capacities are shown in the tables below. The cost of producing 1 ton of ink at each facility in shown in Table 2 and the production costs are in the local currency of the country where the plant is located. The major markets for the inks are North America, South America, Europe, Japan, and the rest of Asia. Table 1 shows the following information: Demand at each market; Transportation costs from each plant to each market in U.S. dollars; Management must come up with a production plan. Answer the questions below. For each case, be sure to fully define the mathematical model (notation, objective function, and constraints). Make sure your results are clear. If the exchange rates are expected as shown in Table 3, and no plant can run below 50 percent of capacity, how much should each plant produce and which markets should each plant supply? If there are no limits on the amount produced in…
Suppose there is a transportation model with 4 factories and 6 warehouses. In order to develop an initial solution using the intuitive lowest cost method, do we have to add one or more dummy sources in the transportation matrix, and why?
Consider the following transportation decision-making information: Plant Capacity Store Demand A 400 X 200 B 500 Y 250 C 100 Z 300 Total 1000 Total 750 Cost to ship from plant to store (per unit of demand) Plant Store X Y Z A $2 $2 $3.5 B $4 $5 $4.5 C $3 $3 $3 A. Develop the following shipping assignment table that uses the Solver function to find the optimal shipping patterns between the plants and the stores. Plant Store X Y Z A B C B. What is the minimal shipping cost?
The more sources and destinations there are for a transportation problem, the smaller the percentage of all cells that will be used in the optimal solution. Explain.
Find the optimal solution for the transportation problem having the cost and requirement table below. -Solve the following transportation models using Excel Solver.
Solve for the optimal Transportation schedule. Find an initial feasible solution using the Intuitive Approach/Least-Cost Method and use Stepping-Stone Method to test for optimality.
Consider the following transportation problem: Destination company A B C Supply 1 5 1 7 10 2 6 4 6 80 3 3 2 5 15 Demand 75 20 50 Since there is not enough supply, some of the demands at these destinations may not be satisfied. Suppose these are penalty costs for every unsatisfied demand unit which are given by 5, 3, and 2 for destination A, B, and C respectively. 1. Determine how many units and from which source needs to be shipped using the following methods: A) NWCB) LCMC) VAM2. Find the minimum distribution cost
The objective function of a transportation problem is to: A. maximize transportation cost B. maximize supply quantities C. minimize total shipping cost D. minimize total demand Don't answer by pen paper and don't use chatgpt otherwise we will give dounvote
Explain how balancing a Transportation Problem If Total Supply Is Less Than Total Demand in linear programming. Please give your example
Jefferson Distributing is analyzing distribution networks with either 4, 5, 6 or 7 warehouses to serve 200 major customers in Europe. Relevant costs include transportation cost from the warehouses to customers, fixed facility costs, and inventory costs in the warehouses. The table below shows the annual transportation cost produced by a facility location software tool for locating 4, 5, 6 or 7 warehouses for this company. Suppose that annual inventory cost for the network can be modeled as $800,000 times the square root of the number of warehouses. Thus, if the network has 4 warehouses, then the annual inventory cost would be $800,000 x √4= $1,600,000. Number of Warehouses Transportation Cost 4 8,000,000 5 6,500,000 6 5,000,000 7 4,400,000 a) If the annual fixed cost per warehouse is $1,000,000, how many warehouses should there be to minimize the total (transportation + warehouse + inventory) cost? b) Now suppose the…