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 centre was established in Fort Worth, Texas, and later, as business expanded, a second distribution centre was established in Santa Fe, New Mexico. The El Paso plant was expanded when the company began marketing its meters in Arizona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby company opened a third distribution centre 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 utilises newer and more efficient equipment as a result manufacturing cost is $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. He cost of shipping a meter from each of the two plants to each of the three distribution centres is shown in Table 1.
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 centre. The company serves nine customer zones from the three distribution centres. The forecast of the number of meters needed in each customer zone for the next quarter is shown in Table 2.
The cost per unit of shipping from each distribution centre to each customer zone is given in table 3. Note that some distribution centres cannot serve certain customer zones. These are indicated by 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 centre. In a similar manner, the Denver, Salt Lake City, and Phoenix customer zones are served by the Santa Fe distribution centres, and the Los Angeles and San Diego customer zones are served by the Las Vegas distribution centre. To determine how many units to ship from each plant, the quarterly customer demand forecasts are aggregated at the distribution centres and a transportation model is used to minimize the cost of shipping from the production plants to the distribution centres.
Table 1. Shipping cost per unit from production plants to distribution centres ($)
Distribution centre
Plant
Fort Worth
Santa Fe
Las Vegas
El Paso
3.20
2.20
4.20
San Bernardino
-
3.90
1.20
Table 2. quarterly demand forecast
Customer zone
Demand (metres)
Dallas
6300
San Antonio
4880
Wichita
2130
Kansas City
1210
Denver
6120
Salt Lake City
4830
Phoenix
2750
Los Angeles
8580
San Diego
4460
Table 3. shipping cost from the distribution centres to the customer zones
Customer zone
Distribution centre
Dallas
San Antonio
Wichita
Kansas City
Denver
Salt Lake City
Phoenix
Los Angeles
San Diego
Fort Worth
0.3
2.1
3.1
4.4
6
-
-
-
-
Santa Fe
5.2
5.4
4.5
6
2.7
4.7
3.4
3.3
2.7
Las Vegas
-
-
-
-
5.4
3.3
2.4
2.1
2.5
Assessment Tasks:
Question:
You are asked to make recommendations for improving Darby Company's supply chain.Develop the Network Model for this problem.
w- MA609 - Business Analytics and Data Intelligence - T1 2020 - Final Assessment Paper Q Q v Home Insert Draw Design Layout References Mailings Review View Share Comments Calibri (Bo... v 16 VA A Aa Ap AaBbCcDdi AaBbCcDdE AaBbCcDdE AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe AaBbCcDdE Paste BIUvab X X ADVA v Heading 2 Heading 3 Normal Question list 2 Question list 3 Body Text italic No Spacing Styles Pane Background and Content: 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 centre was established in Fort Worth, Texas, and later, as business expanded, a second distribution centre was established in Santa Fe, New Mexico. The El Paso plant was expanded when the company began marketing its meters in Arizona, California, Nevada, and Utah. With the growth of the West Coast business, the Darby company opened a third distribution centre 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 utilises newer and more efficient equipment as a result manufacturing cost is $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. He cost of shipping a meter from each of the two plants to each of the three distribution centres is shown in Table L. 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 llowed from the San Bernardino plant to the Fort Worth distribution centre. The company serves nine customer zones from the three distribution centres. The forecast of the number of meters needed in each customer zone for the next quarter is shown in Table 2. The cost per unit of shipping from each distribution centre to each customer zone is given in table 3. Note that some distribution centres cannot serve certain customer zones. These are indicated by 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 centre. In a similar manner, the Denver, Salt Lake City, and Phoenix customer zones are served by the Santa Fe distribution centres, and the Los Angeles and San Diego customer zones are served by the Las Vegas distribution centre. To determine how many units to ship from each plant, the quarterly customer demand forecasts are aggregated at the distribution centres and a transportation model is used to minimize the cost of shipping from the production plants to the distribution centres. Table 1. Shipping cost per unit from production plants to distribution centres ($) Distribution centre Plant Fort Worth Santa Fe Las Vegas El Paso 3.20 2.20 4.20 San Bernardino 3.90 1.20 Table 2. quarterly demand forecas Customer zone Demand (metres) Dallas 6300 San Antonio 4880 Wichita 2130 Kansas City 1210 Denver 6120 Salt Lake City 4830 Phoenix 2750 Los Angeles 8580 San Diego 4460 Page 1 of 2 586 words English (United States) + 100%w- MA609 - Business Analytics and Data Intelligence - T1 2020 - Final Assessment Paper Q Q v Home Insert Draw Design Layout References Mailings Review View Share Comments Calibri (Bo... v 16 A A Aa Ap EVENEv AaBbCcDdi AaBbCcDdEr AaBbCcDdE AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe AaBbCcDdE Paste BIUvab X X ADVA v EE EE Heading 2 Heading 3 Normal Question list 2 Question list 3 Body Text italic No Spacing Styles Pane San Antonio 4880 Wichita 2130 Kansas City 1210 Denver Salt Lake City 6120 4830 Phoenix Los Angeles 2750 8580 San Diego 4460 MA609 - Business Analytics and Data Intelligence - Trimester 1, 2020 Table 3. shipping cost from the distribution centres to the customer zones Customer zone Distribution Dallas San Wichita Kansas Denver Salt Phoenix Los San centre Antonio City Lake Angeles Diego Fort Worth |0.3 City 2.1 4.4 Santa Fe 5.2 3.1 5.4 16 Las Vegas |4.5 2.7 5.4 4.7 3.3 3.4 2.4 3.3 2.1 2.7 2.5 Assessment Tasks: Question: You are asked to make recommendations for improving Darby Company's supply chain. Develop the Network Model for this problem. Page 1 of 2 586 words English (United States) E + 100%