A company has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City,and ships to 12 retail stores, located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Charlotte,Minneapolis, Fayetteville, Birmingham, Orlando, Cleveland, and Philadelphia. The company wants tominimize the transportation costs of shipping one of its products. The per-unit shipping cost from eachdistribution center to each retail location and the amounts currently in inventory and ordered at each retaillocation are shown in the accompanying table. Develop and solve an optimization model to minimize thetotal transportation cost and answer parts a and b.Click here to view the shipping data.....a. What is the minimum cost of shipping?Total Cost = S(Type an integer or a decimal. Do not round.) on centers, located in Atlanta, Leington. Milwaukee, and Salt Lake City, and ships to 12 retal sturos, located in Seattle, San Franciaco, Las Vegan, Tucson, Denver, Charlotte, Minneapolia, Fayetevile, Bimingham, Orlanants to minimize the transportation costs of shipping one of s products The per unit shipping cost from each distribution center to each retail location and he amounts currently in invantory and erdered at each retal locaelop and solve an optimization medel to mininize the total transportation cost and answer parts and b.ipping dataCost of shipping data- XAtlantaLexingtonMilwaukeeSalt Lake CityDemandSeattle$2.15$1.95$1.7050.604,500San FranciscoLes VegasTucsonDenver$2.10$2.00$1.85S0.5517,000f shipping?$1.75$1.70$1.5050 354,500$1.50$1.53$1.41$0.60S0 40S0.954,000$1 20S0 65$0.90De nat round)$1.10S0.954.300CharlotteS0 55S0 407.5003.500MinneapolisFayettevilleBirminghamS0 60$1.05$0.40$1.00$0.95$1.109.000$0 35S0.15S0 70$1.353,30012,000OrlandoS0.5010.70$1.60ClevelandPhiladelphieSupplyS0.60$0.25S0 35$1.609,500$0.5050 3035,000$0.4015.100$1.7016.00040.30017.000PrintDone

Shipping costs is known as the cost of transporting the goods from one place to other. Contingent…

Answered: A company has four distribution…

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

General Ford has two plants, two warehouses, and three customers. The locations of these as follows: Plants: Detroit and Atlanta;Warehouses: Denver and New YorkCustomers: Los Angeles, Chicago, and Philadelphia Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 142 cars per week, and Atlanta can produce 86 cars per week. Los Angeles requires 50 cars per week; Chicago, 52; and Philadelphia 84. It costs $9500 to produce a car in Detroit and $7500 to produce a car in Atlanta, and the costs of shipping a car between cities are given in the table below. What is the minimal cost of meeting General Ford's weekly demands?
Oranges are grown, picked and then stored in warehouses in Tampa, Miami, and Fresno. Theses warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston. The following table shows the shipping costs per truckload (in hundreds of dollars), supply, and demand. Because of an agreement between distributors, shipments are prohibited from Miami to Chicago Formulate this problem as a Linear Programming Define decision variables. Define objective function. Define the constraints.
At the end of a cycle of schedules, a trucking firm has a surplus of one vehicle each in cities A, B, C, D, E, and F and a deficit of one vehicle each in cities 1, 2, 3, 4, 5, and 6. The distances between cities with a surplus and the cities with a deficit are shown below. Find an assignment of surplus vehicles to deficit cities that will result in a minimum total distance. What is the total distance? -Solve the following transportation models using Excel Solver. -Find the optimal solution for the transportation problem having the cost and requirement tablebelow.
The Executive Furniture Corporation, which manufactures office desks at three locations: Des Moines, Evansville and Fort Lauderdale. The firm distributes the desks through regional warehouses located in Albuquerque, Boston and Cleveland. The production costs per desk are the same at each factory and hence the only relevant costs are those of shipping from each source to each destination. They are assumed to be constant regardless of their volume shipped. An estimate of the monthly production capacity at each factory and estimate of the number of desks required per month at each destination and the shipping cost ($) per desk from each source to each destination is given in the following table: Transportation table for Executive Furniture Corporation To From Albuquerque Boston Cleveland Factory capacity Des Moines 6 5 8 300 Evansville 5 9 8 400 Fort Lauderdale 4 5 6 350 Requirements 350 250 450…
Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables: Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs. What would be the effect on the solutions if the capacity at each plant were 70 fishes?
Denver Transportation Company is considering investing in several projects that have varying capital requirements over the next four years. Faced with limited capital each year, management would like to select the most profitable projects that it can afford. The estimated net present value for each project, the capital requirements, and the available capital over the four-year period are shown in the following binary integer linear programming model. Questions 1. What is the optimal solution? 2. What is the total estimated net present value at the optimal solution? 3. Based upon the optimal solution and slack variables, what recommendations could you make to management? Where S = 1 if the store expansion project is accepted; 0 if rejected F = 1 if the fleet expansion project is accepted; 0 if rejected M = 1 if the equipment upgrade project is accepted; 0 if rejected R = 1 if the market research project is accepted; 0 if rejected and currency is in $1,000s.…
Luminous lamps have three factories - F1, F2, and F3 with production capacity 30, 50, and 20 units per week respectively. These units are to be shipped to four warehouses W1, W2, W3, and W4 with requirements of 20, 40, 30, and 10 units per week respectively. The transportation costs (in Rs.) per unit between factories and warehouses are given below. Find an initial basic feasible solution.
A beer distributor needs to plan how to make deliveries from its warehouse (node 1) to a supermarket (node 7), as shown in the network below. A graph with 7 nodes and 9 arcs is shown. Node 1 is connected to node 2 by arc of value 3, to node 5 by arc of value 3, and to node 6 by arc of value 11. Node 2 is connected to node 3 by arc of value 4. Node 3 is connected to node 2 by arc of value 4 and to node 4 by arc of value 7. Node 4 is connected to node 3 by arc of value 7, to node 6 by arc of value 5, and to node 7 by arc of value 6. Node 5 is connected to node 6 by arc of value 7. Node 6 is connected to node 4 by arc of value 5, to node 5 by arc of value 7, and to node 7 by arc of value 3. Develop the LP formulation for finding the shortest route from the warehouse to the supermarket. (Let xij represent the flow from node i to node j.) Min s.t.Node 1 Flows Node 2 Flows Node 3 Flows Node 4 Flows Node 5 Flows Node 6 Flows Node 7…
Anderson Watch Company is considering opening four possible distribution centers located in Atlanta, Lexington, Milwaukee, and Salt Lake City with a fixed cost to open of $17,000, $22,000, $35,000, and $25,000, respectively. They currently have ten retail stores located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Dallas, Birmingham, Orlando, Cleveland, and Philadelphia. Lisa, the supply chain VP, wants to minimize the transportation costs of shipping their French down pillows. The per-unit shipping cost from each distribution center to each retail location and the amounts currently in inventory and ordered at each retail location are shown in the following tables. What is the minimum cost solution? What is the minimum cost solution if Lisa wants to use single sourcing?
Baseball umpiring crews are currently in four cities where three-game series are beginning. When these are finished, the crews are needed to work games in four different cities. The distances (miles) from each of the cities where the crews are currently working to the cities where the new games will begin are shown in the following table. The X indicates that the crew in Oakland cannot be sent to Toronto. Formulate as a linear programming problem to minimize the miles traveled. HINT: Since one assignment cannot be made, what are the options for that variable in the formulation? Solve using Excel solver. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
A company imports goods at two ports: Philadelphia and New Orleans. Shipments of one product are made to customers in Atlanta, Dallas, Columbus, and Boston. For the next planning period, the supplies at each port, customer demands, and shipping costs per case from each port to each customer are as follows: Customers Port Atlanta Dallas Columbus Boston Port Supply Philadelphia 2 6 6 2 5,000 New Orleans 1 2 5 7 3,000 Demand 1,400 3,200 2,000 1,400 Develop a network representation of the distribution system. Develop the objective function and the constraints.
A minimum-cost flow problem has 8 supply nodes, 0 transshipment nodes, and 3 demand nodes. If each supply node can ship to every demand node, how many arcs will be included in the model?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS