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

‏صورة
Wiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs per shipment (labor, transportation, and utilities) are listed in the following table. Sales projections range from 550,000 to 600,000 shipments per year. Location Annual fixed cost Variable Costs per Shipment Denver $5,000,000 $4.65 Santa Fe $4,200,000 $6.25 Salt Lake City $3,500,000 $7.25 a. Plot the total cost curves for all the locations on a single graph. b. Which city provides the lowest overall costs? Thank you!!!
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 Productions 4 1 5 Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
7. The BD restaurant chain purchases materials from four different food suppliers. The company wants to construct a new central distribution center to process and package the materials before shipping them to their various restaurants. The suppliers transport items in 40-foot truck trailers, each with a capacity of 38,000 lbs. The locations of the four suppliers and the annual number of trailer loads that will be transported to the distribution center are shown in the following table (distance in miles). Using the center-of-gravity method, determine a possible location for the distribution center. A B с D X Y 200 200 100 500 250 600 500 300 Load 75 105 135 60 BD wants to evaluate three different sites it has identified for its new distribution center relative to the four suppliers identified. The coordinates of the three sites under consideration are as follows: Site 1: x1 = 360, y₁ = 180 Site 2: X2 = 420, y2 = 450 Site 3: X3 = 250, y3 = 400
An elite logistics company want to determine the optimum assignment of its fleet of trucks to deliveryroutes. The objective is to minimize total costs. The costsdata in hundreds of dollars for the various truck-routecombinations are given in the following table. Develop anassignment that will minimize total cost.Route (in U.S. dollars)Truck 1 2 3 4A 9 13 8 5B 10 11 7 6C 12 6 14 9D 8 9 10 12
Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5. Factor 1 2 3 4 5 6 Factor Description Quality of labor Construction cost Transportation costs Proximity to Markets Taxes 7 Weight 10 7 78565 A 5 3 4 5 2 2 4 B 3 2 5 3 2 5 4 (Enter your response as an integer.) Site Scores Weather Energy costs a) Based on the given information, the best site for Daniel Tracy is C with a total weighted score of 197. (Enter your response as an integer.) b) If site D's score for Energy costs increases from a 3 to a 5, its a total weighted score will be 144. (Enter your response as an integer.) Then, the best site for Daniel Tracy will be C with a total weighted score of 197. (Enter your response as an…
Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)
Excel formulas.
A Develop a transportation grid. Boulder Macon Gary Requirements B find the optimal solution using Microsoft Candidate Selection Boulder Macon Gary Total supplied Profit Boulder Macon Gary Total profit
Exotech Computers manufactures computer componentssuch as chips, circuit boards, motherboards, keyboards,LCD panels, and the like and sells them around the world.It wants to construct a new warehouse/distribution centerin Asia to serve emerging Asian markets. It has identifiedsites in Shanghai, Hong Kong, and Singapore and has ratedthe important location factors for each site as follows:
like this fill the boxes
7

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