TABLE 10.12 SHIPPING COST FROM THE DISTRIBUTION CENTERS TO THE CUSTOMER ZONES Customer Zone Distribution Center San Kansas Salt Lake Los San Dallas Antonio Wichita City Denver City Phoenix Angeles Diego Fort Worth 0.3 2.1 3.1 4.4 6.0 Santa Fe 5.2 5.4 4.5 6.0 2.7 4.7 3.4 3.3 2.7 Las Vegas 5.4 3.3 2.4 2.1 2.5 The cost per unit of shipping from each distribution center to each customer zone is given in Table 10.12; note that some distribution centers cannot serve certain customer zones. These are indicated by a dash, "-". In its current supply chain, demand at the Dallas, San Antonio, Wichita, and Kansas City customer zones is satisfied by shipments from the Fort Worth distribution center. In a similar manner, the Denver, Salt Lake City, and Phoenix customer zones are served by the Santa Fe distribution center, and the Los Angeles and San Diego customer zones are served by the Las Vegas distribution center. To determine how many units to ship from each plant, the quarterly customer demand forecasts are aggregated at the distribution centers, and a transportation model is used to minimize the cost of shipping from the production plants to the distribution centers. Managerial Report You are asked to make recommendations for improving Darby Company's supply chain. Your report should address, but not be limited to, the following issues: 1. If the company does not change its current supply chain, what will its distribution costs be for the following quarter? 2. Suppose that the company is willing to consider dropping the distribution center limitations; that is, customers could be served by any of the distribution centers for which costs are available. Can costs be reduced? If so, by how much? 3. The company wants to explore the possibility of satisfying some of the customer demand directly from the production plants. In particular, the shipping cost is $0.30 per unit from San Bernardino to Los Angeles and $0.70 from San Bernardino to San Diego. The cost for direct shipments from El Paso to San Antonio is $3.50 per unit. Can distribution costs be further reduced by considering these direct plant-to- customer shipments? 4. Over the next five years, Darby is anticipating moderate growth (5000 meters) to the north and west. Would you recommend that Darby consider plant expansion at this time? Cengage Learning 2013 Case Problem 2 Supply Chain Design The Darby Company manufactures and distributes meters used to measure electric power consumption. The company started with a small production plant in El Paso and gradually built a customer base throughout Texas. A distribution center was established in Fort Worth, Texas, and later, as business expanded, a second distribution center was established in Santa Fe, New Mexico. The El Paso plant was expanded when the company began marketing its meters in Ari- zona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby Company opened a third distribution center in Las Vegas and just two years ago opened a second production plant in San Bernardino, California. Manufacturing costs differ between the company's production plants. The cost of each meter produced at the El Paso plant is $10.50. The San Bernardino plant utilizes newer and more efficient equipment; as a result, manufacturing costs are $0.50 per meter less than at the El Paso plant. Due to the company's rapid growth, not much attention had been paid to the efficiency of its supply chain, but Darby's management decided that it is time to address this issue. The cost of shipping a meter from each of the two plants to each of the three distribution centers is shown in Table 10.10. The quarterly production capacity is 30,000 meters at the older El Paso plant and 20,000 meters at the San Bernardino plant. Note that no shipments are allowed from the San Bernardino plant to the Fort Worth distribution center. The company serves nine customer zones from the three distribution centers. The fore- cast of the number of meters needed in each customer zone for the next quarter is shown in Table 10.11. TABLE 10.10 SHIPPING COST PER UNIT FROM PRODUCTION PLANTS TO DISTRIBUTION CENTERS (IN $) Plant El Paso San Bernardino Distribution Center Fort Santa Las Worth Fe Vegas 3.20 2.20 4.20 3.90 1.20 TABLE 10.11 QUARTERLY DEMAND FORECAST Demand (meters) Customer Zone Dallas 6300 San Antonio 4880 Wichita 2130 Kansas City 1210 Denver 6120 Salt Lake City 4830 Phoenix 2750 Los Angeles 8580 San Diego 4460 Cengage Learning 2013 Cengage Learning 2013 a

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
ChapterB: Differential Calculus Techniques In Management
Section: Chapter Questions
Problem 3E
icon
Related questions
Question

solve the problem and provide an excel spreedsheat of the answer and the steps used to get the answer. 

in your solutions ensure to answer these questions 
 You are asked to make recommendations for improving Darby Company’s supply chain.
 Your report should address, but not be limited to, the following issues:
 1. If the company does not change its current supply chain, what will its distribution
 costs be for the following quarter?
 2. Suppose that the company is willing to consider dropping the distribution center
 limitations; that is, customers could be served by any of the distribution centers for
 which costs are available. Can costs be reduced? If so, by how much?
 3. The company wants to explore the possibility of satisfying some of the customer
 demand directly from the production plants. In particular, the shipping cost is $0.30
 per unit from San Bernardino to Los Angeles and$0.70fromSanBernardinotoSan
 Diego. The cost for direct shipments from El Paso to San Antonio is $3.50 per unit.
 Can distribution costs be further reduced by considering these direct plant-to
customer shipments?
 4. Over the next five years, Darby is anticipating moderate growth (5000 meters) to
 the north and west. Would you recommend that Darby consider plant expansion at
 this time?

TABLE 10.12 SHIPPING COST FROM THE DISTRIBUTION CENTERS TO THE CUSTOMER ZONES
Customer Zone
Distribution
Center
San
Kansas
Salt Lake
Los
San
Dallas Antonio Wichita
City
Denver
City
Phoenix Angeles Diego
Fort Worth
0.3
2.1
3.1
4.4
6.0
Santa Fe
5.2
5.4
4.5
6.0
2.7
4.7
3.4
3.3
2.7
Las Vegas
5.4
3.3
2.4
2.1
2.5
The cost per unit of shipping from each distribution center to each customer zone is
given in Table 10.12; note that some distribution centers cannot serve certain customer
zones. These are indicated by a dash, "-".
In its current supply chain, demand at the Dallas, San Antonio, Wichita, and Kansas
City customer zones is satisfied by shipments from the Fort Worth distribution center. In a
similar manner, the Denver, Salt Lake City, and Phoenix customer zones are served by the
Santa Fe distribution center, and the Los Angeles and San Diego customer zones are served
by the Las Vegas distribution center. To determine how many units to ship from each plant,
the quarterly customer demand forecasts are aggregated at the distribution centers, and a
transportation model is used to minimize the cost of shipping from the production plants to
the distribution centers.
Managerial Report
You are asked to make recommendations for improving Darby Company's supply chain.
Your report should address, but not be limited to, the following issues:
1. If the company does not change its current supply chain, what will its distribution
costs be for the following quarter?
2. Suppose that the company is willing to consider dropping the distribution center
limitations; that is, customers could be served by any of the distribution centers for
which costs are available. Can costs be reduced? If so, by how much?
3. The company wants to explore the possibility of satisfying some of the customer
demand directly from the production plants. In particular, the shipping cost is $0.30
per unit from San Bernardino to Los Angeles and $0.70 from San Bernardino to San
Diego. The cost for direct shipments from El Paso to San Antonio is $3.50 per unit.
Can distribution costs be further reduced by considering these direct plant-to-
customer shipments?
4. Over the next five years, Darby is anticipating moderate growth (5000 meters) to
the north and west. Would you recommend that Darby consider plant expansion at
this time?
Cengage Learning 2013
Transcribed Image Text:TABLE 10.12 SHIPPING COST FROM THE DISTRIBUTION CENTERS TO THE CUSTOMER ZONES Customer Zone Distribution Center San Kansas Salt Lake Los San Dallas Antonio Wichita City Denver City Phoenix Angeles Diego Fort Worth 0.3 2.1 3.1 4.4 6.0 Santa Fe 5.2 5.4 4.5 6.0 2.7 4.7 3.4 3.3 2.7 Las Vegas 5.4 3.3 2.4 2.1 2.5 The cost per unit of shipping from each distribution center to each customer zone is given in Table 10.12; note that some distribution centers cannot serve certain customer zones. These are indicated by a dash, "-". In its current supply chain, demand at the Dallas, San Antonio, Wichita, and Kansas City customer zones is satisfied by shipments from the Fort Worth distribution center. In a similar manner, the Denver, Salt Lake City, and Phoenix customer zones are served by the Santa Fe distribution center, and the Los Angeles and San Diego customer zones are served by the Las Vegas distribution center. To determine how many units to ship from each plant, the quarterly customer demand forecasts are aggregated at the distribution centers, and a transportation model is used to minimize the cost of shipping from the production plants to the distribution centers. Managerial Report You are asked to make recommendations for improving Darby Company's supply chain. Your report should address, but not be limited to, the following issues: 1. If the company does not change its current supply chain, what will its distribution costs be for the following quarter? 2. Suppose that the company is willing to consider dropping the distribution center limitations; that is, customers could be served by any of the distribution centers for which costs are available. Can costs be reduced? If so, by how much? 3. The company wants to explore the possibility of satisfying some of the customer demand directly from the production plants. In particular, the shipping cost is $0.30 per unit from San Bernardino to Los Angeles and $0.70 from San Bernardino to San Diego. The cost for direct shipments from El Paso to San Antonio is $3.50 per unit. Can distribution costs be further reduced by considering these direct plant-to- customer shipments? 4. Over the next five years, Darby is anticipating moderate growth (5000 meters) to the north and west. Would you recommend that Darby consider plant expansion at this time? Cengage Learning 2013
Case Problem 2 Supply Chain Design
The Darby Company manufactures and distributes meters used to measure electric power
consumption. The company started with a small production plant in El Paso and gradually
built a customer base throughout Texas. A distribution center was established in Fort Worth,
Texas, and later, as business expanded, a second distribution center was established in Santa
Fe, New Mexico.
The El Paso plant was expanded when the company began marketing its meters in Ari-
zona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby
Company opened a third distribution center in Las Vegas and just two years ago opened a
second production plant in San Bernardino, California.
Manufacturing costs differ between the company's production plants. The cost of each
meter produced at the El Paso plant is $10.50. The San Bernardino plant utilizes newer and
more efficient equipment; as a result, manufacturing costs are $0.50 per meter less than at
the El Paso plant.
Due to the company's rapid growth, not much attention had been paid to the efficiency
of its supply chain, but Darby's management decided that it is time to address this issue.
The cost of shipping a meter from each of the two plants to each of the three distribution
centers is shown in Table 10.10.
The quarterly production capacity is 30,000 meters at the older El Paso plant and 20,000
meters at the San Bernardino plant. Note that no shipments are allowed from the San
Bernardino plant to the Fort Worth distribution center.
The company serves nine customer zones from the three distribution centers. The fore-
cast of the number of meters needed in each customer zone for the next quarter is shown in
Table 10.11.
TABLE 10.10 SHIPPING COST PER UNIT FROM PRODUCTION PLANTS TO
DISTRIBUTION CENTERS (IN $)
Plant
El Paso
San Bernardino
Distribution Center
Fort
Santa
Las
Worth
Fe
Vegas
3.20
2.20
4.20
3.90
1.20
TABLE 10.11 QUARTERLY DEMAND FORECAST
Demand (meters)
Customer Zone
Dallas
6300
San Antonio
4880
Wichita
2130
Kansas City
1210
Denver
6120
Salt Lake City
4830
Phoenix
2750
Los Angeles
8580
San Diego
4460
Cengage Learning 2013
Cengage Learning 2013
a
Transcribed Image Text:Case Problem 2 Supply Chain Design The Darby Company manufactures and distributes meters used to measure electric power consumption. The company started with a small production plant in El Paso and gradually built a customer base throughout Texas. A distribution center was established in Fort Worth, Texas, and later, as business expanded, a second distribution center was established in Santa Fe, New Mexico. The El Paso plant was expanded when the company began marketing its meters in Ari- zona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby Company opened a third distribution center in Las Vegas and just two years ago opened a second production plant in San Bernardino, California. Manufacturing costs differ between the company's production plants. The cost of each meter produced at the El Paso plant is $10.50. The San Bernardino plant utilizes newer and more efficient equipment; as a result, manufacturing costs are $0.50 per meter less than at the El Paso plant. Due to the company's rapid growth, not much attention had been paid to the efficiency of its supply chain, but Darby's management decided that it is time to address this issue. The cost of shipping a meter from each of the two plants to each of the three distribution centers is shown in Table 10.10. The quarterly production capacity is 30,000 meters at the older El Paso plant and 20,000 meters at the San Bernardino plant. Note that no shipments are allowed from the San Bernardino plant to the Fort Worth distribution center. The company serves nine customer zones from the three distribution centers. The fore- cast of the number of meters needed in each customer zone for the next quarter is shown in Table 10.11. TABLE 10.10 SHIPPING COST PER UNIT FROM PRODUCTION PLANTS TO DISTRIBUTION CENTERS (IN $) Plant El Paso San Bernardino Distribution Center Fort Santa Las Worth Fe Vegas 3.20 2.20 4.20 3.90 1.20 TABLE 10.11 QUARTERLY DEMAND FORECAST Demand (meters) Customer Zone Dallas 6300 San Antonio 4880 Wichita 2130 Kansas City 1210 Denver 6120 Salt Lake City 4830 Phoenix 2750 Los Angeles 8580 San Diego 4460 Cengage Learning 2013 Cengage Learning 2013 a
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Economics:
Economics:
Economics
ISBN:
9781285859460
Author:
BOYES, William
Publisher:
Cengage Learning
Economics Today and Tomorrow, Student Edition
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning