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 plant 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-COORDINATES260360810860CxCyy-COORDINATES260135460545NUMBER OF CASES23,50019,00027,00015,500a. Use the centroid method to recommend a location for the new bottling plant. (Round your answers to 1 decimal place.)

Santa Cruz Bottling wants to set up a new plant and searching for a best location. The following…

Answered: Santa Cruz Bottling is a manufacturer…

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

Santa Cruz Bottling is a manufacturer of organic soft drinks on the coast of central California. Its products are enjoying a growing reputation and increased demand throughout the American Southwest. Because of the high cost of transportation soft drinks, they are considering a new plant to serve the states of New Mexico and Arizona. A key concern in their search for a new location is the resultant transportation cost to serve their key markets. Following is a list of cities where their main wholesale customers are located, along with estimated annual demand in cased of product for each. CITY x-COORDINATES y-COORDINATES # OF CASES Phoenix 281 281 24,500 Tucson 381 156 20,000 Albuquerque 831 481 28,000 Santa Fe 881…
Identify five functions that these locations perform: Content aggregation, portals, and e-commerce among the many web-related subjects discussed.
Describe the four main approaches used to solve the problem location?
What exactly is clustering? Give two examples of service sector clustering.
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?
What motivations typically cause firms to initiate a facilities location or relocation project?
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.
What major issues should be considered when determining a retail site location
A larger and more modern post office is to be constructed at a new location in Sally Spring Georgia. Growing suburbs caused a shift in the population density from where it was 30 years ago when the current facility was built. Andy Browne, the postmaster, asked his assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office are shown in the table below. Mail Source Point Round Trips per day X coordinate Y coordinate 1 6 2 8 2 3 6 1 3 3 8 5 4 3 13 3 5 2 15 10 6 7 6 14 Calculate the center of gravity as a possible location for the new facility. Can you please show me how you arrived at the answer?

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