2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 400 190 Factory 1 3 A 8 6 10 6 B 12 8 7 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ? 2.

2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 400 190 Factory 1 3 A 8 6 10 6 B 12 8 7 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ? 2.

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

Q3) The Cure medical distribution center distributes urgent medical equipment for five local hospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest in a new warehouse in Washington DC to minimize the total distance from five major hospitals. The coordinate of the five hospitals is given below: ( (2) 3 Great Fall (C) (47) 122 (121) Fairfax 10 We W Bu (645) -D (-20, 30)- -E (-40, -30) Colesville Fairland Calpen A (10,60) -B (10,-10) Ⓡ South Lourel stuxent search Refuge (MA A (14) tille (214) pha Bowit (00 X -C (45, -20) 201 C a) Use Solver to determine where the new warehouse should be in to minimize the total distance from 5 hospitals. What are the coordinates of the new warehouse? b) Solve your problem again to minimize the maximum distance between hospitals and the new warehouse. What are the coordinates of the new warehouse?
Consider the transportation table below for answering question number 21-25. From To Quezon city Bataan Php 7 Visayas Mindanao Php 10 Php 6 Demand 100 Manila Taguig Supply Php 5 Php 9 Php 12|Php 10 150 200 Php 3 Php 14 50 80 220 400 21. Using Northwest Corner Rule, how many must be supplied from Visayas to Taguig? (a) 170 (b) 180 (c) 190 (d) 200 22. Using Northwest Corner Rule, how many must be supplied from Mindanao to Taguig? (a) 45 (b) 50 (c) 55 (d) 60 23. Using Minimum Cost Method, how many must be supplied from Visayas to QC? (a) 200 (b) 210 (c) 220 (d) 230 24. Using Minimum Cost Method, how many must be supplied from Mindanao to Manila? (a) 35 (b) 40 (c) 50 (d) 55 25. Using Vogel's Approximation Method, how many must be supplied from Bataan to Taguig? (a)20 (b) 25 (c) 30 (d) 40
1. Central Construction Company moves materials between three plants and three projects. Project A requires 72 truckloads each week, project B requires 102, and project C requires 41. Plant W can supply 56 loads, plant X can supply 82, and plant Y can supply 77. Using the cost information given in the following table, compute the optimum transportation cost using the stepping stone method. COST INFORMATION From To Project A To Project B To Project C Plant w P 4.00 8.00 8.00 Plant X 16.00 24.00 16.00 Plant Y 8.00 16.00 24.00
1. For the following problems, provide your written solutions within this template. Do not create a new file. Show all steps used in arriving at the final answers. Incomolete solutions will receive partial credit. 3. Provide formulas using Equation Editor and diagrems using Drawing Tool. 4. Use the Solver to obiain computer solutions in an Excel workbook. 5. Submit the Word and Excel workbook(s) separately as attachments. 2. Problern 1 The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow}. Sources (Supplies) Destinations (Demands) 2500 2900 4 A000 3800 8. 3800 .... **.** 9. R. at 2700 12 3700 oce D. a) Write the mathematical formulation of the problem. b} Use the Excel Solver to solve the problem. Generate the answer and sensitivity…
9-39. Grey Construction would like to determine the leastexpensive way of connecting houses it is buildingwith cable TV. It has identified 11 possible branchesor routes that could be used to connect the houses.The cost in hundreds of dollars and the branches aresummarized in the following table.(a) What is the least expensive way to run cable tothe houses?
2. The table below shows the cost matrix From – To- travel that must fulfil by PT. JauhAbadi marketing officer. Help the officer to determine the route from City A to all other cities with minimum cost Cities A C D E A M 16 18 13 20 B 21 M 16 27 14 C 12 14 M 15 21 D 11 18 19 M 21 E 16 14 17 12 M INSTRUCTION: Use handwriting and software to find solution of Problem 2. Screenshot each process to show how the problem solved.
Q: When we solve the given transportation problem according to the lowest cost method, which warehouse and/or warehouses are suitable for shipment from f3 (F: Factory M: Customer)A) no needb) M1, M2, M3c) M1 and M2d) M3 and M1E) M3
S7.12. The Federal Parcel Service wants to build a new distribution cen- ter in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges and the Char- lotte-Douglas International Airport. The coordinates of these three sites and the number of weekly packages that flow to each are as follows: 1-77 1-85 Airport X= 14 X= 20 X= 30 y = 30 y = 8 ソ=14 w = 17,000 w = 12,000 W = 9000 Determine the best site location using the center-of-gravity technique.
2. Unbalanced. Provide the transportation model for the calculation of cost given the following data: Use the Stepping Stone Method to solve the following. Use degeneracy method or dummy method if necessary.
Sports of All Sorts produces, distributes, and sells high-quality skateboards. Its supply chain consists of three factories (located in Detroit, Los Angeles, and Austin) that produce skateboards. The Detroit and Los Angeles facilities can produce 350 skateboards per week, but the Austin plant is larger and can produce up to 700 skateboards per week. Skateboards must be shipped from the factories to one of four distribution centers, or DCs (located in Iowa, Maryland, Idaho, and Arkansas). Each distribution center can process (repackage, mark for sale, and ship) at most 500 skateboards per week. Factory/DCs Detroit Los Angeles Austin 1 2 3 Retailers/DCs Just Sports Sports 'N Stuff Iowa The Sports Dude 25.00 35.00 40.00 8 9 4 1 Shipping Costs ($ per skateboard) Iowa 30.00 27.50 Maryland 30.00 25.00 4 45.00 40.00 Skateboards are then shipped from the distribution centers to retailers. Sports of All Sorts supplies three major U.S. retailers: Just Sports, Sports 'N Stuff, and The Sports…
Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in different cities. All of sudden there rouse a demand for the product in another five cities that didn't agency of the company. The company is now facing the problem of deciding on how to assign the existing agencies in order to dispatch the product to needy cities in such a waythat the travelling distance is minimized. The distance between the surplus and deficit cities in kilometer is given the following table. Surplus city Deficit cities Deficit cites A1 160 130 115 190 200 B1 135 120 130 160 175 C1 140 110 125 170 185 D1 50 50 80 80 110 E1 55 35 80 80 105 Determine the optimum assignment schedule.
The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Shipping Cost per Case to each Warehouse W2 Factory Сарacity W1 W3 W4 W5 Dummy $5 $5 $4 $7 $0 F1 60,000 $4 $5 $4 $6 $8 $0 F2 80,000 $6 $5 $7 $4 $5 $0 F3 80,000 $5 $9 $6 $7 $4 $0 F4 40,000 Demand 45,000 40,000 30,000 35,000 50,000 60,000 260,000 The minimum shipping cost is S | (Enter your response as a whole number.)