Operations research 1 assignment model 2. A company has six manufacturing plants and six warehouse located at different places in Luzon.The shipping costs for all routes are shown in the following matrix. The costs are in thousands. Findthe optimal solution on the assignment model.WarehousePlantsLagunaCaviteBataanBulacanNueva EcijaTarlacPampanga Manila241820191417161724261311Camarines Quezon Batangas261819222216201415211615161413271315Lucena201311171218

An assignment problem is a technique to find the combinations of the optimal solution to the…

Answered: 2. A company has six manufacturing…

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

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.
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
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. Read each of the following statements and determine which method of transportation is the best option. Provide a reason for your choice. Oil shipping from an oil field in Oklahoma to a refinery in Houston, Texas. a. b. Corn transported from a farm to a local grain elevator. C. Farm equipment manufactured in Canada transported to a warehouse in Wisconsin. d. Cut flowers sent from Hawaii to California.
The solution to this problem is shown below. Use it to answer parts (b) through (e). Transportation Problem Optimal Transportation Schedule To Destination From From Origin 1 оооо 2 3 3 1 2 11 19 0 0 0 9 0 0 Origin Excess Supply 34 16 0 6 Total Transportation Cost or Revenue is 347 Note: The Total Supply Exceeds The Todal Demand By 16 0 3 (b) How many chairs are moved from Baker to Business? (c) How many chairs are moved from Tirey to Parsons? (d) How many chairs are moved from Arena to Education? (e) Which site(s) has (have) chairs left? (Select all that apply.) Baker Hall Tirey Hall Arena Business Education Parsons Hall Holmstedt Hall
Example 3: With the help of North-West Corner method, solve the following transportation problem: W1 W2 W3 W4 Supply P1 21 40 30 15 10 P2 60 25 50 55 8. P3 45 10 60 10 17 Demand 7 8 14 35
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
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
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.
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.
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?
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.)

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