Problem 15-12 (Algo)Santa Cruz Bottling is a manufacturer of organic soft drinks on the coast of central California. Its products are enjoying a growingreputation and increased demand throughout the American Southwest. Because of the high cost of transporting soft drinks, they areconsidering a new plaht to serve the states of New Mexico and Arizona. A key concern in their search for a new location is theresultant transportation costs to serve their key markets. Following is a list of cities where their main wholesale customers are located,along with estimated annual demand in cases of product for each.CITYPhoenixTucsonAlbuquerqueSanta Fex-COORDINATES298390848898SxCyy-COORDINATES290165498568NUMBER OF CASES29,00028,00036,00021,000a. Use the centroid method to recommend a location for the new bottling plant. (Round your answers to 1 decimal place.)

Given, Cities with the relevant x-coordinates, y-coordinates and number of cases. Let x coordinates…

Answered: Problem 15-12 (Algo) Santa Cruz…

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

What mode of transportation is involved in the movement of the greatest number of products?
Identify five functions that these locations perform: Content aggregation, portals, and e-commerce among the many web-related subjects discussed.
Define Transport Management and identify two examples where transport management is applied/used.
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…
Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and Bryan to its con-crete block manufacturing facilities in Abilene, Tyler, and SanAngelo. For the capacities, locations, and shipment costs pertruckload shown in the Figure 13.13, determine the shippingpattern that will minimize transportation costs. What are theestimated transportation costs associated with this optimalallocation pattern?
How can the Philippine destination management office (DOT-TPB) create better destination management system?
The primary expense criteria utilized when studying a logistics network using a transportation model?
A-Ahmed and Salem are studying tourism investment management at Coventry University in the United Kingdom. The course includes writing a report on tourism investment in the Sultanate of Oman. Among the requirements of the information in the selection of two cities for the establishment of tourism investment. Ahmed and Salem chose to establish an integrated tourism project in the towns of Nizwa and Sur. • Discuss the importance of tourism investment in Oman and the establishment of tourism projects in those cities.
Sarah and Alice live and work in different regions of the same country. Each is considering a move to the most economically-prosperous region of this country (referred to below as the “destination region”). Assume that Sarah and Alice are identical in every way except for the following differences: Sarah’s home region is next to the destination region Sarah’s home region is culturally distinct from all other regions in the country Alice’s home region is roughly 2000 km away from the destination region Sarah is 25 years old, while Alice is 35 The unemployment rate in Sarah’s home region is 6.5% The unemployment rate in Alice’s home region is 8% The unemployment rate in the destination region is 5% a) Given this information, describe two reasons why we might expect Sarah to be more likely than Alice to migrate to the destination region. b) Given this information, describe two reasons why we might expect Alice to be more likely than Sarah to migrate to the destination region.
For each of the location problems described, discuss which of the seven assumptions listed in this section are likely to be violated:b. Locating an international network of telecommunications facilities.
Which of the following statement about contemporary industrial location considerations is NOT true? Governments seek to attract industries to underdeveloped regions. China has relocated polluting factories is an example of industrial deglomeration. The Buffalo Billion Investment Development Plan is designed to keep the Buffalo Bills professional football team in the area. Transportation costs are less important in modern industrial location than they were when Weber developed his theory.

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