ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annualnumber of truckloads are given in the accompanying table. Develop and solve a model to find the best location, assumingthat straight-line distances can be used between the locations.The best location for the warehouse is at X= and Y=Retail Store Locations and ShipmentsRetail StoreABCDEcX-Coordinate Y-Coordinate Truckloads52018416DOE33201012282822418121812

Center of gravity model will identify the coordination values of central location based on the…

Answered: ElectroMart wants to identify a…

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

a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B 1 $1.70 $1.90 $1.60 $1.70 2 $1.40 $1.90 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center needed, O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. C. The sum of supply capacities…
The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning their long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B D $1.90 $1.90 $1.70 $1.60 $1.70 2 $1.40 $1.60 $1.70 3 $1.60 $1.50 $1.80 $1.40 a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? O A. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. O B. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. O C. The sum of supply capacities…
The Rae Mischel Company expanded its shipping capacity and the additional cost of doing this from each warehouse to terminal is highlighted in the following table. Determine theminimum cost to ship from each warehouse to terminal.
Answer the following homework question
A company has three existing warehouses to which it will ship furniture from a new factory whose location must be decided. The factory will receive raw materials from its wood supplier and fabric supplier. The annual number of shipments, shipment costs and the location of the suppliers and warehouses are shown below Existing facilities Annual L to or from fact cost Coordinate location Wood supplier 120 10 (100, 400) Fabric supplier 200 10 (800,700) Ware h 1 61 10 (300, 600) Ware h 2 40 10 (200, 100) Ware h 3 70 10 (600, 200) Using the median load answer the following questions –Where the factory should be located to minimize annual transportation cost –What will be the minimum annual transportation cost
A company has 4 plants: Plant 1, Plant 2, Plant 3, and Plant 4. All the plants make the same product The company sells the product in 4 different cities: City 1, City 2, City 3, City 4. Maximum production (in thousands of units) that is possible at the 4 plants are given respectively by (Plant 1 to Plant 4): 5, 25, 10, and 15. Your forecast shows that the demand for the product (in thousands of units) in each of the cities is given by (City 1 to City 4): 15, 7, 9, 10. Your firm does not want to have any backorders or lost demand. The production & transportation cost for getting a product from any given plant to any given city if given blow: Plant 1 Plant 2 Plant 3 Plant 4 Production and Transportation Cost per 1000 units (Thousand $) City 1 City 2 1070 1260 1825 780 800 City 3 1400 1685 1540 1070 2425 1355 843 City 4 1530 1100 500 1045 You need to decide which plant will serve which city and how much. Find the optimal way to serve the demands in all the cities. What is the optimal…
An auto company currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached. b) Using the intuitive lowest cost method, determines which of the candidate locations, inaddition to existing locations, gives the initial solution with a lower cost? c) Using the solutions obtained in b), identify which distribution center still faces a shortage. d) Suppose the company has chosen Houston as their third plant and would like to know the optimaltransportation strategy that minimizes overall costs by solving a minimum-cost flow problem.Terry has defined decision variables, represented as xij, to denote the number of items shippedfrom plant i to distribution center j wherei= C(Cincinnati), T(Tulsa), and H(Houston)j= B(Boston) and P(Phoenix)
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m
Maximize 8x + 9y Subject to -- x + 2 y 0 a) Solve using simplex method
Destination Destination Destination Supply Source 1 75 8 320 Source 2 6 160 13120 4. Source 3 6.5 Demand 160 200 240 Based on the transportation table shown, total transportation cost using North- West Corner Method will be: a. 3040 Ob. 4100 O c. 2640 O d. 1920
6 see pictures to solve

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