Problem 15-12 (Static) 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 transporting soft drinks, they are considering a new plant to serve the states of New Mexico and Arizona. key concern in their search for a new location is the resultant 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. CITY Phoenix Tucson Albuquerque Santa Fe X-COORDINATES 250 350 Cx Cy see 850 y-COORDINATES 250 125 450 520 NUMBER OF CASES 25,000 20,000 28,000 17,000 a. Use the centroid method to recommend a location for the new bottling plant. (Round your answers to 1 decimal place.)

Problem 15-12 (Static) 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 transporting soft drinks, they are considering a new plant to serve the states of New Mexico and Arizona. key concern in their search for a new location is the resultant 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. CITY Phoenix Tucson Albuquerque Santa Fe X-COORDINATES 250 350 Cx Cy see 850 y-COORDINATES 250 125 450 520 NUMBER OF CASES 25,000 20,000 28,000 17,000 a. Use the centroid method to recommend a location for the new bottling plant. (Round your answers to 1 decimal place.)

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

Related questions

Q: QUESTION 3 (Using the same problem) A vendor for the local ballpark food stand is questioning…

A: EVPI is a valuable tool for decision-makers facing uncertainty because it quantifies the value of…

Q: accounts you consider most at risk of being materially misstated

A: The accounts , which I consider most at risk of bieng materially misstated are as follows-

Q: Your deceased client had a gross estate valued at $14 million. His estate includes approximately…

A: The business should be run as per the market conditions, and requirement. The resources for the…

Q: Question 2 Africa World Airline operates in the short-haul flight industry of Ghana. Unlike many of…

A: The mission statement contains either a single sentence or a short paragraph. The mission statement…

Q: D & R A1 2 -3 Question 2. Contango and Backwardation Explain the relationship between contango,…

A: The forward curve structure is denoted by the terms contango and backwardation. When a market is in…

Q: Question 9 1. A system which takes resources from its external environment and converts them into…

A: Company- A group of people can organize a legal organization called a corporation to conduct and…

Q: Question 8 Part G A large company is planning to purchase equipment costing $220,000 and will…

Q: An electronic component manufacturer has two facilities producing a range of esistors. Facility 1…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Questi are long-term, unsecured debt securities.

A: Debentures are long-term debt securities issued by corporations or governments to raise capital.…

Q: a. What is the current profit and proposed profit of the sales of AudioCables? (Leave no cells blank…

A: Current information: Variable Cost (VC) = $ 0.50 Selling Price (SP) = $ 1.00 Fixed Cost (FC) = $…

Q: Aceron Bhd produces three products A, B and C. The unit cost and selling prices are as shown below:…

Q: Q.4. Write a detailed note on national cultural variables.

A: Change order correctly minimizes the risk, improves its chances of approval, and also helps get paid…

Q: Question 2 Alpha Electronics (AE) is a large manufacturer of electronics products. The company sells…

A: (a)

Q: question 10.A competitive network results in a more balanced system of dominance compared to a…

A: Competitors are the ones who provide same or near to the same goods and services in the market.…

Q: COVID-19 in different hospitals nationwide. Below are the costs of production and demands of the…

A: The question presents a scenario where a manufacturer is producing face masks and PPEs for the…

Q: Define Segmentation?

A: Introduction:- Marketing refers to all those activities which are done by marketer to increase the…

Q: Q. 10. Compute the missing term. Dollar Markup Cost $290.25 Selling Price $739.97

A: Markup price refers to the additional amount or percentage added to the cost of a product or service…

Question

100%

Ch. 15 Q9

Problem 15-12 (Static)
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 transporting 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 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.
CITY
Phoenix
Tucson
Albuquerque
Santa Fe
X-COORDINATES
250
Cx
Cy
350
800
850
y-COORDINATES
250
125
450
520
NUMBER OF CASES
25,000
20,000
28,000
17,000
a. Use the centrold method to recommend a location for the new bottling plant. (Round your answers to 1 decimal place.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Given:

VIEW

Step 2: Formula used:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Q. 4.
Ch. 11 Q6
Q.6. What are the two types of decision making?
QUESTION 13 (Please use at least four significant figures in your calculations.) $60 S-curve Turntables $160 Hullabaloo Records $40 $260 S-Curve Turntables manufactures turntables, and sells them through Hullabaloo Records, a chain of specialty record stores. For a model year, they will manufacture their newest model of turntable, called "Orbitz", which will be sold through the record stores. It costs $60 for S- Curve to manufacture the turntables, which it then sells to Hullabaloo for $160. Hullabaloo Records then sells the turntables at retail for $260. Whatever doesn't sell gets put on clearance for $40. Demand for the turntable is expected to be normally distributed with a mean of 1833 and a standard deviation of 1092. What is the optimal order amount that will maximize the SUPPLY CHAIN'S expected profit?
Question 4 There are many types of airlines involved in the air cargo business. Think of an airline that you are familiar with. Determine the characteristics of this airline (e.g. aircraft fleet, services provided, products, service quality and service coverage) and its classification by the air cargo business. (10 marks) With reference to the same airline, critique on three (3) key challenges the airline is likely to face in terms of managing its revenue. (15 marks) (a) (b)
Question 1: A piece of equipment used in a business has a basis of $25,000 and is expected to have salvage value $5,000 at the end of it's 5 years of useful life. Find its annual depreciation rate and tabulate the annual depreciation amounts and book value of the equipment at the end of each year. Nears
Qw.35.
Question 47 Different levels of supply chain analytics include Descriptive, Predictive, Prescriptive, and Cognitive analysis. ents O True O False Question 48 Course ACE) Integrated carriers provide door-to-door service, a consistent schedule of pickup and delivery windows, and standard expedited service through their hub-and-spoke networks. Nonintegrated carriers provide on-demand, air-only service from airport to airport. They rely on freight forwarders or the customer to provide delivery service to and from the airport True O False
Q 9. Discuss the importance of search engines.
Ch 11 Q7
Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
Ch.6 Q5