PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.I REPEAT, ONLY EXCEL PROBLEM 9The Darby Company manufactures and distributes meters used to measure electric powerconsumption. The company started with a small production plant in El Paso and gradually built acustomer 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 Arizona, California,Nevada, and Utah. With the growth of the West Coast business, the Darby Company opened a thirddistribution center in Las Vegas and just two years ago opened a second production plant in SanBernardino, California.Manufacturing costs differ between the company's production plants. The cost of each meterproduced at the El Paso plant is $10.50. The San Bernardino plant utilizes newer and more efficientequipment; 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 thedistribution system, but Darby's management decided that it is time to address this issue. The cost ofshipping a meter from each of the two plants to each of the three distribution centers is shown below:DISTRIBUTION CENTERPLANTEl PasoSan BernardinoFort Worth3.20Santa Fe2.203.90The quarterly production capacity is 30,000 meters at the older El Paso plant and 20,000 meters at theSan Bernardino plant. Note that no shipments are allowed from the San Bernardino plant to the FortWorth distribution center.The company serves nine customer zones from the three distribution centers. The forecast of thenumber of meters needed in each customer zone for the next quarter is shown below:Customer Zone Demand (Meters)DallasSan AntonioWichitaKansas CityDenverSalt Lake CityPhoenixLos AngelesSan DiegoDISTRIBUTIONSanCENTERS Dallas Antonio WichitaFort Worth0.32.13.1Santa Fe5.25.44.5Las Vegas630048802130121061204830275085804460The cost per unit of shipping from each distribution center to each customer zone is given below; notethat some distribution centers cannot serve certain customer zones.CUSTOMER ZONESaltLakeLas Vegas4.201.20KansasLosSanCity Denver City Phoenix Angeles Diego4.46.06.02.75.4-4.73.33.42.43.32.12.72.5In the current distribution system, demand at the Dallas, San Antonio, Wichita, and Kansas Citycustomer 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. Todetermine how many units to ship from each plant, the quarterly customer demand forecasts areaggregated at the distribution centers, and a modified transportation model is used to minimize thecost of shipping from the production plants to the distribution centers.

Answer: We have explain in more details in step by step in a simple way

PROBLEM 9 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 Arizona, 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 the distribution system, 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 below: DISTRIBUTION CENTER PLANT El Paso San Bernardino Fort Worth 3.20 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. DISTRIBUTION CENTERS Fort Worth The company serves nine customer zones from the three distribution centers. The forecast of the number of meters needed in each customer zone for the next quarter is shown below: Santa Fe Las Vegas Customer Zone Dallas San Antonio Wichita Kansas City Denver Salt Lake City Phoenix Los Angeles San Diego Santa Fe 2.20 3.90 San Dallas Antonio Wichita 2.1 0.3 5.2 5.4 The cost per unit of shipping from each distribution center to each customer zone is given below; note that some distribution centers cannot serve certain customer zones. CUSTOMER ZONE 3.1 4.5 Demand (Meters) Kansas City 4.4 6.0 6300 4880 2130 1210 6120 4830 2750 8580 4460 Denver 6.0 2.7 5.4 Salt Lake Las Vegas 4.20 1.20 Los San City Phoenix Angeles Diego - 4.7 3.3 3.4 2.4 3.3 2.1 2.7 2.5 In the current distribution system, 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 modified transportation model is used to minimize the cost of shipping from the production plants to the distribution centers.

PROBLEM 9 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 Arizona, 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 the distribution system, 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 below: DISTRIBUTION CENTER PLANT El Paso San Bernardino Fort Worth 3.20 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. DISTRIBUTION CENTERS Fort Worth The company serves nine customer zones from the three distribution centers. The forecast of the number of meters needed in each customer zone for the next quarter is shown below: Santa Fe Las Vegas Customer Zone Dallas San Antonio Wichita Kansas City Denver Salt Lake City Phoenix Los Angeles San Diego Santa Fe 2.20 3.90 San Dallas Antonio Wichita 2.1 0.3 5.2 5.4 The cost per unit of shipping from each distribution center to each customer zone is given below; note that some distribution centers cannot serve certain customer zones. CUSTOMER ZONE 3.1 4.5 Demand (Meters) Kansas City 4.4 6.0 6300 4880 2130 1210 6120 4830 2750 8580 4460 Denver 6.0 2.7 5.4 Salt Lake Las Vegas 4.20 1.20 Los San City Phoenix Angeles Diego - 4.7 3.3 3.4 2.4 3.3 2.1 2.7 2.5 In the current distribution system, 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 modified transportation model is used to minimize the cost of shipping from the production plants to the distribution centers.

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter20: Queuing Theory

Section20.10: Exponential Queues In Series And Open Queuing Networks

Problem 7P

See similar textbooks