Qnl. Find the optimal solution to the transportation problem using MODI method.WarehousesSupplyW1W2W3W4P119405020Plants17P21008074070P340401601215Demand20

Answered: Qnl. Find the optimal solution to the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

2) Using the cost table of the transportation problem shown below, do the following: a) Develop the appropriate LP model of the problem. WAREHOUSE PLANT A B C D DEMAND 1 5 10 7 20 200 2 3 12 5 25 400 3 8 10 10 18 600 4 7 8 12 30 1000 SUPPLY 200 500 300 1000
a.Find the starting solution of this transportation model by Least Cost Method. (15P) (Unit transportation costs are given in the table) 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
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?
b) Table 2 shows the transportation costs, demands and supplies of a transportation problem. Table 2: Transportation problem To From A B C Supply 1 7 4 150 8 11 50 3 250 10 11 12 Demand 100 200 150 i) Find the initial solution using the Minimum Cost method and identify the special case if any. ii) Suppose the initial solution to the above problem takes the basic variables x11 = 100, x12 = 50, X23 = 50, x32 = 150 and x33 = 100. Find the optimal solution using Modified Distribution method. iii) Present the optimal solution obtained in ii) graphically.
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.
Here is the initial tableau (by the NorthWest method) of a Min transportation problem. 1 2 3 Demand 19 Dual(v) 1 15 9 S1: 11 10 14 0 S2: 0 S3: B 0 B 3 N 15 Demanders 2 8 0 9 12 188 15 9 21 5 N 0 B 0 B 13 10 8 8 20 3 0 20 -4 N -6 N 0 B 17 7 5 4 0 0 1 -14 N -8 N 0 B Supply Dual(u) 0 (188 188 188 188 Using the Loop method fill in the values of the next tableau Each 2x2 matrix is the relevant square in the tableau. 9 (For grading convenience, in bottom right corner of each box use 1 for "B" and 0 for "N") 22 188 188 188 30 -4 2
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.
(iii) Find the initial basic feasible solution for the following transportation problem using VAM. Explain each step. Destination D1 D2 D3 D4 Supply 01 11 13 17 14 250 Origin 02 16 18 14 10 300 O3 Demand 200 225 275| 250 21 24 13 10 400
9.2-6. Consider the transportation problem having the following parameter table: Plants respecti and 20 Th Destination 4 Supply mine the 1. 9. 20 30 30 20 to the re 8. 4 9. Source 7. minimiz (а) Fort 3. 6. 4(D) 0. 0. stru Demand (b) Use solu (c) Star tivel tima 25 25 10 20 After several iterations of the transportation simplex method, a BF solution is obtained that has the following basic variables, x= 20, 20. Continue the transportation simplex method for wo more iterations by hand. After two iterations, state whether the solution is optimal 25, 5, X2 =0, x – 0, 15 9.2-9. T systems The (1) electr ing. The and, if so, why. D1.9.2-7. Consider the transportation problem having the fol- 740O 20
The creation of the has resulted in and O U.S. land bridge, greater price reductions, faster deliveries, and less risk from perils of the sea. O U.S. land bridge, greater shipment safety, faster deliveries, and less risk from government restrictions on imports O U.S. interstate highways, greater shipment safety, faster deliveries, and less risk from perils of the sea. O U.S. land bridge, greater shipment safety, faster deliveries, and less risk from perils of the sea.
TRANSPORTATION . Given the following transport. tion matrix where the numbers in the cells represent cost of transporting 1 unit from a specific source to a specific destination, determine the initial solution using the 3 methods and determine the optimum solution by using the initial solution with the lowest value of Z. 3 4 40 35| M M 20 30 From/To 5 6 Dummy | Supply 1 M 100 60 45 M 200 3 12 M 300 4 15 10 300 5 M M 15 300 Demand 300 300 300 | 150 150 1,200
9. Solve the following transportation problem using Excel. Factory A E K Demand B 6 5 8 35 Warehouse C 8 11 9 28 D 8 9 7 32 M 5 7 13 25 Supply 30 40 50

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Qnl. Find the optimal solution to the transportation problem using MODI method Warehouses Supply Wi W2 W3 W4 P1 19 40 50 20 Plants 17 P2 100 80 40 70 P3 40 40 60 20 12 15 Demand