S7.20. An army division in Iraq has five troop encampments in thedesert, and the division leaders want to determine the best locationfor a supply depot to serve the camps. The (x, y) coordinates (in miles)of the camps, A, B, C, D, and E, and the daily amount of supplies (intons) required at each camp are as follows:S.CCoordinatesCampyDaily tonnage (1000s)11012085703001105203507530045060E400600100m uoya. Determine the best site for the supply depot using the cen-ter-of-gravity technique.b. Suppose the division commanders are limited to three possi-ble sites for the supply depot because of airfield locations andenemy troop concentrations. The coordinates (in miles) of thesethree potential sites are site 1 (400, 250), site 2 (100, 200), and site3 (200, 500). Using the load-distance technique, determine thebest site for the supply depot.antsA,B.

Answered: S7.20. An army division in Iraq has…

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

Given the dataset of a supply network in the following table: Location X co-ordinates Y co-ordinates Supply or demand Site 1 61 44 40 Site 2 12 16 Site 3 38 26 76 Site 4 6 22 72 63 22 54 Supplier 1 Supplier 2 26 8 77 18 62 37 Supplier 3 Supplier 4 8 65 43 Supplier 5 43 36 26 Supplier 6 8 41 68 a. Calculate the Euclidean distance from every potential site to every supplier b. Calculate the load-distance value for every potential site. c. Conclude on the best site with the lowest load-distance value.
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup itsdistribution centre.I. What is the main objective of using this technique? II. What information will be needed in order to use this technique? III. Setup a numerical example that can be used to demonstrate to the owner of thecompany how the technique can be used. IV. Use the numerical example set up above to demonstrate how the centre of gravitylocation technique is used.
Q1. Find the initial basic feasible solution of the following transportation problem by (a) Northwest-corner cell method (b) Least cost cell method Destination Source I 2 3 4 1 2 3 Supply 2 7 4 5 3 3 I 8 5 4 7 7 1 6 2 14 Demand 2 9 18 State which of method is better.
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y- Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc 6 8 4 Sky Production 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
2. You have been tasked by Corica Pastries, to setup a retail location anywhere inMalaysia, to introduce their world famous apple strudels to the Malaysian market.b. Store location analysisi. Alternate geographic trading areasii. Type of locationiii. Literacy of populationiv. Trading factorsv. Accessibilityvi. Amenities This is not a writting assignment, please don't reject. If don't know let others to answer. Thank you
#4. The Pelican Company has four distribution centers (A, B, C, and D) that require 50,000, 40,000, 60,000 and 40,000 liters of diesel fuel, respectively, per month for their long-haul trucks. Three fuel wholesalers (1, 2 and 3) have indicated their willingness to supply as many as 60,000, 80,000, and 50,000 liters of fuel, respectively. The total cost (shipping and price) of delivering 1000 liters of fuel from each wholesaler to each distribution center is shown in the following table. Distribution center Wholesaler A B C D • 1 1700 1600 1600 1600 2 1500 1800 1600 1700 3 1800 1500 1800 1600 I. Determine the optimal solution. Check if all capacities have been exhausted and that all demands can be met with this solution. II. What is the total cost of the solution?
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Judy inc. Zac Supermarket Harry Inc. Sky Productions Annual Volume X-Coordinate Y-Coordinate 3 7 5 2 8 4 1 5 25 13 6 4 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
A clothing manufacturer produces women’s clothes at four locations in Mexico. Relative locationshave been determined, as shown in the table below. The location of a central shipping pointfor bolts of cloth must now be determined. Weekly quantities to be shipped to each location arealso shown in the table. Determine the coordinates of the location that will minimize distributioncosts. Location (x,y) WeeklyQuantityA 5,7 15B 6,9 20C 3,9 25D 9,4 30
ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs.I. Design a numerical example in order to demonstrate to the Productions andOperations Manager how break-even analysis can be used in this case. II. Demonstrate to the OM manager how to go about choosing the best location using thenumerical example you designed above.
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. . If total fixed cost = 40000 AVC = 20 Price per unit = 10 Break even point = 40000 / 20 - 10= 4000 So at the 4000 units of production, there will be no profit and loss as the total revenue is equal to the total cost. Demonstrate to the OM manager how to go about choosing the best location using thenumerical example you designed above.
Supply Solve the following Transportation problem using best cell method What is the total cost? 1 2 3 4 A 25 3 10 5 9 Destination B 35 2 1 2 6 C 10 1 2 8 3 D 30 1 2 8 3 25 20 25 30

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