Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures thewashers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the followingnumbers of washing machines to be produced at each location:New York CityFort WorthSan DiegoMinneapolisBindley has three plants that can produce the motors. The plants and production capacities are105,000135,000120,000BoulderMaconGary60,00070,000105,00050,000Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they wereproduced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit(Shipment will be made in lots of 1,000)PRODUCED AT NEW YORK CITYBoulder142212MaconGarySHIPPED TOFORT WORTH182614SAN DIEGO2514MINNEAPOLIS131422Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant andhow many motors should be shipped from each plant to each destination.a. Develop a transportation grid for this problem. Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant andhow many motors should be shipped from each plant to each destination.a. Develop a transportation grid for this problem.New York City Fort WorthFrom/ToBoulderMaconGaryRequirementsCandidate SolutionBoulderMaconGaryTotal suppliedb. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)ProfitSan DiegoBoulderMaconGaryTotal profitMinneapolisSupplyTotal Shipped

The transportation problem is a classic optimization problem in operations research that deals with…

Answered: Bindley Corporation has a one-year…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 100P

See similar textbooks

Similar questions

Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country. New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) Macon Gary PRODUCED AT NEW YORK CITY Boulder 12 From/To Boulder Macon Gary Requirements 75,000 45,000 60,000 50,000 100,000 145,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Profit 24 11 Boulder Macon…
FlexSteal, marketed as a miracle brush-on sealant and baldness cure, is manufactured at three plants which supply the demand at the four regional centres in the United States. The cost to ship a truckload from each of the plants to the regional centres is shown in the table below. Note that the capacity and the total demand are both measured in truckloads. Plant 1 Plant 2 Plant 3 Total Demand (units) A) $106,850 B) $107,450 C) $108,500 Philadelphia D) $109,750 $89 $120 $95 300 Atlanta $75 $88 $82 1. What is the lowest cost solution for the existing set of plants and regional centres? 300 Dallas $93 $103 $112 300 Los Angeles $115 $93 $98 300 Capacity (units) 400 400 400
A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. Location Criteria Weight 1 2 3 4 Raw material availability 0.06 P VG OK VG Infrastructute 0.07 P G VG OK Transportation costs 0.33 G P OK P Labor relations 0.25 VG G P OK Quality of life 0.29 G OK P VG VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 2 3 4 ______ is the best location and _______ is the worst location.
From plants Existing plants Atlanta Tulsa Proposed locations New Orleans Houston Forecast demand To Distribution Centers Los Angeles $8 $4 $5 $4 800 New York $5 $7 $6 $6 1200 Production capacity 600 900 500 500 2000 Unit production cost $6 $5 $4 (anticipated) $3 (anticipated) Williams Auto Top Carriers has decided to open a third plant in one of the two cities - New Orleans and Houston. Based on the information below, which of the new location in combination with the existing plants and distribution centers, yields a lower cost for the firm? Find the total transportation cost, and the optimal product quantities for each routes.
Jason Company manufactures plastic products at three locations in Malaysia: Skudai, Taiping, and Ujok. The company needs to supply the products to three clients in Penang, Kuantan, and Melaka. The production capacities of the plants are given below. a) Find the initial solution using northwest corner rule method. b) Find the optimal solution using stepping stone method. Client Plant (To) Supply (From) Penang Kuantan Melaka RM50 RM40 RM60 Skudai 4000 RM30 RM45 RM40 Taiping 3000 RM60 RM35 RM30 Ujok 3000 Demand 2000 4500 3500 10000
Jason Company manufactures plastic products at three locations in Malaysia: Skudai, Taiping, and Ujok. The company needs to supply the products to three clients in Penang, Kuantan, and Melaka. The production capacities of the plants are given below. a) Find the initial solution using northwest corner rule method. b) Find the optimal solution using stepping stone method. Client Plant (То) Supply (From) Penang Kuantan Melaka RM50 RM40 RM60 Skudai 4000 RM30 RM45 RM40 Taiping 3000 RM60 RM35 RM30 Ujok 3000 Demand 2000 4500 3500 10000
Develop a network showing the origin nodes, destinations, arcs, cost per arc, supply, and demand. Match the correct answer to each question. Warehouse A B C D City E City F City G City H Warehouse Supply. 0.51 0.21 0.52 0.41 4000 Question 1 0.31 Question 2 0.56 0.43 0.35 0.41 0.28 City Demand 4,400 3,000 6,500 4,700 Match the correct answer to the following questions: 1. What is the supply constraint for Warehouse D? 2. What demand constraint for City H? 0.32 0.54 0.33 4000 0.54 0.34 0.52 6300 6000 [Choose ] [Choose ] > >
Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating only the transportation costs per unit as shown in the tables below, which site is best? FROM EXISTING PLANTS TO DECATUR MINNEAPOLIS CARBONDALE DEMAND Blue Earth $20 $17 $21 250 Ciro 25 27 20 200 Des Moines 22 25 22 350 Capacity 300 200 150 FROM PROPOSED PLANTS TO EAST ST. LOUIS ST. LOUIS Blue Earth $29 $27 Ciro 30 28 Des Moines 30 31 Capacity 150 150
Hardgrave Machine Company produces computer components at its factories in Cincinnati, Kansas City, and Pittsburgh. These factories have not been able to keep up with demand for orders at Hardgrave’s four warehouses in Detroit, Houston, New York, and Los Angeles. As a result, the firm has decided to build a new factory to expand its productive capacity. The two sites being considered are Seattle, Washington, and Birmingham, Alabama. Both cities are attractive in terms of labour supply, municipal services, and ease of factory financing. Table 1 presents the production costs and monthly supplies at each of the three existing factories, monthly demands at each of the four warehouses, and estimated production costs at the two proposed factories. Transportation costs from each factory to each warehouse are summarized in Table 2. In addition to this information, Hardgrave estimates that the monthly fixed cost of operating the proposed facility in Seattle would be $400,000. The…
Canning Transport is to move goods from three factories to three distribution centers. Information about the move is given below. Give the network (draw chart with nodes) model and create an LP in Tab #11 to find the minimum shipping costs. Source Supply Destinatio Demand A B с 200 100 150 Shipping costs are: Source A B C n X Y Z X 3 9 5 50 125 125 Destination Y 2 10 6 4 (Source B cannot ship to destination Z) Z 5
Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used es a row material by manufacturers of plastic goods around the United States. SP currently operstes four manufacturing centers in Philadelphis, PA: Atlants, GA: St. Louis, MO; and Salt Lake City, UT. The plants have different capacities and production costs as indicated in the table below. МAXIMUM CAPAАCITY PROD. COSTS (x 188,800 LB.) (PER 1,808 LB.) $325.00 $275.00 $305.00 $250.00 PLANT Philadelphia Atlanta 7.5 9.0 St. Louis 12.0 18.3 Salt Lake City SP currently has six contract customers located in New York City: Birmingham, AL; Terre Haute, IN; Doallas, TX; Spokane, WA; and San Diego, CA. Transportstion costs between the plants and verious customers, es well os contracted demand from esch customer, are shown in the table below. TRANSPORT COSTS PER 1,02e LB. TERRE HAUTE BIRMINGHAM $ 52 FROM/TO Philadelphia Atlanta St. Louis Salt Lake City NYC DALLAS SPOKANE $ 62 SAN DIEGO $ 85 $ 45 $ 56 78 55 42 58 59 se 82…
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown below. Shipping Cost per Case to Warehouses Factory Сарacity W1 W2 W3 W4 W5 $1.20 $3.60 | $4.80 $6.00 $7.20 F1 40,000 30,000 10,000 $2.40 $2.40 | $1.20 $4.80 $6.00 F2 30,000 25,000 5,000 $1.20 $6.00 $1.20 $3.60 $1.20 F3 30,000 10.000 20,000 $6.00 $2.40 $4.80 $6.00 $4.80 F4 25,000 25,000 Demand 30,000 35,000 25,000 15,000 20,000 125,000 What is the total cost of the optimal solution? Total cost = $ (Enter your response to the nearest dollar.)

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